Question 1

(a)  Your daughter has expressed a wish to attend university when she finishes school in five (5) years.  You anticipate the cost will be $60,000 at the time she commences university.  If your financial institution is offering you 4% pa (compounded monthly), how much do you need to deposit in your account each month in order to save the required amount before your daughter commences university?

(b) You have been offered the opportunity to purchase a start up company building electric cars for the Australian market called Green Motors P/L.  Your initial investment is $22,000,000. The term of the project is 5 years. The project has an expected rate of return of 10% pa.  All expected cash flows for the project are below and you have an expected rate of return of 10% pa.

End of year Cash flow ($mil)
1 1.8
2 3
3 6.5
4 8.4
5 12.3

 

(i)      Based on your required rate of return would you purchase this investment? Present all calculations to support your answer.

(ii)     Would you change your opinion from (i) if the expected rate of return rose to 15%?  Present all calculations to support your answer.

(c)     You have commenced work as a certified Financial Planner. Your supervisor has provided the following financial data for a new client Brant Jerome. The client turned 34 years old today and plans to retire when she turns 67. The client owns a diversified share portfolio which is valued today at $47,000. It is expected that this portfolio will earn (on average) 7% per annum indefinitely. Brant also has a superannuation account with a balance of $78,000 to which he currently contributes $1,000 per month. The superannuation account is expected to continue to earn 8% per annum. At his retirement your client plans to consolidate his financial holdings and purchase a monthly annuity as a pension to fund his planned lifestyle. Brant believes he will need to self-fund his retirement until he reaches the age of 85 at which time he would like to have $120,000 remaining to fund any costs not covered by the age pension. During the pension phase of his retirement Brant will adopt a Balanced investment strategy which will return 5% pa (compounded monthly) on his annuity investment.

(i)     What will be the value of Brant’s financial assets when he retires at age 67? Present all calculations to support your answer.

(ii)     What will be the monthly pension amount that Brant will receive on his retirement?  Present all calculations to support your answer.

 

Question 2

(a) Bradley hates taking risk with his money; “I hate shares and property, I know a lot of people who have lost money in those investments”.  As a result he will only consider bank guaranteed investments.  Bank guaranteed investments are returning 1%.  Bradley has a marginal tax rate of 32.5% and pays medicare levy of 2%.

Assuming he pays tax at 32.5% plus medicare levy, on the income from his investment, is he preserving the real dollar value of his investment if inflation is 2.5% per annum?  Show your workings to justify your answer.

(b) Below is the monthly share price data for A2 Milk Company for the 2018 financial year (source: https://au.finance.yahoo.com/quote/A2M.AX/). Note: no dividends were declared for the 2017-18 FY.

Date Open Close
Jul-17 3.79 4.14
Aug-17 4.15 5.04
Sep-17 5.1 5.86
Oct-17 5.92 7.62
Nov-17 7.34 7.59
Dec-17 7.6 7.37
Jan-18 7.4 8.29
Feb-18 8.32 12.23
Mar-18 12.21 11.46
Apr-18 10.96 11.31
May-18 11.36 9.93
Jun-18 9.7 10.52
  1. Calculate the 2017-2018 monthly holding period returns (in both $ and %) for A2M.
  2. Calculate the average monthly return (%) for A2M.
  3.   Using the data provided calculate the annual holding period return (in both $ and % terms) for an international (non-Australian) shareholder of A2M.

(c)     The monthly data  for the Australian All Ordinaries share price index (Source: https://au.finance.yahoo.com/ is below.

Date Open Close
Jul-17 5,764.00 5,773.90
Aug-17 5,773.90 5,776.30
Sep-17 5,776.30 5,744.90
Oct-17 5,744.90 5,976.40
Nov-17 5,976.40 6,057.20
Dec-17 6,057.20 6,167.30
Jan-18 6,167.30 6,146.50
Feb-18 6,146.50 6,117.30
Mar-18 6,117.30 5,868.90
Apr-18 5,868.90 6,071.60
May-18 6,071.60 6,123.50
Jun-18 6,123.50 6,289.70
  1. Calculate the monthly holding period returns (%) for the Australian share market (MKT) during 2017-2018 FY.
  2. Calculate the average monthly holding period return (%) for the MKT (ALL ORDS).
  3.  Calculate the annual holding period return (in % terms) for the Australian share market (MKT) (as proxied by the All Ords index) during 2017-2018 FY.
  4.  Using Excel (XL) prepare a line graph comparing the monthly returns for A2M and the return on the Australian (MKT).
  5. Calculate the risk for 2018 as measured by standard deviation of both A2M and the MKT.
  6.  According to Reuters Finance A2M Ltd has a Beta of 1.04. In terms of share investment, define what Beta represents. What does A2M’s Beta of 1.04 mean? How risky is it?
  7.  The average return on the market (MKT) in Australia for the past 10 years has been 9.55% (Source: https://www.asx.com.au). The yield on Australian 10 year treasury bonds is currently 2.29%. Using these as proxies for the Return on Market (MKT) and Risk Free Rate (Rf), combine them with the A2M Beta (above) and calculate the return expected for A2M using the Capital Asset Pricing Model (CAPM).
  8.  Using the CAPM data from the previous question create an XL scatter plot graph to plot the Security Market Line (SML) using the Risk Free Rate, Return on Market, and A2M as  data points.
  9.  Recreate the graph from (viii) above but this time also include the actual 2018 returns for A2M and the MKT as previously found (using the same beta measures).
  10. Based on your CAPM findings construct a portfolio made up of 40% A2M and 60% MKT. Calculate the estimated return and β for this portfolio.

 

This solution is available in Excel Format only.

Click on Buy Solution and make payment. All prices shown above are in USD. Payment supported in all currencies. Price shown above includes the solution of all questions mentioned on this page. Please note that our prices are fixed (do not bargain).

After making payment, solution is available instantly.Solution is available either in Word or Excel format unless otherwise specified.


If your question is slightly different from the above question, please contact us at info@myassignmentguru.com with your version of question.