Victorian Renovations

Start your own business plan »

Rental Remodeling Business Plan

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