Question

Consider an asset expected to generate the following finite set of cash flows.             0                 &nbsp

Consider an asset expected to generate the following finite set of cash flows.

            0                      1                      2                      3                      4                      5          years

            |---------------     |----------------   |----------------   |----------------   |----------------- |

            -$11500           $1500              $7500              $1200              $1200              $4800

As shown on the timeline, the cost of the asset is $11,500. Assume a required rate of return of 10% per year, compounded annually.

A.        Calculate the net present value (NPV) of this set of cash flows.

B.        Calculate the internal rate of return (IRR) of the set of cash flows.

C.        Based on the NPV, should the company invest in this asset? Why or why not?

D.        Based on the IRR, should the company invest in this asset? Why or why not?

Homework Answers

Answer #1

a)

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

NPV = -11,500 + 1,500 / (1 + 0.1)1 + 7,500 / (1 + 0.1)2 + 1,200 / (1 + 0.1)3 + 1,200 / (1 + 0.1)4 + 4,800 / (1 + 0.1)5

NPV = $763.60

b)

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

NPV = -11,500 + 1,500 / (1 + R)1 + 7,500 / (1 + R)2 + 1,200 / (1 + R)3 + 1,200 / (1 + R)4 + 4,800 / (1 + R)5

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

NPV = -11,500 + 1,500 / (1 + 0.1255)1 + 7,500 / (1 + 0.1255)2 + 1,200 / (1 + 0.1255)3 + 1,200 / (1 + 0.1255)4 + 4,800 / (1 + 0.1255)5

NPV = 0

Therefore IRR is 12.55%

c)

Company should invest as the project has a positive NPV.

d)

Company should invest as the IRR is greater that cost of capital

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
Q1.) What is the payback period for the following set of cash flows? Year Cashflow 0...
Q1.) What is the payback period for the following set of cash flows? Year Cashflow 0 -$3900 1 1500 2 1400 3 1800 4 1800 Q2.) An investment project costs $14,400 and has annual cash flows of $4,200 for six years. What is the discounted payback period if the discount rate is 5 percent? Q3.)A project has projected cash flows of –$28,800, $10,400, $13,100, $15,000, $12,100 and –$8,600 for years 0 to 5, respectively. Should this project be accepted based...
. (NPV,IRR)A company can invest $1,600,000 in a capital budgeting project that will generate the following...
. (NPV,IRR)A company can invest $1,600,000 in a capital budgeting project that will generate the following forecasted cash flows: Year Cash flow 1 $500,000 2 720,000 3 300,000 4 600,000 The company has a 13% cost of capital. a. Calculate the project’s net present value. b. Calculate the project’s internal rate of return. c. Should the firm accept or reject the project? d. What is the value added to the firm if it accepts this proposed investment?
Find the NPV of an asset which costs $100,000, and is expected to generate net cash...
Find the NPV of an asset which costs $100,000, and is expected to generate net cash flows of $50,000 for each of the next three years. The discount rate is 12%. Indicate whether the asset should be purchased.
A project costs $5,000 at t = 0 and will generate annual cash flows of $750...
A project costs $5,000 at t = 0 and will generate annual cash flows of $750 for 10 years, starting at t = 1. The discount rate is 6%. What is the NPV? What is the IRR? (Write down the equation for the IRR and get the solution using Excel or the calculator.) A project costs $5,000 and will generate annual cash flows of $200 in the first year, $300 in the second year and $400 in the third year....
Project P costs $15,000 and is expected to produce benefits (cash flows) of $4,500 per year...
Project P costs $15,000 and is expected to produce benefits (cash flows) of $4,500 per year for five years. Project Q costs $37,500 and is expected to produce cash flows of $11,100 per year for five years. Calculate each project’s (a) net present value (NPV), (b) internal rate of return (IRR), and (c) mod- ified internal rate of return (MIRR). The firm’s required rate of return is 14 percent.  Compute the (a) NPV, (b) IRR, (c) MIRR, and (d) discounted payback...
Company ABC is considering a project with the following projected cash flows (in thousands): Year 0:...
Company ABC is considering a project with the following projected cash flows (in thousands): Year 0: -$60 Year 1: 10 Year 2: 20 Year 3: 30 Year 4: 40 Year 5: -$25 a. Assuming a 10% hurdle rate, the NPV for the project is b. Assuming a 10% hurdle rate, the IRR for company ABC project is: c. Based on the NPV calculation (10% hurdle rate) , should company ABC undertake the project d. Based on the IRR calculation (10%...
2. A company is considering a project that has the following cash flows: C0 = -3,000,...
2. A company is considering a project that has the following cash flows: C0 = -3,000, C1 = +900, C2 = +500, C3 = +1,100, and C4 = +1,900, with a risk-adjusted discount rate of 8%. A) Calculate the Net Present Value (NPV), Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), and Profitability Index (PI) of this project. B) If you were the manager of the firm, will you accept or reject the project based on the...
Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the...
Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project’s IRR. Consider the following situation: Fuzzy Button Clothing Company is analyzing a project that requires an initial investment of $500,000. The project’s...
You are considering an investment with the following cash flows. If the required rate of return...
You are considering an investment with the following cash flows. If the required rate of return for this investment is 16.5 percent, should you accept the investment based solely on the internal rate of return rule? Why or why not? Year: 0, 1, 2, 3 Cash Flow: -152000, 98,200, 102,300, -4,900 A. Yes; The IRR exceeds the required return. B. Yes; The IRR is less than the required return. C. No; The IRR is less than the required return. D....
Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows:   ...
Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows:    Year Cash Flow 0 –$ 43,000,000 1 67,500,000 2 – 18,000,000    a. If the company requires a return of 11 percent on its investments, what is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)    NPV            $    b. Compute the IRRs for this project. (Do not round intermediate calculations and...