Question

The yearly cash flow estimates of an investment are shown in the table. a) Use the...

The yearly cash flow estimates of an investment are shown in the table.

a) Use the linear interpolation to derive the rate of return of this investment (initial guess = 15%).

Year 0 1 2 3
Cash flow, $ -80,000 9,000 70,000 30,000

b) If MARR = 20%, is this investment acceptable?

Homework Answers

Answer #1

Let IRR be i%,then

-80000 + 9000*(P/F,i%,1) + 70000*(P/F,i%,2) + 30000*(P/F,i%,3) = 0

Dividing by 10000

0.9*(P/F,i%,1) + 7*(P/F,i%,2) + 3*(P/F,i%,3) = 8

using trail and error method

When i = 15%, value of 0.9*(P/F,i%,1) + 7*(P/F,i%,2) + 3*(P/F,i%,3) = 0.9*0.869565 + 7*0.756144 + 3*0.657516 = 8.048165

When i = 16%, value of 0.9*(P/F,i%,1) + 7*(P/F,i%,2) + 3*(P/F,i%,3) = 0.9*0.862069 + 7*0.743163 + 3*0.640658 = 7.899976

using interpolation

i = 15% + (8.048165-8) /(8.048165-7.899976)*(16%-15%)

i = 15% + 0.32% = 15.32%

b.

As IRR < MARR, investment is not justified

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
For the project shown in the following​ table, calculate the internal rate of return ​(IRR). Then​...
For the project shown in the following​ table, calculate the internal rate of return ​(IRR). Then​ indicate, for the​ project, the maximum cost of capital that the firm could have and still find the IRR acceptable. Initial investment ​(CF 0CF0​) ​$80,000 Year ​(t​) Cash inflows ​(CF Subscript tCFt​) 1 ​$25,000 2 ​$45,000 3 ​$30,000 4 ​$30,000 5 ​$15,000
Two projects have the estimated details as shown in Table 2.2. Construct cash flow diagrams for...
Two projects have the estimated details as shown in Table 2.2. Construct cash flow diagrams for the two projects and use present worth (PW) analysis to determine which project should be selected at the rate of 12% per year Table 2.2: Details for Project R and Project S Project R Project S Initial cost (RM) 30,000 20,000 Annual cost (RM) 7,000 for first year, increasing by 1,000 per year for subsequent years 0 for the first 3 year, 5,000 from...
Internal rate of return For the project shown in the following​ table, calculate the internal rate...
Internal rate of return For the project shown in the following​ table, calculate the internal rate of return ​(IRR). Then​ indicate, for the​ project, the maximum cost of capital that the firm could have and still find the IRR acceptable. The​ project's IRR is ​%. (Round to two decimal​ places.) Initial investment ​(CF 0CF0​) $110,000 Year ​(t​) Cash inflows ​(CF Subscript tCFt​) 1 $25,000 2 $50,000 3 $30,000 4 $35,000 5 $10,000
Internal rate of return. For each of the projects shown in the following table, calculate the...
Internal rate of return. For each of the projects shown in the following table, calculate the internal rate of return (IRR). Then indicate, for each project, the maximum cost of capital that the firm could have and still find the IRR acceptable. Project A Project B Project C Project D Initial investment -$90,000 -$490,000 -$20,000 -$240,000 Year Cash inflows 1 $20,000 $150,000 $7,500 $120,000 2 25,000 150,000 7,500 100,000 3 30,000 150,000 7,500 80,000 4 35,000 150,000 7,500 60,000 5...
The following table describes the cash flow schedule of an investment project. What is the payback...
The following table describes the cash flow schedule of an investment project. What is the payback period? Year Cash Flow 0 1 2 3 4 5 -100,000 30,000 50,000 15,000 7,000 7,000 4.5 years 4 years 3 years 5 years
Table 1 Year 0 1 2 3 Cash Flow -30,000 13,000 9,000 16,500 Use Table 1...
Table 1 Year 0 1 2 3 Cash Flow -30,000 13,000 9,000 16,500 Use Table 1 to answer questions 1-5. 1. What is the IRR? 2. What is the NPV? Assume cost of capital of 8%. 3. What is the Profitability Index? 4. What is the discounted payback period? 5. Invest or do not invest?
Drake Corporation is reviewing an investment proposal. The initial cost is $105,000. Estimates of the book...
Drake Corporation is reviewing an investment proposal. The initial cost is $105,000. Estimates of the book value of the investment at the end of each year, the net cash flows for each year, and the net income for each year are presented in the schedule below. All cash flows are assumed to take place at the end of the year. The salvage value of the investment at the end of each year is assumed to equal its book value. There...
Consider the following cash flows for two mutually exclusive capital investment projects. The required rate of...
Consider the following cash flows for two mutually exclusive capital investment projects. The required rate of return is 15%. Use this Year         Project A Cash Flow        Project B Cash Flow 0                         -$40,000                           -$30,000 1                              12,000                            9,000 2                              12,000                             9,000 3                              12,000                             9,000 4                              10,800      8,100 5                              10,800                              8,100 6                              5,400      8,100 7. What is the profitability index of project B? a) 1.03 b) 1.06 c) .94 d) 1.09 e) 1.117 8. Calculate the net present value of project A. a) $1,564.25 b) $1,227.71 c) $3,802 d) $2,709,21 e) $331.40
Internal rate of return   For the project shown in the following​ table, calculate the internal rate...
Internal rate of return   For the project shown in the following​ table, calculate the internal rate of return ​(IRR). Then​ indicate, for the​ project, the maximum cost of capital that the firm could have and still find the IRR acceptable. Initial investment   $160,000 Year (t)   Cash inflows 1   $35,000 2   $25,000 3   $45,000 4   $45,000 5   $45,000 The​ project's IRR is? The maximum cost of capital that the firm could have and still find the IRR acceptable is?
You have the following investment options as laid out in the table below: Project Cash Flow...
You have the following investment options as laid out in the table below: Project Cash Flow Year A B C D E 0 -$1000 -$1200 -$2000 -$1600 -$1400 1 900 800 950 900 400 2 500 700 950 900 400 3 100 700 950 900 1200 4 50 300 950 900 400 If your MARR is 15%, which of these options should you select? Solve this problem by challenger-defender analysis.