Question

In: Finance

An analyst identifies the following cash flows for an average-risk project: • Year 0 -$5,000 •...

An analyst identifies the following cash flows for an average-risk project:

• Year 0 -$5,000
• Year 1-2 $1,900
• Year 3 $2,500
• Year 4 $2,000

22. If the company’s cost of capital is 12%, the project’s discounted payback period is closest to: *

A. 2.5 years

B. 3.0 years

C. 3.9 years

D. None of the above

23. If the company’s cost of capital is 12%, the project’s Modified Internal Rate of Return is closest to: *

A. 14.48%

B. 18.00%

C. 12.48%

D. 18.48%

E. None of the above

Solutions

Expert Solution

22) B. 3.0 Years
Working:
Year Cash flow Discount factor Discounted cash flow Cumulative Discounted cash flow
x a b=1.12^-a c=a*b d
0 -5,000.00              1.000 -5,000.00 -5,000.00
1     1,900.00              0.893    1,696.43 -3,303.57
2     1,900.00              0.797    1,514.67 -1,788.90
3     2,500.00              0.712    1,779.45           -9.45
4     2,000.00              0.636    1,271.04    1,261.58
Discounted payback period = 3+(9.45/1271.04)
=               3.0
23) D. 18.48%
Working:
Year Cash flow
0 -5,000.00
1     1,900.00
2     1,900.00
3     2,500.00
4     2,000.00
Finance Rate 12%
Reinvestment Rate 12%
=mirr(C23:C27,finance rate, reinvestment rate)
= 18.48%
Note:
C23:C27 is the value of cash flow from year 0 to 4.

Related Solutions

A hospital’s project has the following expected cash flows Year Cash flow 0 ($5,000) 1 $1,000...
A hospital’s project has the following expected cash flows Year Cash flow 0 ($5,000) 1 $1,000 2 $2,000 3 $3,000 If the cost of capital is 12%, should the project be undertaken? Show your calculations
A project has the following cash flows. This project is of average risk and the WACC...
A project has the following cash flows. This project is of average risk and the WACC is 0.1. Find the Net Present Value. Round your answer to two decimal places. Year 0 Year 1 Year 2 Year 3 Cash Flow -$91 $50 $40 $7
Project Y has following cash flows:  C 0 = -800,  C 1 = +5,000, and  C 2 = -5,000....
Project Y has following cash flows:  C 0 = -800,  C 1 = +5,000, and  C 2 = -5,000. Calculate the IRRs for the project. 25 percent and 400 percent. 125 percent and 500 percent. -44 percent and 11.6 percent. No IRRs exist for this project.
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 380 ?$ 380 1 210 280 2 210 280 3 210 280 4 210 If the opportunity cost of capital is 11%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 280 ?$ 280 1 160 180 2 160 180 3 160 180 4 160 If the opportunity cost of capital is 10%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.) Project A Profitability Index Project B
The following are the cash flows of two projects: Year Project A Project B 0 −$...
The following are the cash flows of two projects: Year Project A Project B 0 −$ 290 −$ 290 1 170 190 2 170 190 3 170 190 4 170 If the opportunity cost of capital is 11%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
The following are the cash flows of two projects: Year Project A Project B 0 $...
The following are the cash flows of two projects: Year Project A Project B 0 $ (330) $ (330) 1 160 230 2 160 230 3 160 230 4 160 If the opportunity cost of capital is 12%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.) Project Profitability Index: A B
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 220 ?$ 220 1 100 120 2 100 120 3 100 120 4 100 If the opportunity cost of capital is 10%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
The following are the cash flows of two projects: Year Project A Project B 0 $...
The following are the cash flows of two projects: Year Project A Project B 0 $ (260 ) $ (260 ) 1 140 160 2 140 160 3 140 160 4 140 a. Calculate the NPV for both projects if the opportunity cost of capital is 16%. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Project A Project B b. Suppose that you can choose only one of these projects. Which would you choose? Project A...
The following are the cash flows of two projects: Year Project A Project B 0 $...
The following are the cash flows of two projects: Year Project A Project B 0 $ (330 ) $ (330 ) 1 160 230 2 160 230 3 160 230 4 160 a. If the opportunity cost of capital is 12%, calculate the NPV for both projects. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Which of these projects is worth pursuing? ****NOTE**** You are finding the NPV, NOT the Profitability index!
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT