Question

The cash flow diagram below has an internal rate of return of 30%. What is the...

The cash flow diagram below has an internal rate of return of 30%. What is the value of Y if perpetual service is assumed?

Year 0 is $1000000

Year 1 is $500000

Year 2 is $500000

Year 3 is $Y

Year 4 is $Y

Year 5 is $Y

Year 6 is $Y

Year ∞ is $Y

Homework Answers

Answer #1
cash flow PV @ IRR 30% PV
yr0 1000000 1
yr1 500000 0.769230769 384615.3846
yr2 500000 0.591715976 295857.9882
yr3 Y 0.455166136 0.4551661 Y
yr4 Y 0.350127797 0.3501278 y
yr5 Y 0.269329074 0.269329 y
yr6 Y 0.207176211 0.207176 y
yr ∞ Y 0.69058737 0.690587 y
1.972386588 680473.373+1.9723865 y
total Known amount = 680473.3728
1000000 = 680473.373+1.9724Y
1.9724Y = 319526.6272
Y = 319526.63/1.9724 161998.8998
y = 161998.9 SAY 162000

Cash flow in year 0 = 1000000 is out flow and at IRR the PV of inflow will be equal to PV of outflow. the PV factor at year 6 =0.207176211. but the cash flow is perpetual after year 6, then the PV of perpetuity at 6th year end = cash flow / discount rate = y/.3 = 3.333 is discounted by using 6th year discound rate =3.33333 x 0.207176211 = 0.69058737

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 cash flow in the spreadsheet below, what is the internal rate of return? Please...
Given the cash flow in the spreadsheet below, what is the internal rate of return? Please give answer as a decimal not as a percent. For example write 0.153 not 15.3%. Year Cash Flow 0 -6306 1 1366 2 1556 3 984 4 1100 5 856 6 1526 7 1097 8 1469 0.115459
Find the minimum and maximum internal rate of return for the following cash flow. Year Cash...
Find the minimum and maximum internal rate of return for the following cash flow. Year Cash flow 0 -4,000 1 2,000 2 2,000 3 -2,000 4 1,900 5 900 6 200
A project has the following cash flows. What is the internal rate of return?                Year             ...
A project has the following cash flows. What is the internal rate of return?                Year                 0                      1                        2                     3                Cash flow     -$782,100        $219,500             $348,600           $348,600
What are the Net Present Value and Internal Rate of Return for the following cash flows...
What are the Net Present Value and Internal Rate of Return for the following cash flows - assuming a 3.5% discount rate? Year 0: ($35,900) Year 1: $20,750 Year 2: ($16,750) Year 3: $32,100 Year 4: $12,525 Year 5: $18,220 Is the project profitable on a discounted basis? Is it something we would want to pursue as an organization?
Given the cash flow below, calculate the External Rate of Return when MARR = 12%. Ans...
Given the cash flow below, calculate the External Rate of Return when MARR = 12%. Ans xx.x% Year Cash Flow 0 $-190,000 1 $-40,000 2 $76,000 3 $107,000 4 $123,000 5 $140,000 Please answer using excel and have formulas posted.
What is the Internal Rate of Return on an investment with the following cash flows? Year...
What is the Internal Rate of Return on an investment with the following cash flows? Year Cash Flow... 0 -$761,125 1 $330,500 2 $454,700 3 $161,200 Answers: a. 12.93 percent b. 9.42 percent c. 11.88 percent d. 14.71 percent e. 10.96 percent
What is the Modified Internal Rate of Return (MIRR) for the following cash flows? Assume that...
What is the Modified Internal Rate of Return (MIRR) for the following cash flows? Assume that the required rate of return is 4% Year CFs 0 -1,000 1 100 2 200 3 350 4 800
A project has the following cash flows. What is the internal rate of return? THE ANSWER...
A project has the following cash flows. What is the internal rate of return? THE ANSWER IS 21.32% PLEASE SHOW WORK WITHOUT USING EXCEL YEAR 0 1 2 3 NET INCOME -$390,000 $168,000 $190,000 $218,600
a. Determine the internal rate of return of the following investment: Period Cash flow 0 −$15,094...
a. Determine the internal rate of return of the following investment: Period Cash flow 0 −$15,094 1 10,000 2 10,000 3 1,000 b Draw the net present value profile for the investment of A. Using a hand calculator and the rollback method described in the chapter, compute the net present value using a discount rate of 0.10.
Determine the number of possible rate of return (i*) values for the cash flow below according...
Determine the number of possible rate of return (i*) values for the cash flow below according to the rule of signs (Descartes’ rule). Year Annual Revenues, $ Annual Costs,$ 0 $0 -$500 1 $350 -$500 2 $250 -$300 3 $450 -$350 4 $150 -$100 5 $350 -$150 Four One Three Two
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT