Office Equipment Rental Business Plan

START YOUR OWN BUSINESS PLAN

Rate this plan
(5/5, 2 votes)

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
Entrepreneurs 0% $0 $0 $285 $513 $855 $1,280 $1,642 $1,918 $2,166 $3,223 $3,363 $3,551
Companies 0% $0 $500 $500 $900 $1,500 $2,245 $2,880 $3,365 $3,800 $5,655 $5,900 $6,230
Total Sales $0 $500 $785 $1,413 $2,355 $3,525 $4,522 $5,283 $5,966 $8,878 $9,263 $9,781
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
Entrepreneurs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Companies $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
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
John 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Bookkeeper 0% $400 $400 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Sales 0% $0 $500 $1,000 $1,000 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Customer support 0% $0 $1,000 $2,000 $3,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Total People 2 4 5 6 8 8 8 8 8 8 8 8
Total Payroll $2,400 $3,900 $5,600 $6,600 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400
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 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% 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 $500 $785 $1,413 $2,355 $3,525 $4,522 $5,283 $5,966 $8,878 $9,263 $9,781
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Costs of Sales $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 $0 $500 $785 $1,413 $2,355 $3,525 $4,522 $5,283 $5,966 $8,878 $9,263 $9,781
Gross Margin % 0.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 $2,400 $3,900 $5,600 $6,600 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400
Sales and Marketing and Other Expenses $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
Rent $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Payroll Taxes 15% $360 $585 $840 $990 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $4,793 $6,518 $8,473 $9,623 $11,693 $11,693 $11,693 $11,693 $11,693 $11,693 $11,693 $11,693
Profit Before Interest and Taxes ($4,793) ($6,018) ($7,688) ($8,210) ($9,338) ($8,168) ($7,171) ($6,410) ($5,727) ($2,815) ($2,430) ($1,912)
EBITDA ($3,960) ($5,185) ($6,855) ($7,377) ($8,505) ($7,335) ($6,338) ($5,577) ($4,894) ($1,982) ($1,597) ($1,079)
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($4,793) ($6,018) ($7,688) ($8,210) ($9,338) ($8,168) ($7,171) ($6,410) ($5,727) ($2,815) ($2,430) ($1,912)
Net Profit/Sales 0.00% -1203.60% -979.36% -581.03% -396.52% -231.75% -158.60% -121.33% -95.99% -31.70% -26.23% -19.55%
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 $500 $785 $1,413 $2,355 $3,525 $4,522 $5,283 $5,966 $8,878 $9,263 $9,781
Subtotal Cash from Operations $0 $500 $785 $1,413 $2,355 $3,525 $4,522 $5,283 $5,966 $8,878 $9,263 $9,781
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 $500 $785 $1,413 $2,355 $3,525 $4,522 $5,283 $5,966 $8,878 $9,263 $9,781
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 $2,400 $3,900 $5,600 $6,600 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400
Bill Payments $52 $1,568 $1,794 $2,045 $2,199 $2,460 $2,460 $2,460 $2,460 $2,460 $2,460 $2,460
Subtotal Spent on Operations $2,452 $5,468 $7,394 $8,645 $10,599 $10,860 $10,860 $10,860 $10,860 $10,860 $10,860 $10,860
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 $2,452 $5,468 $7,394 $8,645 $10,599 $10,860 $10,860 $10,860 $10,860 $10,860 $10,860 $10,860
Net Cash Flow ($2,452) ($4,968) ($6,609) ($7,232) ($8,244) ($7,335) ($6,338) ($5,577) ($4,894) ($1,982) ($1,597) ($1,079)
Cash Balance $65,648 $60,681 $54,072 $46,840 $38,596 $31,261 $24,922 $19,345 $14,451 $12,470 $10,873 $9,794
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 $68,100 $65,648 $60,681 $54,072 $46,840 $38,596 $31,261 $24,922 $19,345 $14,451 $12,470 $10,873 $9,794
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $68,100 $65,648 $60,681 $54,072 $46,840 $38,596 $31,261 $24,922 $19,345 $14,451 $12,470 $10,873 $9,794
Long-term Assets
Long-term Assets $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
Accumulated Depreciation $0 $833 $1,666 $2,499 $3,332 $4,165 $4,998 $5,831 $6,664 $7,497 $8,330 $9,163 $9,996
Total Long-term Assets $50,000 $49,167 $48,334 $47,501 $46,668 $45,835 $45,002 $44,169 $43,336 $42,503 $41,670 $40,837 $40,004
Total Assets $118,100 $114,815 $109,014 $101,573 $93,508 $84,431 $76,262 $69,091 $62,681 $56,954 $54,139 $51,709 $49,797
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 $1,508 $1,726 $1,972 $2,117 $2,378 $2,378 $2,378 $2,378 $2,378 $2,378 $2,378 $2,378
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 $1,508 $1,726 $1,972 $2,117 $2,378 $2,378 $2,378 $2,378 $2,378 $2,378 $2,378 $2,378
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,508 $1,726 $1,972 $2,117 $2,378 $2,378 $2,378 $2,378 $2,378 $2,378 $2,378 $2,378
Paid-in Capital $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000
Retained Earnings ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900)
Earnings $0 ($4,793) ($10,811) ($18,499) ($26,709) ($36,047) ($44,216) ($51,387) ($57,797) ($63,524) ($66,339) ($68,769) ($70,681)
Total Capital $118,100 $113,307 $107,289 $99,601 $91,391 $82,053 $73,884 $66,713 $60,303 $54,576 $51,761 $49,331 $47,419
Total Liabilities and Capital $118,100 $114,815 $109,014 $101,573 $93,508 $84,431 $76,262 $69,091 $62,681 $56,954 $54,139 $51,709 $49,797
Net Worth $118,100 $113,307 $107,289 $99,601 $91,391 $82,053 $73,884 $66,713 $60,303 $54,576 $51,761 $49,331 $47,419