Accounting and finance for business assignment go to

Question

ACCOUNTING AND FINANCE FOR BUSINESS ASSIGNMENT

Case Study 1 -

FACT SET

Go to www.asx.com.au and look up the prices for your allocated stock in the Search field at the top right of the screen.

TASKS

1. In Table 1, enter the date and last price of each stock, then calculate the market cap, current P/E, and current dividend yield for each stock based on the last price.

2. In Table 2, provide a definition explaining the information each data item provides you as a potential investor in the stock.  [Provide a single agreed answer per team.]

3. Compare and contrast the current market value of each stock.  [Provide a single agreed answer per team.]

Table 1

	IPL	NUF	RHL	RIC	Mark
Date of Last Price					4
Last Price (AUD)					4
Shares Outstanding (M)	1,690.0m	266.7m	79.3m	307.8m
Market Cap (B AUD)					4
Earnings Per Share (AUD) (TTM)	$0.076	$0.061	$0.054	$0.089
Current P/E Ratio (TTM)					4
Dividend (AUD) (TTM)	$0.087	$0.11	$0.10	$0.04
Current Dividend Yield (%)					4

Table 2

	Definition/Explanation	Mark
Last Price		1
Bid Price		1
Ask Price		1
Shares Outstanding		1
Market Capitalisation		1
Beta		1
Earnings Per Share (TTM)		1
Current P/E Ratio (TTM)		1
Dividend Per Share (TTM)		1
Current Dividend Yield (%)		1

Case Study 2 -

FACT SET

Go to https://au.finance.yahoo.com and obtain the closing adjusted price for each of the four stocks on the 31st December for each year from 2009 to 2015. [Enter the stock code in the "Enter Symbol" field top left of screen.  Click the "Look Up" button.  Click the "Historical Prices" hyperlink. Select "Monthly" for Frequency. Click on the "Apply" button. Record the December Adjusted Close Price for each December. Note each row is titled the first of the month, but actually refers to monthly data and hence the closing adjusted price shown is the Last Price of the month.]

Go to https://au.finance.yahoo.com and obtain the dividends paid by each of the four stocks for each year from 2009 to 2015. [Enter the stock code in the "Enter Symbol" field top left of screen.  Click the "Look Up" button.  Click the "Historical Prices" hyperlink. Select "Dividends Only" after Show. Click on the "Apply" button. Record the Dividends paid in each relevant year.]

TASKS

1. Calculate the Holding Period Return for each company for each year from 1^st January 2010 to 31^st December 2015.

2. Estimate the Expected Return of each company based on your historical sample of returns.

3. Estimate the risk of each company based on your historical sample of returns.

4. Calculate the five-year Total Return to Shareholders of each company over the period from 31st December 2010 (Year 0) to 31st December 2015 (Year 5), using the following formula:

[Price_Year5 + Dividends_Year1-5/Price_{Year 0}]^1/5 - 1

5. Compare and contrast the risk and return of each company. [Provide a single agreed answer per team.]

Case Study 3 -

FACT SET

Go to the website for your allocated company and obtain the Income Statement and Balance Sheet for the company for the 2009/10 (Year 0) and 2014/15 (year 5) financial years.  You will find this information in the relevant Annual Reports.

TASKS

1. Based on the information contained in these statements calculate for each company:

a. The annual growth in Earnings per Share over the five years to 30th June 2015, using the following formula.

[EPS_{Year 5}/EPS _{Year 0}]^1/5 - 1

b. The Net Profit Margin, Asset Turnover Ratio, Leverage Ratio, Net Debt to Equity Ratio and Return on Equity for the company for both financial years.

2. Demonstrate what would happen to the 2014/15 Return on Equity and the Net Debt to Equity Ratios if your allocated company just prior to the end of the 2015 financial year raised an additional $50 million loan from the bank, which it invested entirely in new plant and equipment. Assume that the immediate effect on sales and net profit was zero.

3. Demonstrate what would happen to the 2014/15 Return on Equity and the Net Debt to Equity Ratios if your allocated company just prior to the end of the 2015 financial year instead of raising the additional loan raised an additional $50 million through the sale of new shares to the public, which it used to pay for the new plant and equipment. Assume that the immediate effect on sales and net profit was zero.

4. Compare and contrast the financial performance of the companies over the past 5 years. [Provide a single agreed answer per team.]

5. Use your analysis of the financial performance of the companies over the past 5 years to explain any differences in the Total Return to Shareholder between the companies over the past 5 years, which you have calculated in Case Study 2. [Provide a single agreed answer per team.]

Attachment:- Assignment.rar