Victorian Renovations
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 | |||||||||||||
| Rental Revenue | 0% | $0 | $0 | $0 | $0 | $4,800 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Sales | $0 | $0 | $0 | $0 | $4,800 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | |
| 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 | |
| Rental Costs | $0 | $0 | $0 | $0 | $480 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $480 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | |
| 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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% |
| Long-term Interest Rate | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | $0 | $0 | $0 | $0 | $4,800 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | |
| Direct Cost of Sales | $0 | $0 | $0 | $0 | $480 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | |
| Other Production Expenses | $3,000 | $5,000 | $5,000 | $5,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $3,000 | $5,000 | $5,000 | $5,000 | $480 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | |
| Gross Margin | ($3,000) | ($5,000) | ($5,000) | ($5,000) | $4,320 | $2,160 | $2,160 | $2,160 | $2,160 | $2,160 | $2,160 | $2,160 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | |
| Expenses | |||||||||||||
| Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Sales and Marketing and Other Expenses | $2,100 | $2,100 | $2,100 | $2,300 | $200 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Depreciation | $0 | $0 | $0 | $0 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
| Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $400 | $400 | $400 | $300 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Insurance | $300 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Payroll Taxes | 15% | $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 | $2,800 | $2,500 | $2,500 | $2,600 | $700 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | |
| Profit Before Interest and Taxes | ($5,800) | ($7,500) | ($7,500) | ($7,600) | $3,620 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | |
| EBITDA | ($5,800) | ($7,500) | ($7,500) | ($7,600) | $4,020 | $1,960 | $1,960 | $1,960 | $1,960 | $1,960 | $1,960 | $1,960 | |
| Interest Expense | $900 | $898 | $896 | $894 | $892 | $890 | $888 | $886 | $884 | $882 | $880 | $878 | |
| Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Profit | ($6,700) | ($8,398) | ($8,396) | ($8,494) | $2,728 | $670 | $672 | $674 | $676 | $678 | $680 | $682 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 56.83% | 27.91% | 28.00% | 28.08% | 28.17% | 28.25% | 28.34% | 28.42% | |
| 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 | $0 | $0 | $0 | $0 | $4,800 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | |
| Subtotal Cash from Operations | $0 | $0 | $0 | $0 | $4,800 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | |
| 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Received | $0 | $0 | $0 | $0 | $4,800 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | |
| 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Bill Payments | $223 | $6,757 | $8,398 | $8,399 | $8,267 | $1,661 | $1,330 | $1,328 | $1,326 | $1,324 | $1,322 | $1,320 | |
| Subtotal Spent on Operations | $223 | $6,757 | $8,398 | $8,399 | $8,267 | $1,661 | $1,330 | $1,328 | $1,326 | $1,324 | $1,322 | $1,320 | |
| 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 | $348 | $350 | $352 | $354 | $356 | $358 | $360 | $362 | $364 | $366 | $368 | |
| 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 | $223 | $7,105 | $8,748 | $8,751 | $8,621 | $2,017 | $1,688 | $1,688 | $1,688 | $1,688 | $1,688 | $1,688 | |
| Net Cash Flow | ($223) | ($7,105) | ($8,748) | ($8,751) | ($3,821) | $383 | $712 | $712 | $712 | $712 | $712 | $712 | |
| Cash Balance | $74,277 | $67,172 | $58,424 | $49,673 | $45,852 | $46,236 | $46,948 | $47,660 | $48,372 | $49,084 | $49,796 | $50,508 | |
| 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 | $74,500 | $74,277 | $67,172 | $58,424 | $49,673 | $45,852 | $46,236 | $46,948 | $47,660 | $48,372 | $49,084 | $49,796 | $50,508 |
| Other Current Assets | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 |
| Total Current Assets | $75,250 | $75,027 | $67,922 | $59,174 | $50,423 | $46,602 | $46,986 | $47,698 | $48,410 | $49,122 | $49,834 | $50,546 | $51,258 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $144,000 | $144,000 | $144,000 | $144,000 | $144,000 | $144,000 | $144,000 | $144,000 | $144,000 | $144,000 | $144,000 | $144,000 | $144,000 |
| Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $400 | $800 | $1,200 | $1,600 | $2,000 | $2,400 | $2,800 | $3,200 |
| Total Long-term Assets | $144,000 | $144,000 | $144,000 | $144,000 | $144,000 | $143,600 | $143,200 | $142,800 | $142,400 | $142,000 | $141,600 | $141,200 | $140,800 |
| Total Assets | $219,250 | $219,027 | $211,922 | $203,174 | $194,423 | $190,202 | $190,186 | $190,498 | $190,810 | $191,122 | $191,434 | $191,746 | $192,058 |
| 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 | $6,477 | $8,118 | $8,116 | $8,211 | $1,616 | $1,286 | $1,284 | $1,282 | $1,280 | $1,278 | $1,276 | $1,274 |
| 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 | $0 | $6,477 | $8,118 | $8,116 | $8,211 | $1,616 | $1,286 | $1,284 | $1,282 | $1,280 | $1,278 | $1,276 | $1,274 |
| Long-term Liabilities | $160,000 | $160,000 | $159,652 | $159,302 | $158,950 | $158,596 | $158,240 | $157,883 | $157,523 | $157,161 | $156,797 | $156,431 | $156,062 |
| Total Liabilities | $160,000 | $166,477 | $167,770 | $167,418 | $167,161 | $160,213 | $159,526 | $159,166 | $158,804 | $158,440 | $158,074 | $157,706 | $157,336 |
| Paid-in Capital | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 |
| Retained Earnings | ($750) | ($750) | ($750) | ($750) | ($750) | ($750) | ($750) | ($750) | ($750) | ($750) | ($750) | ($750) | ($750) |
| Earnings | $0 | ($6,700) | ($15,098) | ($23,494) | ($31,988) | ($29,260) | ($28,590) | ($27,919) | ($27,245) | ($26,569) | ($25,891) | ($25,211) | ($24,528) |
| Total Capital | $59,250 | $52,550 | $44,152 | $35,756 | $27,262 | $29,990 | $30,660 | $31,331 | $32,005 | $32,681 | $33,359 | $34,039 | $34,722 |
| Total Liabilities and Capital | $219,250 | $219,027 | $211,922 | $203,174 | $194,423 | $190,202 | $190,186 | $190,498 | $190,810 | $191,122 | $191,434 | $191,746 | $192,058 |
| Net Worth | $59,250 | $52,550 | $44,152 | $35,756 | $27,262 | $29,990 | $30,660 | $31,331 | $32,005 | $32,681 | $33,359 | $34,039 | $34,722 |
By 
