Question

Calculate NPV, payback period and IRR for the following project given a required return of 10%:...

Calculate NPV, payback period and IRR for the following project given a required return of 10%:

Project z
Time 0 1 2 3 4 5
Cash Flow -11,000 6,230 4,120 1,530 3,500 990

Homework Answers

Answer #1

1)

NPV = Present value of cash inflows - present value of cash outflows

NPV = -11,000 + 6,230 / (1 + 0.1)1 + 4,120 / (1 + 0.1)2 + 1,530 / (1 + 0.1)3 + 3,500 / (1 + 0.1)4 + 990 / (1 + 0.1)5

NPV = $2,223.37

2)

Cumulative cash flow for year 0 = -11,000

Cumulative cash flow for year 1 = -11,000 + 6,230 = -4,770

Cumulative cash flow for year 2 = -4,770 + 4,120 = -650

Cumulative cash flow for year 3 = -650 + 1,530 = 880

650 / 1,530 = 0.42

Payback period = 2 + 0.42 = 2.42 years

3)

IRR is the rate of return that makes NPV equal to 0

NPV = -11,000 + 6,230 / (1 + R)1 + 4,120 / (1 + R)2 + 1,530 / (1 + R)3 + 3,500 / (1 + R)4 + 990 / (1 + R)5

Using trial and error method, i.e., after trying various values for R, lets try R as 20.13%

NPV = -11,000 + 6,230 / (1 + 0.2013)1 + 4,120 / (1 + 0.2013)2 + 1,530 / (1 + 0.2013)3 + 3,500 / (1 + 0.2013)4 + 990 / (1 + 0.2013)5

NPV = 0

Therefore, IRR is 20.13%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Given the following cash flows for a capital project, calculate the NPV and IRR. The required...
Given the following cash flows for a capital project, calculate the NPV and IRR. The required rate of return is 8 percent. Year 0 1 2 3 4 5 Cash Flows $-37004 $11550 $12750 $16800 $10700 $5350 NPV=4947. IRR=18.0% NPV=4947. IRR=9.9% NPV=9464. IRR=9.9% NPV=9464. IRR=18.0%
Compute the Payback period, NPV, IRR, and PI and give accept/reject decision for the following project....
Compute the Payback period, NPV, IRR, and PI and give accept/reject decision for the following project. The cost of capital is 10 percent. Assume the policy payback period is 3 years. Year Cash Inflow (Outflow) 0 (400) 1 100 2 200 3 200 4 300
(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 ​$75,000 and expected free cash flows of ​$26,000 at the end of each year for 5 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​?
Please show your steps! Question 1 a) What is the NPV, IRR, and payback period of...
Please show your steps! Question 1 a) What is the NPV, IRR, and payback period of a project with the following cash flows if WACC is 20%? Time: 0 1 2 3 4 5 -$350,000 $100,000 $100,000 $100,000 $50,000 $50,000 NPV= IRR= Payback period= b) Should you accept or reject the project according to NPV and IRR? *can you please include greater than an less than signs.* Thank you.
A project has the following cash flows. What is the payback period, NPV, PI, IRR, MIRR,...
A project has the following cash flows. What is the payback period, NPV, PI, IRR, MIRR, and EAA? Assume an interest rate of 5%. Year CF ($) 0) -5,000 1). 2,700 2). 3,300 3) 1,400 4). 330 5) 340 Also upload your excel files showing your work.
​(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 ​$26,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​? a. The​ project's payback period is nothing years.  ​(Round...
The NPV and payback period Suppose you are evaluating a project with the cash inflows shown...
The NPV and payback period Suppose you are evaluating a project with the cash inflows shown in the following table. Your boss has asked you to calculate the project’s net present value (NPV). You don’t know the project’s initial cost, but you do know the project’s regular, or conventional, payback period is 2.50 years. The project's annual cash flows are: Year Cash Flow Year 1 $400,000 Year 2 600,000 Year 3 500,000 Year 4 475,000 If the project’s desired rate...
 LO 3 LO 4 7. Calculating NPV and IRR. A project that provides annual cash...
 LO 3 LO 4 7. Calculating NPV and IRR. A project that provides annual cash flows of $2,620 for eight years costs $9,430 today. Is this a good project if the required return is 8 percent? What if it's 24 percent? At what discount rate would you be indifferent between accepting the project and rejecting it?  LO 4 9. Calculating NPV. For the cash flows in the previous problem, what is the NPV at a discount rate of...
​Payback, NPV, and IRR: Rieger International is evaluating the feasibility of investing ​$96,000 in a piece...
​Payback, NPV, and IRR: Rieger International is evaluating the feasibility of investing ​$96,000 in a piece of equipment that has a 5​-year life. The firm has estimated the cash inflows associated with the proposal as shown in the following​ table: The firm has a 8% cost of capital. a.  Calculate the payback period for the proposed investment. b.  Calculate the net present value​ (NPV) for the proposed investment. c.  Calculate the internal rate of return ​(IRR)​, rounded to the nearest...
to evaluate a project which would be the most accurate measure NPV, IRR, or payback period...
to evaluate a project which would be the most accurate measure NPV, IRR, or payback period also which is the easiest to calculate without a computer