Information Management Hawaii
Appendix
| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Hardware – Image Platforms | 0% | $78,500 | $78,500 | $78,500 | $86,350 | $86,350 | $86,350 | $94,985 | $94,985 | $94,985 | $104,484 | $104,484 | $104,484 |
| Hardware – Printers | 0% | $5,000 | $5,000 | $5,000 | $5,500 | $5,500 | $5,500 | $6,050 | $6,050 | $6,050 | $6,655 | $6,655 | $6,655 |
| Hardware – Facsimiles | 0% | $10,250 | $10,250 | $10,250 | $11,275 | $11,275 | $11,275 | $12,403 | $12,403 | $12,403 | $13,643 | $13,643 | $13,643 |
| Hardware – Misc (TW, Shrd) | 0% | $3,250 | $3,250 | $3,250 | $3,575 | $3,575 | $3,575 | $3,933 | $3,933 | $3,933 | $4,326 | $4,326 | $4,326 |
| Professional Services | 0% | $0 | $0 | $2,500 | $2,750 | $2,750 | $2,750 | $3,025 | $3,025 | $3,025 | $3,328 | $3,328 | $3,328 |
| Government (Comp) | 0% | $6,250 | $6,250 | $6,250 | $6,875 | $6,875 | $6,875 | $7,563 | $7,563 | $7,563 | $8,319 | $8,319 | $8,319 |
| Supplies (Toner/Paper) | 0% | $36,000 | $36,000 | $36,000 | $39,600 | $39,600 | $39,600 | $43,560 | $43,560 | $43,560 | $47,916 | $47,916 | $47,916 |
| Service – Agreements/Repairs | 0% | $68,000 | $68,000 | $68,000 | $74,800 | $74,800 | $74,800 | $82,280 | $82,280 | $82,280 | $90,508 | $90,508 | $90,508 |
| Equipment Rentals | 0% | $17,500 | $17,500 | $17,500 | $19,250 | $19,250 | $19,250 | $21,175 | $21,175 | $21,175 | $23,293 | $23,293 | $23,293 |
| Other | 0% | $2,250 | $2,250 | $2,250 | $2,475 | $2,475 | $2,475 | $2,723 | $2,723 | $2,723 | $2,995 | $2,995 | $2,995 |
| Total Sales | $227,000 | $227,000 | $229,500 | $252,450 | $252,450 | $252,450 | $277,695 | $277,695 | $277,695 | $305,465 | $305,465 | $305,465 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Hardware – Image Platforms | $48,670 | $48,670 | $48,670 | $53,537 | $53,537 | $53,537 | $58,891 | $58,891 | $58,891 | $64,780 | $64,780 | $64,780 | |
| Hardware – Printers | $3,250 | $3,250 | $3,250 | $3,575 | $3,575 | $3,575 | $3,933 | $3,933 | $3,933 | $4,326 | $4,326 | $4,326 | |
| Hardware – Facsimiles | $6,355 | $6,355 | $6,355 | $6,991 | $6,991 | $6,991 | $7,690 | $7,690 | $7,690 | $8,459 | $8,459 | $8,459 | |
| Hardware – Misc (TW, Shrd) | $2,275 | $2,275 | $2,275 | $2,503 | $2,503 | $2,503 | $2,753 | $2,753 | $2,753 | $3,028 | $3,028 | $3,028 | |
| Professional Services | $0 | $0 | $1,250 | $1,375 | $1,375 | $1,375 | $1,513 | $1,513 | $1,513 | $1,664 | $1,664 | $1,664 | |
| Government (Comp) | $2,188 | $2,188 | $2,188 | $2,406 | $2,406 | $2,406 | $2,647 | $2,647 | $2,647 | $2,912 | $2,912 | $2,912 | |
| Supplies (Toner/Paper) | $16,200 | $16,200 | $16,200 | $17,820 | $17,820 | $17,820 | $19,602 | $19,602 | $19,602 | $21,562 | $21,562 | $21,562 | |
| Service – Agreements/Repairs | $27,200 | $27,200 | $27,200 | $29,920 | $29,920 | $29,920 | $32,912 | $32,912 | $32,912 | $36,203 | $36,203 | $36,203 | |
| Equipment Rentals | $9,625 | $9,625 | $9,625 | $10,588 | $10,588 | $10,588 | $11,646 | $11,646 | $11,646 | $12,811 | $12,811 | $12,811 | |
| Other | $563 | $563 | $563 | $619 | $619 | $619 | $681 | $681 | $681 | $749 | $749 | $749 | |
| Subtotal Direct Cost of Sales | $116,325 | $116,325 | $117,575 | $129,333 | $129,333 | $129,333 | $142,266 | $142,266 | $142,266 | $156,492 | $156,492 | $156,492 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Production Personnel | |||||||||||||
| None planned | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Sales and Marketing Personnel | |||||||||||||
| Alan Fukuyama – Sales (Maui) | $3,000 | $3,000 | $3,000 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | |
| Brian Kurlansky – Sales (Kona) | $3,000 | $3,000 | $3,000 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | |
| Jay Moore – Sales (Maui) | $3,000 | $3,000 | $3,000 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | |
| Wilbert Shimabukuro – Sales (Hilo) | $3,000 | $3,000 | $3,000 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | |
| Vacant – Aftermarket Sales (Maui) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Vacant – Aftermarket Sales (Hilo) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal | $12,000 | $12,000 | $12,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | |
| General and Administrative Personnel | |||||||||||||
| Bill Harding – General Manager | $4,500 | $4,500 | $4,500 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | |
| Laurie Watson – Admin Manager | $3,650 | $3,650 | $3,650 | $3,850 | $3,850 | $3,850 | $3,850 | $3,850 | $3,850 | $3,850 | $3,850 | $3,850 | |
| Vacant – Office Manager (Hilo) | $2,450 | $2,450 | $2,450 | $2,650 | $2,650 | $2,650 | $2,650 | $2,650 | $2,650 | $2,650 | $2,650 | $2,650 | |
| Vacant – Whse & Delivery (Maui) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Vacant – Whse & Delivery (Hilo) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal | $10,600 | $10,600 | $10,600 | $11,400 | $11,400 | $11,400 | $11,400 | $11,400 | $11,400 | $11,400 | $11,400 | $11,400 | |
| Other Personnel | |||||||||||||
| Earle Oshiro – Systems Manager (Hilo) | $4,000 | $4,000 | $4,000 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | |
| Joe Alfonsi – Systems Manager (Maui) | $4,000 | $4,000 | $4,000 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | |
| Wane Ogawa – Syst Engineer (Hilo) | $3,150 | $3,150 | $3,150 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | |
| Francis Takahashi – Syst Engineer (Hilo) | $3,150 | $3,150 | $3,150 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | |
| Baron Ganeko – Syst Engineer (Kona) | $3,150 | $3,150 | $3,150 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | $3,350 | |
| Abe Braceros – Sr. Syst Engineer (Maui) | $3,200 | $3,200 | $3,200 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | |
| Arlo Villanueva – Syst Tech (Maui) | $2,250 | $2,250 | $2,250 | $2,450 | $2,450 | $2,450 | $2,450 | $2,450 | $2,450 | $2,450 | $2,450 | $2,450 | |
| Caroline Nacua – Syst Tech (Maui) | $2,250 | $2,250 | $2,250 | $2,450 | $2,450 | $2,450 | $2,450 | $2,450 | $2,450 | $2,450 | $2,450 | $2,450 | |
| Vacant – Syst Tech (Kona) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Vacant – Syst Tech (Maui) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal | $25,150 | $25,150 | $25,150 | $26,850 | $26,850 | $26,850 | $26,850 | $26,850 | $26,850 | $26,850 | $26,850 | $26,850 | |
| Total People | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | |
| Total Payroll | $47,750 | $47,750 | $47,750 | $51,250 | $51,250 | $51,250 | $51,250 | $51,250 | $51,250 | $51,250 | $51,250 | $51,250 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 38.00% | 38.00% | 38.00% | 38.00% | 38.00% | 38.00% | 38.00% | 38.00% | 38.00% | 38.00% | 38.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | $227,000 | $227,000 | $229,500 | $252,450 | $252,450 | $252,450 | $277,695 | $277,695 | $277,695 | $305,465 | $305,465 | $305,465 | |
| Direct Cost of Sales | $116,325 | $116,325 | $117,575 | $129,333 | $129,333 | $129,333 | $142,266 | $142,266 | $142,266 | $156,492 | $156,492 | $156,492 | |
| Production Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $116,325 | $116,325 | $117,575 | $129,333 | $129,333 | $129,333 | $142,266 | $142,266 | $142,266 | $156,492 | $156,492 | $156,492 | |
| Gross Margin | $110,675 | $110,675 | $111,925 | $123,118 | $123,118 | $123,118 | $135,429 | $135,429 | $135,429 | $148,972 | $148,972 | $148,972 | |
| Gross Margin % | 48.76% | 48.76% | 48.77% | 48.77% | 48.77% | 48.77% | 48.77% | 48.77% | 48.77% | 48.77% | 48.77% | 48.77% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | $12,000 | $12,000 | $12,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | |
| Advertising/Promotion | $500 | $500 | $500 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Commissions | $11,350 | $11,350 | $11,475 | $12,623 | $12,623 | $12,623 | $13,885 | $13,885 | $13,885 | $15,273 | $15,273 | $15,273 | |
| Travel – Sales | $1,500 | $1,500 | $1,500 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Learning & Growth – Sales | $0 | $0 | $0 | $400 | $400 | $400 | $400 | $400 | $400 | $1,250 | $1,250 | $1,250 | |
| Entertainment | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | |
| Total Sales and Marketing Expenses | $25,800 | $25,800 | $25,925 | $29,473 | $29,473 | $29,473 | $30,735 | $30,735 | $30,735 | $32,973 | $32,973 | $32,973 | |
| Sales and Marketing % | 11.37% | 11.37% | 11.30% | 11.67% | 11.67% | 11.67% | 11.07% | 11.07% | 11.07% | 10.79% | 10.79% | 10.79% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | $10,600 | $10,600 | $10,600 | $11,400 | $11,400 | $11,400 | $11,400 | $11,400 | $11,400 | $11,400 | $11,400 | $11,400 | |
| Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
| Telephone & ISP | $2,850 | $2,850 | $2,850 | $2,850 | $2,850 | $2,850 | $2,850 | $2,850 | $2,850 | $2,850 | $2,850 | $2,850 | |
| Office Supplies | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
| Insurance | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | |
| Bank Charges | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Postage | $835 | $835 | $835 | $835 | $835 | $835 | $835 | $835 | $835 | $835 | $835 | $835 | |
| Taxes & Licenses | $850 | $850 | $850 | $850 | $850 | $850 | $850 | $850 | $850 | $850 | $850 | $850 | |
| Bonuses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Learning & Growth – Admin | $0 | $0 | $0 | $150 | $150 | $150 | $150 | $150 | $150 | $750 | $750 | $750 | |
| Accounting | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Rent | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | |
| Payroll Taxes | 30% | $14,325 | $14,325 | $14,325 | $15,375 | $15,375 | $15,375 | $15,375 | $15,375 | $15,375 | $15,375 | $15,375 | $15,375 |
| Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total General and Administrative Expenses | $38,960 | $38,960 | $38,960 | $40,960 | $40,960 | $40,960 | $40,960 | $40,960 | $40,960 | $41,560 | $41,560 | $41,560 | |
| General and Administrative % | 17.16% | 17.16% | 16.98% | 16.22% | 16.22% | 16.22% | 14.75% | 14.75% | 14.75% | 13.61% | 13.61% | 13.61% | |
| Other Expenses: | |||||||||||||
| Other Payroll | $25,150 | $25,150 | $25,150 | $26,850 | $26,850 | $26,850 | $26,850 | $26,850 | $26,850 | $26,850 | $26,850 | $26,850 | |
| Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Learning & Growth – Service | $0 | $0 | $0 | $850 | $850 | $850 | $650 | $650 | $850 | $1,500 | $1,500 | $1,500 | |
| Travel – Service | $1,500 | $1,500 | $1,500 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Freight & Cartage | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
| Total Other Expenses | $29,150 | $29,150 | $29,150 | $32,200 | $32,200 | $32,200 | $32,000 | $32,000 | $32,200 | $32,850 | $32,850 | $32,850 | |
| Other % | 12.84% | 12.84% | 12.70% | 12.76% | 12.76% | 12.76% | 11.52% | 11.52% | 11.60% | 10.75% | 10.75% | 10.75% | |
| Total Operating Expenses | $93,910 | $93,910 | $94,035 | $102,633 | $102,633 | $102,633 | $103,695 | $103,695 | $103,895 | $107,383 | $107,383 | $107,383 | |
| Profit Before Interest and Taxes | $16,765 | $16,765 | $17,890 | $20,485 | $20,485 | $20,485 | $31,735 | $31,735 | $31,535 | $41,589 | $41,589 | $41,589 | |
| EBITDA | $16,765 | $16,765 | $17,890 | $20,485 | $20,485 | $20,485 | $31,735 | $31,735 | $31,535 | $41,589 | $41,589 | $41,589 | |
| Interest Expense | $11,667 | $11,667 | $11,667 | $11,667 | $11,667 | $11,667 | $11,667 | $11,667 | $11,667 | $11,667 | $11,667 | $11,667 | |
| Taxes Incurred | $1,530 | $1,937 | $2,365 | $3,351 | $3,351 | $3,351 | $7,626 | $7,626 | $7,550 | $11,370 | $11,370 | $11,370 | |
| Net Profit | $3,569 | $3,161 | $3,858 | $5,467 | $5,467 | $5,467 | $12,442 | $12,442 | $12,318 | $18,552 | $18,552 | $18,552 | |
| Net Profit/Sales | 1.57% | 1.39% | 1.68% | 2.17% | 2.17% | 2.17% | 4.48% | 4.48% | 4.44% | 6.07% | 6.07% | 6.07% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | $147,550 | $147,550 | $149,175 | $164,093 | $164,093 | $164,093 | $180,502 | $180,502 | $180,502 | $198,552 | $198,552 | $198,552 | |
| Cash from Receivables | $0 | $2,648 | $79,450 | $79,479 | $80,593 | $88,358 | $88,358 | $88,652 | $97,193 | $97,193 | $97,517 | $106,913 | |
| Subtotal Cash from Operations | $147,550 | $150,198 | $228,625 | $243,572 | $244,685 | $252,450 | $268,859 | $269,154 | $277,695 | $295,745 | $296,069 | $305,465 | |
| 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 | $0 | $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 | $30,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Received | $177,550 | $150,198 | $228,625 | $243,572 | $244,685 | $252,450 | $268,859 | $269,154 | $277,695 | $295,745 | $296,069 | $305,465 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | $47,750 | $47,750 | $47,750 | $51,250 | $51,250 | $51,250 | $51,250 | $51,250 | $51,250 | $51,250 | $51,250 | $51,250 | |
| Bill Payments | $3,455 | $106,054 | $176,195 | $180,247 | $208,235 | $195,733 | $196,816 | $227,755 | $214,007 | $215,366 | $250,790 | $235,663 | |
| Subtotal Spent on Operations | $51,205 | $153,804 | $223,945 | $231,497 | $259,485 | $246,983 | $248,066 | $279,005 | $265,257 | $266,616 | $302,040 | $286,913 | |
| 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Long-term Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 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 | $51,205 | $153,804 | $223,945 | $231,497 | $259,485 | $246,983 | $248,066 | $279,005 | $265,257 | $266,616 | $302,040 | $286,913 | |
| Net Cash Flow | $126,345 | ($3,605) | $4,680 | $12,075 | ($14,800) | $5,467 | $20,793 | ($9,852) | $12,438 | $29,129 | ($5,971) | $18,552 | |
| Cash Balance | $351,345 | $347,740 | $352,420 | $364,495 | $349,696 | $355,163 | $375,956 | $366,105 | $378,543 | $407,672 | $401,700 | $420,252 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | $225,000 | $351,345 | $347,740 | $352,420 | $364,495 | $349,696 | $355,163 | $375,956 | $366,105 | $378,543 | $407,672 | $401,700 | $420,252 |
| Accounts Receivable | $0 | $79,450 | $156,252 | $157,127 | $166,005 | $173,770 | $173,770 | $182,606 | $191,147 | $191,147 | $200,866 | $210,261 | $210,261 |
| Inventory | $200,000 | $127,958 | $127,958 | $129,333 | $142,266 | $142,266 | $142,266 | $156,492 | $156,492 | $156,492 | $172,142 | $172,142 | $172,142 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $425,000 | $558,753 | $631,949 | $638,879 | $672,766 | $665,731 | $671,199 | $715,054 | $713,744 | $726,182 | $780,679 | $784,103 | $802,655 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Assets | $425,000 | $558,753 | $631,949 | $638,879 | $672,766 | $665,731 | $671,199 | $715,054 | $713,744 | $726,182 | $780,679 | $784,103 | $802,655 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | $0 | $100,184 | $170,219 | $173,291 | $201,710 | $189,208 | $189,208 | $220,622 | $206,870 | $206,989 | $242,935 | $227,807 | $227,807 |
| Current Borrowing | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $1,000,000 | $1,100,184 | $1,170,219 | $1,173,291 | $1,201,710 | $1,189,208 | $1,189,208 | $1,220,622 | $1,206,870 | $1,206,989 | $1,242,935 | $1,227,807 | $1,227,807 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $1,000,000 | $1,100,184 | $1,170,219 | $1,173,291 | $1,201,710 | $1,189,208 | $1,189,208 | $1,220,622 | $1,206,870 | $1,206,989 | $1,242,935 | $1,227,807 | $1,227,807 |
| Paid-in Capital | $0 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 |
| Retained Earnings | ($575,000) | ($575,000) | ($575,000) | ($575,000) | ($575,000) | ($575,000) | ($575,000) | ($575,000) | ($575,000) | ($575,000) | ($575,000) | ($575,000) | ($575,000) |
| Earnings | $0 | $3,569 | $6,730 | $10,588 | $16,056 | $21,523 | $26,990 | $39,432 | $51,874 | $64,193 | $82,744 | $101,296 | $119,848 |
| Total Capital | ($575,000) | ($541,431) | ($538,270) | ($534,412) | ($528,944) | ($523,477) | ($518,010) | ($505,568) | ($493,126) | ($480,807) | ($462,256) | ($443,704) | ($425,152) |
| Total Liabilities and Capital | $425,000 | $558,753 | $631,949 | $638,879 | $672,766 | $665,731 | $671,199 | $715,054 | $713,744 | $726,182 | $780,679 | $784,103 | $802,655 |
| Net Worth | ($575,000) | ($541,431) | ($538,270) | ($534,412) | ($528,944) | ($523,477) | ($518,010) | ($505,568) | ($493,126) | ($480,807) | ($462,256) | ($443,704) | ($425,152) |
By 
