Question

In: Operations Management

Year Project A PROJECT B PROJECT C 0 (R28000) (R68000) (R15000) 1 R11000 R42000 R11000 2...

Year Project A PROJECT B PROJECT C
0 (R28000) (R68000) (R15000)
1 R11000 R42000 R11000
2 R11000 R18000 R4000
3 R11000 R15000 R2000
4 R11000 R18000 R1000

Suddy limited is considering investing in one of three potential projects.The details of the three projects being considered are summerized above

Present value factors based on 10% cost of capital for project duration:

year 1 = 0.909

year 2 = 0.826

year 3 = 0.751

year 4 = 0.683

Required :

1- Determine which of the above projects has the shortest payback period

2- Determine which of the above projects has the highest net present value. Assume the cost of capital to be 10%

3- Briefly discuss the merits of the NPV Methods

Solutions

Expert Solution

Payback period = Y + ( A / B ) where

Y = The number of years before the payback year.

A =Total remaining to be paid back at the start of the break even year. This is the amount that brings cumulative cash flow to 0.

B = Total (net) cash inflow in the entire payback year.

Project A

Payback period = Y + ( A / B )

                             =2+ (6000/11000)

                        =2+0.55

                           =2.55 years

Project B

Payback period = 2+ (8000/15000)

                        =2+0.53

                           =2.53 years

Project C

Payback period = 1+ (4000/4000)

                          =1+1

                           =2.0 years

Project C has the shortest payback period.

--------------------------------------------

Project wth highest NPV

NPV = -Cq + C1 /1+r + C2 /(1+r)2 + .... + CT /(1+r)T

where -Cq =Initial investment

C =Cash inflow

r= discount rate

T= Time

NPV of project A

   = -(28000) + 11000/1+0.1 + 11000/ (1+0.1)2 +11000/ (1+0.1)3+11000/ (1+0.1)4

   = -$4320

NPV of project B

   = -(68000) + 42000/1+0.1 + 18000/ (1+0.1)2 +15000/ (1+0.1)3+18000/ (1+0.1)4

   = -$8672

NPV of project C

   = -(15000) + 11000/1+0.1 + 4000/ (1+0.1)2 +2000/ (1+0.1)3+1000/ (1+0.1)4

   = -$1980

Project C has the Highest NPV

                         --------------------------------

Advantages Of Net Present Value (NPV)

1. NPV gives important to the time value of money.

2.In the calculation of NPV, both after cash flow and before cash flow over the life span of the project are considered.

3. Profitability and risk of the projects are given high priority.

4. NPV helps in maximizing the firm's value.


Related Solutions

Consider the following two​ projects: Project Year 0 ​C/F Year 1 ​C/F Year 2 ​C/F Year...
Consider the following two​ projects: Project Year 0 ​C/F Year 1 ​C/F Year 2 ​C/F Year 3 ​C/F Year 4 ​C/F Year 5 ​C/F Year 6 ​C/F Year 7 ​C/F Discount Rate Alpha minus79 20 25 30 35 40 ​N/A ​N/A 16​% Beta minus80 25 25 25 25 25 25 25 17​% The net present value​ (NPV) for project beta is closest​ to:
Find the discounted payback period. YEAR PROJECT A PROJECT B PROJECT C PROJECT D 0 (10,000)...
Find the discounted payback period. YEAR PROJECT A PROJECT B PROJECT C PROJECT D 0 (10,000) (15,000) (20,000) (30,000) 1 5,000 5,000 10,000 0 2 5000 5,000 10,000 0 3 20,000 5,000 4,000 100,000 4 1,000 10,000 2,000 120,000 5 - 5,000 - 60,000 answer : A(3 years) B(4years) C(4 years) D(3 years) Pls show me the working on how to get the discounted payback period. Pls do not show the working in excel, pls do it manually and attached...
Year Project A Project B 0 -$150,000 -$150,000 1 8,000 80,000 2 30,000 40,000 3 45,000...
Year Project A Project B 0 -$150,000 -$150,000 1 8,000 80,000 2 30,000 40,000 3 45,000 35,000 4 55,000 25,000 5 85,000 20,000 At what WACC would there be a break-even between the two projects? 7.23% 8.48% 7.57% 7.89% What is the NPV for Project A assuming the WACC is 10%? $5,653.94 $10,522.64 $6,219.33 $11,574.90 What is the IRR for Project B? 11.2% 13.9% 11.6% 10.9% What is the discounted payback period of Project A assuming the WACC is 10%?...
YEAR PROJECT A PROJECT B PROJECT C 2018 ($3,000,000) ($3,000,000) ($3,200,000) 2019 $0 $975,000 $985,000 2020...
YEAR PROJECT A PROJECT B PROJECT C 2018 ($3,000,000) ($3,000,000) ($3,200,000) 2019 $0 $975,000 $985,000 2020 $600,000 $975,000 $925,000 2021 $900,000 $975,000 $1,000,000 2022 $3,000,000 $1,000,000 $950,000 PLEASE calculate the Payback method for each and show me how you got to the answer!!
Consider cash flows for projects A and B Year: 0, 1, 2, 3, 4, 5 Project...
Consider cash flows for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: -$1000, 375, 375, 375, 375,-100 Project B: -$1000, 900, 700, 500, -200, 200 The cost of capital for both projects is 10% 1. Find the NPV and MIRR of projects A and B. If project A and B are mutually exclusive. 2. Find the crossover rate for projects A and B. 3. What is the profitability index for projects A and B? How...
Project Wind Power Year 0 Year 1 Year 2 Year 3 Costs $6,000,000 $4,000,000 $0 $0...
Project Wind Power Year 0 Year 1 Year 2 Year 3 Costs $6,000,000 $4,000,000 $0 $0 Benefits $18,000,000 $15,000,000 $12,000,000 $12,000,000 Project Hydroelectric power Year 0 Year 1 Year 2 Year 3 Costs $4,000,000 $2,000,000 $1,000,000 $0 Benefits $10,000,000 $14,000,000 $15,000,000 $16,000,000 If the interest rate is 3%, which project would you choose and why? Show your work using excel (15 points) If the interest rate is 15%, which project would you choose and why? Show your work using excel...
a+b+c=(abc)^(1/2) show that (a(b+c))^(1/2)+(b(c+a))^(1/2)+(c(a+b))^(1/2)>36
a+b+c=(abc)^(1/2) show that (a(b+c))^(1/2)+(b(c+a))^(1/2)+(c(a+b))^(1/2)>36
Year Project(A) Project (B) 0 -$30,000 -$30,000 1 13,000 5,000 2 11,000 5,000 3 9,000 5,000...
Year Project(A) Project (B) 0 -$30,000 -$30,000 1 13,000 5,000 2 11,000 5,000 3 9,000 5,000 4 7,000 5,000 5 0 5,000 6 7 8 9 10 0 0 0 0 0 5,000 5,000 5,000 5,000 5,000 The required rate of return is 10%. 3). What is the payback period for each of the projects? Which project should be accepted if the payback period method is applied? Assume that the target payback period is 4 years. Explain why. (4). What...
Let A, B and C be events. Express for k = 0, 1, 2, 3, the...
Let A, B and C be events. Express for k = 0, 1, 2, 3, the probabilities that: a) Exactly k of events A, B and C occur. b) At least k of events A, B and C occur.
Project Year 0 Year 1 Year 2 Year 3 Year 4 A    -$ 49 $ 25...
Project Year 0 Year 1 Year 2 Year 3 Year 4 A    -$ 49 $ 25 $ 22 $ 22 $ 15 B -$ 101 $ 19 $ 39 $ 51 $ 61 a. What are the IRRs of the two​ projects? b. If your discount rate is 4.8%​, what are the NPVs of the two​ projects? c. Why do IRR and NPV rank the two projects​ differently?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT