Horizontal analysis of financial statement is one of the most important techniques to find out how company is doing financially
Horizontal analysis formula= Amount in comparision Year - Amount in base year * 100
Amount in base Year
PARTICULARS | current year | previous year | Horizontal ANALYSIS |
NET SALES | 43251 | 39474 | 9.6% |
COST OF SALES | 20351 | 18038 | 12.8% |
SELLING & ADM | 15965 | 14266 | 11.9% |
OPERATING INCOME | 6935 | 7170 | -3.3% |
OTHER INCOME | 86 | 461 | -14% |
INCOME BEFORE TAXES | 7021 | 7631 | -8% |
PROVISION FOR INCOME TAX | 1879 | 1973 | -4.8% |
NET INCOME | 5142 | 5658 | -9.1% |
AS PER THE GIVEN INFORMATON FROM HORIZONTAL ANALYSIS IT CAN BE CONCLUDED THAT COMPANY SALES HAVE INCREASED AS COMPARISION TO PREV YEAR BUT INCREAMENT IN SALES HAS LED TO INCREASE IN COST OF SALES BY 12.8% AND SELLING & ADMIS EXP BY 11.9% WHICH HAS RESULTED IN LOSS OF INCOME BY 9.1% AS COMPARISON TO PREVIOUS YEAR ,
THE DATA CLEARLY SHOWS THAT TO INCREASE THE PROFIT COMPANY HAS TO REDUCE ITS SELLING AND ADMISTARTIVE EXP BECAUSE WE CAN SEE THE SALES HAS INCREASED BY 9.6% BUT EXPENSES WHICH ARE DONE TO INCREASE SALES ARE FAR MORE THAN SALES RESULTS WE GET.
SO COMPANY NOT SHOWING FRUITFULL RESULTS.
Current Year Net sales $43,251 Cost of sales 20,351 Selling and Administrative expense 15,965 Operating income...
Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Income Statement Data for Year $66,800 $413,000 46,000 308,000 14,400 77,000 680 1,800 (90) (380) 1,400 6,900 $4,230 $18,920 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Balance Sheet Data (End of Year) $18,000 $47,000 27,500 121,000 $45,500 $168,000 $11,000 $54,000 16,800 45,000 17,700 69,000 $45,500 $168,000 Total assets Total...
Profitability ratios reflect the net result of all the firm's erect. B policies and operating decisions. The profitability ratios include the: (1) Operating profit margin, (2) Net profit margin, (3) Return on total assets (ROA), (4) Basic earning power (BEP) ratio, and (5) Return on common equity (ROE). The operating profit margin indicates what percentage of sales remain after et B are accounted for. It is a measure of the firm's operating effidency. Its equation is: B. It measures the...
Net sales Cost of goods sold Selling and administrative expenses Interest expense Other Income Income taxes Net Income Target Wal-Mart (1/31/22) (1/31/22) Income Statement Data for Year $78,000 $420,000 54,600 310,900 19,500 88,200 780 2,100 204,300 B, 120 $ 2.041 S 15.080 1.099 Current assets Noncurrent assets Tatal assets Current liabilities Long-term liabilities Tatal stockhalders' equity Tatal liabilities and stockholders' equity Target Wal-Mart Balance Sheet Data (End of Year) $20,160 $ 47,520 28,000 121,000 $48,160 $168,520 $12,000 $ 54.000 21,712...
Gadget Twin Inc. Income Statement For the Year Ending on December 31 (Millions of dollars) Year 2 Year 1 Net Sales 6,350 5,000 Operating costs except depreciation and amortization 1,120 1,040 Depreciation and amortization 318 200 Total Operating Costs 1,438 1,240 Operating Income (or EBIT) 4,912 3,760 Less: Interest 663 395 Earnings before taxes (EBT) 4,249 3,365 Less: Taxes (40%) 1,700 1,346 Net Income 2,549 2,019 Calculate the profitability ratios of Gadget Twin Inc. in the following table. Convert all...
Question 2 of 2 < Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income Income taxes Net income Target Wal-Mart (1/31/22) (1/31/22) Income Statement Data for Year $60,000 $404,000 39,000 282,800 14,400 68,680 600 2,020 20 4,000 2,107 19,075 $3.913 $ 35,425 Current assets Noncurrent assets Total assets Current liabilities Long-term liabilities Total stockholders' equity Total liabilities and stockholders' equity Target Wal-Mart Balance Sheet Data (End of Year) $13,500 $36,400 24,000 110,000 $37.500 $146,400 $9,000...
Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating income (loss) Year 1 $1,000,000 740,000 260,000 230,000 $ 30,000 Year 2 $ 780,000 520,000 260,000 200,000 $ 60,000 Year 3 $1,000,000 785,000 215,000 230,000 $ (15,000) In the latter part of Year 2, a competitor went out of business and in the process dumped a large number of units on the market. result, Starfax's sales dropped by 20% during Year 2 even though production increased during...
2018 2017 Income Statement Information Sales revenue Cost of goods sold Net income $ $ 10,440,000 6,827,760 360,000 8,400,000 5,900,000 248,000 Balance Sheet Information Current assets Long-term assets $ 1,600,000 2,200,000 $ 1,500,000 1,900,000 Total assets $ 3,800,000 $ 3,400,000 $ Current liabilities Long-term liabilities Common stock Retained earnings 1.200,000 1,500,000 800,000 300,000 900.000 1,500,000 800,000 200,000 Total liabilities and stockholders' equity 3,800,000 $ 3,400,000 Required: 1. Calculate the following profitability ratios for 2018 (Round your answers to 1 decimal...
Net sales Cost of goods sold Operating expenses Interest expense Income tax expense Current assets Plant assets (net) Current liabilities Long-term liabilities Net cash common by operating activities Capital expenditures Dividends paid on common stock Weighted-average common shares outstanding Novak Corp. 2022 $2,304,000 1,504.000 362.240 10,960 108,400 466,950 680,050 84.900 138,765 176,640 115,200 46,080 80,000 Martinez Corp. 2022 $793,600 435,200 125,440 4,880 46,080 198,720 178,720 43,200 51,160 46,080 25,600 19,200 50,000 Compute working capital and the current ratio for each...
Net sales Income before interest and taxes Net income after taxes Interest expense Stockholders' equity, December 31 (2016: $191,000) Common stock, December 31 $422,000 119,000 55,560 8,650 314,000 210,000 $269,000 75,000 63,200 7,500 240,000 231,000 The average number of shares outstanding was 7,810 for 2018 and 6,880 for 2017 Required Compute the following ratios for Finch for 2018 and 2017. a. Number of times interest was earned. (Round your answers to 2 decimal places.) b. Earnings per share based on...
Sales revenue Cost of goods sold Gross profit Selling, general, and administrative expenses Loss on sales of securities Income before interest and taxes Interest expense Income before taxes Income tax expense Net income Retained earnings, January 1, 2017 $542,825 (435,550) $107,275 $(65,830) (310) $41,135 (9,220) $31,915 (12,766) $19,149 58,615 $77,764 (12,149) $65,615 Dividends paid on common stock Retained earnings, December 31, 2017 December 31, 2016 Heartland Inc. Comparative Statements of Financial Position (thousands omitted) December 31, 2017 Assets Current assets:...