Gemini Electronics Template and Raw Data
Gemini Electronics Template and Raw Data
Gemini Electronics Template and Raw Data
2005 2006
Sales $2,142,659,000 $5,413,625,000
COGS 1,323,957,000 3,120,000,500
Gross Profit 818,702,000 2,293,624,500
Operating Costs
S&D 212,340,640 545,980,400
R&D 93,640,450 220,340,340
Administration 95,003,300 405,340,300
EBITDA 417,717,610 1,121,963,460
Balance Sheet
2,005 2,006
Assets
Cash $310,630,300 $790,419,373
A/R 316,972,950 758,988,750
Parts Inventory 253,578,360 607,191,000
WIP Inventory 26,789,180 45,354,460
Finished Goods Inventory 359,340,630 960,187,250
Total Current Assets 1,267,311,420 3,162,140,833
S&D
R&D
Administration
EBITDA
Amortization
Operating Profit (EBIT)
Interest
Earnings Before Taxes
Taxes
Net Income
Balance Sheet
2005 2006 2007 2008
Assets
Cash
A/R
Parts Inventory
WIP Inventory
Finished Goods Inventory
Total Current Assets
Long-Term Debt
Total Liabilites
Shareholders Equity
Total Liabilities & Equities
2009
2009
1,000,000 ommitted
2005 2006 % Change 2007 % Change 2008 % Change
Sales
COGS
Gross Profit
S&D
R&D
Administration
EBITDA
Amortization
Operating Profit (EBIT)
Interest
Earnings Before Taxes
Taxes
Net Income
Balance Sheet
2005 2006 2007 2008
Assets
Cash
A/R
Parts Inventory
WIP Inventory
Finished Goods Inventory
Total Current Assets
Long-Term Debt
Total Libilities
Shareholders Equity
Total Liabilities & Equities
2009 % Change
2009
Income Statement 1,000,000 ommitted
2005 2006 2007 2008 2009 Industry
Sales
COGS
Gross Profit
Operating Costs
Selling and Distribution
R&D
Administration
Depreciation
Operating Profit
Interest
Earnings Before Taxes
Taxes
Net Income
Balance Sheet
Assets 2005 2006 2007 2008 2009 Industry
Cash
Accounts Receivable
Parts Inventory
WIP Inventory
Finished Goods Inventory
Total Current Assets
Liabiities
Accounts Payable
Current Portion of Long-term Debt
Total Current Liabilities
Long-term Debt
Shareholders’ Equity
Total Liabilities and Equities
Ratio Formula 2005 2006 2007 2008 2009 Industry Comments
Liquidity
Current CA/CL
Quick CA-Inv-PP/CL
Cash Cash + MS/CL
Asset Management
AR TO Credit Sales/ Avg AR
AR TO Day 365/AR TO
Inv. TO COGS/Avg. Inv.
Inv. TO Days 365/ Inv. TO
AP TO COGS/Avg. AP
AP TO Days 365/AP TO
FA TO Sales/Avg. FA
TA TO Sales/Avg. Ta
Lerverage
Debt TL/TA
Debt/Equity LTD/Equity
Coverage
TIE EBIT/Int.Exp.
Profitability
GPM GP/Sales
OPM Op. Inc./Sales
NPM NI/Sales
OP ROI EBIT/Avg. TA
ROA NI+I(1-t)/Avg. TA
ROE NI/Avg. Equity