Quiz A Consider an investment which costs $1,000 and appreciates in market value at the rate of 10% per year over its life of 5 years. After 5 years the investment is sold. During this time it pays a dividend yield of 5%. Dividend yield is measured in the usual way as a percentage of current market value. Dividends are paid at the end of each year.
To finance the investment, the owner borrows $800 and uses $200 of his own money. Interest on the loan is at the rate of 8% per annum paid annually in arrears. Loan repayments include only interest. The capital amount of the loan is repaid at the end of the investment. Allow for income tax at the rate of 40%. Annual taxable income equals dividends less interest payments. A negative taxable income will result in a tax refund in the same year. Assume no CGT (capital gains tax). Required 1. Considering this 5 year investment as just a future stream of cash flows (including loan payments), find its NPV over a range of discount rates from say 0-50%. Plot this NPV profile and identify the IRR. If possible, find the exact value of the IRR. Why is IRR so high? 2. Taking time points at the end of each year through to time 4 (end of year 4), find the IRR of the investment (i.e. of what remains of the investment) at each of these instants. Explain why IRR changes through time, and suggest how a clever investor can manage this change. 3. Imagine that instead of borrowing $800, the investor borrows $950 (and uses only $50 of her own). What effect will this have on the answer to Question 1 above (a further IRR calculation will help here)? Explain what this effect means for an investor starting with some finite amount of cash and trying to get rich. Please include all excel spreadsheets used, including formulas. Maximum length is 10 pages, including write-up, graphs, excel spreadsheets and formulas. |