Question

In: Finance

(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 ​$85,000 and expected free cash flows of ​$25,000 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​?

Solutions

Expert Solution

a.Payback Period = ( Last Year with a Negative Cash Flow ) + [( Absolute Value of negative Cash Flow in that year)/ Total Cash Flow in the following year)]

= 3 + (10000/25000)

= 3.40 years

Hence the correct answer is 3.40 years

Note:

Year Investment Cash Inflow Net Cash Flow
0 -85,000.00 -    -85,000.00 (Investment + Cash Inflow)
1 -    25,000.00 -60,000.00 (Net Cash Flow + Cash Inflow)
2 -    25,000.00 -35,000.00 (Net Cash Flow + Cash Inflow)
3 -    25,000.00 -10,000.00 (Net Cash Flow + Cash Inflow)
4 -    25,000.00 15,000.00 (Net Cash Flow + Cash Inflow)
5 -    25,000.00 40,000.00 (Net Cash Flow + Cash Inflow)
6 -    25,000.00 65,000.00 (Net Cash Flow + Cash Inflow)

b. NPV = Present Value of Cash Inflows - Present Value of Cash Outflows

= [ $ 25,000 * 1/(1.09) ^ 1 +$ 25,000 * 1/(1.09) ^2+$ 25,000 * 1/(1.09) ^3+.......+$ 25,000 * 1/(1.09) ^6] - $ 85,000

= $ 27,147.96

Hence the correct answer is  $ 27,147.96

c. PI = Present Value of Cash Inflows / Present Value of Cash Outflows

= $ 112,147.96 / $ 85,000

= 1.32

Hence the correct answer is 1.32

d. IRR :

Project M

Let the IRR be x.

Now , Present Value of Cash Outflows=Present Value of Cash Inflows

85,000 = 25000/(1.0x) +25000/ (1.0x)^2 +25000/(1.0x)^3+ ............+$ 25000/(1.0x)^6      

Or x= 19.114%

Hence the IRR is 19.11%


Related Solutions

(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​?
​(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 ​$22,000 at the end of each year for 7 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 ​$90,000 and expected free cash flows of ​$26,000 at the end of each year for 6 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 ​$80,000 and expected free cash flows of ​$24,000 at the end of each year for 7 years. The required rate of return for this project is 6 percent. a. What is the​ project's payback​ period? 3.33 years b. What is the​ project's NPV​? ____ c. What is the​ project's PI​? _____ d. What is the​ project's IRR​? _____
NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash outlay of...
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 6 years. The required rate of return for this project is 7 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​?
. 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...
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...
​(​NPV, ​PI, and IRR calculations​) You are considering two independent​ projects, project A and project B....
​(​NPV, ​PI, and IRR calculations​) You are considering two independent​ projects, project A and project B. The initial cash outlay associated with project A is ​$50,000​ and the initial cash outlay associated with project B is ​$70,000 The required rate of return on both projects is 9 percent. The expected annual free cash inflows from each project are in the popup​ window: Calculate the NPV​, PI​, and IRR for each project and indicate if the project should be accepted.   ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT