Reference no: EM132173405 , Length: word count:1800

Task

Please show all workings including any formula used.

Question 1

This question relates to material covered in the Topics 1 to 3. This question addresses the 5th and 6th subject learning outcomes.

For the following numerical problems, detailed answers must be shown. This involves providing a brief description of the problems, formulae used, progressive and final answers to the questions. For assignments you are expected to show your workings using the appropriate formula.

(a) Scotty Thomson expects to receive the following stream of cash flows from an investment over the next 7 years:

If Scotty's required rate of return is 6% per annum on this investment, how much should he pay for this investment opportunity?

(b) Jarrad Waite has purchased a new apartment in North Melbourne for $1.8 million. He plans to finance the whole amount with a loan from the community bank Kanga Kash. Jarrad has been offered a 30 year term loan with monthly repayments at a nominal rate of 5% per annum.
Given Jarrad is financing the whole purchase amount with debt, what will be his monthly repayment amount?

(c) Ben Cunnington is planning for his retirement and has $50,000 to invest as a lump sum into a retirement investment plan. Ben plans to work for another 35 years before retiring at the age of 65 and, as well as the $50,000 lump sum, he plans to deposit $1,500 into a capital secured share index fund each month of his remaining working life. He estimates that his retirement account will generate an annual return of 7%. Ben plans to retire at 65 and then draw a pension from his savings for a further twenty five years. During this retirement phase Ben expects to be investing conservatively and estimates a 5% per annum return. At the age of 90, at the completion of the pension, Ben would like to have $200,000 remaining in the account for contingencies.

(i) Calculate the Future Value of the monthly saving deposits and the lump sum deposited today based on monthly compounding and a rate of 7% per annum.

(ii) Calculate the annual pension that Ben will receive after retirement, taking into account the requirement to have $200,000 remaining at the end of the pension period. Ben plans to receive his first retirement pension payment annually with the first payment occurring one year after he retires.

Question 2
This question relates to material covered in the Topics 1 to 3. This question addresses the 5th and 6th subject learning outcomes.
Following is an example of a cash flow timeline developed using the Table Function within MS Word. Please use this example as a means to develop a similar timeline in your answer to the following question.
Example only:

Below are the expected cash flows and interest rates for the next nine years. Cash flows will occur at the end of the nominated years.

(i) Using the Table function within MS Word, draw a time line showing the above cash flows and interest rates.
(ii) What will be the accumulated value of all these cash flows at each of the following times:
Time 0
Time 4
Time 10

Question 3

Australian Corporate Tax Cuts

This question relates to material covered in Topic 1 particularly the Australian taxation system and the dividend imputation credits. This question addresses the 1st, 2nd, 3rd and 4th subject learning outcomes.

Students are expected to conduct their own research and develop their own opinions about the merits of this topic. There is no single correct answer and students will be marked on the depth of their research, the quality of their arguments (for and against), and their demonstrated understanding of the issues involved in this complex area of financial policy.

Write an essay of between 600 and 1,000 words discussing the following topic.

The Australian federal government and business representative bodies argue that the Australian corporate tax rate is too high and makes Australia uncompetitive with competing economies. The government has plans to eventually lower the Australian corporate tax rate to 25%. The government believes that this will improve the economy and ultimately taxpayers by stimulating business investment and creating jobs. Internationally, many countries are lowering their corporate tax rates including, most recently, Donald Trump's United States.

Does Australia's current level of corporate taxation make the country economically uncompetitive? Start by reviewing The Conversation article Fact Check: Is Australia's corporate tax rate not competitive with the rest of the region?". Do you believe that lowering the Australian corporate tax rate is good policy? Discuss this issue and give particular consideration to the Australian dividend imputation system and how the Australian corporate tax rate impacts on Australian taxpayers.

There are a divergence of views and resources available for students to access. There are many items in the mainstream online media which canvas the Government's view and also that of those opposing. Students should access resources from government, industry, and not for profit community groups such as Get Up! as well as the broader print and electronic media.

Remember, there is no correct answer and individual students will be assessed on their demonstrated understanding of the issues and the depth and quality of their individual research.

Question 4
This question relates to material covered in Topics 1-5. This question addresses the 1st, 2nd and 3rd subject learning outcomes.

Conduct some research into the 2017/18 financial year performance of the largest players in the Australian grocery market Woolworth's and Coles by looking at the performance of the publicly listed companies which own these businesses, Woolworths Group Limited (WOW.AX) and Wesfarmers Limited (WES.AX). These two companies, through their Woolworth and Coles supermarket divisions, record approximately 61% of the more than $100 billion annual sales in the Australian grocery market (Roy Morgan Research Institute, 2018).

(i) Find the monthly holding period returns for the 2017/18 financial year for Woolworths (WOW), Wesfarmers (WES) and the market (MKT) as proxied by the All Ordinaries index. The monthly holding period return is the return you would receive if you bought an asset on the first day of the month (opening price) and sold it on the last day of the month (closing price). Using Excel provide a line graph with the monthly returns for all three securities. Graph your results on one graph showing monthly returns for WOW, WES and the MKT over the year with percentage (%) return results plotted on the y (vertical) axis and time (month) on the x (horizontal) axis. (Use 'Close' rather than 'Adjusted Close' for the selling price.) Note: Opening price MUST equal previous month closing price.

(ii) For each of the three investment options calculate the average monthly holding period return?

(iii) For each of the three investment options calculate the annual holding period return?

(iv) For each of the three investment options calculate the standard deviation of the monthly rates of return.

(v) Use the scatter plot Excel graph function to plot your results from (iii) and (iv) above with risk on the x axis and return on the y axis for each of the three investments.

(vi) If the 10 year government bond rate is 2.00% and the long term return on the market as proxied by the ASX is 5.75%, assuming the beta (β) for WOW is 0.77 and for WES is 0.81, use the Capital Asset Pricing Model (CAPM) to find the expected returns for WOW and WES.

(vii) Construct and graph the Security Market Line (SML) (use a scatter plot and fit the SML line) showing where WOW, WES and the MKT should lie.

(viii) Based on your findings construct a portfolio made up of 30% WOW and 70% WES. Calculate the estimated return and β for this portfolio.

(ix) Based on your understanding of the CAPM and the SML, which of these asset(s) or portfolio(s) would you invest in and which would you not invest in. Explain your choice.

Attachment:- Assignment.rar