Question

In: Economics

For the alternatives shown below, determine the incremental rate of return for cash flows for Q...

For the alternatives shown below, determine the incremental rate of return for cash flows for Q – P.

Alternative P

Alternative Q

First cost, $

-50,000

-85,000

Annual operating cost, $ per year

-8,600

-2,000

Annual revenue, $ per year

22,000

45,000

Salvage value, $

3,000

8,000

Life, years

2

3

Solutions

Expert Solution

We have the following information

Alternative P

Alternative Q

First cost, $

-50,000

-85,000

Annual operating cost, $ per year

-8,600

-2,000

Annual revenue, $ per year

22,000

45,000

Salvage value, $

3,000

8,000

Life, years

2

3

Alternative P

Initial Cost (P) = $50,000

Annual Operating Cost (C) = $8,600

Annual Revenue (R) = $22,000

Salvage Value (S) = $3,000

Life (n) = 2

Assuming rate of return of 0.5% or 0.005

Present Worth (PW) = – P – C(P/A, 0.5%, 2) + R(P/A, 0.5%, 2) + S(P/F, 0.5%, 2)

PW = – 50,000 – 8,600(P/A, 0.5%, 2) + 22,000(P/A, 0.5%, 2) + 3,000(P/F, 0.5%, 2)

PW = – 50,000 – 8,600[((1 + 0.005)2 – 1)/0.005(1 + 0.005)2] + 22,000[((1 + 0.005)2 – 1)/0.005(1 + 0.005)2] + 3,000/(1 + 0.005)2

PW = – 50,000 – (8,600 × 1.9851) + (22,000 × 1.9851) + (3,000 × 0.9901)

PW = – 50,000 – 17,071.86 + 43,672.2 + 2,970.3

PW = – 20,429.36

The rate of return of Alternative P is Zero.

Alternative Q

Initial Cost (P) = $85,000

Annual Operating Cost (C) = $2,000

Annual Revenue (R) = $45,000

Salvage Value (S) = $8,000

Life (n) = 3

Assuming rate of return of 1% or 0.01

Present Worth (PW) = – P – C(P/A, 1%, 3) + R(P/A, 1%, 3) + S(P/F, 1%, 3)

PW = – 85,000 – 2,000(P/A, 1%, 3) + 45,000(P/A, 1%, 3) + 8,000(P/F, 1%, 3)

PW = – 85,000 – 2,000[((1 + 0.01)3 – 1)/0.01(1 + 0.01)3] + 45,000[((1 + 0.01)3 – 1)/0.01(1 + 0.01)3] + 8,000/(1 + 0.01)3

PW = – 85,000 – (2,000 × 1.9704) + (45,000 × 1.9704) + (8,000 × 0.9803)

PW = – 85,000 – 3,940.8 + 88,668 + 7,842.4

PW = 7,569.6

Assuming rate of return of 5% or 0.05

Present Worth (PW) = – P – C(P/A, 5%, 3) + R(P/A, 5%, 3) + S(P/F, 5%, 3)

PW = – 85,000 – 2,000(P/A, 5%, 3) + 45,000(P/A, 5%, 3) + 8,000(P/F, 5%, 3)

PW = – 85,000 – 2,000[((1 + 0.05)3 – 1)/0.05(1 + 0.05)3] + 45,000[((1 + 0.05)3 – 1)/0.05(1 + 0.05)3] + 8,000/(1 + 0.05)3

PW = – 85,000 – (2,000 × 1.8594) + (45,000 × 1.8594) + (8,000 × 0.9070)

PW = – 85,000 – 3,718.8 + 83,673 + 7,256

PW = 2,210.2

Assuming rate of return of 10% or 0.1

Present Worth (PW) = – P – C(P/A, 10%, 3) + R(P/A, 10%, 3) + S(P/F, 10%, 3)

PW = – 85,000 – 2,000(P/A, 10%, 3) + 45,000(P/A, 10%, 3) + 8,000(P/F, 10%, 3)

PW = – 85,000 – 2,000[((1 + 0.1)3 – 1)/0.1(1 + 0.1)3] + 45,000[((1 + 0.1)3 – 1)/0.1(1 + 0.1)3] + 8,000/(1 + 0.1)3

PW = – 85,000 – (2,000 × 1.7355) + (45,000 × 1.7355) + (8,000 × 0.8264)

PW = – 85,000 – 3,471 + 78,097.5 + 6,611.2

PW = – 3,762.3

Therefore the rate of return for Alternative Q is

i = 5% + ((2210.2 – 0)/2210.2 – (– 3762.3)) × 5%

i = 5% + (2210.2/5972.5) × 5%

i = 6.85%


Related Solutions

Compare the following 2 alternatives using the incremental rate of return method. Determine which is the...
Compare the following 2 alternatives using the incremental rate of return method. Determine which is the most efficient and which is the most profitable. MARR=8% per year compounded yearly. (Note: For full credit, I want you to compute the actual IRR values) Alter. Construction cost Annual Benefits Salvage Life (yrs) A $1,250,000 $300,000 $12,500 12 B $750,000 $270,000 $10,000 7
Five alternatives are being evaluated by the incremental rate of return method . Incremental Initial Overall...
Five alternatives are being evaluated by the incremental rate of return method . Incremental Initial Overall ROR Rate of Return Alternative Investment , S versus DN . % A B C D A -25.000 9.6 - 27.3 9.4 35.3 25.0 B 15.1 0 38.5 24.4 C - 40,000 13.4 - 46.5 27.3 D -60,000 25.4 6.8 E -75,000 20.2 - 35.000 If the projects above are independent , the one or ones to select at an MARR of 18 %...
A company has the following mutually exclusive investment alternatives. The cash flows are shown below. Year...
A company has the following mutually exclusive investment alternatives. The cash flows are shown below. Year Project A Project B 0 -$1,000 -$1,000 1 600 300 2 600 600 3 600 900 If the cost of capital is 10%, which investment(s) should the company select? Both Project A and Project B Project B with a NPV of $444.78 Project B with a NPV of $276.31 Project A with a NPV of $493.11 Project A with a NPV of $253.64
Two alternatives with the cash flow described below. MACRS depreciation and 5years MACRS Incremental tax rate=24%...
Two alternatives with the cash flow described below. MACRS depreciation and 5years MACRS Incremental tax rate=24% After tax MARR= 10% A B Initial cost 11,000 33,000 Uniform Annual Benefits 3,000 9,000 Salvage Value 2,000 5,000 Life(years) 5 5 Find the alternative to choiisw, after cinsidering taxes
Which alternatives can be eliminated immediately in the first step of incremental rate of return analysis,...
Which alternatives can be eliminated immediately in the first step of incremental rate of return analysis, if MARR = 12.0%? Which increment should be examined first in incremental rate of return analysis, if MARR = 12.0%? Do-nothing A B C D First cost 0 $5,500 $3,500 $7,000 $3,500 Annual benefit 0 1,054 765 1,448 545 Life 10 yrs ROR 14.0% 17.5% 16.0% 9.0% Life 10 yrs ROR 13.0% 17.0% 16.0% 10.5% The answer choices are B-A A-B B-C A-C I...
Using the prices and cash flows of Treasury coupon bonds shown below, determine the par bond...
Using the prices and cash flows of Treasury coupon bonds shown below, determine the par bond yield for each of the Treasury securities. Bond Price Year 1 Year 2 Year 3 1 99.50 105 2 101.25 6 106 3 100.25 7 7 107 Using Excel, solve the above problem and graph the resulting Treasury par bond yield curve (show formula). Suppose that the 6-month, 12-month, 18-month, and 24-month zero rates are 5%, 6%, 6.5%, and 7% respectively. What is the...
Rate of Return Analysis: The table below shows the cash flows associated with a certain investment....
Rate of Return Analysis: The table below shows the cash flows associated with a certain investment. (a) How many possible rates of return are there for this set of cash flows? (b) Find all the rate of return values for these cash flows between 0% and 100%. Please, explain and show solution procedures. Year                              0                    1                2               3                4                  5                   6 Cash Flow ($)         15,000          -30,000         1500          6000          6000          6000            6000
The cash flows for four mutually exclusive alternatives are provided in the table below. If the...
The cash flows for four mutually exclusive alternatives are provided in the table below. If the useful life is 10 years for each alternative, find the best alternative using incremental rate of return analysis. MARR = 10% P Q R S Initial Cost 19,000 16,000 11,000 8,500 EUAB 3,500 3,100 2,200 1,350 A. Alt. S B. Alt. P C. Alt. Q D. Alt. R
Estimated cash flows appear below for an investment project. The project's required rate of return (RRR)...
Estimated cash flows appear below for an investment project. The project's required rate of return (RRR) is 11.40%. What is the discounted payback period for the project in years? Cash flows after Year 0 are assumed to be end-of-year cash flows. Year 0 cash flow = -67,000 Year 1 cash flow = 17,000 Year 2 cash flow = 20,000 Year 3 cash flow = 27,000 Year 4 cash flow = 30,000 Year 5 cash flow = 24,000 Select one: a....
Suppose your firm is considering investing in Project Q with the cash flows shown in the...
Suppose your firm is considering investing in Project Q with the cash flows shown in the table. Assume that the required rate of return on projects of this risk class is 10.5 percent, and that the maximum allowable payback and discounted payback statistics for the project are 3.5 and 4.5 years, respectively. Use the IRR decision to evaluate this project; should it be accepted or rejected? A. IRR = 18.32%; accept the project B. IRR = 16.46%; accept the project...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT