qsn

profileMichelle_Michy
2018060401302220180601223057final_statement_analysis__part_two_fpfp.xlsx
Home>Applied Sciences homework help>qsn

Sheet1

Income horizontal analysis
12/31/17 12/31/16 12/31/15
Total Revenue 4,976,553 4,825,335 3,963,313
Cost of Revenue 2,737,830 2,584,724 2,057,766
Gross Profit 2,238,723 2,240,611 1,905,547
Total Revenue 3.13 21.75 _
Cost of Revenue 5.92 25.61 _
Gross Profit -0.08 17.58 _
Income vertical analysis
12/31/17 12/31/16 12/31/15
Revenue % 100% 100% 100%
Cost of revenue % 55.01 53.57 51.92
Gross profit % 44.99 46.63 48.08

Sheet2

Vertical analysis
Horizontal Analysis
12/31/17 12/31/16 12/31/15 12/31/17 12/31/16 12/31/15
Cash And Cash Equivalents 312,483.00 7.80 250,470.00 7 129,852 5 Cash And Cash Equivalents 24.76 92.88 _
Short Term Investments - - - Short Term Investments - - -
Net Receivables 609,670.00 15.00 622,685.00 17 433,638 15 Net Receivables -2.09 43.60 _
Inventory 1,158,548.00 28.90 917,491.00 25 783,031 27 Inventory 26.27 17.17 _
Other Current Assets 256,978.00 6.41 174,507.00 5 152,242 5 Other Current Assets 47.26 14.62 _
Total Current Assets 2,337,679.00 58.35 1,965,153.00 54 1,498,763 52 Total Current Assets 18.96 31.12 _
Long Term Investments - - - Long Term Investments _
Property Plant and Equipment 885,774.00 22.10 804,211.00 22 538,531 19 Property Plant and Equipment _
Goodwill 555,674.00 13.87 563,591.00 15 585,181 20 Goodwill -1.40 -3.69 _
Intangible Assets 46,995.00 1.17 64,310.00 2 75,686 3 Intangible Assets -3.07 -15.03 _
Accumulated Amortization - - - Accumulated Amortization _ _ _
Other Assets 97,444.00 2.43 110,204.00 3 75,652 3 Other Assets 37.49 _
Deferred Long Term Asset Charges 82,801.00 2.07 136,862.00 4 92,157 3 Deferred Long Term Asset Charges 48.50 _
Total Assets 4,006,367.00 3,644,331.00 2,865,970 _ Total Assets
Current Liabilities Current Liabilities
Accounts Payable 857,949.00 21.41 618,429.00 17 393,395 14 Accounts Payable 38.73 57.20 _
Short/Current Long Term Debt 152,000.00 3.79 27,000.00 7 42,000 1 Short/Current Long Term Debt 462.96 -35.71 _
Other Current Liabilities 50,426.00 1.26 40,387.00 1 43,415 2 Other Current Liabilities 24.86 -6.97 _
Total Current Liabilities 1,060,375.00 26.47 685,816.00 19 478,810 17 Total Current Liabilities 54.62 43.23 _
Long Term Debt 765,046.00 19.10 790,388.00 22 624,070 22 Long Term Debt -3.20 26.65 _
Other Liabilities 137,227.00 4 94,868 3 Other Liabilities 18.27 44.65 _
Deferred Long Term Liability Charges - - - Deferred Long Term Liability Charges - - _
Minority Interest - - - Minority Interest - - _
Negative Goodwill - - Negative Goodwill - - _
Total Liabilities 1,987,725.00 1,613,431.00 1,197,748 Total Liabilities 23.2 34.71 _
Stockholders' Equity
Misc. Stocks Options Warrants - - - Misc. Stocks Options Warrants - -
Redeemable Preferred Stock - - - Redeemable Preferred Stock - -
Preferred Stock - - _ Preferred Stock - -
Common Stock 146 0.03 145 0.03 144 0.03 Common Stock 0.69 145
Retained Earnings 1,184,441 30 1,259,414 35 1,076,533 38 Retained Earnings -5.95 16.99
Treasury Stock - - - Treasury Stock - -
Capital Surplus 872,266 22 823,484 23 636,558 22 Capital Surplus 5.92 29.37
Other Stockholder Equity -38,211 -52,143 -45,013 Other Stockholder Equity 26.72 -15.84
Total Stockholder Equity 2,018,642 50 2,030,900 56 1,668,222 Total Stockholder Equity -0.6 21.74
Net Tangible Assets 1,415,973 1,402,999 1,007,355 58

Sheet3

Ratios
2017 2016 2015
ROE
net income -48,260 256,979 232,573
net sales 4,976,553 4,825,335 3,963,313
% 0.96 5.33 5.87
Total assets turnover
net sales 4,976,553 4,825,335 3,963,313
average total assets 2,337,679 1,965,153 1,498,763
2.13 2.46 2.64
Financial Leverage
total assets 4,006,367 3,644,331 2,865,970
total equity 2,018,642 2,030,900 1,668,222
1.98 1.79 1.72
contribution margin
Sales 4,976,553 4,825,335 3,963,313
variable costs 2,737,830 2,584,724 2,057,766
2,238,723 2,240,611 1,905,547
current ratio
current assets 2,337,679 1,965,153 1,498,763
current liabilities 1,060,375 685,816 478,810
2.20 2.87 3.13
D/E ratio
Debt 152,000 27,000 42,000
Equity 2,018,642 2,030,900 1,668,222
0.08 0.01 0.03
EPS
Net income -48,260 256,979 232,573
no of ordinary shares 146 145 144
-330.55 1772.27 1615.09
Debt to capital
Debt to 152,000 27,000 42,000
capital 1,415,973 1,402,999 1,007,355
0.11 0.02 0.04

Sheet4

Altman Z-Score
2017 2016 2015
working capital 1277304 1279337 1019953
total assets 4,006,367 3,644,331 2,865,970
0.32 0.35 0.36
retained earning 1,184,441 1,259,414 1,076,533
total assets 4,006,367 3,644,331 2,865,970
0.30 0.35 0.38
EBIT 24,229 414,716 401,313
Total assets 4,006,367 3,644,331 2,865,970
0.01 0.11 0.14
Market equity value 2,018,642 2,030,900 1,668,222
total liabilities 1,987,725 1,613,431 1,197,748
1.02 1.26 1.39
sales 4,976,553 4,825,335 3,963,313
total assets 4,006,367 3,644,331 2,865,970
1.24 1.32 1.38
Z 2.88 3.39 3.65