Calculate the internal rate of return using 10% and 18% discount rates and interpolation method in question 1 roman iv

Business/Management

ScanSolve AI Answer

Step-by-step solution

3 steps

You're asking for a re-calculation of part (iv) from the first question. Here are the steps for calculating the Internal Rate of Return (IRR) using the interpolation method with 10% and 18% discount rates:

iv. Calculate the Internal Rate of Return (IRR) using 10% and 18% discount rates and interpolation method.

Given Data:
Initial Investment (C0C_0) = Nle120,000
Cash Inflows (CFtCF_t):
Year 1: Nle25,000
Year 2: Nle30,000
Year 3: Nle28,000
Year 4: Nle35,000
Year 5: Nle32,000 + Nle15,000 (Scrap Value) = Nle47,000

  1. Calculate NPV at 10% (NPVLNPV_L).

    The formula for Present Value (PV) is PV=CFt(1+r)tPV = \frac{CF_t}{(1+r)^t}.

    • PV Year 1: Nle25,000(1+0.10)1=Nle25,0001.10=Nle22,727.27\frac{\text{Nle25,000}}{(1+0.10)^1} = \frac{\text{Nle25,000}}{1.10} = \text{Nle22,727.27}
    • PV Year 2: Nle30,000(1+0.10)2=Nle30,0001.21=Nle24,793.39\frac{\text{Nle30,000}}{(1+0.10)^2} = \frac{\text{Nle30,000}}{1.21} = \text{Nle24,793.39}
    • PV Year 3: Nle28,000(1+0.10)3=Nle28,0001.331=Nle21,036.60\frac{\text{Nle28,000}}{(1+0.10)^3} = \frac{\text{Nle28,000}}{1.331} = \text{Nle21,036.60}
    • PV Year 4: Nle35,000(1+0.10)4=Nle35,0001.4641=Nle23,905.30\frac{\text{Nle35,000}}{(1+0.10)^4} = \frac{\text{Nle35,000}}{1.4641} = \text{Nle23,905.30}
    • PV Year 5: Nle47,000(1+0.10)5=Nle47,0001.61051=Nle29,183.18\frac{\text{Nle47,000}}{(1+0.10)^5} = \frac{\text{Nle47,000}}{1.61051} = \text{Nle29,183.18} Total PV of Inflows at 10% = Nle22,727.27 + Nle24,793.39 + Nle21,036.60 + Nle23,905.30 + Nle29,183.18 = Nle121,645.74
    NPVL=Total PV of Inflows−Initial InvestmentNPV_L = \text{Total PV of Inflows} - \text{Initial Investment} NPVL=Nle121,645.74−Nle120,000=Nle1,645.74NPV_L = \text{Nle121,645.74} - \text{Nle120,000} = \text{Nle1,645.74}
  2. Calculate NPV at 18% (NPVHNPV_H).

    • PV Year 1: Nle25,000(1+0.18)1=Nle25,0001.18=Nle21,186.44\frac{\text{Nle25,000}}{(1+0.18)^1} = \frac{\text{Nle25,000}}{1.18} = \text{Nle21,186.44}
    • PV Year 2: Nle30,000(1+0.18)2=Nle30,0001.3924=Nle21,545.63\frac{\text{Nle30,000}}{(1+0.18)^2} = \frac{\text{Nle30,000}}{1.3924} = \text{Nle21,545.63}
    • PV Year 3: Nle28,000(1+0.18)3=Nle28,0001.643032=Nle17,041.88\frac{\text{Nle28,000}}{(1+0.18)^3} = \frac{\text{Nle28,000}}{1.643032} = \text{Nle17,041.88}
    • PV Year 4: Nle35,000(1+0.18)4=Nle35,0001.93887776=Nle18,052.96\frac{\text{Nle35,000}}{(1+0.18)^4} = \frac{\text{Nle35,000}}{1.93887776} = \text{Nle18,052.96}
    • PV Year 5: Nle47,000(1+0.18)5=Nle47,0002.2878757568=Nle20,544.60\frac{\text{Nle47,000}}{(1+0.18)^5} = \frac{\text{Nle47,000}}{2.2878757568} = \text{Nle20,544.60} Total PV of Inflows at 18% = Nle21,186.44 + Nle21,545.63 + Nle17,041.88 + Nle18,052.96 + Nle20,544.60 = Nle98,371.51
    NPVH=Total PV of Inflows−Initial InvestmentNPV_H = \text{Total PV of Inflows} - \text{Initial Investment} NPVH=Nle98,371.51−Nle120,000=−Nle21,628.49NPV_H = \text{Nle98,371.51} - \text{Nle120,000} = -\text{Nle21,628.49}
  3. Use the interpolation formula to find IRR.

    IRR=L+NPVLNPVL−NPVH(H−L)\text{IRR} = L + \frac{NPV_L}{NPV_L - NPV_H} (H - L)

    Where L=0.10L = 0.10 (10%) and H=0.18H = 0.18 (18%).

    IRR=0.10+Nle1,645.74Nle1,645.74−(−Nle21,628.49)(0.18−0.10)\text{IRR} = 0.10 + \frac{\text{Nle1,645.74}}{\text{Nle1,645.74} - (-\text{Nle21,628.49})} (0.18 - 0.10) IRR=0.10+Nle1,645.74Nle1,645.74+Nle21,628.49(0.08)\text{IRR} = 0.10 + \frac{\text{Nle1,645.74}}{\text{Nle1,645.74} + \text{Nle21,628.49}} (0.08) IRR=0.10+Nle1,645.74Nle23,274.23(0.08)\text{IRR} = 0.10 + \frac{\text{Nle1,645.74}}{\text{Nle23,274.23}} (0.08) IRR=0.10+0.070719×0.08\text{IRR} = 0.10 + 0.070719 \times 0.08 IRR=0.10+0.00565752\text{IRR} = 0.10 + 0.00565752 IRR=0.10565752≈10.57%\text{IRR} = 0.10565752 \approx 10.57\% 10.57%\boxed{\text{10.57\%}}
Was this helpful?

Still stuck on this one?

Ask a follow-up, and the answer starts from this question.

Got a different question?Ask your own question
Handwritten step-by-step solution preview

Handwritten Step-by-Step Solution

Get this as a handwritten image on WhatsApp — like a tutor wrote it for you.

Try on WhatsApp