05 - Horizontal and Vertical Analysis

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 3

2018-19 2019-20

Sales Revenue $ 2,126,279.13 100% $ 2,439,535.25


Less: Cost of Goods Sold $ 1,106,549.68 52% $ 1,488,534.60
Gross Margin $ 1,019,729.45 48% $ 951,000.65
Expenses: 0%
Advertising $ 51,635.53 2% $ 90,371.03
Depreciation $ 55,000.00 3% $ 55,000.00
Interest $ 77,115.60 4% $ 80,847.35
Other $ 25,000.00 1% $ 45,000.00
Payroll $ 288,412.78 14% $ 323,869.93
Utilities $ 58,853.13 3% $ 68,865.40
Net Income before Taxes $ 463,712.43 22% $ 287,046.95
Income Tax $ 163,047.45 8% $ 167,500.00
Net Income $ 300,664.98 14% $ 119,546.95
100%
61%
39%
0%
4%
2%
3%
2%
13%
3%
12%
7%
5%
2018-19 2019-20

Sales Revenue $ 2,126,279.13 $ 2,439,535.25 15%


Less: Cost of Goods Sold $ 1,106,549.68 $ 1,488,534.60 35%
Gross Margin $ 1,019,729.45 $ 951,000.65 -7%
Expenses:
Advertising $ 51,635.53 $ 90,371.03 75%
Depreciation $ 55,000.00 $ 55,000.00 0%
Interest $ 77,115.60 $ 80,847.35 5%
Other $ 25,000.00 $ 45,000.00 80%
Payroll $ 288,412.78 $ 323,869.93 12%
Utilities $ 58,853.13 $ 68,865.40 17%
Net Income before Taxes $ 463,712.43 $ 287,046.95 -38%
Income Tax $ 163,047.45 $ 167,500.00 3%
Net Income $ 300,664.98 $ 119,546.95 -60%

You might also like