Question

In: Finance

What is the payback period, NPV, IRR of A. Using this information, should we accept Project...

What is the payback period, NPV, IRR of A. Using this information, should we accept Project A. Why or why not.

Given the following information answer the question above. The discount rate is 10 percent.

     PROJECT A      

t           Cash Flow      

0          (150,000)       

1          40,000          

2          40,000             

3          40,000         

4           40,000          

5            40,000              

ROUND TO NEAREST DOLLAR OR TEN %

Solutions

Expert Solution

NPV of a project= PV of cash inflows - PV of cash outflows

= cash flow per year*annuity factor(10%, 5 years) - initial investment

= 40,000*3.791 - 1,50,000= $1,640 (approx)

Since the NPV is positive, hence the project should be accepted.

Payback Period= initial investment/ annual cash inflows

= 1,50,000/ 40,000= 3.75 years

This means that if we invest in this project, it will taken 3 years and 9 months to recover the initial investment in the form of annual cash flows.

Internal Rate of Return (IRR)= It is the discount rate at which the PV of cash inflows is equal to the PV of cash outflows, i.e, NPV=0.

This is computed by trial and error method, i.e, taking a rate and applying the same to check if the NPV is equal to 0. Let the required IRR be r :

-1,50,000+ 40,000/(1+r) + 40,000/(1+r)^2 + 40,000/(1+r)^3 + 40,000/(1+r)^4 + 40,000/(1+r)^5 = 0

Putting r=10%, we get NPV= 1640

Putting r=10.5%, we get NPV= -286

Hence, we can say that the IRR lies in between 10% and 10.5%.

We will apply interpolation technique to find this rate, as follows, by applying the following formula:

IRR = L + (A/ (A-B)) X (H-L)

Where,

L = Lower Discount Rate

H = Higher Discount Rate

A = NPV at Lower Discount Rate

B = NPV at Higher Discount Rate

hence, as per the question, IRR= 10 + (1640/ (1640- (-286))) * (10.5-10) = 10.42% (approx)

As per the above results, since we are assessing one particular project, hence NPV is a good technique to take a decision. Since the NPV is positive, we should accept the project.


Related Solutions

If these two projects are mutually exclusive, which project should the company accept based on the NPV, IRR, MIRR, payback, and discounted payback period for each project?
Considering the following projects.ProjectYear01234ACash flows-$100$35$35$35$35BCash flows-$100$60$50$40$30Project A has WACC = 6.00% while project B has WACC = 8.50%.If these two projects are mutually exclusive, which project should the company accept based on the NPV, IRR, MIRR, payback, and discounted payback period for each project?Would your decision (Your answer from part A) change if these two projects were independent?
IN EXCEL< SHOW THE FORMULAS > Determine the Payback period, NPV and IRR for both project...
IN EXCEL< SHOW THE FORMULAS > Determine the Payback period, NPV and IRR for both project A and B (show work). Which Project would you select and why? Be specific. Project A will require an initial investment of $ 200,000 and Project B will require and initial investment of $ 325,000. The cost of capital for both projects is 12%. The cash inflows for the next 5 years are listed below: Project A Project B 0 ($200,000) ($325,000) 1 $50,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...
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...
(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​?
For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each...
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. Risk free rate = 1.10%, MRP = 9.5%, Required return = 14.40% Yes excel is fine Expected cash flows for the four potential projects that Avalon is...
(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​?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT