Calculate the average monthly holding period return

Assignment Help Other Subject
Reference no: EM132172483 , Length: word count:1800

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, 3rdand 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?" (https://theconversation.com/factcheck-is-australias-corporate-tax-rate-not-competitive-with-the-rest-of-the-region-37226). 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:- Requirement.zip

Reference no: EM132172483

Questions Cloud

What are the major provisions of the civil rights act : What are the major provisions of the Civil Rights Act of 1964?
Screening for and management of chronic conditions : What are the benefits of using evidence-based standards in screening for and management of chronic conditions?
Discuss the healthcare policies outcomes : Discuss the healthcare policies outcomes. Were the original goals achieved? If the goals were not achieved, provide an alternative that would address the policy
Why a third party candidate has never been successful : Third Party Candidates: Discuss two (2) political reasons why a third party candidate has never been successful in winning a presidential election.
Calculate the average monthly holding period return : 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
How john adams described the ideal form of government : Activity for Assessment: 1)"A government of laws, not of men" is how John Adams described the ideal form of government. The Constitution of the United States.
Write about biography of Juan Garrido : Assignment - Write about biography of "Juan Garrido"
Explain the various aspects of the plain view doctrine : Explain the various aspects of the plain view doctrine. Compare and contrast the various means of identifying suspects.
Health insurance portability and privacy act : Complete the following by giving summary of the legislation. Health Insurance Portability and Privacy Act

Reviews

len2172483

11/21/2018 1:17:18 AM

Assignment 2 is worth 20% of total assessment and is marked out of 100. Please show all workings including any formula used. .Please read this before writing assignment..... So i m sending u this ways These figures are not being sent in text, i am attaching those

Write a Review

Other Subject Questions & Answers

  Discuss most frequent multitasking distractions at work

What are your most frequent multitasking distractions at work, at home with your family, and while studying or doing homework

  Describe the frank-starling law that affect cardiac function

Describe how this effect is beneficial in something such as hemorrhage but futile in a disease process such as CHF

  Regulatory and control policiesregulations at workplaces

discuss smoking bans while considering the following1. regulatory and control policies2. regulations at workplaces and

  Who is the elderly traveller

What does Young Goodman Brown learn about himself and/or about humankind in his experience in the forest? Please write three comments to receive full credit for the discussion.

  Differentiate urgent care centers and emergency departments

What are the differences between Urgent Care Centers and Emergency departments? Prepare a written 2 page discussion (double spaced).

  What practice settings and role opportunities are emerging

How should educational programs prepare nurses to assume different future roles, and at what educational level? What challenges does the multigenerational workforce create in your day to day practice?

  What would be the potential needs of the miners families

What would be the potential needs of the miners' families in receiving a message about this incident? What would be the potential needs of the company's employees when receiving a message about this incident?

  Scope of the federal government

The New Deal policies drastically altered the scope of the federal government. Discuss how the Great Depression created a favorable political environment

  Is there a clear statement of the issue

Is there a clear statement of the issue? Can you tell who is involved and why are they involved? Are their arguments well supported by research?

  What measures if any protect employees from subjectivity

What measures, if any, protect employees from subjectivity? Does the performance appraisal process encourage employee development?

  Find the cost-of-living in each of the given locations

find the cost-of-living in each of these locations. Based on this information, determine the location where you would earn the most money.

  The closest the constitution comes to guaranteeing

The closest the Constitution comes to guaranteeing or advocating equality is the Fourteenth Amendment's declaration that the states must provide.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd