Annual Review Report- Assignment 2
dhaanj
sample_for_assignment_2-financial_analysis_spreadsheet.xlsxStep 1 - Ratios
| STEP 1: Print out this tab's 2 pages & make notes about how you should interpret/apply each item | ||
| Test of Investment & Asset Utilization | Cells below are available for typing comments. All other cells on this tab are password protected. | |
| Working Capital | All Current Assets | Ex: Working capital tells us the value of all our Current Assets that we have on hand to "work" with in |
| - Current Liabilities | order to meet our upcoming Current Liabilities that will be due in the next 12 months. Higher levels | |
| Working Capital | are optimal--we especially want to see Cash being the largest part of Current Assets. Afterall, A/R takes | |
| time to collect and we cannot send a pallet of inventory to pay the electric bill. We must write a check. | ||
| #18 | Current Ratio | |
| All Current Assets | ||
| Current Liabilities | ||
| #19 | Acid Test (Quick) Ratio | |
| Cash Current Assets | ||
| Current Liabilities | ||
| Accounts Receivable Turnover (as times) | ||
| Net Sales | ||
| Net Accounts Rec. | ||
| #14 | Days Receivables (or Collection Period) | |
| (Accounts Receivable Turnover as Days) | ||
| Net Accounts Rec. | ||
| ( Sales ÷ 365 ) | ||
| #16 | Inventory Turnover (as times) | |
| Cost of Goods Sold | ||
| Inventory | ||
| #15 | Days of Inventory | |
| (Inventory Turnover as Days) | ||
| Inventories | ||
| ( Cost of Goods Sold ÷ 365 ) | ||
| #9 | Asset Turnover | |
| Sales Revenue | ||
| Total Assets | ||
| #10 | Invested Capital Turnover | |
| Sales Revenue | ||
| ( LongTerm Liabilities + Stockholders' Equity ) | ||
| #11 | Equity Turnover | |
| Sales Revenue | ||
| Shareholders' Equity | ||
| #12 | Capital Intensity | |
| Sales Revenue | ||
| Propery Plant Equip. | ||
| Profitability Measures | ||
| #5 | Gross Margin Percentage | |
| Gross Margin | ||
| Net Sales Revenues | ||
| #6 | Profit Margin (percentage) | |
| Net Income | ||
| Net Sales Revenues | ||
| #7 | Earnings Per Share (of Common Stock) | |
| Net Income | ||
| # Shares Outstanding | ||
Step 2 - Financial Data
| STEP 2: Key Data & Print Tab | Replace with Name of Company 1 | Replace with Name of Company 2 | |||||||
| Key in SHADED cells ONLY! | Year 1 | Year 2 | Year 3 | Year 4 | Year 1 | Year 2 | Year 3 | Year 4 | |
| Income Statement data | 2009 | 2010 | 2011 | 2012 | 2009 | 2010 | 2011 | 2012 | |
| 1 | Net Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 2 | Cost of Sales (COGS) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 3 | Gross Margin | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 4 | Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 5 | PreTax Operating Profit | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 6 | Net Income | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| Balance Sheet data | |||||||||
| 7 | Monetary Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 8 | Accounts Receivable | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 9 | Inventory | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 10 | Current Assets (all) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 11 | Property, Plant, & Equip. | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 12 | Total Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 13 | Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 14 | Long-Term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 15 | Total Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 16 | Stockholders' Equity | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 17 | # outstanding Shares | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
Step 3 - Analysis Review
| STEP 3: Print this tab & review each item's analyses. Make notes on trends or issues to discuss in your paper. | Replace with Name of Company 1 | Replace with Name of Company 2 | |||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | ||
| Investment & Asset Utilization | 2009 | 2010 | 2011 | 2012 | 2009 | 2010 | 2011 | 2012 | |
| Working Capital | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| #18 | Current Ratio | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| #19 | Acid Test (Quick) Ratio | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Accounts Receivable Turnover | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| times | times | times | times | times | times | times | times | ||
| #14 | Days Receivables | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| (or Collection Period) | days | days | days | days | days | days | days | days | |
| #16 | Inventory Turnover | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| times | times | times | times | times | times | times | times | ||
| #15 | Days of Inventory | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| days | days | days | days | days | days | days | days | ||
| #9 | Asset Turnover | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| times | times | times | times | times | times | times | times | ||
| #10 | Invested Capital Turnover | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| times | times | times | times | times | times | times | times | ||
| #11 | Equity Turnover | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| times | times | times | times | times | times | times | times | ||
| #12 | Capital Intensity | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Profitability Measures | |||||||||
| #5 | Gross Margin Percentage | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
| #6 | Profit Margin (Percentage) | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
| #7 | Earnings Per Share | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| (Common Stock) | |||||||||
STEP 2 - SAMPLE
| STEP 2: Key Data & Print Tab | ABC MANUFACTURING, INC. (in thousands) | Replace with Name of Company 2 | |||||||
| Key in SHADED cells ONLY! | Year 1 | Year 2 | Year 3 | Year 4 | Year 1 | Year 2 | Year 3 | Year 4 | |
| Income Statement data | 2009 | 2010 | 2011 | 2012 | 2009 | 2010 | 2011 | 2012 | |
| 1 | Net Sales | $19,014 | $20,862 | $24,128 | $27,855 | $0 | $0 | $0 | $0 |
| year-to-year change | 1,848 | 3,266 | 3,727 | - 0 | - 0 | - 0 | |||
| percentage changed | 9.72% | 15.66% | 15.45% | 0.00% | 0.00% | 0.00% | |||
| 2 | Cost of Sales (COGS) | $10,214 | $11,354 | $13,657 | $15,101 | $0 | $0 | $0 | $0 |
| year-to-year change | 1,140 | 2,303 | 1,444 | - 0 | - 0 | - 0 | |||
| percentage changed | 11.16% | 20.28% | 10.57% | 0.00% | 0.00% | 0.00% | |||
| 3 | Gross Margin | $8,800 | $9,508 | $10,471 | $11,500 | $0 | $0 | $0 | $0 |
| year-to-year change | 708 | 963 | 1,029 | - 0 | - 0 | - 0 | |||
| percentage changed | 8.05% | 10.13% | 9.83% | 0.00% | 0.00% | 0.00% | |||
| 4 | Interest Expense | $68 | $49 | $42 | $54 | $0 | $0 | $0 | $0 |
| year-to-year change | (19) | (7) | 12 | - 0 | - 0 | - 0 | |||
| percentage changed | -27.94% | -14.29% | 28.57% | 0.00% | 0.00% | 0.00% | |||
| 5 | PreTax Operating Profit | $2,517 | $2,844 | $2,983 | $3,125 | $0 | $0 | $0 | $0 |
| year-to-year change | 327 | 139 | 142 | - 0 | - 0 | - 0 | |||
| percentage changed | 12.99% | 4.89% | 4.76% | 0.00% | 0.00% | 0.00% | |||
| 6 | Net Income | $1,907 | $2,133 | $2,223 | $2,368 | $0 | $0 | $0 | $0 |
| year-to-year change | 226 | 90 | 145 | - 0 | - 0 | - 0 | |||
| percentage changed | 11.85% | 4.22% | 6.52% | 0.00% | 0.00% | 0.00% | |||
| Balance Sheet data | |||||||||
| 7 | Monetary Current Assets | $4,292 | $4,538 | $3,757 | $3,899 | $0 | $0 | $0 | $0 |
| year-to-year change | 246 | (781) | 142 | - 0 | - 0 | - 0 | |||
| percentage changed | 5.73% | -17.21% | 3.78% | 0.00% | 0.00% | 0.00% | |||
| 8 | Accounts Receivable | $3,344 | $3,138 | $3,280 | $3,450 | $0 | $0 | $0 | $0 |
| year-to-year change | (206) | 142 | 170 | - 0 | - 0 | - 0 | |||
| percentage changed | -6.16% | 4.53% | 5.18% | 0.00% | 0.00% | 0.00% | |||
| 9 | Inventory | $3,199 | $2,715 | $3,350 | $3,575 | $0 | $0 | $0 | $0 |
| year-to-year change | (484) | 635 | 225 | - 0 | - 0 | - 0 | |||
| percentage changed | -15.13% | 23.39% | 6.72% | 0.00% | 0.00% | 0.00% | |||
| 10 | Current Assets (all) | $11,150 | $11,297 | $11,531 | $11,688 | $0 | $0 | $0 | $0 |
| year-to-year change | 147 | 234 | 157 | - 0 | - 0 | - 0 | |||
| percentage changed | 1.32% | 2.07% | 1.36% | 0.00% | 0.00% | 0.00% | |||
| 11 | Property, Plant, & Equip. | $2,075 | $2,115 | $2,279 | $2,240 | $0 | $0 | $0 | $0 |
| year-to-year change | 40 | 164 | (39) | - 0 | - 0 | - 0 | |||
| percentage changed | 1.93% | 7.75% | -1.71% | 0.00% | 0.00% | 0.00% | |||
| 12 | Total Assets | $14,802 | $14,998 | $15,465 | $15,932 | $0 | $0 | $0 | $0 |
| year-to-year change | 196 | 467 | 467 | - 0 | - 0 | - 0 | |||
| percentage changed | 1.32% | 3.11% | 3.02% | 0.00% | 0.00% | 0.00% | |||
| 13 | Current Liabilities | $3,776 | $3,958 | $3,865 | $4,194 | $0 | $0 | $0 | $0 |
| year-to-year change | 182 | (93) | 329 | - 0 | - 0 | - 0 | |||
| percentage changed | 4.82% | -2.35% | 8.51% | 0.00% | 0.00% | 0.00% | |||
| 14 | Long-Term Liabilities | $251 | $228 | $296 | $322 | $0 | $0 | $0 | $0 |
| year-to-year change | (23) | 68 | 26 | - 0 | - 0 | - 0 | |||
| percentage changed | -9.16% | 29.82% | 8.78% | 0.00% | 0.00% | 0.00% | |||
| 15 | Total Liabilities | $4,027 | $4,186 | $4,161 | $4,516 | $0 | $0 | $0 | $0 |
| year-to-year change | 159 | (25) | 355 | (4,516) | - 0 | - 0 | - 0 | ||
| percentage changed | 3.95% | -0.60% | 8.53% | 0.00% | 0.00% | 0.00% | |||
| 16 | Stockholders' Equity | $10,775 | $10,812 | $11,304 | $11,416 | $0 | $0 | $0 | $0 |
| year-to-year change | 37 | 492 | 112 | (11,416) | - 0 | - 0 | - 0 | ||
| percentage changed | 0.34% | 4.55% | 0.99% | 0.00% | 0.00% | 0.00% | |||
| 17 | # outstanding Shares | 12,500 | 12,500 | 12,500 | 12,500 | 0 | 0 | 0 | 0 |
| year-to-year change | - 0 | - 0 | - 0 | (12,500) | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
STEP 3 - SAMPLE
| STEP 3: Print this tab & review each item's analyses. Make notes on trends or issues to discuss in your paper. | ABC MANUFACTURING, INC. (in thousands) | Replace with Name of Company 2 | |||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | ||
| Investment & Asset Utilization | 2009 | 2010 | 2011 | 2012 | 2009 | 2010 | 2011 | 2012 | |
| Working Capital | $ 7,374.00 | $ 7,339.00 | $ 7,666.00 | $ 7,494.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $7,374,000 worth of Current Assets to "work with" to cover Current Liab. | |||||||||
| #18 | Current Ratio | 2.95 | 2.85 | 2.98 | 2.79 | 0.00 | 0.00 | 0.00 | 0.00 |
| For every $1 in current liabilities, the company has $2.95 worth of current assets | |||||||||
| #19 | Acid Test (Quick) Ratio | 1.14 | 1.15 | 0.97 | 0.93 | 0.00 | 0.00 | 0.00 | 0.00 |
| For every $1 in current liabilities, the company has $1.14 worth of cash assets | |||||||||
| Accounts Receivable Turnover | 5.69 | 6.65 | 7.36 | 8.07 | 0.00 | 0.00 | 0.00 | 0.00 | |
| A/R was completely collected & reestablished 5.69 times this year. | times | times | times | times | |||||
| #14 | Days Receivables | 64.19 | 54.90 | 49.62 | 45.21 | 0.00 | 0.00 | 0.00 | 0.00 |
| (or Collection Period) | The company waited, on average, 64.19 days to collect A/R balances from customers. | days | days | days | days | ||||
| #16 | Inventory Turnover | 3.19 | 4.18 | 4.08 | 4.22 | 0.00 | 0.00 | 0.00 | 0.00 |
| Inventories were completely sold out & replaced 3.19 times this year. | times | times | times | times | |||||
| #15 | Days of Inventory | 114.32 | 87.28 | 89.53 | 86.41 | 0.00 | 0.00 | 0.00 | 0.00 |
| On average, the inventory sat around for 114.3 days before being sold! | days | days | days | days | |||||
| #9 | Asset Turnover | 1.28 | 1.39 | 1.56 | 1.75 | 0.00 | 0.00 | 0.00 | 0.00 |
| The company earned enough Sales Revenue to completely replace assets 1.28 times. Put another way…. Every dollar of assets generated $1.28 in Revenue. | times | times | times | times | |||||
| #10 | Invested Capital Turnover | 1.72 | 1.89 | 2.08 | 2.37 | 0.00 | 0.00 | 0.00 | 0.00 |
| The company earned enough Sales Revenue to completely replace Invested Capital 1.72 times. -or- Every $1 of Invested Capital returned $1.72 in Sales Revenue. | times | times | times | times | times | times | times | ||
| #11 | Equity Turnover | 1.76 | 1.93 | 2.13 | 2.44 | 0.00 | 0.00 | 0.00 | 0.00 |
| Every $1 of Stockholders' Equity returned $1.76 in Sales Revenue. | times | times | times | times | times | times | times | ||
| #12 | Capital Intensity | 9.16 | 9.86 | 10.59 | 12.44 | 0.00 | 0.00 | 0.00 | 0.00 |
| Every $1 invested in PPE Capital returned $9.16 in Sales Revenue. | |||||||||
| Profitability Measures | |||||||||
| #5 | Gross Margin Percentage | 46.3% | 45.6% | 43.4% | 41.3% | 0.0% | 0.0% | 0.0% | 0.0% |
| 46.3% of Sales Revenue is available to cover Selling & Admin expenses. | |||||||||
| #6 | Profit Margin (Percentage) | 10.0% | 10.2% | 9.2% | 8.5% | 0.0% | 0.0% | 0.0% | 0.0% |
| 10.0% of every $1 in Sales Revenue drops to bottom-line Net Income Profits. | |||||||||
| #7 | Earnings Per Share | $ 0.153 | $ 0.171 | $ 0.178 | $ 0.189 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| (Common Stock) | The company earned 15.3-centsof Net Income profits per share of Common Stock. | ||||||||
Financial data - 1 company
| Replace with name of company | |||||||||
| shade = data; plain = formula | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | |
| Income Statement data | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | |
| 1 | Net Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 2 | Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 3 | Gross Margin | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 4 | Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 5 | PreTax Operating Profit | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 6 | Net Income | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| Balance Sheet data | |||||||||
| 7 | Monetary Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 8 | Accounts Receivable | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 9 | Inventory | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 10 | Current Assets (all) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 11 | Property, Plant, & Equip. | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 12 | Total Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 13 | Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 14 | Long-Term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 15 | Total Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 16 | Stockholders' Equity | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| 17 | # outstanding Shares | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| year-to-year change | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| percentage changed | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| Profitability Measures | |||||||||
| #5 | Gross Margin Percentage | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Excel Formula: =+C19/C15 | =+D19/D15 | =+E19/E15 | etc. | etc. | etc. | etc. | etc. | ||
| #6 | Profit Margin | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Excel Formula: =+C23/C15 | =+D23/D15 | =+E23/E15 | etc. | etc. | etc. | etc. | etc. | ||
| #7 | Earnings Per Share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Excel Formula: =+C23/C28 | =+D23/D28 | =+E23/E28 | etc. | etc. | etc. | etc. | etc. | ||
| . | |||||||||
1
2
3
4
5
6
7
8
9
A
B
C
D
E
Working Capital
All Current Assets
- Current Liabilities
Working Capital
#18
Current Ratio
STEP 1: Print out this tab's 2 pages & make notes about how you should interpret/apply each item
Test of Investment & Asset Utilization
