| | ABC Sporting Goods |
| | P&L Statement |
| | | Year 1 | % | Year 2 | % | Year 3 | % | Year 4 | % | Year 5 | % | | Avg | % |
| | Sales | 1,120,560 | 100.0% | 1,170,985 | 100.0% | 1,210,799 | 100.0% | 1,184,161 | 100.0% | 1,146,031 | 100.0% | | 1,166,507 | 100.0% |
| | Cost of Sales | 671,215 | 59.9% | 684,640 | 58.5% | 700,386 | 57.8% | 714,254 | 60.3% | 694,969 | 60.6% | | 693,093 | 59.4% |
| | Gross Profit | 449,345 | 40.1% | 486,345 | 41.5% | 510,412 | 42.2% | 469,907 | 39.7% | 451,062 | 39.4% | - | 473,414 | 40.6% |
| | Officers' Compensation | 36,000 | 3.2% | 36,720.00 | 3.1% | 37,454.40 | 3.1% | 38,203 | 3.2% | 38,968 | 3.4% | | 37,469 | 3.2% |
| | Salary & Wages | 115,418 | 10.3% | 121,189 | 10.3% | 127,248 | 10.5% | 133,610 | 11.3% | 126,930 | 11.1% | | 124,879 | 10.7% |
| | Rent | 68,000 | 6.1% | 68,000 | 5.8% | 68,000 | 5.6% | 68,000 | 5.7% | 68,000 | 5.9% | | 68,000 | 5.8% |
| | Taxes | 5,780 | 0.5% | 5,852 | 0.5% | 5,925 | 0.5% | 5,999 | 0.5% | 6,074 | 0.5% | | 5,926 | 0.5% |
| | Interest Paid | 22,411 | 2.0% | 20,300 | 1.7% | 18,435 | 1.5% | 20,150 | 1.7% | 19,865 | 1.7% | | 20,232 | 1.7% |
| | Amort & Depr | 17,929 | 1.6% | 16,500 | 1.4% | 15,000 | 1.2% | 15,800 | 1.3% | 15,000 | 1.3% | | 16,046 | 1.4% |
| | Advertising | 28,014 | 2.5% | 30,200 | 2.6% | 34,000 | 2.8% | 32,400 | 2.7% | 27,800 | 2.4% | | 30,483 | 2.6% |
| | Benefits-Pension | 41,461 | 3.7% | 42,635 | 3.6% | 44,470 | 3.7% | 46,390 | 3.9% | 44,792 | 3.9% | | 43,950 | 3.8% |
| | Other SGA | 28,014 | 2.5% | 31,150 | 2.7% | 33,408 | 2.8% | 34,102 | 2.9% | 35,678 | 3.1% | | 32,470 | 2.8% |
| | Total Operating Expenses | 363,027 | 32.4% | 372,546 | 31.8% | 383,940 | 31.7% | 394,655 | 33.3% | 383,107 | 33.4% | | 379,455 | 32.5% |
| | Net Profit | 86,318 | 7.7% | 113,799 | 9.7% | 126,472 | 10.4% | 75,252 | 6.4% | 67,955 | 5.9% | | 93,959 | 8.1% |
| | Balance Sheet |
| | Cash | | | | | | | | | $35,000 | 6.6% |
| | Receivables | | | | | | | | | 30,250 | 5.7% |
| | Inventory | | | | | | | | | 204,150 | 38.5% |
| | Other Current Assets | | | | | | | | | 13,560 | 2.6% |
| | Total Current Assets | | | | | | | | | 282,960 | 53.4% |
| | Fixed Assets | | | | | | | | | 238,125 | 44.9% |
| | Other Non-Current Assets | | | | | | | | | 8,900 | 1.7% |
| | TotalNon-Current Assets | | | | | | | | | 247,025 | 46.6% |
| | Total Assets | | | | | | | | | 529,985 | 100.0% |
| | Accounts Payable | | | | | | | | | 119,800 | 22.6% |
| | Loans/Notes Payable | | | | | | | | | 32,280 | 6.1% |
| | Other Current Liabilities | | | | | | | | | 107,342 | 20.3% |
| | Total Current Liabilities | | | | | | | | | 259,422 | 48.9% |
| | Other Long Term Liabilities | | | | | | | | | 164,000 | 30.9% |
| | Total Liabilities | | | | | | | | | 423,422 | 79.9% |
| | Net Worth | | | | | | | | | 106,563 | 20.1% |
| | Total Liabilities & Net Worth | | | | | | | | | 529,985 | 100.0% |
lakotajign
abc_pl.xls
