FIN700 Assume that Jillian Black
55 Pages9152 Words106 Views
Financial Management (FIN700)
Added on 2020-05-28
FIN700 Assume that Jillian Black
Financial Management (FIN700)
Added on 2020-05-28
ShareRelated Documents
QUESTION `1. [6 + 6 = 12 Marks.]a)This is a two period certainty model problem. Assume that Jillian Black has a sole income from Halcyon Ltd in which she owns 10% of the ordinary share capital. In its financial year 2016-17 just ended, Halcyon Ltd reported net profits after tax of $800,000, and announced its net profits after tax expectation for the next financial year, 2017-18, to be 20% higher than this year’s figure. The company operates with a dividend payout ratio of 80%, which it plans to continue, and will pay the annual dividend for 2016-17 in mid-January, 2018, and the dividend for 2017-18 in mid-January, 2019.In mid-January, 2019, Jillian wishes to spend $100,000, which will include the cost of new furniture. How much can she consume in mid-January, 2018 if the capital market offers an interest rate of 8% per year?Answer:Income EstimationsYear2016-172017-18Net Profit800000960000Dividend Payout80%80%Dividend640000768000Equity holding of Jillian Black10%10%Dividend of Jillian Black6400076800Two period Certainty problemYearIncomeOpening AmountInterestConsumptionBalance2016-201764000057606912054176.8814943.122017-20187680014943.128256.8810000010000001
b)This question relates to the valuation of shares.Ram Shack Ltd has just paid a dividend of $3.00 a share. Investors require a 13% per annum return on investments such as Ram Shack. What would a share in Ram Shack Ltd be expected to sell for today (January, 2018) if the dividend is expected to increase by 20% in January, 2019, 16% in January, 2020, 12% in January, 2021 and thereafter by 5 per cent a year forever, from January, 2022 onwards? Answer:YearDividendPVF @ 13%PV of Dividend20183.000.8852.65520193.600.7832.81920204.180.6932.89420214.680.6132.869202261.39*0.54333.319Price of Share44.555* 4.68 x (1+0.05)/(0.13-0.05)= 61.392
QUESTION 2. [(4 + 4) + (2 + 3 + 3 + 3 + 3) = 22 Marks]a)This question relates to the time value of money and deferred annuities.Colin Way is age 40 today and plane to retire on his 65th birthday. With future inflation, Colin estimates that he will require around $2,000,000 at age 65 to ensure that he will have a comfortable life in retirement. He believes that he can contribute $3,000 at the end of each month, starting in one months’ time and finishing on his 65th birthday.i)If the fund to which he contributes earns 6% per annum, compounded monthly (after tax), how much will he have at age 65? Will he have achieved his targeted sum? What is the surplus or the shortfall?Answer:Total fund Balance on his 65th Birthday 20,78,981.89Required Amount 20,00,000.00Surplus 78,981.89 Hence, the surplus amount is $78981.89. (Refer Appendix)ii)Using the fund balance, Colin then wishes to commence a monthly pension payable by the fund starting one month after his 65th birthday, and ending on his 85th birthday, after which he expects that the fund will be fully expended. If the fund continues to earn the above return of 6% per annum, compounded monthly, how much monthly pension will Colin receive, if the fund balance reduces to zero as planned after the last pension payment on his 85th birthday?Answer:The fund balance $ 78,981.89The amount of monthly pension = $567.08(Refer appendix)b)This question relates to loan repayments and loan terms.Ray and Betty Read wish to borrow $600,000 to buy a home. The loan from Battlers Bank requires equal monthly repayments over 20 years, and carries.an interest rate of 4.8% per annum, compounded monthly. The first repayment is due at the end of the first month.You are required to calculate:i)The effective annual interest rate on the above loan.Answer:Nominal Interest rate0.048Monthly Interest Rate0.004Effective Interest Rate(1+r/n)^nEffective Interest Rate4.91%ii)the amount of the monthly repayment (consisting of interest and principal repayment components) if the same amount is to be repaid every month over the 20 year period of the loan.Answer:3Installment=Loan Amount/(1+r)^240Loan 6,00,000.00 R0.004Installment= 3,893.74
(Refer appendix)iii)the amount of $X, if - instead of the above - Battlers Bank agrees that Ray and Betty will repay the loan by paying the bank $3,300 per month for the first 12 months, then $3,750 a month for the next 12 months, and after that $X per month for the balance of the 20 year term.Answer:The revised loan amount to be taken for calculating the amount of X will be $ 570184.82 and interest rate will be 4.8%.Amount of installment= $ 570184.82/ Cumulative present value factor @ 4.8%The amount of X= 570184.82/ 144.45Hence X= 3,947.28 (Refer Appendix)iv)how long (in years and months) it would take to repay the loan if, alternatively, Ray and Betty decide to repay $3,500 per month, with the first repayment again being at the end of the first month after taking the loan, and continuing until the loan was repaid.Answer:Loan amount: $600000Installment= $3500/MonthInterest= 4.8%Hence, the no. of years required to repay the loan= 24.17 yearsWe can say 24 Years and 2 months.(Refer Appendix)v)under option iv) above, the amount of the final repayment. [NOTE: Towards the end of the loan repayment period, after the final full monthly instalment of $3,500 is paid, a lesser amount is likely to be outstanding. That amount, plus interest to the end of the following month, is the final loan repayment amount.] Answer:The extra amount to be paid over and above the loan amount is $ 204.23Hence, the amount of final repayment $ 6,00,204.234
QUESTION 3. [(2 + 2 + 3 + 3 + 3 + 3 = 16 marks]This question relates to alternative investment choice techniquesLaurel Hardy is considering the following cash flows for two mutually exclusive projects. Year Cash Flows, Investment X ($) Cash Flows, Investment Y ($) 0 -42,000 -42,000 1 12,000 18,000 2 18,000 18,000 3 27,000 18,000You are required to answer the following questions:i)If the cash flows after year 0 occur evenly over each year, what is the payback period for each project, and on this basis, which project would you prefer? YearCash Flows XCash Flows Y0-42000-42000112000180002180001800032700018000As given in the question the cash flows occur evenly. So, we take the average of cash flows for project X and project Y cash flows are already even.Average = (12000+18000+27000)/357000Average Cash flows19000Payback Period(Years)2.212.33Hence, project X will be preferred over project Y.IN THE REMAINING PARTS, ASSUME THAT ALL CASH FLOWS OCCUR AT THE END OF EACH YEAR.ii)Would the payback periods then be any different to your answer in i)? If so, what would the payback periods be?YearCash Flows XCumulative Cash FlowsCash Flows Y0-42000-42000-42000112000-3000018000218000-12000180003270001500018000Payback Period(Years)2.442.335
In this case the cash flows are even and hence, the payback period of project X increased.iii)Sketch freehand the net present value (NPV) profiles for each investment on the same graph. Label both axes and the NPV profile for each investment.Di0%2%4%6%8%10%12%14%16%18%20%22%24%26%28%30%(15,000...(10,000...(5,000...- 5,000...10,000...15,000...20,000...NPV(X)NPV(Y)iv)Calculate the internal rate of return (IRR) for each project and indicate them on the graph. [NOTE: It is satisfactory if the approximate IRR is 6Discounting RateNPV(X)NPV(Y)0% 15,000.00 12,000.00 2% 12,508.45 9,909.90 4% 10,183.38 7,951.64 6% 8,010.41 6,114.22 8% 5,976.68 2,763.34 10% 4,070.62 1,232.96 12% 2,281.84 1,232.96 14% 600.96 -210.62 16% -980.48 -1,573.99 18% -2,470.16 -2,863.09 20% -3,875.00 -4,083.33 22% -5,201.33 -5,239.65 24% -6,454.87 -6,336.54 26% -7,640.86 -7,378.11 28% -8,764.07 -8,368.10 30% -9,828.86 -9,309.97
calculated for Investment X by trial and error, and stated as a percentage correct to the nearer whole number. The IRR for Investment Y should be calculated as a percentage exactly, correct to 1 decimal place.]Project XYearCash FlowsPVF @ 14%PVPVF @15%PVPVF @ 14.75%PV0-420001.000-42000.001.000-42000.001.000-42000.001120000.87710526.320.87010434.780.87110457.892180000.76913850.420.75613610.590.75913670.943270000.67518224.230.65817752.940.66217871.16NPV600.962-201.6930.00IRR=LDR+ NPV at LDR x (UDR-LDR)NPV at LDR- NPV at UDRIRR=14.75%Project YYearCashFlowsPVF @ 13%PVPVF @ 14%PVPVF @ 13.7%PV0-420001.000-42000.001.000-420001.000-420001180000.88515929.200.87715789.4740.88015831.132180000.78314096.640.76913850.4160.77413923.63180000.69312474.900.67512149.4870.68012245.91NPV500.75-210.62351IRR=LDR+ NPV at LDR x (UDR-LDR)NPV at LDR- NPV at UDRIRR=13.7%7
IRR TableIRRNPV(X)NPV(Y)13%1428.464500.74713.70%846.5580.64714%600.962-210.62414.75%0.000-728.10715%-201.693-901.948IRR13%13.70%14%14.75%15%-1500.000-1000.000-500.0000.000500.0001000.0001500.0002000.0002500.000IRR GraphNPV(Y)NPV(X)v)Calculate the exact crossover point and indicate it on the above graph.Answer:Calculation of Crossover PointYearProject X Cash FlowsProject Y Cash FlowsDifference0-42000-42000011200018000-6000218000180000327000180009000Crossover Point22.47%8
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
FIN700 Financial Management : Assignmentlg...
|12
|1817
|65
Financial Analysis Assignment | Financial Managementlg...
|38
|7207
|71