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) |