| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Apartment | 0% | $2,093 | $1,890 | $2,093 | $2,025 | $5,270 | $5,100 | $5,270 | $5,270 | $5,100 | $2,093 | $2,025 | $2,093 |
| Large Jacuzzi | 0% | $1,395 | $1,260 | $1,395 | $2,363 | $4,611 | $4,463 | $4,611 | $4,611 | $4,463 | $1,395 | $2,363 | $1,395 |
| Adjoining Unit | 0% | $1,116 | $1,008 | $1,116 | $1,080 | $3,953 | $3,825 | $3,953 | $3,953 | $3,825 | $1,116 | $1,080 | $1,116 |
| Smaller Unit | 0% | $977 | $882 | $977 | $945 | $3,294 | $3,188 | $3,294 | $3,294 | $3,188 | $977 | $945 | $977 |
| Total Sales | $5,580 | $5,040 | $5,580 | $6,413 | $17,128 | $16,575 | $17,128 | $17,128 | $16,575 | $5,580 | $6,413 | $5,580 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Apartment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Large Jacuzzi | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Adjoining Unit | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Smaller Unit | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| John Maesch | 0% | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
| Frank Williams | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | |
| Total Payroll | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $2,000 | $2,000 | $2,000 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| 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 | 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% | 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | $5,580 | $5,040 | $5,580 | $6,413 | $17,128 | $16,575 | $17,128 | $17,128 | $16,575 | $5,580 | $6,413 | $5,580 | |
| Direct Cost of Sales | $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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Gross Margin | $5,580 | $5,040 | $5,580 | $6,413 | $17,128 | $16,575 | $17,128 | $17,128 | $16,575 | $5,580 | $6,413 | $5,580 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $2,000 | $2,000 | $2,000 | |
| Sales and Marketing and Other Expenses | $392 | $217 | $217 | $217 | $217 | $217 | $217 | $217 | $217 | $217 | $217 | $217 | |
| Depreciation | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | |
| Insurance | $215 | $215 | $215 | $215 | $215 | $215 | $215 | $215 | $215 | $215 | $215 | $215 | |
| Telephone | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Security | $35 | $35 | $35 | $35 | $35 | $35 | $35 | $35 | $35 | $35 | $35 | $35 | |
| Duties & Subscriptions | $175 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | |
| Room/Housecleaning | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | |
| Groceries | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | |
| Payroll Taxes | 15% | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $300 | $300 | $300 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $3,520 | $3,170 | $3,170 | $3,170 | $3,170 | $3,170 | $3,170 | $3,170 | $3,170 | $4,320 | $4,320 | $4,320 | |
| Profit Before Interest and Taxes | $2,060 | $1,870 | $2,410 | $3,243 | $13,958 | $13,405 | $13,958 | $13,958 | $13,405 | $1,260 | $2,093 | $1,260 | |
| EBITDA | $2,430 | $2,240 | $2,780 | $3,613 | $14,328 | $13,775 | $14,328 | $14,328 | $13,775 | $1,630 | $2,463 | $1,630 | |
| Interest Expense | $4,375 | $4,375 | $4,375 | $4,375 | $4,375 | $4,375 | $4,375 | $4,375 | $4,375 | $4,375 | $4,375 | $4,375 | |
| Taxes Incurred | ($694) | ($626) | ($491) | ($283) | $2,396 | $2,258 | $2,396 | $2,396 | $2,258 | ($779) | ($571) | ($779) | |
| Net Profit | ($1,620) | ($1,879) | ($1,474) | ($849) | $7,187 | $6,773 | $7,187 | $7,187 | $6,773 | ($2,336) | ($1,712) | ($2,336) | |
| Net Profit/Sales | -29.04% | -37.27% | -26.41% | -13.24% | 41.96% | 40.86% | 41.96% | 41.96% | 40.86% | -41.86% | -26.69% | -41.86% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | $1,395 | $1,260 | $1,395 | $1,603 | $4,282 | $4,144 | $4,282 | $4,282 | $4,144 | $1,395 | $1,603 | $1,395 | |
| Cash from Receivables | $2,000 | $2,140 | $4,172 | $3,794 | $4,206 | $5,077 | $12,832 | $12,445 | $12,846 | $12,832 | $12,156 | $4,206 | |
| Subtotal Cash from Operations | $3,395 | $3,400 | $5,567 | $5,397 | $8,488 | $9,221 | $17,114 | $16,727 | $16,989 | $14,227 | $13,760 | $5,601 | |
| 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 | $525,000 | $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 | $528,395 | $3,400 | $5,567 | $5,397 | $8,488 | $9,221 | $17,114 | $16,727 | $16,989 | $14,227 | $13,760 | $5,601 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $2,000 | $2,000 | $2,000 | |
| Bill Payments | $20,194 | $5,821 | $5,553 | $5,690 | $5,981 | $8,566 | $8,437 | $8,570 | $8,566 | $8,336 | $5,553 | $5,747 | |
| Subtotal Spent on Operations | $21,194 | $6,821 | $6,553 | $6,690 | $6,981 | $9,566 | $9,437 | $9,570 | $9,566 | $10,336 | $7,553 | $7,747 | |
| 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 | $500,000 | $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 | $21,194 | $6,821 | $506,553 | $6,690 | $6,981 | $9,566 | $9,437 | $9,570 | $9,566 | $10,336 | $7,553 | $7,747 | |
| Net Cash Flow | $507,201 | ($3,421) | ($500,987) | ($1,294) | $1,507 | ($345) | $7,677 | $7,157 | $7,424 | $3,891 | $6,207 | ($2,146) | |
| Cash Balance | $519,201 | $515,779 | $14,793 | $13,499 | $15,006 | $14,661 | $22,338 | $29,494 | $36,918 | $40,809 | $47,015 | $44,869 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | $12,000 | $519,201 | $515,779 | $14,793 | $13,499 | $15,006 | $14,661 | $22,338 | $29,494 | $36,918 | $40,809 | $47,015 | $44,869 |
| Accounts Receivable | $4,000 | $6,185 | $7,826 | $7,839 | $8,855 | $17,495 | $24,849 | $24,863 | $25,263 | $24,849 | $16,202 | $8,855 | $8,834 |
| Other Current Assets | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
| Total Current Assets | $17,000 | $526,386 | $524,605 | $23,632 | $23,354 | $33,500 | $40,510 | $48,200 | $55,757 | $62,767 | $58,011 | $56,870 | $54,703 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $200,000 | $200,000 | $200,000 | $700,000 | $700,000 | $700,000 | $700,000 | $700,000 | $700,000 | $700,000 | $700,000 | $700,000 | $700,000 |
| Accumulated Depreciation | $30,000 | $30,370 | $30,740 | $31,110 | $31,480 | $31,850 | $32,220 | $32,590 | $32,960 | $33,330 | $33,700 | $34,070 | $34,440 |
| Total Long-term Assets | $170,000 | $169,630 | $169,260 | $668,890 | $668,520 | $668,150 | $667,780 | $667,410 | $667,040 | $666,670 | $666,300 | $665,930 | $665,560 |
| Total Assets | $187,000 | $696,016 | $693,865 | $692,522 | $691,874 | $701,650 | $708,290 | $715,610 | $722,797 | $729,437 | $724,311 | $722,800 | $720,263 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | $20,000 | $5,636 | $5,364 | $5,494 | $5,695 | $8,285 | $8,151 | $8,285 | $8,285 | $8,151 | $5,361 | $5,562 | $5,361 |
| Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $20,000 | $5,636 | $5,364 | $5,494 | $5,695 | $8,285 | $8,151 | $8,285 | $8,285 | $8,151 | $5,361 | $5,562 | $5,361 |
| Long-term Liabilities | $0 | $525,000 | $525,000 | $525,000 | $525,000 | $525,000 | $525,000 | $525,000 | $525,000 | $525,000 | $525,000 | $525,000 | $525,000 |
| Total Liabilities | $20,000 | $530,636 | $530,364 | $530,494 | $530,695 | $533,285 | $533,151 | $533,285 | $533,285 | $533,151 | $530,361 | $530,562 | $530,361 |
| Paid-in Capital | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 |
| Retained Earnings | $117,000 | $117,000 | $117,000 | $117,000 | $117,000 | $117,000 | $117,000 | $117,000 | $117,000 | $117,000 | $117,000 | $117,000 | $117,000 |
| Earnings | $0 | ($1,620) | ($3,499) | ($4,972) | ($5,821) | $1,366 | $8,138 | $15,326 | $22,513 | $29,285 | $26,949 | $25,238 | $22,902 |
| Total Capital | $167,000 | $165,380 | $163,501 | $162,028 | $161,179 | $168,366 | $175,138 | $182,326 | $189,513 | $196,285 | $193,949 | $192,238 | $189,902 |
| Total Liabilities and Capital | $187,000 | $696,016 | $693,865 | $692,522 | $691,874 | $701,650 | $708,290 | $715,610 | $722,797 | $729,437 | $724,311 | $722,800 | $720,263 |
| Net Worth | $167,000 | $165,380 | $163,501 | $162,028 | $161,179 | $168,366 | $175,138 | $182,326 | $189,513 | $196,285 | $193,949 | $192,238 | $189,902 |