Fin assignment
coolstudent1
financial_analysis_spreadsheet_done.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 | ||||||
| - Current Liabilities | |||||||
| Working Capital | |||||||
| #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 | TARGET CORPORATION | Wall Mart | ||||||||
| 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 | $65,357 | $67,390 | $69,865 | $73,301 | $408,085 | $421,849 | $446,950 | $469,162 | |
| year-to-year change | 2,033 | 2,475 | 3,436 | 13,764 | 25,101 | 22,212 | ||||
| percentage changed | 3.11% | 3.67% | 4.92% | 3.37% | 5.95% | 4.97% | ||||
| 2 | Cost of Sales (COGS) | $44,062 | $45,725 | $47,860 | $50,568 | $304,444 | $315,287 | $335,127 | $352,297 | |
| year-to-year change | 1,663 | 2,135 | 2,708 | 10,843 | 19,840 | 17,170 | ||||
| percentage changed | 3.77% | 4.67% | 5.66% | 3.56% | 6.29% | 5.12% | ||||
| 3 | Gross Margin | $21,295 | $21,665 | $22,005 | $22,733 | $103,641 | $106,562 | $111,823 | $116,865 | |
| year-to-year change | 370 | 340 | 728 | 2,921 | 5,261 | 5,042 | ||||
| percentage changed | 1.74% | 1.57% | 3.31% | 2.82% | 4.94% | 4.51% | ||||
| 4 | Interest Expense | $801 | $757 | $866 | $762 | $1,884 | $2,004 | $2,160 | $2,064 | |
| year-to-year change | (44) | 109 | (104) | 120 | 156 | (96) | ||||
| percentage changed | -5.49% | 14.40% | -12.01% | 6.37% | 7.78% | -4.44% | ||||
| 5 | PreTax Operating Profit | $3,872 | $4,495 | $4,456 | $4,609 | $22,118 | $23,538 | $24,398 | $25,737 | |
| year-to-year change | 623 | (39) | 153 | 1,420 | 860 | 1,339 | ||||
| percentage changed | 16.09% | -0.87% | 3.43% | 6.42% | 3.65% | 5.49% | ||||
| 6 | Net Income | $2,488 | $2,920 | $2,929 | $2,999 | $14,962 | $15,959 | $16,454 | $17,756 | |
| year-to-year change | 432 | 9 | 70 | 997 | 495 | 1,302 | ||||
| percentage changed | 17.36% | 0.31% | 2.39% | 6.66% | 3.10% | 7.91% | ||||
| Balance Sheet data | ||||||||||
| 7 | Monetary Current Assets | $2,200 | $1,712 | $794 | $784 | $7,907 | $7,395 | $6,550 | $7,781 | |
| year-to-year change | (488) | (918) | (10) | (512) | (845) | 1,231 | ||||
| percentage changed | -22.18% | -53.62% | -1.26% | -6.48% | -11.43% | 18.79% | ||||
| 8 | Accounts Receivable | $6,966 | $6,153 | $5,927 | $5,841 | $4,144 | $5,089 | $5,937 | $6,788 | |
| year-to-year change | (813) | (226) | (86) | 945 | 848 | 851 | ||||
| percentage changed | -11.67% | -3.67% | -1.45% | 22.80% | 16.66% | 14.33% | ||||
| 9 | Inventory | $7,179 | $7,596 | $7,918 | $7,903 | $32,713 | $36,318 | $40,714 | $43,803 | |
| year-to-year change | 417 | 322 | (15) | 3,605 | 4,396 | 3,089 | ||||
| percentage changed | 5.81% | 4.24% | -0.19% | 11.02% | 12.10% | 7.59% | ||||
| 10 | Current Assets (all) | $18,424 | $17,213 | $16,449 | $16,388 | $48,032 | $51,893 | $54,975 | $54,940 | |
| year-to-year change | (1,211) | (764) | (61) | 3,861 | 3,082 | (35) | ||||
| percentage changed | -6.57% | -4.44% | -0.37% | 8.04% | 5.94% | -0.06% | ||||
| 11 | Property, Plant, & Equip. | $25,280 | $25,493 | $29,149 | $30,653 | $99,544 | $105,098 | $109,603 | $113,929 | |
| year-to-year change | 213 | 3,656 | 1,504 | 5,554 | 4,505 | 4,326 | ||||
| percentage changed | 0.84% | 14.34% | 5.16% | 5.58% | 4.29% | 3.95% | ||||
| 12 | Total Assets | $44,533 | $43,705 | $46,630 | $48,163 | $170,407 | $180,663 | $193,406 | $203,105 | |
| year-to-year change | (828) | 2,925 | 1,533 | 10,256 | 12,743 | 9,699 | ||||
| percentage changed | -1.86% | 6.69% | 3.29% | 6.02% | 7.05% | 5.01% | ||||
| 13 | Current Liabilities | $11,327 | $10,070 | $14,287 | $14,031 | $55,543 | $58,484 | $62,300 | $71,818 | |
| year-to-year change | (1,257) | 4,217 | (256) | 2,941 | 3,816 | 9,518 | ||||
| percentage changed | -11.10% | 41.88% | -1.79% | 5.29% | 6.52% | 15.28% | ||||
| 14 | Long-Term Liabilities | $17,859 | $18,148 | $16,522 | $17,574 | $42,216 | $50,932 | $55,345 | $49,549 | |
| year-to-year change | 289 | (1,626) | 1,052 | 8,716 | 4,413 | (5,796) | ||||
| percentage changed | 1.62% | -8.96% | 6.37% | 20.65% | 8.66% | -10.47% | ||||
| 15 | Total Liabilities | $29,186 | $28,218 | $30,809 | $31,605 | $97,759 | $109,416 | $117,645 | $121,367 | |
| year-to-year change | (968) | 2,591 | 796 | 11,657 | 8,229 | 3,722 | ||||
| percentage changed | -3.32% | 9.18% | 2.58% | 11.92% | 7.52% | 3.16% | ||||
| 16 | Stockholders' Equity | $15,347 | $15,487 | $15,821 | $16,558 | $72,648 | $71,247 | $75,761 | $81,738 | |
| year-to-year change | 140 | 334 | 737 | (1,401) | 4,514 | 5,977 | ||||
| percentage changed | 0.91% | 2.16% | 4.66% | -1.93% | 6.34% | 7.89% | ||||
| 17 | # outstanding Shares | 744,644,454 | 704,038,218 | 669,292,929 | 645,294,423 | 3,786 | 3,516 | 3,418 | 3,314 | |
| year-to-year change | (40,606,236) | (34,745,289) | (23,998,506) | (270) | (98) | (104) | ||||
| percentage changed | -5.45% | -4.94% | -3.59% | -7.13% | -2.79% | -3.04% | ||||
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. | TARGET CORPORATION | Wall Mart | ||||||||||
| 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,097 | $ 7,143 | $ 2,162 | $ 2,357 | $ (7,511) | $ (6,591) | $ (7,325) | $ (16,878) | ||||
| #18 | Current Ratio | 1.63 | 1.71 | 1.15 | 1.17 | 0.86 | 0.89 | 0.88 | 0.76 | |||
| #19 | Acid Test (Quick) Ratio | 0.19 | 0.17 | 0.06 | 0.06 | 0.14 | 0.13 | 0.11 | 0.11 | |||
| Accounts Receivable Turnover | 9.38 | 10.95 | 11.79 | 12.55 | 98.48 | 82.89 | 75.28 | 69.12 | ||||
| times | times | times | times | times | times | times | times | |||||
| #14 | Days Receivables | 38.90 | 33.33 | 30.96 | 29.09 | 3.71 | 4.40 | 4.85 | 5.28 | |||
| (or Collection Period) | days | days | days | days | days | days | days | days | ||||
| #16 | Inventory Turnover | 6.14 | 6.02 | 6.04 | 6.40 | 9.31 | 8.68 | 8.23 | 8.04 | |||
| times | times | times | times | times | times | times | times | |||||
| #15 | Days of Inventory | 59.47 | 60.64 | 60.39 | 57.04 | 39.22 | 42.04 | 44.34 | 45.38 | |||
| days | days | days | days | days | days | days | days | |||||
| #9 | Asset Turnover | 1.47 | 1.54 | 1.50 | 1.52 | 2.39 | 2.34 | 2.31 | 2.31 | |||
| times | times | times | times | times | times | times | times | |||||
| #10 | Invested Capital Turnover | 1.97 | 2.00 | 2.16 | 2.15 | 3.55 | 3.45 | 3.41 | 3.57 | |||
| times | times | times | times | times | times | times | times | |||||
| #11 | Equity Turnover | 4.26 | 4.35 | 4.42 | 4.43 | 5.62 | 5.92 | 5.90 | 5.74 | |||
| times | times | times | times | times | times | times | times | |||||
| #12 | Capital Intensity | 2.59 | 2.64 | 2.40 | 2.39 | 4.10 | 4.01 | 4.08 | 4.12 | |||
| Profitability Measures | ||||||||||||
| #5 | Gross Margin Percentage | 32.6% | 32.1% | 31.5% | 31.0% | 25.4% | 25.3% | 25.0% | 24.9% | |||
| #6 | Profit Margin (Percentage) | 3.8% | 4.3% | 4.2% | 4.1% | 3.7% | 3.8% | 3.7% | 3.8% | |||
| #7 | Earnings Per Share | $ 0.000 | $ 0.000 | $ 0.000 | $ 0.000 | $ 3.952 | $ 4.539 | $ 4.814 | $ 5.358 | |||
| (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. | ||
| . | |||||||||
