| 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 | |||||||||||||
| Sales | 0% | $81,000 | $81,000 | $81,000 | $175,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Sales | $81,000 | $81,000 | $81,000 | $175,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | |
| 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 | |
| Sales | $32,000 | $32,000 | $32,000 | $58,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $32,000 | $32,000 | $32,000 | $58,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | |
| 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 | ||
| President | 0% | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
| Head of American Division | 0% | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 |
| Vice President American Division | 0% | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 |
| Other | 0% | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | |
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | $81,000 | $81,000 | $81,000 | $175,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | |
| Direct Cost of Sales | $32,000 | $32,000 | $32,000 | $58,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | |
| Other | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | |
| Total Cost of Sales | $34,750 | $34,750 | $34,750 | $60,750 | $34,750 | $34,750 | $34,750 | $34,750 | $34,750 | $34,750 | $34,750 | $34,750 | |
| Gross Margin | $46,250 | $46,250 | $46,250 | $114,250 | $46,250 | $46,250 | $46,250 | $46,250 | $46,250 | $46,250 | $46,250 | $46,250 | |
| Gross Margin % | 57.10% | 57.10% | 57.10% | 65.29% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | |
| Expenses | |||||||||||||
| Payroll | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | |
| Sales and Marketing and Other Expenses | $8,350 | $8,350 | $8,350 | $8,900 | $8,275 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | |
| Depreciation | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | |
| Leased Equipment | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | |
| Utilities | $500 | $500 | $550 | $600 | $575 | $550 | $500 | $500 | $500 | $500 | $550 | $500 | |
| Insurance | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Rent | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
| Other | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Payroll Taxes | 12% | $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 Operating Expenses | $45,842 | $45,842 | $45,892 | $46,492 | $45,842 | $45,892 | $45,842 | $45,842 | $45,842 | $45,842 | $45,892 | $45,842 | |
| Profit Before Interest and Taxes | $408 | $408 | $358 | $67,758 | $408 | $358 | $408 | $408 | $408 | $408 | $358 | $408 | |
| EBITDA | $700 | $700 | $650 | $68,050 | $700 | $650 | $700 | $700 | $700 | $700 | $650 | $700 | |
| Interest Expense | $397 | $395 | $392 | $732 | $729 | $727 | $557 | $555 | $552 | $383 | $381 | $378 | |
| Taxes Incurred | $3 | $3 | ($9) | $16,757 | ($80) | ($92) | ($37) | ($37) | ($36) | $6 | ($6) | $7 | |
| Net Profit | $7 | $10 | ($26) | $50,270 | ($241) | ($276) | ($112) | ($110) | ($108) | $19 | ($17) | $22 | |
| Net Profit/Sales | 0.01% | 0.01% | -0.03% | 28.73% | -0.30% | -0.34% | -0.14% | -0.14% | -0.13% | 0.02% | -0.02% | 0.03% | |
| 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 | $40,500 | $40,500 | $40,500 | $87,500 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | |
| Cash from Receivables | $0 | $1,350 | $40,500 | $40,500 | $42,067 | $85,933 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | |
| Subtotal Cash from Operations | $40,500 | $41,850 | $81,000 | $128,000 | $82,567 | $126,433 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | |
| 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 | $41,000 | $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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Received | $40,500 | $41,850 | $81,000 | $169,000 | $82,567 | $126,433 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | |
| 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 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | |
| Bill Payments | $7,207 | $65,861 | $55,999 | $58,444 | $124,982 | $28,603 | $56,279 | $56,120 | $56,118 | $56,112 | $55,991 | $56,024 | |
| Subtotal Spent on Operations | $31,907 | $90,561 | $80,699 | $83,144 | $149,682 | $53,303 | $80,979 | $80,820 | $80,818 | $80,812 | $80,691 | $80,724 | |
| 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 | $20,000 | $0 | $0 | $20,000 | $0 | $0 | |
| Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Long-term Liabilities Principal Repayment | $334 | $334 | $334 | $334 | $333 | $333 | $333 | $333 | $333 | $333 | $333 | $333 | |
| 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 | $32,241 | $90,895 | $81,033 | $83,478 | $150,015 | $53,636 | $101,312 | $81,153 | $81,151 | $101,145 | $81,024 | $81,057 | |
| Net Cash Flow | $8,259 | ($49,045) | ($33) | $85,522 | ($67,448) | $72,797 | ($20,312) | ($153) | ($151) | ($20,145) | ($24) | ($57) | |
| Cash Balance | $78,259 | $29,215 | $29,181 | $114,703 | $47,255 | $120,052 | $99,740 | $99,587 | $99,436 | $79,291 | $79,267 | $79,210 | |
| 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 | $70,000 | $78,259 | $29,215 | $29,181 | $114,703 | $47,255 | $120,052 | $99,740 | $99,587 | $99,436 | $79,291 | $79,267 | $79,210 |
| Accounts Receivable | $0 | $40,500 | $79,650 | $79,650 | $126,650 | $125,083 | $79,650 | $79,650 | $79,650 | $79,650 | $79,650 | $79,650 | $79,650 |
| Inventory | $25,000 | $35,200 | $35,200 | $35,200 | $63,800 | $35,200 | $35,200 | $35,200 | $35,200 | $35,200 | $35,200 | $35,200 | $35,200 |
| Other Current Assets | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
| Total Current Assets | $100,000 | $158,959 | $149,065 | $149,031 | $310,153 | $212,538 | $239,902 | $219,590 | $219,437 | $219,286 | $199,141 | $199,117 | $199,060 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 |
| Accumulated Depreciation | $0 | $292 | $584 | $876 | $1,168 | $1,460 | $1,752 | $2,044 | $2,336 | $2,628 | $2,920 | $3,212 | $3,504 |
| Total Long-term Assets | $35,000 | $34,708 | $34,416 | $34,124 | $33,832 | $33,540 | $33,248 | $32,956 | $32,664 | $32,372 | $32,080 | $31,788 | $31,496 |
| Total Assets | $135,000 | $193,667 | $183,481 | $183,155 | $343,985 | $246,078 | $273,150 | $252,546 | $252,101 | $251,658 | $231,221 | $230,905 | $230,556 |
| 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 | $5,000 | $63,994 | $54,132 | $54,166 | $124,060 | $26,727 | $54,408 | $54,249 | $54,248 | $54,246 | $54,123 | $54,158 | $54,120 |
| Current Borrowing | $30,000 | $30,000 | $30,000 | $30,000 | $71,000 | $71,000 | $71,000 | $51,000 | $51,000 | $51,000 | $31,000 | $31,000 | $31,000 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $35,000 | $93,994 | $84,132 | $84,166 | $195,060 | $97,727 | $125,408 | $105,249 | $105,248 | $105,246 | $85,123 | $85,158 | $85,120 |
| Long-term Liabilities | $20,000 | $19,666 | $19,332 | $18,998 | $18,664 | $18,331 | $17,998 | $17,665 | $17,332 | $16,999 | $16,666 | $16,333 | $16,000 |
| Total Liabilities | $55,000 | $113,660 | $103,464 | $103,164 | $213,724 | $116,058 | $143,406 | $122,914 | $122,580 | $122,245 | $101,789 | $101,491 | $101,120 |
| Paid-in Capital | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 |
| Retained Earnings | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) |
| Earnings | $0 | $7 | $17 | ($9) | $50,261 | $50,020 | $49,744 | $49,632 | $49,521 | $49,413 | $49,431 | $49,414 | $49,437 |
| Total Capital | $80,000 | $80,007 | $80,017 | $79,991 | $130,261 | $130,020 | $129,744 | $129,632 | $129,521 | $129,413 | $129,431 | $129,414 | $129,437 |
| Total Liabilities and Capital | $135,000 | $193,667 | $183,481 | $183,155 | $343,985 | $246,078 | $273,150 | $252,546 | $252,101 | $251,658 | $231,221 | $230,905 | $230,556 |
| Net Worth | $80,000 | $80,007 | $80,017 | $79,991 | $130,261 | $130,020 | $129,744 | $129,632 | $129,521 | $129,413 | $129,431 | $129,414 | $129,437 |