ipl-logo

Horizontal Analysis Ratio

1473 Words6 Pages

Financial Analysis
Horizontal Analysis of Income Statement
Revenue 2014 2013 2012 2011 Sales revenue 206% 194% 181% 100% Less cost of goods sold 221% 209% 200% 100%
Gross profit 165% 151% 128% 100% Expenses Operating Expenses Admin expenses 155% 139% 120% 100% Selling and distribution expenses 151% 142% 127% 100% Total 153% 141% 123% 100% Operating Profit 175% 161% 132% 100% Non Operational Expenses Financial expenses 263% 187% 135% 100% Net Income Before Taxes 175% 161% 132% 100% Income tax expense 198% 186% 174% 100% Net Income 172% 159% 129% 100%

Horizontal analysis focuses on trends and changes in financial statement items over time. Along with the dollar amounts presented in the financial statements, horizontal analysis can help a financial statement user to see relative changes over time and identify positive or perhaps troubling trends. Base year for this analysis is taken as 2011. The table shows that the sales revenue and cost of goods sold increased over the years. And so did the gross profit of the company. All the expenses, admin and selling increased over the years.But the increase in cost of goods sold was greater than the increase in the sales revenues. This shows that the company is incurring higher raw material cost. Moreover, financial expense over the year also rose. …show more content…

Horizontal Analysis of Balance Sheet
Assets 2014 2013 2012 2011 Current Assets Stocks and stores 136% 144% 151% 100% Accounts Receivable 219% 516% 192% 100% Advances and prepayments 14% 90% 67% 100% Bank 278% 138% 44% 100% Cash 0% 0% 222% 100% Total Current Assets 136% 168% 130%

Show More
Related

Xacc/280 Week 4 Financial Statement Analysis

470 Words | 2 Pages

All four statements have the name of the company, a title statement, a date to show what time period the statement is for, and a unit of measure to show amounts of dollars for each statement. Balance sheets are used to show the company’s assets, liabilities and stockholders’ equity. This is to show where

Read More

Est1 Task 3

864 Words | 4 Pages

Task 3 Limited companies have a legal duty to produce a balance sheet of their annual accounts which are submitted to Companies House, Shareholders and HM Revenue & Customs. Producing a balance sheet is essential for any organisation who wish to raise finance, the majority of lenders or investors will want to see a set of business accounts. A balance sheet will closely monitor the performance of the business, showing the shareholder’s equity, liabilities and assets of the business. Ratio calculations evaluate the financial results of any business in order to gauge its performance. Ratios allow businesses to compare against different principles using the figures on the balance sheet.

Read More

Reid Paralegal Services Company Case Study

605 Words | 3 Pages

7.4 General Assumptions General Assumptions Year 1 2 3 Short Term Interest Rate 9.5% 9.5% 9.5% Long Term Interest Rate 10.0% 10.0% 10.0% Federal Tax Rate 33.0% 33.0% 33.0% Provincial Tax Rate 5.0% 5.0% 5.0% Personnel Taxes 15.0% 15.0% 15.0%   7.5 Profit and Loss Statements Proforma Profit and Loss (Yearly) Year 1 2 3 Sales $407,778 $440,400 $475,632 Cost of Goods Sold $40,778 $44,040 $47,563 Gross Margin 90.00% 90.00% 90.00% Operating Income $367,000 $396,360 $428,069 Expenses Payroll $198,500 $227,115 $257,268 General and Administrative $25,200 $26,208 $27,256 Marketing Expenses $2,039 $2,202 $2,378 Professional Fees and Licensure $5,219 $5,376 $5,537 Insurance Costs $1,987 $2,086 $2,191 Travel and Vehicle Costs $7,596 $8,356 $9,191 Rent and Utilities $20,000 $21,000 $22,050 Miscellaneous Costs $4,893 $5,285 $5,708 Payroll Taxes $29,775 $34,067 $38,590 Total Operating Costs $295,209 $331,695 $370,169 EBITDA $71,791 $64,666 $57,900 Federal Income Tax $23,691 $18,656 $16,642 Provincial Income Tax $3,590 $2,827 $2,522 Interest Expense $8,738 $8,131 $7,468 Depreciation Expenses $4,107 $4,107 $4,107 Net Profit $31,666 $30,944 $27,160 Profit Margin 7.77% 7.03%

Read More

Bus 601 Week 1 Financial Statement Analysis

1053 Words | 5 Pages

This report represents the company’s assets, liabilities and owner’s equity. Therefore, the equation of this report is Assets = Liabilities + Owner’s Equity. The equation itself works as the format as to how the balance sheet items are being presented in the report. Assets are separated into current assets (i.e. cash, inventories, accounts receivables, prepaid asset accounts etc.), and non-current assets (i.e. property, plant & equipment, land, etc.

Read More

Case Study Cool Moose

1318 Words | 6 Pages

Cool Moose Creamery Incremental Income Statement New Triple Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Sales $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 Cost of Goods Sold 1336 1336 1336 1336 1336 1336 1336 Gross Margin 8,664 8,664 8,664 8,664 8,664 8,664 8,664 Depreciation 285.71 1,714.29 1,714.29 1,714.29 1,714.29 1,714.29 1,714.29 Refrigerator Expense 150 Delivery expense 150 Installation Expense 650 Utilities 350 350 350 350 350 350 350 Wages 2,239.95 2,109.15 2,109.15 2,109.15 2,109.15 2,109.15 2,109.15 Interest Expense 594 662.5705 504.3456 334.6827 152.7547 8.241626 0 Opportunity Cost 2,415 2,415 2,415 2,415 2,415 2,415 2415 Total Expense 7,834.98 7,251.01 7,092.78 6,923.12 6,741.19 6,596.68 6,588.44 Net Income $829.02 $1,412.99 $1,571.22 $1,740.88 $1,922.81 $2,067.32 $2,075.56 Disadvantages: a) Customers will reduce buy scooped ice

Read More

Vertical And Horizontal Analysis: DICK S Sporting Goods

352 Words | 2 Pages

Vertical and Horizontal Analysis: 1. Net Sales: The 6.5% increase of net sale from 2013 – 2014 comes from the opening of new DICK’S Sporting Goods stores, the continuous enhancement of the e-commerce platform and redesign of the mobile app. Besides, the laid plans to expand distraction center in Georgia also contributes to the increase in the total sales. By comparison, the 9.7% increase of the net sale of 2014 - 2015 demonstrates that opening Filed & Stream specialty stores, reallocateing space within the stores towards high growth categories the company contribute to the profitable growth and an elevation of net sales. 2.

Read More

John Deere & Company Financial Analysis

1243 Words | 5 Pages

This decline is primarily because of reduced shipment volumes, and unfavorable effects of foreign currency exchange and a less favorable product mix. Net income of the Company’s equipment operations was $1,058 million for 2016, compared with $1,308 million in 2015. In addition to the operating factors mentioned above, a higher effective tax rate in 2016 reduced net income. The cost of sales to net sales ratio for 2016 was 78.0 percent, compared with 78.1 percent last year. The decrease was due primarily to price realization and lower production costs, largely offset by the unfavorable effects of foreign currency exchange and the impact of a less favorable product

Read More

Delta Air Profitability Ratios

587 Words | 3 Pages

The currency fluctuations (Dollar Strength 2015) increased expenses as Latin America negatively influenced revenue (Monica 2016). The fuel expenses decreased by 44% saving 5.1 billion dollars (Monica 2016), along with help of DAL’s refinery. Salaries expense increased due to announcement of increased pay for employees (Black 2015). UCH Comparison: UCH OPM almost doubled due to considerable increase of income by 118% by controlling costs. The OPM of UCH is still lower than DAL.

Read More

Variance Analysis Task 4

737 Words | 3 Pages

Positive figures show excess and the deficit of it vice versa. The most important tool to be taken seriously is the breakeven point where the company must maintain equilibrium. However, if we notice the total profit from this year and previous task data most of the figures are left untouched which should be utilized to increase the productivity level. The company has a favorable turnover which shows that it has the ability of acquiring its market share. The variance has an adverse effect due to a change in price of raw material, labor cost and factory overheads.

Read More

Break Even Analysis Paper

475 Words | 2 Pages

It also includes the variable expenses that change depending on how many items are sold in a given period such as a component part to

Read More

Company Balance Sheet Analysis

1068 Words | 5 Pages

Balance statements is show if the business has the finances to pay for their acquired debt. Long term and short term debt is discussed in classified sheet unlike the none classified sheet. Assembling all of the assets, cash, account receivable, notes receivable, investments, equipment inventory. Each subgroups of asset have a total amount which is calculated in total assets. Liabilities is organized that exact way.

Read More

Outline For Business Analysis Paper

597 Words | 3 Pages

The organization structure they use i. Who makes what decisions? d. Is the proportion of money from different products changing? e. How about return on investment? Profit margin? Other financial measures of interest (6) Projections for the

Read More

2D/4D Ratio Analysis

1592 Words | 7 Pages

The purpose for this lab is to test what has been suggested by many authors decades ago, if the 2D/4D ratio is in fact a sexually dimorphic trait between men and women. Several studies had been conducted in the past, and had demonstrated that in fact males tend to have lower 2D and 4D ratios than women (Galis et al., 2010, George, 1930). Past studies has suggested this difference in ratio between males and females is observed as early as several months to two years old babies, and is in fact due to the levels of androgens including testosterone and oestrogen in which the baby in its mother womb is exposed to (Austin et al., 2002, Manning et al., 1998). In this lab, Students placed their right hand with palms faced down on top of the paper

Read More

Marks And Spencer Competitive Analysis

1614 Words | 7 Pages

In terms of controlling, the management of Marks and Spencer has frequent reporting of expenditures with costs to provide a form of feedback. The reactions of managers to such type of data rely on the expectations or the formal budget or planned targets. The management believes in collecting and assigning cost data that is being shifted away from control. There is a recognition related to the repetitive exercise of planning and re-planning for creating a full time job for accountants. The assessment and evaluation of cost data in the aspects of launching new product by Marks and Spencer is about gaining insights and learning ways for achieving the goals of organisation in most effective manner.

Read More

Swot Analysis Of International Trade

892 Words | 4 Pages

Year Merchandise in Million $ % Growth Services in Million $ % Growth 2014-15 -144179 -2.32% 75683 3.73% 2013-14 -147609 -24.56% 72965 12.40% 2012-13 -195656 3.11% 64915 1.27% 2011-12 -189759 49.04% 64098 45.41% 2010-11 -127322 7.72% 44081 22.39% 2009-10

Read More

More about Horizontal Analysis Ratio

Related Topics

Open Document