Finance

profileBfh
CaseStudy1.xlsx

Ratios

Profitability Ratios Liquidity Ratios Efficiency Ratios Leverage Ratios
Gross Profit Margin = Gross Profit/Revenue 0.1610 16.10% Current Ratio = CA/CL 0.9637 96.37% Inventory Turnover Ratio = COGS/Avg. Inventory 32.6229 Debt-to-assets ratio = Total Debt/Total Assets 0.2034 20.34%
Net Profit Margin = Net Income/Revenue 0.1080 10.80% Quick Ratio = (Cash + Short-term marketable investments + receivables) / CL 0.8717 87.17% Days of Inventory on Hand = Days in Period / Inventory Turnover 11.1884 Debt-to-capital ratio = Total debt/(total debt + total shareholders' equity) 0.2034 20.34%
ROA = Net Income/Avg. Total Assets 0.0200 2.00% A/R Turnover Ratio = Revenue / Avg. Receivables 4.6104 Debt-to-equity ratio = Total debt / total shareholders' equity 0.2554 25.54%
ROE = Net Income/Avg. Total Equity 0.0248 2.48% Days of Sales Outstanding = Days in Period / A/R Turnover 79.1691
Total Asset Turnover = Revenue / Avg. Total Assets 0.1856

Sheet2

2012 2011
Revenue $ 1,845,930.00 $ 1,819,948.00
COGS $ 1,548,692.00 $ 1,513,497.00
Gross Profit $ 297,238.00 $ 306,451.00
EBT $ 201,129.00 $ 265,410.00
Net Income $ 199,273.00 $ 263,862.00
Total Assets $ 9,790,510.00 $ 10,103,187.00
Total Equity $ 7,798,700.00 $ 8,239,684.00
Current Assets $ 745,605.00 $ 936,873.00
Current Liabilities $ 773,723.00 $ 951,505.00
Cash $ 274,337.00 $ 287,544.00
Short-term Marketable Investments $ 5,823.00 $ 178,954.00
A/R $ 394,257.00 $ 406,513.00
Inventory $ 49,659.00 $ 45,286.00
A/P $ 41,404.00 $ 80,114.00
Fixed Assets $ 8,821,779.00 $ 9,116,072.00
Total Debt $ 1,991,810.00 $ 1,896,949.00