Financial Statement Review

profilelanxxxx
financial20statement20case20study20template1.xlsx

Sheet1

Company: All data shown in ____thousands___________ of U.S. Dollars except stock information
Financial Data 2011 2012 % chg
Sales 149,197 169,287 88.1%
Cost of Sales (COGS) 104,011 119,261 87.2%
Gross Profit   45,186 50,026 90.3%
Net Income (Loss) 9,651 2,526 -26.1%
Inventory 9,446 11,749 80.3%
Cash 795 5,013 15.9%
Total Current Assets 27,277 32,333 84.3%
Long Term Debt ( part of total liability) 12,659 13,760 92.0%
Total Equity (Stockholders) 104,509 108,195 96.6%
Total Assets 158,908 165,664 95.9%
Liquidity Ratios - Speed to which a company can turn assets into cash
Current Ratio/ Liquidity Current Assets 32,333 _______$1.19________
Current Liabilities 27,126
Leverage (Debt) Ratios - Degree to which a firm relies on borrowed funds in its operations
Debt to ( Owner's) Equity Ratio Total Liabilities __________57,469 _____ _______531%____
Owner's Equity 108,195
Profitability (Performance) Ratios - How profitable a company is relative to its sales and resources.
Profit Margin (Return on Sales) Net Income ________2526 ____ ______1%_________
Sales 169287
ROI - Return on Equity Net Income after taxes ____________2526___ _________2.3%__
Total Owner's equity 108195
Activity Ratios - How effectively managmeent is turning over inventory
Inventory Turnover* Sales ___________169287____ ___14.41times____________
inventory 11749
addition ratios
acid-test ratio cash+accounts receivable+marketable securities/current liabilities 5013/27126=0.18

Sheet2