Question

In: Finance

A firm is evaluating two projects for this year’s capital budget. Its WACC is 14%. Project...

A firm is evaluating two projects for this year’s capital budget. Its WACC is 14%. Project A costs $6,000 and its expected cash inflows would be $2,000 per year for 5 years. Project B costs $18,000 and its expected cash inflows would be $5,600 per year for 5 years. Calculate NPV and IRR for each project.

Refer to problem 7. Calculate the MIRR and payback for each project.

Refer to Problem 7. Calculate the discounted payback for each project.

Refer to Problem 7. If the projects were mutually exclusive, which one would you recommend? If the projects were independent, which one(s) would you recommend? Explain.

Solutions

Expert Solution

PROJECT A:

NPV = Present value of cash inflows - present value of cash outflows

NPV = -6000 + 2000 / ( 1 + 0.14)1 + 2000 / ( 1 + 0.14)2 + 2000 / ( 1 + 0.14)3 + 2000 / ( 1 + 0.14)4 + 2000 / ( 1 + 0.14)5  

NPV = -6000 + 1754.386 + 1538.935 + 1349.943 + 1184.161 + 1038.737

NPV = $866.162

IRR is the rate of return that makes NPV equal to 0

NPV = -6000 + 2000 / ( 1 + R)1 + 2000 / ( 1 + R)2 + 2000 / ( 1 + R)3 + 2000 / ( 1 + R)4 + 2000 / ( 1 + R)5

Using trial and error method, i.e, after trying various values for R, let try R as 19.86

NPV = -6000 + 2000 / ( 1 + 0.1986)1 + 2000 / ( 1 + 0.1986)2 + 2000 / ( 1 + 0.1986)3 + 2000 / ( 1 + 0.1986)4 + 2000 / ( 1 + 0.1986)5

NPV = 0

Therefore IRR is 19.86%

Future value of year 1 cash flow = 2000 ( 1 + 0.14)4 = 3,377.92

Future value of year 2 cash flow = 2000 ( 1 + 0.14)3 = 2,963.088

Future value of year 3 cash flow = 2000 ( 1 + 0.14)2 = 2,599.2

Future value of year 4 cash flow = 2000 ( 1 + 0.14)1 = 2,280

Future value of year 5 cash flow = 2000 ( 1 + 0.14)0 = 2000

Total future value = 2000 + 2,280 + 2,599.2 + 2,963.088 + 3,377.92 = 13,220.208

MIRR = ( ?13,220.208 / 6000)1/5 - 1

MIRR = 1.1712 - 1

MIRR = 0.1712 or 17.12%

Payback period = 6000 / 2000

Payback period = 3 years

Cumulative cash flow for year 0 = -6000

Cumulative cash flow for year 1 = -6000 +  1754.386 = -4,245.614

Cumulative cash flow for year 2 = -4,245.614 + 1538.935 = -2,706.679

Cumulative cash flow for year 3 = -2,706.679 + 1349.943 = -1,356.736

Cumulative cash flow for year 4 = -1,356.736 + 1184.161 = -172.575

Cumulative cash flow for year 5 = -172.575 + 1038.737 = 866.162

172.575 / 1038.737 = 0.166

Discounted payback period = 4 + 0.166 = 4.166 years

PROJECT B:

NPV = Present value of cash inflows - present value of cash outflows

NPV = -18000 + 5600 / ( 1 + 0.14)1 + 5600 / ( 1 + 0.14)2 + 5600 / ( 1 + 0.14)3 + 5600 / ( 1 + 0.14)4 + 5600 / ( 1 + 0.14)5  

NPV = -6000 + 4912.281 + 4309.018 + 3779.84 + 3315.65 + 2908.465

NPV = $1225.254

IRR is the rate of return that makes NPV equal to 0

NPV = -18000 + 5600 / ( 1 + R)1 + 5600 / ( 1 + R)2 + 5600 / ( 1 + R)3 + 5600 / ( 1 + R)4 + 5600 / ( 1 + R)5

Using trial and error method, i.e, after trying various values for R, let try R as 16.8

NPV = -18000 + 5600 / ( 1 + 0.168)1 + 5600 / ( 1 + 0.168)2 + 5600 / ( 1 + 0.168)3 + 5600 / ( 1 + 0.168)4 + 5600 / ( 1 + 0.168)5

NPV = 0

Therefore IRR is 16.8%

Future value of year 1 cash flow = 5600 ( 1 + 0.14)4 = 9,458.177

Future value of year 2 cash flow = 5600 ( 1 + 0.14)3 = 8,296.646

Future value of year 3 cash flow = 5600 ( 1 + 0.14)2 = 7,277.76

Future value of year 4 cash flow = 5600 ( 1 + 0.14)1 = 6,384

Future value of year 5 cash flow = 5600 ( 1 + 0.14)0 = 5600

Total future value = 5600 + 6,384 + 7,277.76 + 8,296.646 + 9,458.177 = 37,016.583

MIRR = ( ?37,016.583 / 18000)1/5 - 1

MIRR = 1.1551 - 1

MIRR = 0.1551 or 15.51%

Payback period = 18000 / 5600

Payback period = 3.21 years

Cumulative cash flow for year 0 = -18000

Cumulative cash flow for year 1 = -18000 +  4912.281 = -13,087.719

Cumulative cash flow for year 2 = -13,087.719 + 4309.018 = -8,778.539

Cumulative cash flow for year 3 = -8,778.539 + 3779.84 = -4,998.699

Cumulative cash flow for year 4 = -4,998.699 + 3315.65 = -1,683.049

Cumulative cash flow for year 5 = -1,683.049 + 2908.465 = 1,225.416

1,683.049 / 2908.465 = 0.579

Discounted payback period = 4 + 0.579 = 4.579 years

If the projects were mutually exclusive, we always go by the NPV rule. Project B has a higher NPV, therefore project B should be accepted.

If the projects were independent, both projects should be accepted as both projects has positive NPV, IRR and MIRR greater tha cost of capital.

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

A firm is evaluating two projects for this year’s capital budget. Its WACC is 14%. Project...
A firm is evaluating two projects for this year’s capital budget. Its WACC is 14%. Project A costs $6,000 and its expected cash inflows would be $2,000 per year for 5 years. Project B costs $18,000 and its expected cash inflows would be $5,600 per year for 5 years. Calculate NPV and IRR for each project. Refer to problem 7. Calculate the MIRR and payback for each project. Refer to Problem 7. Calculate the discounted payback for each project. Refer...
A firm with a 14% WACC is evaluating two projects for this year’s capital budget. After-tax...
A firm with a 14% WACC is evaluating two projects for this year’s capital budget. After-tax cash flows, including depreciation, are as follows: PROJECT A: year 0 = -$6000 | year 1 = $2000 | year 3 = $2000 | year 4 = $2000 | year 5 = $2000 PROJECT B: Year 0 = -$18,000 | Year 1 = $5600 | Year 2 = $5600 | year 3 = $5600 | year 4 = $5600 | year 5 = $5600...
Coriander with a 14% WACC is evaluating two projects for this year’s capital budget. After-tax cash...
Coriander with a 14% WACC is evaluating two projects for this year’s capital budget. After-tax cash flows, including depreciation are as follows: Year Project A Project B O -$6000 -$18,000 1 $2000 $5,600 2 $2000 $5,600 3 $2000 $5,600 4 $2000 $5,600 5 $2000 $5,600 a. Calculate NPV and IRR for each project b. Assuming the projects are independent which one (s) would you recommend? c. If the projects are mutually exclusive, which would you recommend?
eBook A firm with a 14% WACC is evaluating two projects for this year's capital budget....
eBook A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 0 1 2 3 4 5 Project M -$21,000 $7,000 $7,000 $7,000 $7,000 $7,000 Project N -$63,000 $19,600 $19,600 $19,600 $19,600 $19,600 Calculate NPV for each project. Do not round intermediate calculations. Round your answers to the nearest cent. Project M:    $   Project N:    $   Calculate IRR for each project. Do not round intermediate calculations. Round your answers...
A firm with a 14% WACC is evaluating two projects for this years capital budget. After...
A firm with a 14% WACC is evaluating two projects for this years capital budget. After tax cash flows, including depreciation, are as follows: 0 1 2 3 4 5 Project M -$30,000 $10,000 $10,000 $10,000 $10,000 $10,000 Project N -$90,000 $28,000 28,000 $28,000 $28,000 $28,000 1) What is the MIRR? 2) If the projects are mutually exclusive, which would you recommend? 3) Notice that the projects have the same cash flow timing pattern. Why is there a conflict between...
A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax...
A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 0 1 2 3 4 5 Project M -$30,000 $10,000 $10,000 $10,000 $10,000 $10,000 Project N -$90,000 $28,000 $28,000 $28,000 $28,000 $28,000 Calculate NPV for each project. Do not round intermediate calculations. Round your answers to the nearest cent. Project M:    $   Project N:    $   Calculate IRR for each project. Do not round intermediate calculations. Round your answers to...
A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax...
A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 0 1 2 3 4 5 Project M -$6,000 $2,000 $2,000 $2,000 $2,000 $2,000 Project N -$18,000 $5,600 $5,600 $5,600 $5,600 $5,600 Calculate NPV for each project. Do not round intermediate calculations. Round your answers to the nearest cent. Project M:    $   Project N:    $   Calculate IRR for each project. Do not round intermediate calculations. Round your answers to...
A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax...
A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 0 1 2 3 4 5 Project M -$18,000 $6,000 $6,000 $6,000 $6,000 $6,000 Project N -$54,000 $16,800 $16,800 $16,800 $16,800 $16,800 Calculate NPV for each project. Round your answers to the nearest cent. Do not round your intermediate calculations. Project M    $ Project N    $ Calculate IRR for each project. Round your answers to two decimal places. Do...
A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax...
A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: Project M -$27,000 $9,000 $9,000   $9,000 $9,000   $9,000 Project N -$81,000 $25,200 $25,200 $25,200 $25,200 $25,200 Calculate NPV for each project. Do not round intermediate calculations. Round your answers to the nearest cent. Calculate M $_____ Calculate N $______ Calculate IRR for each project. Do not round intermediate calculations. Round your answers to two decimal places. Calculate...
A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax...
A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 0 1 2 3 4 5 Project M -$6,000 $2,000 $2,000 $2,000 $2,000 $2,000 Project N -$18,000 $5,600 $5,600 $5,600 $5,600 $5,600 Calculate NPV for each project. Round your answers to the nearest cent. Do not round your intermediate calculations. Project M    $ Project N    $ Calculate IRR for each project. Round your answers to two decimal places. Do...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT