Question

In: Finance

1. a. Calculate the IRR for the following project if its cost was $5,000 and the...

1.

a. Calculate the IRR for the following project if its cost was $5,000 and the annual expenditures and costs were:

Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
2,000 2,000 2,000 2,000 -1,000

-1,000

b. Assume a firm's WACC is 10 percent. Calculate the NPV for the following project if its cost was $5,000 and the annual expenditures and costs were:

Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
2,000 2,000 2,000 2,000 -1,000 -1,000

c. Assume you think the expected rate of return is too high. What should you do?

Group of answer choices

Do nothing.

Not enough information to say.

Sell the stock if you own it.

Buy the stock.

Solutions

Expert Solution

a. Guessing the rates between 10% and 13%

IRR using interpolation = Lowest Discount Rate + [NPV at Lower rate /(NPV at Lower Rate - NPV at Higher Rate) * (Difference in rate)]

= 10% + [ 154.34 /(154.34- (-74.13)) * (13-10)]

= 12.03%

Workings:

Year Cash flows PV Factor @10% Discounted cash flows
0 -5,000 1 -5000
1 2000 0.9090909 1818.181818
2 2000 0.8264463 1652.892562
3 2000 0.7513148 1502.629602
4 2000 0.6830135 1366.026911
5 -1000 0.6209213 -620.9213231
6 -1000 0.5644739 -564.4739301
NPV 154.3356396
Year Cash flows PV Factor @13% Discounted cash flows
0 -5,000 1 -5000
1 2000 0.8849558 1769.911504
2 2000 0.7831467 1566.293367
3 2000 0.6930502 1386.100325
4 2000 0.6133187 1226.637455
5 -1000 0.5427599 -542.759936
6 -1000 0.4803185 -480.3185274
NPV -74.13581235

b. NPV = $154. 34

Year Cash flows PV Factor @10% Discounted cash flows
0 -5,000 1 -5000
1 2000 0.9090909 1818.181818
2 2000 0.8264463 1652.892562
3 2000 0.7513148 1502.629602
4 2000 0.6830135 1366.026911
5 -1000 0.6209213 -620.9213231
6 -1000 0.5644739 -564.4739301
NPV 154.34

c. Option ,Buy the stock. [ The stock will be selling at a lower price when the expected rate is too high to attract investors]


Related Solutions

Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial...
Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial Investment: -100,000 Annual project cash flow 22,000 for 6 years Cost of capital is 6%
Calculate the IRR for the following project: a. An initial outflow of $15,220 followed by inflows...
Calculate the IRR for the following project: a. An initial outflow of $15,220 followed by inflows of $5,000, $6,000, and $6,500 b. An initial outflow of $47,104 followed by inflows of $16,000, $17,000, and $18,000.
If your firm were to consider investing in the following project, calculate the NPV, IRR, and...
If your firm were to consider investing in the following project, calculate the NPV, IRR, and Payback values. Would this be a good investment for your company? PROJECT CASH FLOWS AND VALUES FOR A PROPOSED NEW PRODUCTION FACILITY: In year 0, invest $1,000,000 for a new production facility. The project will also require an investment of $50,000 into Net Working Capital. (Assume regular conditions of liquidation at project end.) The project is forecasted to last 4 years. Facility investment is...
Calculate the IRR for the following proposal: Machine cost $4,500,000 Set up cost $30,000 Training cost...
Calculate the IRR for the following proposal: Machine cost $4,500,000 Set up cost $30,000 Training cost $30,000 Annual maintenance cost $15,000 Anticipated annual savings $477,000 Annual labor savings $40,000 Useful life in years 8 Overhaul cost in year 4 $30,000 Annual operating cost $27,000 Hurdle rate 8% Salvage value $50,000 Depreciation method straight line
sparta corp. has a prospective project with an irr of 7.25%. its cost of preferred equity,...
sparta corp. has a prospective project with an irr of 7.25%. its cost of preferred equity, cost of common equity, and post-tax cost of debt are 7%, 9%, and 4%, respectively, and sparta raises equal amounts of funding from all these three sources. choose the best statement: A- the project’s required rate of return must be greater than 7.25%. B- the project’s net present value (npv) must be $0. C- the project’s npv must be negative. D- the project’s npv...
1. Compute the NPV of a project with the following information. The IRR is 9%. The...
1. Compute the NPV of a project with the following information. The IRR is 9%. The project life is 3 years. The initial cost is $19,000. In years 1 and 2 the cash inflows are $4,500 and $5,500, respectively. Cash flow in year 3 is missing. WACC is 12%.
Number 1: Explain the answers to the following: (a) If the IRR of a project exceeds...
Number 1: Explain the answers to the following: (a) If the IRR of a project exceeds the required rate of return, what do you know about the Modified Internal Rate of Return? (b). Why should funds raised to satisfy the additional funds needed be considered long term funds?
Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1...
Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1 = 10 = CF2 = CF3 = CF4 = CF5 = CF6 = CF7 = CF8 = CF9, and CF10 = -65. In Excel, plot the NPV against r (= discount rate), using r = 0%, 2%, 4%, 6%, 8%, 10%, 12%, 14%, 16%, 18%, 20%, 22%, 24%, 26%, 28%, and so on until you find all IRRs on the horizontal axis. Approximately, what...
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...
. For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For...
. For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each capital budgeting decision tool, indicate if the project should be accepted or rejected, assuming that each project is independent of the others. Important Note: The venture capital folks have a firm maximum payback period of four years.          Project A= Required rate of Return= 16.30% Project B= R= 12.50% Project C= R= 15.35% Project D= R= 17.25%      Expected cash flows for the four...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT