Create Excel scatter lot graph to plot Security Market Line

Assignment Help Other Subject

Reference no: EM132459376

Assignment -

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.

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

Question 1 - Eric has just been made CEO (Chief Financial Officer) of Sun Energy Storage Ltd, a company that produces batteries for solar panels used in residential properties. His focus is to reduce costs as much as possible in the short term and improve profitability. This, he feels, is important to shareholders.

a. Is Eric's focus on short-term profitability the best strategy for Sun Energy? Why or why not? Justify your position, outlining why your choice of strategy is superior.

b. Prior to the introduction of the dividend imputation system, dividends were taxed under the classical tax system. Explain the differences between the two different tax systems. Use examples to illustrate your explanation.

Question 2 - Below is the FY 2019 monthly share price data for Qantas FY

Date	Open	Close
July 18	6.17	6.72
Aug 18	6.72	6.43
Sept 18	6.45	5.9
Oct 18	5.81	5.47
Nov 18	5.44	5.96
Dec 18	6.06	5.79
Jan 19	5.84	5.44
Feb 19	5.44	5.73
Mar 19	5.77	5.66
Apr 19	5.66	5.61
May 19	5.57	5.55
Jun 19	5.47	5.4

i. Calculate the 2018-2019 monthly holding period returns (in both $ and %) for Qantas (ASX code QAS).

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

iii. Calculate the annual holding period return (HPR) for Qantas.

iv. Using Excel, prepare a line graph of the HPR for Qantas.

v. Calculate the risk measured by the standard deviation for Qantas.

vi. If the standard deviation for the market is 10.67%, how does this compare with Qantas's standard deviation calculated in (v)? Explain your conclusions.

Question 3 - a. In terms of share investment define that beta (β) represents.

b. According to Investing.com, Qantas has a beta of 0.59. What does this mean?

c. In terms of riskiness how would you compare Qantas's beta to the market?

d. Calculate the expected returns for Qantas using the Capital Asset Pricing Model (CAPM) and the following yields:

- the risk free rate (Rf) as measured by the yield on Australian 10 year treasury bonds is 2.75%

- the average return on the market for the past 10 years has been 9.25%

- use the Qantas beta of 0.59.

e. i. Using the CAPM data from (d), create an Excel scatter lot graph to plot the Security Market Line (SML) using the Rf, return on the market and Qantas.

ii. Based on your CAPM findings, construct a portfolio made up of 45% Qantas and 55% market. Calculate the estimated return and beta for this portfolio.

Reference no: EM132459376

Questions Cloud

Sales revenue under the worst-case scenario : What is the sales revenue under the worst-case scenario? What is the operating cash flow under the worst-case scenario based on this analysis?

Compute Dunnes US tax liability : Compute Dunne's U.S. tax liability after any available FTCs. Dunne's U.S. tax rate is 21%.Dunne paid $25,000 in Brazilian income taxes

What the depreciation expense : The company had costs of $77,535, dividends of $3,640, and interest expense of $2,920. If the tax rate was 40 percent, what the depreciation expense?

What will happen to interest rates on treasury securities : Predict what will happen to interest rates on a corporation's bonds if the federal government guarantees today that it will pay creditors if the corporation

Create Excel scatter lot graph to plot Security Market Line : Using the CAPM data from (d), create an Excel scatter lot graph to plot the Security Market Line (SML) using the Rf, return on the market and Qantas

What is the minimum monthly unit sales : What is the minimum monthly unit sales that Steady would require to make it more profitable as a specialty widget manufacturer than it is currently

What was the yield to maturity on the day you bought bond : Home Plc issued a nine year bond in November 2011 with a coupon rate of 8% (face value = £100). In November 2016 (just after that year's coupon

What was the yield to maturity on the day : Home Plc issued a nine year bond in November 2011 with a coupon rate of 8% (face value = £100). In November 2016 (just after that year's coupon had been paid)

What is the cobit framework : What is the COBIT Framework and how will I be able to implement such a framework for my own personal company of 2000 employees?

User Account

All Pages