Question

In: Economics

Calculate the IRR for the following cash flows. You must show trial-and-error methodology and use interpolation...

Calculate the IRR for the following cash flows. You must show trial-and-error methodology and use interpolation to find the IRR to 2 decimal points to get credit.

Year 0 1   2 3 4 5 6 7 8

NetCash -35,700 +8,000 +8,000 +8000 +8,000 +8,000 +8,000 +8,000 +2,000

Flow, $ -2,000

                    

Solutions

Expert Solution

Asumme discount rate @ 10% and 15%.

second multiply cash flows with discount rate value to find present value of cash flows.

compare net present value of cashflows with inital investment amount.

if it is same then that will be the IRR or if not procceed with different discount rate.

here @ 15% discount rate the present value of cash flows is approximate same as inital inveatment.

hence, IRR is 15%. ( with trial and error method)

note ( as interest increse net value decrease)

so when you use t & Eh method procced with random interest and compare with it wisely.

for two decimal IRR

IRR= lower discount rate + [ npv at lower rate *( higher rate - lower rate ) / ( npv at lower rate - npv at higher rate


Related Solutions

How to find IRR in excel using trial-error method? Cash flows for each year are following:...
How to find IRR in excel using trial-error method? Cash flows for each year are following: Y0 = -55 Y1 = -30.62 Y2 = 4.14 Y3 = 6.68 Y4 = 8.74 Y5 = 9.54 Y6: tricky part is after Y5, cash flow growth is 3% indefinitly rate of return = 11%
Use the following cash flows to calculate the NPV, IRR, PI. The firm's WACC is 6%....
Use the following cash flows to calculate the NPV, IRR, PI. The firm's WACC is 6%. Y0 = ($1,500), Y1= $600, Y2 = $700, Y3 = $500. Determine which statement is true. a) NPV = 108.84; IRR = 9.99%; PI = 1.07 b) NPV = 108.84; IRR = 10.47%; PI = 1.07 c) NPV = 108.84; IRR = 9.99%; PI = 0.0726 d) NPV = 300; IRR = 9.99%; PI = 1.20 Please Explain
Find IRR for following cash flows:
4)         Find IRR for following cash flows:                     0_____1_____2_____3_____4                     ($100)    $10       $10     $10     $110                           a) use spreadsheet, make sure that you know the procedure                     Show spreadsheet printout                        b) use intuition: if initial cashflow is changed to (90) the IRR will be Higher/lower because _________________________________       Hint: Consider the impact of a higher discount rate on the PV of a given set of cash flows.5)         The Stated rate i=10% per year compounded semi-annually. TheEffective annual rate is                         __________%              a) use built-in calculator/Excel...
2. a) Calculate the IRR of the following cash flows: -$550,000 in year 0; $430,000 in...
2. a) Calculate the IRR of the following cash flows: -$550,000 in year 0; $430,000 in year 1; $100,000 in year 2; and $200,000 in year 3. Is the project acceptable if the cost of capital is 10%? b) Now calculate the MIRR of the same cash flows assuming a reinvestment rate of 12%. Is the project acceptable or not acceptable under this methodology?
These are the cash flows for two projects. Calculate the NPV and IRR for both. Then...
These are the cash flows for two projects. Calculate the NPV and IRR for both. Then select the best project according to the NPV measure. Use a WACC of 10% for both projects. The investments are 7 for project 1, and 8 for project 2. Cash flows for project 1 year 1 2 3 4 cash 4 6 2 4 Cash flows for project 2 year 1 2 3 4 cash 3 2 7 4 Calculate the NPV for project...
Find IRR for following cash flows:                                     0_____1_
Find IRR for following cash flows:                                     0_____1_____2_____3_____4                                     ($100) $10       $10     $10     $110 a) use calculator, make sure that you know the procedure. p/yr=____, N=____, PMT=_____, FV=_____, PV=_____, IRR=____% per period. b) use spreadsheet, make sure that you know the procedure. Show spreadsheet printout by using Excel c) use intuition: if initial cash flow is changed to (90) the IRR will be higher because _________________________________ Hint: Consider the impact of a higher discount rate on the PV of a...
Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1...
Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1 = 10 = CF2 = CF3 = CF4 = CF5 = CF6 = CF7 = CF8 = CF9, and CF10 = -65. In Excel, plot the NPV against r (= discount rate), using r = 0%, 2%, 4%, 6%, 8%, 10%, 12%, 14%, 16%, 18%, 20%, 22%, 24%, 26%, 28%, and so on until you find all IRRs on the horizontal axis. Approximately, what...
The IRR calculation assumes that cash flows are reinvested at the . If the IRR is...
The IRR calculation assumes that cash flows are reinvested at the . If the IRR is than the project's risk-adjusted cost of capital, then the project should be accepted; however, if the IRR is less than the project's risk-adjusted cost of capital, then the project should be . Because of the IRR reinvestment rate assumption, when projects are evaluated the IRR approach can lead to conflicting results from the NPV method. Two basic conditions can lead to conflicts between NPV...
6 You have the following cash flows: FIND the IRR, NPV (using 8 %), and the...
6 You have the following cash flows: FIND the IRR, NPV (using 8 %), and the Profitability Index (Bang for your buck) T0 = -1250 IRR = _______________%_ T1 = 350 NPV = __$______________ T2 = 450 PI = __$______________ T3 = 450 T4 = 550
What is the IRR of the following set of cash flows?     Year Cash Flow 0...
What is the IRR of the following set of cash flows?     Year Cash Flow 0 –$11,768             1 6,500             2 5,400             3 6,200             24.09% 25.36% 26.63% 25.87% 24.85%
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT