Prepare a horizontal analysis of the income statement

Assignment Help Accounting Basics
Reference no: EM132085312

ASSIGNMENT 1

In gradebook you will see a section "Company number" with a number between 1 and 6. This is the number of the company that you are allocated for this assignment.

1 Aristocrat Leisure Ltd (ALL)
2. Bega Cheese Ltd (BGA)
3. Cash Converters International Ltd (CCV)
4. JB Hi Fi Ltd (JBH)
5. Retail Food Group Ltd (RFG)
6. Woolworths Ltd (WOW)

Required:

A. Access the annual reports for your allocated company for the years 2013, 2015 & 2017. These reports arc usually available on the company's website under "Investors". Alternatively, if you cannot locate each of the years, you should be able to access.

B. The annual reports will provide you with six years of financial statements for 2012, 2013, 2014, 2015, 2016 & 2017.

C. Prepare a horizontal analysis of the Income statement for the five years 2013 - 2017. Comment on the changes over the five years. (Approximately 300 words)

D. Calculate the following ratios for the five years 2013 - 2017 (2012 financial information will assist you in calculating averages, where necessary).
1. Return on total assets (not in text - search in Google and cite your findings)
2. Rate of return on ordinary equity
3. Operating profit margin
4. Gross profit Margin
5. Inventories turnover period
6. Settlement period for debtors
7. Current ratio
8. Quick ratio (acid test ratio)
9. Debt to assets ratio (not in text - search in Google and cite your findings)
10. Interest cover ratio (Times interest earned)
11. Assets turnover (not in text - search in Google and cite your findings)
12. Earnings per share
13. Price-earnings ratio (refer to Blackboard for stock price history for five years).
14. Dividend yield (refer to Blackboard for the dividend history for five years). (7 marks)

E. Given the ratios over five years, comment on the company's profitability, efficiency, liquidity, financial gearing and investment ratios. Approximately 1.000 words.

You may also refer to coverage in the financial press that is related to sour company. This might help you in evaluation of the company - please cite 'our sources!

Cash Converters Ltd (CCV) Year end 30th June

 

2013

2014

2015

2016

2017

Dividends paid during year

$0.0375

$0.040

$0.04

$0.02

$0.01

Market price of share at 30th June each year

$1.07

$1.08

$0.70

$0.44

$0.395

Attachment:- accounting formulas.rar

Reference no: EM132085312

Questions Cloud

Pay gap between women and men salary : Pay gap between women and men salary, Discuss what steps should employees and managers take to close these gaps in salary between men and women ?
Follow-up with an interviewer : Remind them of points that stood out during the interview and that separated you from everyone else. Allay any negatives that remain.
How you would use your leadership abilities : what resources are available for organizational growth and expansion. Assess what skills and knowledge are needed to access these resources.
What is the weighted average cost of capital : The cost of equity is 14.5 percent and the aftertax cost of debt is 4.8 percent. What is the weighted average cost of capital?
Prepare a horizontal analysis of the income statement : ACC00724 - Accounting for Managers - Prepare a horizontal analysis of the Income statement for the five years 2013 - 2017. Comment on the changes over
Research the various database management system : IT 650 : Research the various database management system (DBMS) products available for your scenario and compare the top contenders to highlight.
Required external financing over the next year : What is the formula to calculate the required external financing over the next year?
What price would these bonds sell in the marketplace : At what price would these bonds sell in the marketplace? How many bonds would the firm have to issue to raise $1 million?
Weight of equity-weight of debt : What are the weight of equity, weight of debt, cost of equity, after tax cost of debt, Wacc.

Reviews

len2085312

8/13/2018 12:58:42 AM

Given the ratios over five years, comment on the company's profitability, efficiency, liquidity, financial gearing and investment ratios. Approximately 1.000 words. Note: You may also refer to coverage in the financial press that is related to sour company. This might help you in evaluation of the company - please cite 'our sources!

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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