Question

In: Finance

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 functions

              b) use formula


6)         Term structure:           

                                    Two year rate is i=5% per year

                     Three year rate is i=6% per year

              Find the implied forward rate for the third year.                                                   i=_____%

7)    Real rate, r = 5% inflation rate, P = 2%

                        a)         Find thenominal rate (i) using approximate method, i.e. i = r+P                  i =______%


                        b)         Find thenominal rate (i) using the exact method,

                     i.e. 1+ i = (1+r)*(1+P)        i =_____%

8)    Do problem 9 using r = 5% and P = 100%

              a)    i =_____% approximately

              b)    i =_____% using the exact method.

            Note: Compare ‘a’ and ‘b’ in problems 8 and 9. The approximation isreasonable only when the rates are small.

Solutions

Expert Solution

--------------------------------------------------------------------------------------------------------------------------

Question-5

Question-5 part(b)

Effective annual interest rate = [1*(1+r)^n -1] * 100

r= rate per period = 10%/2 = 5%

n= number of compounding per period

=>Effective annual interest rate = [1*(1.05)^2-1]*100 = 10.25%

-----------------------------------------------------------------------------------------------------------------------------

Question-6

Let forward rate for 3rd year be r%

hence,

(1*(1.05)^2)*(1+r) = 1*(1.06)^3

=>1.1025(1+r) = 1.191016

=>r = 8.0287%

------------------------------------------------------------------------------------------------------------------------------------

Question-7

(a)

Under approximation method=

Nominal Interest rate(i) = Real interest rate(r)+Inflation(p)

=>Nominal interest rate(i)= 5%+2% = 7%

(b)

Under Exact method or Fishers Equation=

(1+i)= (1+r)(1+p)

=>(1+i) = (1+5%)*(1+2%)

=>(1+i) = 1.05*1.02

=>1+i=1.071

=>i = 0.071 or 7.1%

-------------------------------------------------------------------------------------------


Related Solutions

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...
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
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...
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%
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%
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,280             1 6,200             2 4,200             3 6,100             Multiple Choice 21.46% 21.9% 22.34% 20.8% 23%
What is the IRR of the following set of cash flows? Year 0 Cash Flow –$10,741...
What is the IRR of the following set of cash flows? Year 0 Cash Flow –$10,741 Year 1 Cash Flow $5,900 Year 2 Cash Flow $4,300 Year 3 Cash Flow $6,100
Day Interiors is considering a project with the following cash flows. What is the IRR of...
Day Interiors is considering a project with the following cash flows. What is the IRR of this project? Year Cash Flow 0 -$100,400 1 35,900 2 50,800 3 45,000
What is NPV, IRR, PI, MIRR of a project with the following cash flows if the...
What is NPV, IRR, PI, MIRR of a project with the following cash flows if the discount rate is 14 percent? Year CF 0 -18,000    1 5000 2 7500 3 8400 4 2100 Also upload your excel files showing your work.
What is the internal rate of return (IRR) on an investment with the following cash flows?...
What is the internal rate of return (IRR) on an investment with the following cash flows? Holding period 5 years. Round your answer to nearest 0.25%. Please show work (NO EXCEL) Year Net Income Purchase Price $4,000,000 1 $250,000 2 $300,000 3 $350,000 4 $400,000 5 $450,000 Resale $4,750,000 (net of costs)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT