sorry to occupy your time, please help me do this question and please step by step so I can understand
Terminal value = CF6*1.015/(0.21-0.015) = 53486.08 | ||||
CF6 = 53486.08*0.195/1.015 = | $ 10,275.65 | |||
Further, 10275.65=7500*(1+g)^5 | ||||
G = (10275.65/7500)^(1/5)-1 = | 6.50% | |||
Therefore initial growth rate = 6.5% | ||||
NPV of the project = -55000+7500/1.21+7500*1.065/1.21^2+7500*1.065^2/1.21^3+7500*1.065^3/1.21^4+7500*1.065^4/1.21^5+7500*1.065^5/1.21^6+53486.08/1.21^6 = | -10281.533 | |||
Alternatively: | ||||
Year | Cash flows | PVIF at 21% | PV at 21% | |
0 | -55000.00 | 1.00000 | -55000.00 | |
1 | 7500.00 | 0.82645 | 6198.35 | |
2 | 7987.50 | 0.68301 | 5455.57 | |
3 | 8506.69 | 0.56447 | 4801.80 | |
4 | 9059.62 | 0.46651 | 4226.38 | |
5 | 9648.50 | 0.38554 | 3719.91 | |
6 | 10275.65 | 0.31863 | 3274.14 | |
Terminal value = 10275.65*1.015/(0.21-0.015) = 53486.08 | 53486.08 | 0.31863 | 17042.31 | |
Projects NPV = | $ -10,281.53 | |||
b) | IRR is that discount rate for which NPV = 0 | |||
Hence, 50000 = 2500/(r-0.025) | ||||
[The formula for PV of growing perpetuity is used] | ||||
Where r = IRR | ||||
r (IRR) = 2500/50000+0.025 = | 7.50% | |||
As the IRR of 7.5% is more than the cost of capital of 6.5%, | ||||
the investment can be accepted per the IRR rule. | ||||
c) | NPV of the Project B = -50000+2500/(0.065-0.025) = | $ 12,500.00 | ||
EAB = 12500*6.5% = | $ 812.50 | |||
NPV of Project C = -60000+9000*(1.065^10-1)/(0.065*1.065^10) = | $ 4,699.47 | |||
EAB = 4699.47*0.065*1.065^10/(1.065^10-1) = | $ 653.72 | |||
As the EAB of Project C is more it is to be chosen. |
sorry to occupy your time, please help me do this question and please step by step...
Please show work, don't give me an excel based response, thank you! Consider a capital expenditure project to purchase and install new equipment with an initial cash outlay of $25,000. The project is expected to generate net after-tax cash flows each year of $6800 for ten years, and at the end of the project, a one-time after-tax cash flow of $11,000 is expected. The firm has a weighted average cost of capital of 12 percent and requires a 3-year payback...
Important: Show your solutions! QUESTION 1: Consider the following two projects: Year Cash Flow (A) Cash Flow (B) -$364,000 -$52,000 25,000 46,000 68,000 22,000 68,000 21,500 458,000 17,500 Whichever project you choose, if any, you require a return of 11 percent on your investment. 1) Suppose these two projects are independent. Which project(s) should you accept based on: a. The Payback rule? Explain. (1096) b. The Profitability Index rule? Explain. (10%) c. The IRR rule? Explain. (10%) d. The NPV...
Please show all work & calculations. Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked you to analyze two proposed capital investments - Project X and Project Y. Each project requires a net investment outlay of $10,000, and the cost of capital for each project is 12 percent. The project's expected net cash flows are as follows: Year 0 1 Project X ($10,000) $6,500 $3,000 $3,000 $1,000 Project Y ($10,000) $3,000 $3,000 $3,000...
please solve and explain how to find IRR Only. and draw the time line for this problem! thanks! 9.6 Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked you to analyze two proposed capital investments-project X and project Y. Each project requires a net investment outlay of $10,000, and the opportunity cost of capital for each project is 12 percent. The projects' expected net cash flows are as follows: Year Project X ($)...
Help and verified and be clear. The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company's CFO remembers that the internal rate of return (IRR) of Project Lambda is...
Newfoundland Vintners Co-operative is considering two mutually exclusive projects: Absinth and Brandy. Project Absinth requires a $20,000 cash outlay today and is expected to generate after-tax cash flows of $11,000 in year 1, $8,500 in year 2, and $7,500 in year 3. Project Brandy requires a $30,000 cash outlay today and is expected to generate after-tax cash flows of $7,000 in year 1, $9,000 in year 2, $11,000 in year 3, and $16,000 in year 4. Neither project can be...
draw time line for answer a 9.6 Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked you to analyze two proposed capital investments - project X and project Y. Each project requires a net investment outlay of $10,000, and the opportunity cost of capital for each project is 12 percent. The projects' expected net cash flows are as follows: Year Project X ($) (10,000) 6,500 3,000 3,000 1,000 Project Y ($) (10,000) 3,000...
draw time line for answer a Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked you to analyze two proposed capital investments-project X and project Y. Each project requires a net investment outlay of $10,000, and the opportunity cost of capital for each project is 12 percent. The projects' expected net cash flows are as follows: 9.6 Project X (S) (10,000) Year Project Y ($) (10,000) 6,500 1 3,000 3,000 3,000 3,000 3,000...
СР, 0 A project's internal rate of return (IRR) is the -Select- that forces the PV of its inflows to equal its cost. The IRR is an estimate of the project's rat of return, and it is comparable to the - Select on a bond. The equation for calculating the IRR is: NPV = CF. + CF + СР + ... + =0 (1 + IRR) (1 + ru (1 + R) CF (1 + IRR) CFt is the expected...
Please help me fill in the last blank UPDATE: This is all the information I have been given. I just need help with the last blank. DCF analysis doesn't always lead to proper capital budgeting decisions because capital budgeting projects are not passive investments like stocks and bonds. Managers can often take positive actions after the investment has been made to alter a project's cash flows. These opportunities are real options that offer the right but not the obligation to...