Question

In: Finance

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%

Solutions

Expert Solution

Year Cash flow PVIF @ 6% present value A Cumulative cash flow Discounted Cumulative cash flow
0 -100000     1.0000 (100,000.00) (100,000.00) (100,000.00)
1 22000     0.9434      20,754.72     (78,000.00)     (79,245.28)
2 22000     0.8900      19,579.92     (56,000.00)     (59,665.36)
3 22000     0.8396      18,471.62     (34,000.00)     (41,193.74)
4 22000     0.7921      17,426.06     (12,000.00)     (23,767.68)
5 22000     0.7473      16,439.68      10,000.00       (7,328.00)
6 22000     0.7050      15,509.13      32,000.00         8,181.14
        8,181.14      32,000.00      16,362.27
Ans 1) NPV =         8,181.14
Ans 2) Payback period =                4.55 year
=4+12000/22000
Ans 3) Discounted payback period =
=5+7328/15509.13                4.47 year
Ans 4) IRR = 8.56%
Ans 5) MIRR= 7.40%

jeff jeffy answered 7 months ago
Next > < Previous

Related Solutions

. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial...
. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial cost of $60,000, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 12%. Show your work. a. What is the project’s NPV? (Hint: Begin by constructing a timeline). b. What is the project’s IRR? c. What is the project’s MIRR? d. What is the project’s PI? e. What is the project’s payback period? f. What is...
Calculate the five different criteria for evaluating projects (regular payback, discounted payback, NPV, IRR, and MIRR)...
Calculate the five different criteria for evaluating projects (regular payback, discounted payback, NPV, IRR, and MIRR) for the two projects listed below. The firm’s WACC is 9.90%. If the projects are mutually exclusive and the firm has sufficient budget available, which project (if any) would you choose to proceed with, and why? (Hint: you may want to create the full cash flow table for each project to fully show your work.) periods 0 1 2 3 4 project Hay cash...
Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment...
Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment of $20,000 with expected after-tax operating cash flows of $125,000 per year for each of the next 3 years. However, in preparation for its termination at the end of year 3, an additional investment of $350,000 must be made at the end of Year 2. Please show all work in excel.
Explain how to calculate the capital budgeting criterion (in excel) : NPV, IRR, MIRR, Payback, Discounted...
Explain how to calculate the capital budgeting criterion (in excel) : NPV, IRR, MIRR, Payback, Discounted Payback, Crossover Rate, and decide between mutually exclusive and/or independent projects
Calculations of the NPV, IRR and the payback for the project and an analysis of the...
Calculations of the NPV, IRR and the payback for the project and an analysis of the results. I need the excel formula calculation and analysis of the questions You have identified a potential opportunity for WBC, which involves undertaking a project that will have a ten-year life. The project requires an initial purchase of equipment and furniture totalling $4,500,000, plus ancillary programming capability and machinery costing $1,500,000. The equipment and furniture will depreciate and have a salvage value of $500,000...
. 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...
You evaluate ALL of its projects by applying the Payback, Discounted Payback, NPV, and IRR rules....
You evaluate ALL of its projects by applying the Payback, Discounted Payback, NPV, and IRR rules. Assume the cost of capital is 10%. Assume cash flows of: TIME               CASH FLOWS -------------------------------------------------------------- 0               -$100 1               +$75 2               +$50 3               +$25 What is the payback?                                What is the Discounted Payback?                                What...
(Payback ​period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash...
(Payback ​period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash outlay of ​$90,000 and expected free cash flows of ​$28,000 at the end of each year for 5 years. The required rate of return for this project is 6 percent. a. What is the​ project's payback​ period? b. What is the​ project's NPV​? c. What is the​ project's PI​? d. What is the​ project's IRR​?
(Payback ​period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash...
(Payback ​period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash outlay of ​$80000 and expected free cash flows of ​$25000 at the end of each year for 6 years. The required rate of return for this project is 9 percent. a. What is the​ project's payback​ period? b. What is the​ project's NPV​? c. What is the​ project's PI​? d. What is the​ project's IRR​?
​(Payback period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash...
​(Payback period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash outlay of $70,000 and expected free cash flows of ​$28,000 at the end of each year for 5 years. The required rate of return for this project is 8 percent. a. What is the​ project's payback​ period? b. What is the​ project's NPV​? c. What is the​ project's PI​? d. What is the​ project's IRR​?
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT