Preview

Accounting Analysis Report

Satisfactory Essays
Open Document
Open Document
1198 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Accounting Analysis Report
1. Step One
(a)
Net finance costs = finance expenses – interest revenue
EBIT = Profit before tax + Net finance costs 2012
2011
2010
2009

$ '000
$ '000
$ '000
$ '000
Revenue
422291
423791
381219
347547
Sales
418981
411652
372120
343078
Cost of sales
-175843
-171256
-164789
-145275
Gross Profit
246448
252535
216430
202272
Finance expenses
563
787
597
118
Interest revenue
441
371
195
606
Net finance cost
122
416
402
-488
Profit before income Tax
20495
22690
17459
21888
Earnings before interest and tax (EBIT)
20617
23106
17861
21400
Net Profit
16103
18218
12331
15649
Trend Analysis
2012
2011
2010
2009
Revenue
121.5
121.9
109.7
100
Sales
122.1
120.0
108.5
100
Gross Profit
121.0
117.9
113.4
100
Earnings before interest and tax (EBIT)
121.8
124.8
107.0
100
Net Profit
477.1
666.9
505.9
100

(b)
Based on this analysis, profits have been increased over the period.

2. Step Two
(a)
Absolute $000’s figures
2012
2011
2010
2009
2008
Sales Revenue
418981
411652
372120
343078

Gross Profit
246448
252535
216430
202272

Net Profit
16103
18218
12331
15649

EBIT
20617
23106
17861
21400

Total Assets
146282
149280
129194
141668
108512
Total Equity
94629
91724
84792
74981
69989
Return on Equity
17.3%
20.6%
15.4%
21.6%

Return on Assets
14.0%
16.6%
13.2%
17.1%

Gross Profit Margin
58.8%
61.3%
58.2%
59.0%

Profit Margin
4.9%
5.6%
4.8%
6.2%

Net Profit Margin
3.8%
4.4%
3.3%
4.6%

Detailed calculation on Appendix 2 (a)
(b)
Ratios
2012
2011
2010
2009
Return on Equity
17.3%
20.6%
15.4%
21.6%
Return on Assets
14.0%
16.6%
13.2%
17.1%
Gross Profit Margin
58.8%
61.3%
58.2%
59.0%
Profit Margin
4.9%
5.6%
4.8%
6.2%
Net Profit Margin
3.8%
4.4%
3.3%
4.6%
Trend Analysis
2012
2011
2010
2009
Return on Equity
80.1
95.6
71.5
100
Return on Assets
81.5
97.0



References: P332-p333, Accounting: business reporting for decision making, 4E Study Guide by Jacqueline Birt Dividend payout ratio http://www.dividendpayoutratio.org/Good-Dividend-Payout-Ratio.html Price Earnings ratio http://www.theoptionsguide.com/price-to-earnings-ratio.aspx

You May Also Find These Documents Helpful

  • Powerful Essays

    Sales | 2,269,548 | 1,835,922 | Total Asset | 1,425,308 | 1,121,605 | Total Shareholders Equit | 1,044,226 | 810,873 | Average Total asset | 1986110.5 | | Average total shareholders equity | 1449662.5 | | Interest expenses | -2,945 | -269 | Income before interest and tax | 349,705 | 289,061 | | | | Times interest earned | 117.74 | 1073.57 | ROI | 16.87% | 15.95% |…

    • 1971 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    Revenue. Revenue includes net sales, cost of goods sold, and gross profit. Gross profit continues to grow at 30.4% with .23%/ $4,900 from year 12 to 13, and .93%/ $19,600 from year 13 to 14. Net sales also showed the same growth at 100%. The company expects continued growth over the next three years and according to the trend analysis, has the ability to do so. This demonstrates the company’s ability to keep overhead under control and maintain constant margin in relation to sales, consistent year after year. The expenses are variable in relation to the sales. Higher gross sales leads to higher operating income available to service debt in the form of interest payments.…

    • 1596 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Xacc 280 Week 3

    • 898 Words
    • 4 Pages

    As you can see in the Linden percentage columns they are significantly less profitable than the Industry. With the EBIT we can see that Linden is less profitable than the industry standard. Linden has a very good interest rate, because its borrowing less, in the end that could hurt them in terms of leveraging the return on equity. Look for excessive executive salaries and bonuses, lavish travel and entertainment expenses, money spent on acquiring other companies, and any other expenditures that aren’t strictly necessary to run the business.…

    • 898 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    The identified trends in Finish Line’s income statement positively reflect on its successful fiscal year. With the provided information of the covered period, it can be determined how Finish Line’s profitability and productivity exemplified the company’s strong performance and improvements since last fiscal year. At a…

    • 1736 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    QUESTION 2 Financial Statement Analysis (8 marks) BPS Ltd, a supplier of telecommunications equipment, retails its products through suburban outlets. Shown below are the calculations of some of its key financial ratios for 2011 and 2012. 2012 2011 Return on Equity 13% 12% Return on Assets 8% 9% Profit margin 20% 18% Asset turnover 0.40 0.50 Days in inventory 72 days 55 days Days in debtors 42 days 42 days Current ratio 1.6 1.5 Quick ratio 0.7 1.1 Debt-to-Equity ratio 1.4 1.0…

    • 1403 Words
    • 8 Pages
    Powerful Essays
  • Powerful Essays

    Chipotle Mexican Grill

    • 3043 Words
    • 13 Pages

    | 2011 | 2012 | SALES | 1,331,968,000 | 1,518,417,000 | 1,835,922,000 | 2,269,548,000 | 2,731,224,000 | COGS | 1,045,041,000 | 1,139,898,000 | 1,346,517,000 | 1,680,321,000 | 1,990,884,000 | SALES-COGS | 286,927,000 | 378,519,000 | 489,405,000 | 589,227,000 | 740,340,000 | GROSS MARGIN | 21.54 | 24.92 | 26.65 | 25.96 | 27.10 | (3) Operating Margins (Hint: Use Income from operations/Sales) Expressed as percentage. | 2008 | 2009 | 2010 | 2011 | 2012 | SALES | 1,331,968,000 | 1,518,417,000 | 1,835,922,000 | 2,269,548,000 | 2,731,224,000 | Op.…

    • 3043 Words
    • 13 Pages
    Powerful Essays
  • Good Essays

    Sun Microsystem Paper

    • 1039 Words
    • 5 Pages

    A complete analysis was conducted on the financial statements and status of Sun Microsystems. After examining the research findings and analysis it is fair to say that evidence determines that Sun Microsystems finances has not been on a steady incline. In fact, it had definitely experienced some highs and lows in its return on investment and stockholders? In order to get a concise understanding of where problems are within the company’s operations the following factors were considered and examined: the annual percentage change in net income per common share diluted, net income/net revenues, the major income statement accounts to net revenues, return on stockholders? In order for Sun Microsystems to see a greater return in its bottom line assets it must consider an alternative approach of operating its organization. The following is a comprehensive view of the finances of Sun Microsystems from 1998-2001. Sun Microsystems has experienced significant fluctuations in performance…

    • 1039 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Tootsie Roll

    • 274 Words
    • 2 Pages

    Tootsie Hersheys Earnings per share As given in the income statement $1.60 $1.97 Current ratio Current assets $211,878 = 3.78 $1,385,434 = 1.52 Current liabilities $56,066 $910,628 Gross Profit Ratio Gross profit (Net sales - Cost of goods sold) $176,947 = 35.7% $2,053,137 = 38.7% Net Sales $495,592 $5,298,668 Profit margin ratio Net Income $53,475 = 10.8% $435,994 =…

    • 274 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    accounting review

    • 6905 Words
    • 80 Pages

    A company had a beginning balance in retained earnings of $44,500. It had net income of $7,500 and paid out cash dividends of $6,000 in the current period. The ending balance in retained earnings equals:…

    • 6905 Words
    • 80 Pages
    Satisfactory Essays
  • Powerful Essays

    RETURN ON EQUITY | | | |PROFIT AFTER TAX X 100 |38.03% |18.84% | |EQUITY | | | |RETURN ON CAPITAL EMPLOYED | | | |OPERATING PROFIT(BEFORE INTEREST AND TAX)X100 |7.4% |4.3% | |TOTAL ASSET-CURRENT LIABILITIES | |…

    • 1436 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    Comprehensive Annual Financial Report (CAFR) is a report used by cities, and local governments to provide the public with their financial records each year, while adhering to government accounting standards board (GASB) guidelines. The report presents a comprehensive picture of the reporting entity’s financial condition, it provides how funds are spent and allocated throughout the year.…

    • 2247 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    Accounting review

    • 265 Words
    • 2 Pages

    -Determine the consolidated totals (Sales, COGS, Inventory, Depreciable Assets, Land, NCI in sub income, etc.)…

    • 265 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Revenue and Dell

    • 1723 Words
    • 7 Pages

    4. Is Dell’s strategy working? What is your assessment of the financial performance that Dell’s strategy has delivered during fiscal years 2000-2008? Use the financial ratios presented in the Appendix of the text (pages 240-241) as a basis for doing your calculations and drawing conclusions about Dell’s performance.…

    • 1723 Words
    • 7 Pages
    Good Essays
  • Powerful Essays

    Accounting Final Paper

    • 3139 Words
    • 13 Pages

    Below are extracts from the financial statements of a listed company which operates a chain of bakery and sandwich retail outlets in the United Kingdom.…

    • 3139 Words
    • 13 Pages
    Powerful Essays
  • Satisfactory Essays

    Employee Retention

    • 256 Words
    • 2 Pages

    The correlations of manager tenure (+0.44) and crew tenure (+0.26) with profits show that there is a clear positive financial effect of increasing tenure. Though both factors have a quite strong correlation with profits, the manager tenure seems to be a much stronger driver.…

    • 256 Words
    • 2 Pages
    Satisfactory Essays