AMT Computers
Appendix
Sales Forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Unit Sales | |||||||||||||
Systems | 0% | 85 | 115 | 145 | 190 | 245 | 175 | 120 | 100 | 180 | 275 | 350 | 275 |
Service | 0% | 200 | 200 | 200 | 200 | 244 | 256 | 269 | 282 | 296 | 311 | 327 | 343 |
Software | 0% | 150 | 200 | 250 | 330 | 430 | 310 | 210 | 180 | 320 | 490 | 620 | 490 |
Training | 0% | 145 | 155 | 165 | 170 | 225 | 200 | 150 | 150 | 200 | 220 | 250 | 200 |
Other | 0% | 160 | 176 | 192 | 240 | 200 | 175 | 125 | 100 | 104 | 200 | 250 | 200 |
Total Unit Sales | 740 | 846 | 952 | 1,130 | 1,344 | 1,116 | 874 | 812 | 1,100 | 1,496 | 1,797 | 1,508 | |
Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Systems | $2,000.00 | $2,000.00 | $2,000.00 | $1,828.95 | $1,890.63 | $1,966.17 | $2,131.58 | $2,115.38 | $2,083.33 | $1,966.40 | $1,980.29 | $1,984.50 | |
Service | $75.00 | $69.00 | $58.00 | $46.00 | $50.00 | $47.00 | $50.00 | $50.00 | $91.00 | $124.00 | $75.00 | $67.00 | |
Software | $200.00 | $200.00 | $200.00 | $200.00 | $223.00 | $217.00 | $242.00 | $253.00 | $220.00 | $211.00 | $204.00 | $207.00 | |
Training | $37.00 | $35.00 | $39.00 | $41.00 | $56.00 | $50.00 | $33.00 | $33.00 | $50.00 | $55.00 | $60.00 | $50.00 | |
Other | $300.00 | $300.00 | $300.00 | $1,133.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | |
Sales | |||||||||||||
Systems | $170,000 | $230,000 | $290,000 | $347,501 | $463,204 | $344,080 | $255,790 | $211,538 | $374,999 | $540,760 | $693,102 | $545,738 | |
Service | $15,000 | $13,800 | $11,600 | $9,200 | $12,200 | $12,032 | $13,450 | $14,100 | $26,936 | $38,564 | $24,525 | $22,981 | |
Software | $30,000 | $40,000 | $50,000 | $66,000 | $95,890 | $67,270 | $50,820 | $45,540 | $70,400 | $103,390 | $126,480 | $101,430 | |
Training | $5,365 | $5,425 | $6,435 | $6,970 | $12,600 | $10,000 | $4,950 | $4,950 | $10,000 | $12,100 | $15,000 | $10,000 | |
Other | $48,000 | $52,800 | $57,600 | $271,920 | $60,000 | $52,500 | $37,500 | $30,000 | $31,200 | $60,000 | $75,000 | $60,000 | |
Total Sales | $268,365 | $342,025 | $415,635 | $701,591 | $643,894 | $485,882 | $362,510 | $306,128 | $513,535 | $754,814 | $934,107 | $740,149 | |
Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Systems | 0.00% | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 |
Service | 0.00% | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 |
Software | 0.00% | $120.00 | $120.00 | $120.00 | $120.00 | $120.00 | $120.00 | $120.00 | $120.00 | $120.00 | $120.00 | $120.00 | $120.00 |
Training | 0.00% | $11.10 | $11.10 | $11.10 | $11.10 | $11.10 | $11.10 | $11.10 | $11.10 | $11.10 | $11.10 | $11.10 | $11.10 |
Other | 0.00% | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 |
Direct Cost of Sales | |||||||||||||
Systems | $144,500 | $195,500 | $246,500 | $323,000 | $416,500 | $297,500 | $204,000 | $170,000 | $306,000 | $467,500 | $595,000 | $467,500 | |
Service | $6,000 | $6,000 | $6,000 | $6,000 | $7,320 | $7,680 | $8,070 | $8,460 | $8,880 | $9,330 | $9,810 | $10,290 | |
Software | $18,000 | $24,000 | $30,000 | $39,600 | $51,600 | $37,200 | $25,200 | $21,600 | $38,400 | $58,800 | $74,400 | $58,800 | |
Training | $1,610 | $1,721 | $1,832 | $1,887 | $2,498 | $2,220 | $1,665 | $1,665 | $2,220 | $2,442 | $2,775 | $2,220 | |
Other | $14,400 | $15,840 | $17,280 | $21,600 | $18,000 | $15,750 | $11,250 | $9,000 | $9,360 | $18,000 | $22,500 | $18,000 | |
Subtotal Direct Cost of Sales | $184,510 | $243,061 | $301,612 | $392,087 | $495,918 | $360,350 | $250,185 | $210,725 | $364,860 | $556,072 | $704,485 | $556,810 |
Personnel Plan | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Production Personnel | |||||||||||||
Manager | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Assistant | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Technical | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Technical | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Technical | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Fulfillment | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Fulfillment | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Subtotal | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $14,500 | $14,500 | $14,500 | $14,500 | $14,500 | |
Sales and Marketing Personnel | |||||||||||||
Manager | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | |
Technical Sales | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Technical Sales | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Salesperson | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Salesperson | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Salesperson | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Salesperson | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Salesperson | $0 | $0 | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Salesperson | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | |
General and Administrative Personnel | |||||||||||||
President | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | |
Finance | $0 | $0 | $0 | $0 | $0 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Admin Assistant | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Bookkeeping | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Clerical | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Clerical | $0 | $0 | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Clerical | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | |
Other Personnel | |||||||||||||
Programming | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Other Technical | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Total People | 19 | 19 | 19 | 19 | 19 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | |
Total Payroll | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $59,500 | $59,500 | $64,500 | $64,500 | $64,500 | $64,500 | $64,500 |
Pro Forma Profit and Loss | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | $268,365 | $342,025 | $415,635 | $701,591 | $643,894 | $485,882 | $362,510 | $306,128 | $513,535 | $754,814 | $934,107 | $740,149 | |
Direct Cost of Sales | $184,510 | $243,061 | $301,612 | $392,087 | $495,918 | $360,350 | $250,185 | $210,725 | $364,860 | $556,072 | $704,485 | $556,810 | |
Production Payroll | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $14,500 | $14,500 | $14,500 | $14,500 | $14,500 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $194,010 | $252,561 | $311,112 | $401,587 | $505,418 | $369,850 | $259,685 | $225,225 | $379,360 | $570,572 | $718,985 | $571,310 | |
Gross Margin | $74,356 | $89,465 | $104,524 | $300,004 | $138,477 | $116,032 | $102,825 | $80,903 | $134,175 | $184,242 | $215,122 | $168,839 | |
Gross Margin % | 27.71% | 26.16% | 25.15% | 42.76% | 21.51% | 23.88% | 28.36% | 26.43% | 26.13% | 24.41% | 23.03% | 22.81% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | |
Ads | $5,000 | $5,000 | $7,000 | $10,000 | $15,000 | $10,000 | $4,000 | $4,000 | $20,000 | $15,000 | $20,000 | $10,000 | |
Catalog | $2,000 | $3,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Mailing | $3,000 | $11,800 | $5,500 | $10,500 | $10,500 | $5,500 | $10,500 | $10,500 | $10,500 | $22,000 | $8,000 | $5,000 | |
Promo | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,000 | $0 | $15,000 | $0 | |
Shows | $0 | $0 | $0 | $0 | $0 | $0 | $3,200 | $0 | $10,000 | $7,000 | $0 | $0 | |
Literature | $0 | $7,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
PR | $0 | $0 | $0 | $1,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Seminar | $1,000 | $0 | $0 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $0 | $0 | $0 | |
Service | $2,000 | $1,000 | $1,000 | $500 | $2,500 | $500 | $500 | $500 | $500 | $500 | $500 | $250 | |
Training | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | |
Total Sales and Marketing Expenses | $37,450 | $52,250 | $39,950 | $53,450 | $59,450 | $55,450 | $57,650 | $54,450 | $81,450 | $78,950 | $77,950 | $49,700 | |
Sales and Marketing % | 13.95% | 15.28% | 9.61% | 7.62% | 9.23% | 11.41% | 15.90% | 17.79% | 15.86% | 10.46% | 8.34% | 6.71% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | |
Marketing/Promotion | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $1,000 | $1,010 | $1,020 | $1,030 | $1,040 | $1,050 | $1,061 | $1,072 | $1,083 | $1,094 | $1,105 | $1,116 | |
Leased Equipment | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Rent | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | |
Utilities | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
Insurance | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other General and Administrative Expenses | $500 | $505 | $510 | $515 | $520 | $525 | $530 | $535 | $540 | $545 | $550 | $556 | |
Total General and Administrative Expenses | $22,250 | $22,265 | $22,280 | $22,295 | $22,310 | $27,325 | $27,341 | $27,357 | $27,373 | $27,389 | $27,405 | $27,422 | |
General and Administrative % | 8.29% | 6.51% | 5.36% | 3.18% | 3.46% | 5.62% | 7.54% | 8.94% | 5.33% | 3.63% | 2.93% | 3.70% | |
Other Expenses: | |||||||||||||
Other Payroll | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Contract/Consultants | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | |
Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Other Expenses | $3,125 | $3,125 | $3,125 | $3,125 | $3,125 | $3,125 | $3,125 | $3,125 | $3,125 | $3,125 | $3,125 | $3,125 | |
Other % | 1.16% | 0.91% | 0.75% | 0.45% | 0.49% | 0.64% | 0.86% | 1.02% | 0.61% | 0.41% | 0.33% | 0.42% | |
Total Operating Expenses | $62,825 | $77,640 | $65,355 | $78,870 | $84,885 | $85,900 | $88,116 | $84,932 | $111,948 | $109,464 | $108,480 | $80,247 | |
Profit Before Interest and Taxes | $11,531 | $11,825 | $39,169 | $221,134 | $53,592 | $30,132 | $14,709 | ($4,029) | $22,227 | $74,778 | $106,642 | $88,592 | |
EBITDA | $12,531 | $12,835 | $40,189 | $222,164 | $54,632 | $31,182 | $15,770 | ($2,957) | $23,310 | $75,872 | $107,747 | $89,708 | |
Interest Expense | $2,580 | $2,543 | $3,213 | $3,175 | $3,137 | $3,099 | $3,060 | $3,022 | $2,983 | $2,944 | $2,919 | $2,893 | |
Taxes Incurred | $1,790 | $1,856 | $7,191 | $43,592 | $10,091 | $5,407 | $3,494 | ($1,410) | $3,849 | $14,367 | $20,745 | $17,140 | |
Net Profit | $7,160 | $7,426 | $28,764 | $174,367 | $40,364 | $21,626 | $8,154 | ($5,641) | $15,395 | $57,467 | $82,978 | $68,559 | |
Net Profit/Sales | 2.67% | 2.17% | 6.92% | 24.85% | 6.27% | 4.45% | 2.25% | -1.84% | 3.00% | 7.61% | 8.88% | 9.26% |
Pro Forma Cash Flow | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $40,255 | $51,304 | $62,345 | $105,239 | $96,584 | $72,882 | $54,376 | $45,919 | $77,030 | $113,222 | $140,116 | $111,022 | |
Cash from Receivables | $197,554 | $205,157 | $230,197 | $292,807 | $361,392 | $594,717 | $542,833 | $409,504 | $306,536 | $266,085 | $443,341 | $646,672 | |
Subtotal Cash from Operations | $237,808 | $256,461 | $292,543 | $398,045 | $457,976 | $667,599 | $597,210 | $455,423 | $383,566 | $379,307 | $583,457 | $757,694 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
New Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Other Liabilities (interest-free) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Long-term Liabilities | $0 | $0 | $100,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Investment Received | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $237,808 | $256,461 | $392,543 | $398,045 | $457,976 | $667,599 | $597,210 | $455,423 | $383,566 | $379,307 | $583,457 | $757,694 | |
Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Expenditures from Operations | |||||||||||||
Cash Spending | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $59,500 | $59,500 | $64,500 | $64,500 | $64,500 | $64,500 | $64,500 | |
Bill Payments | $224,870 | $29,690 | $51,343 | $273,659 | $573,158 | $646,765 | $265,321 | $184,400 | $219,402 | $594,568 | $826,664 | $918,082 | |
Subtotal Spent on Operations | $271,370 | $76,190 | $97,843 | $320,159 | $619,658 | $706,265 | $324,821 | $248,900 | $283,902 | $659,068 | $891,164 | $982,582 | |
Additional Cash Spent | |||||||||||||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Principal Repayment of Current Borrowing | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $500 | $500 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $2,942 | $2,962 | $2,983 | $3,005 | $3,026 | $3,047 | $3,069 | $3,091 | $3,113 | $3,135 | $3,157 | $3,179 | |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $276,812 | $81,652 | $103,326 | $325,664 | $625,184 | $711,812 | $330,390 | $254,491 | $289,515 | $664,703 | $894,821 | $986,261 | |
Net Cash Flow | ($39,004) | $174,809 | $289,217 | $72,382 | ($167,208) | ($44,212) | $266,820 | $200,932 | $94,051 | ($285,395) | ($311,364) | ($228,566) | |
Cash Balance | $16,428 | $191,237 | $480,454 | $552,836 | $385,628 | $341,416 | $608,235 | $809,167 | $903,218 | $617,823 | $306,459 | $77,893 |
Pro Forma Balance Sheet | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $55,432 | $16,428 | $191,237 | $480,454 | $552,836 | $385,628 | $341,416 | $608,235 | $809,167 | $903,218 | $617,823 | $306,459 | $77,893 |
Accounts Receivable | $395,107 | $425,664 | $511,228 | $634,320 | $937,865 | $1,123,784 | $942,066 | $707,366 | $558,071 | $688,040 | $1,063,547 | $1,414,196 | $1,396,650 |
Inventory | $805,098 | $620,589 | $377,528 | $301,612 | $392,087 | $495,918 | $360,350 | $250,185 | $210,725 | $364,860 | $556,072 | $704,485 | $556,810 |
Other Current Assets | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
Total Current Assets | $1,280,637 | $1,087,680 | $1,104,993 | $1,441,386 | $1,907,788 | $2,030,329 | $1,668,832 | $1,590,786 | $1,602,963 | $1,981,119 | $2,262,442 | $2,450,140 | $2,056,353 |
Long-term Assets | |||||||||||||
Long-term Assets | $350,000 | $350,000 | $350,000 | $350,000 | $350,000 | $350,000 | $350,000 | $350,000 | $350,000 | $350,000 | $350,000 | $350,000 | $350,000 |
Accumulated Depreciation | $50,000 | $51,000 | $52,010 | $53,030 | $54,060 | $55,100 | $56,150 | $57,211 | $58,283 | $59,366 | $60,460 | $61,565 | $62,681 |
Total Long-term Assets | $300,000 | $299,000 | $297,990 | $296,970 | $295,940 | $294,900 | $293,850 | $292,789 | $291,717 | $290,634 | $289,540 | $288,435 | $287,319 |
Total Assets | $1,580,637 | $1,386,680 | $1,402,983 | $1,738,356 | $2,203,728 | $2,325,229 | $1,962,682 | $1,883,575 | $1,894,680 | $2,271,753 | $2,551,982 | $2,738,575 | $2,343,672 |
Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Current Liabilities | |||||||||||||
Accounts Payable | $223,897 | $28,222 | $42,561 | $254,653 | $551,164 | $637,827 | $259,200 | $177,509 | $199,845 | $567,136 | $795,533 | $902,805 | $443,022 |
Current Borrowing | $90,000 | $87,500 | $85,000 | $82,500 | $80,000 | $77,500 | $75,000 | $72,500 | $70,000 | $67,500 | $65,000 | $64,500 | $64,000 |
Other Current Liabilities | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
Subtotal Current Liabilities | $328,897 | $130,722 | $142,561 | $352,153 | $646,164 | $730,327 | $349,200 | $265,009 | $284,845 | $649,636 | $875,533 | $982,305 | $522,022 |
Long-term Liabilities | $284,862 | $281,920 | $278,958 | $375,975 | $372,970 | $369,944 | $366,897 | $363,828 | $360,737 | $357,624 | $354,489 | $351,332 | $348,153 |
Total Liabilities | $613,759 | $412,642 | $421,519 | $728,128 | $1,019,134 | $1,100,271 | $716,097 | $628,837 | $645,582 | $1,007,260 | $1,230,022 | $1,333,637 | $870,175 |
Paid-in Capital | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 |
Retained Earnings | $418,355 | $466,878 | $466,878 | $466,878 | $466,878 | $466,878 | $466,878 | $466,878 | $466,878 | $466,878 | $466,878 | $466,878 | $466,878 |
Earnings | $48,523 | $7,160 | $14,586 | $43,350 | $217,717 | $258,080 | $279,707 | $287,860 | $282,220 | $297,615 | $355,082 | $438,060 | $506,619 |
Total Capital | $966,878 | $974,038 | $981,464 | $1,010,228 | $1,184,595 | $1,224,958 | $1,246,585 | $1,254,738 | $1,249,098 | $1,264,493 | $1,321,960 | $1,404,938 | $1,473,497 |
Total Liabilities and Capital | $1,580,637 | $1,386,680 | $1,402,983 | $1,738,356 | $2,203,728 | $2,325,229 | $1,962,682 | $1,883,575 | $1,894,680 | $2,271,753 | $2,551,982 | $2,738,575 | $2,343,672 |
Net Worth | $966,878 | $974,038 | $981,464 | $1,010,228 | $1,184,595 | $1,224,958 | $1,246,585 | $1,254,738 | $1,249,098 | $1,264,493 | $1,321,960 | $1,404,938 | $1,473,497 |