What will be the value of Brant financial assets

Reference no: EM132365810

Assignment Questions -

Q1. 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 retire satage 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.

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

(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%.

i. 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.

ii. When considering your calculations, how would you explain the benefits of risk to Bradley?

(b) Explain the Australian dividend imputation credit system and how it applies in Australia. Include an analysis of how the receipt of franking credits will result in differing returns for Australian resident and international investors.

(c) Below is the monthly share price data for A2 Milk Company for the 2018 financial year. 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.10	5.86
Oct 17	5.92	7.62
Nov 17	7.34	7.59
Dec 17	7.60	7.37
Jan 18	7.40	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.70	10.52

i. Calculate the 2017-2018 monthly holding period returns (in both $ and %) for A2M.

ii. Calculate the average monthly return (%) for A2M.

iii. Using the data provided calculate the annual holding period return (in both $ and % terms) for an international (non-Australian) shareholder of A2M.

(d) The monthly data for the Australian All Ordinaries share price index 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

i. Calculate the monthly holding period returns (%) for the Australian share market (MKT) during 2017-2018 FY.

ii. Calculate the average monthly holding period return (%) for the MKT (ALL ORDS).

iii. 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.

iv. Using Excel (XL) prepare a line graph comparing the monthly returns for A2M and the return on the Australian (MKT).

v. Calculate the risk for 2018 as measured by standard deviation of both A2M and the MKT.

vi. 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?

vii. The average return on the market (MKT) in Australia for the past 10 years has been 9.55%. 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).

viii. 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.

ix. 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).

x. Based on your CAPM findings construct a portfolio made up of 40% A2M and 60% MKT. Calculate the estimated return and β for this portfolio.

Rationale - This assessment task will assess the following learning outcome/s:

be able to evaluate and explain the congruence of accounting, finance and treasury functions.
be able to explain and critique the objectives of financial management in contemporary organisations.
be able to critically evaluate mainstream financial theory and concepts.
be able to discuss and evaluate ethical considerations in financial dealings.
be able to demonstrate appropriate communication skills in the context of corporate finance.
be able to demonstrate specific technical competencies and skills in utilising quantitative techniques in financial analysis.

The requirements of this assignment cover up to and including Topic 5 of the Online Learning materials. The assignment is designed to develop your financial analysis and problem solving skills and develop your written communication skills. The questions require you to apply the knowledge and tools covered in the subject topics in order to demonstrate your understanding of the subject content. This assignment has a heavy focus on fundamental financial mathematics which is a critical building block to develop your capacity to understand and resolve complex finance problems.

Attachment:- Assignment File - Questions.rar

Reference no: EM132365810

Questions Cloud

Problems affecting projects in organization : When component providers failed to? deliver, project leaders did not locate and train new providers in time.

Revenue of the appliance business : By mid-decade, GE plans to have 75 percent of the revenue of the appliance business to come from American-made products.

Provide the journal entry for the estimated warranty expense : Provide the journal entry for the August 15 warranty work. If an amount box does not require an entry, leave it blank. Provide the journal entry for estimated.

Meaningful relationships with coworkers : Mae has a keen ability to form meaningful relationships with coworkers. People confide in her and feel that she really listens

What will be the value of Brant financial assets : What will be the value of Brant's financial assets when he retire satage 67? Present all calculations to support your answer

Provide the journal entry to record the payroll tax expense : Provide the journal entry to record the payroll tax expense for the period. If an amount box does not require an entry, leave it blank. Round to two decimal.

Think of ethical dilemma and issue : Think of an ethical dilemma/issue that you experienced recently - one in which you had to decide whether one choice or another was the more ethical.

Reflect on the results of the five categorical strengths : Reflect on the results of the five categorical strengths from your Clifton Strengths assessment, including what those results might indicate about your leadersh

Discuss your ideas of how to prevent paying phony billings : Discuss your ideas of how to prevent paying phony billings from a fictitious company. Also, evaluate the ideas others suggest in the discussion.

Reviews

len2365810

9/4/2019 10:21:12 PM

Marking criteria and standards - Correctly identify underlying financial management issues and all of the potential implications of finance data/results. A demonstrated and excellent understanding of finance theoretical perspectives. Output and recommendations are well researched and include well written arguments with references and sources acknowledged and output professionally presented. Correctly identify underlying financial management problem and identify and use appropriate finance technique to accurately solve problem. Ability to interpret the results of quantitative problem analysis. Use of appropriate formulae with very few errors. High standard of formatting enhancing the logical presentation of the output which aids understanding by report end users.

9/4/2019 10:21:03 PM

Requirements - Submission Requirements - High level oral and written communication skill is consistently rated the most important attribute of finance and accounting professionals by the accounting professional bodies. It is important that text responses are well written and that the written work (including formulae) have a professional level of presentation and formatting. Each session a number of students in ACC515 are investigated for incorrect referencing and plagiarism. Unfortunately this can take many forms from simple cut and pasting to the practice of purchasing assignment solutions from third party providers. In this assignment you are encouraged to research widely however you must recognise and acknowledge when you are using the work of others including academic and public media sources. Many students find academic referencing challenging, however an academic reference list, properly formatted using hanging indent, must be provided. Please note that it is a submission requirement that you include a reference list and assignments which do not include a properly formatted reference list will incur a 5 mark penalty.

9/4/2019 10:20:56 PM

In the assignment students are expected to write out the appropriate formula that they have selected to solve specific finance problems and show all workings. In terms of presentation for formula it is recommended that students use the formula function available through MS Word which allows students to present complex formulae in a professional manner within a Word Document. The assignment is marked out of 100. It is recommended that your name and student ID are included in the first page and the pages should be numbered.

Write a Review

Required(*) Message

User Account

All Pages