Question

In: Finance

Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...

Consider the following two mutually exclusive projects:

  

Year Cash Flow (A) Cash Flow (B)
0 –$260,730        –$15,011         
1 27,800        4,942         
2 56,000        8,023         
3 55,000        13,040         
4 426,000        9,138         

  

Whichever project you choose, if any, you require a 6 percent return on your investment.
a. What is the payback period for Project A?

   

b. What is the payback period for Project B?
c. What is the discounted payback period for Project A?
d. What is the discounted payback period for Project B?
e. What is the NPV for Project A?
f. What is the NPV for Project B ?

  

g. What is the IRR for Project A?
h. What is the IRR for Project B?
i. What is the profitability index for Project A?
j. What is the profitability index for Project B?

Solutions

Expert Solution

Qa)  Payback period for project A

Years Cashflow Cumulative cashflow
0 -260,730 -260,730
1 27,800 -232,930
2 56,000 -176,930
3 55,000 -121,930
4 426,000 304,070

Payback period= year before full recovery + Cumulative cash flow of the year before recovery / cash flow of year after recovery

= 3 + 121,930 / 426,000

= 3 + 0.29

= 3.29 years

Qb) Payback period of Project B

Years Cash flow Cumulative Cash flow
0 -15,011 -15,011
1 4,942 -10,069
2 8,023 -2,046
3 13,040 10,994
4 9,138 20,132

Payback period= year before full recovery + cumulative cash flow of the year before full recovery / cash flow of the year after recovery

= 2 + 2,046 / 13,040

= 2 + 0.16

= 2.16 years

Qc) Discounted payback period of project A

Years Cashflow(a) Discounting factor (b) Discounted cash flow(a × b) Cumulative discounted Cashflow
0 -260,730 - -260,730 -260,730
1 27,800 0.943 26,215.4 -234,514.6
2 56,000 0.890 49,840 -184,674.6
3 55,000 0.840 46,200 -138,474.6
4 426,000 0.792 337,392 198,917.4

Discounted payback period = year before full recovery + Cumulative discounted cashflow in the year before full recovery / discounted cash flow of the year after full recovery

= 3 + 138,474.6 / 198,917.4

= 3 + 0.70

= 3.70 years

Qd) Discounted payback period of project B

Years Cashflow ( a) Discounting factor (b) Discounted Cashflow (a × b) Cumulative discounted Cash flow
0 -15,011 0 -15,011 -15,011
1 4,942 0.943 4,660.31 -10,350.69
2 8,023 0.890 7,140.47 -3,210.22
3 13,040 0.840 10,953.6 7,743.38
4 9,138 0.792 7,237.3 14,980.68

Discounted payback period = Year before full recovery + Cumulative discounted cash flow in the year before full recovery / discounted cash flow of the year after full recovery

= 2 + 3,210.22 / 10,953.60

= 2 + 0.29

= 2.29 year

Note :- Using PVF table for discounting factors

Answer may differ , due to discounting factor for project A (answer when using financial calculator for project A discounted payback  = 3.41 years)


Related Solutions

Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$ 364,000 –$ 52,000 1 46,000 25,000 2 68,000 22,000 3 68,000 21,500 4 458,000 17,500 Whichever project you choose, if any, you require a return of 11 percent on your investment. a-1. What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)    a-2. If you apply the payback criterion, which...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$199,124        –$15,993          1 25,800        5,691          2 51,000        8,855          3 54,000        13,391          4 416,000        8,695             Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A?     b. What is the payback period for Project B? c. What is the discounted...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$ 360,000 –$ 45,000 1 35,000 23,000 2 55,000 21,000 3 55,000 18,500 4 430,000 13,600    Whichever project you choose, if any, you require a 14 percent return on your investment.    a-1 What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)    Payback period   Project A years     Project...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$251,835        –$15,247          1 25,100        4,828          2 55,000        8,358          3 50,000        13,472          4 385,000        8,102             Whichever project you choose, if any, you require a 6 percent return on your investment. a.What is the discounted payback period for Project A? b.What is the discounted payback period for Project B?
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$251,835        –$15,247          1 25,100        4,828          2 55,000        8,358          3 50,000        13,472          4 385,000        8,102             Whichever project you choose, if any, you require a 6 percent return on your investment. a.What is the discounted payback period for Project A? b.What is the discounted payback period for Project B?
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$216,888        –$15,026          1 26,900        4,016          2 51,000        8,270          3 54,000        13,423          4 420,000        9,668             Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A?     b. What is the payback period for Project B? c. What is the discounted...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$ 345,000 –$ 48,500 1 50,000 24,500 2 70,000 22,500 3 70,000 20,000 4 445,000 15,100    Whichever project you choose, if any, you require a 14 percent return on your investment.    a-1 What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)    Payback period   Project A years     Project...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$ 430,000 –$ 74,000 1 78,000 32,000 2 98,000 30,000 3 73,000 27,500 4 448,000 22,600 Whichever project you choose, if any, you require a 15% return on your investment. a-1. What is the payback period for each project? (Round the final answers to 2 decimal places.) Payback Period Project A years Project B years a-2. If you apply the payback criterion, which investment will...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 $...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 $ -450,000 $ -80,000 1 90,000 34,000 2 110,000 32,000 3 75,000 29,500 4 450,000 24,600 Whichever project you choose, if any, you require a 15% return on your investment. a-1. What is the payback period for each project? (Round the final answers to 2 decimal places.) Payback Period Project A years Project B years b-1. What is the discounted payback period for each project?...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$335,008        –$15,743          1 28,200        5,321          2 53,000        8,353          3 53,000        13,945          4 412,000        8,958             Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A?     b. What is the payback period for Project B? c. What is the discounted...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT