Margarita Momma

Start your own business plan »

Beverage Machine Rental 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
Unit Sales
Machine Rental 0% 30 48 36 36 55 48 48 57 57 57 50 50
Extra Mix 0% 10 20 10 15 25 20 20 25 25 25 25 25
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 40 68 46 51 80 68 68 82 82 82 75 75
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Machine Rental $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
Extra Mix $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00
Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Sales
Machine Rental $3,000 $4,800 $3,600 $3,600 $5,500 $4,800 $4,800 $5,700 $5,700 $5,700 $5,000 $5,000
Extra Mix $150 $300 $150 $225 $375 $300 $300 $375 $375 $375 $375 $375
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $3,150 $5,100 $3,750 $3,825 $5,875 $5,100 $5,100 $6,075 $6,075 $6,075 $5,375 $5,375
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Machine Rental 0.00% $7.60 $7.60 $7.60 $7.60 $7.60 $7.60 $7.60 $7.60 $7.60 $7.60 $7.60 $7.60
Extra Mix 0.00% $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80
Other 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
Machine Rental $228 $365 $274 $274 $418 $365 $365 $433 $433 $433 $380 $380
Extra Mix $48 $96 $48 $72 $120 $96 $96 $120 $120 $120 $120 $120
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $276 $461 $322 $346 $538 $461 $461 $553 $553 $553 $500 $500
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
Payroll 0% $900 $900 $900 $900 $900 $900 $900 $950 $950 $950 $950 $950
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $900 $900 $900 $900 $900 $900 $900 $950 $950 $950 $950 $950
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% 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 $3,150 $5,100 $3,750 $3,825 $5,875 $5,100 $5,100 $6,075 $6,075 $6,075 $5,375 $5,375
Direct Cost of Sales $276 $461 $322 $346 $538 $461 $461 $553 $553 $553 $500 $500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $276 $461 $322 $346 $538 $461 $461 $553 $553 $553 $500 $500
Gross Margin $2,874 $4,639 $3,428 $3,479 $5,337 $4,639 $4,639 $5,522 $5,522 $5,522 $4,875 $4,875
Gross Margin % 91.24% 90.96% 91.42% 90.96% 90.84% 90.96% 90.96% 90.89% 90.89% 90.89% 90.70% 90.70%
Expenses
Payroll $900 $900 $900 $900 $900 $900 $900 $950 $950 $950 $950 $950
Sales and Marketing and Other Expenses $20 $30 $30 $20 $20 $20 $30 $20 $20 $20 $20 $30
Depreciation $13 $13 $13 $13 $13 $13 $13 $13 $13 $13 $10 $11
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $0 $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 $933 $943 $943 $933 $933 $933 $943 $983 $983 $983 $980 $991
Profit Before Interest and Taxes $1,942 $3,697 $2,486 $2,546 $4,404 $3,706 $3,696 $4,539 $4,539 $4,539 $3,895 $3,884
EBITDA $1,954 $3,709 $2,498 $2,559 $4,417 $3,719 $3,709 $4,552 $4,552 $4,552 $3,905 $3,895
Interest Expense $91 $90 $89 $88 $87 $86 $86 $85 $84 $83 $82 $81
Taxes Incurred $555 $902 $599 $615 $1,079 $905 $903 $1,114 $1,114 $1,114 $953 $951
Net Profit $1,296 $2,705 $1,798 $1,844 $3,238 $2,715 $2,708 $3,341 $3,341 $3,342 $2,860 $2,852
Net Profit/Sales 41.13% 53.04% 47.94% 48.20% 55.11% 53.23% 53.10% 54.99% 55.00% 55.01% 53.20% 53.06%
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 $3,150 $5,100 $3,750 $3,825 $5,875 $5,100 $5,100 $6,075 $6,075 $6,075 $5,375 $5,375
Subtotal Cash from Operations $3,150 $5,100 $3,750 $3,825 $5,875 $5,100 $5,100 $6,075 $6,075 $6,075 $5,375 $5,375
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 $3,150 $5,100 $3,750 $3,825 $5,875 $5,100 $5,100 $6,075 $6,075 $6,075 $5,375 $5,375
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 $900 $900 $900 $900 $900 $900 $900 $950 $950 $950 $950 $950
Bill Payments $22 $711 $1,978 $752 $1,705 $1,214 $1,978 $1,058 $2,185 $1,251 $2,178 $1,089
Subtotal Spent on Operations $922 $1,611 $2,878 $1,652 $2,605 $2,114 $2,878 $2,008 $3,135 $2,201 $3,128 $2,039
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 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
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 $1,022 $1,711 $2,978 $1,752 $2,705 $2,214 $2,978 $2,108 $3,235 $2,301 $3,228 $2,139
Net Cash Flow $2,128 $3,389 $772 $2,073 $3,170 $2,886 $2,122 $3,967 $2,840 $3,774 $2,147 $3,236
Cash Balance $2,967 $6,356 $7,128 $9,201 $12,372 $15,258 $17,379 $21,346 $24,186 $27,961 $30,107 $33,343
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 $839 $2,967 $6,356 $7,128 $9,201 $12,372 $15,258 $17,379 $21,346 $24,186 $27,961 $30,107 $33,343
Inventory $700 $424 $963 $642 $1,296 $758 $1,297 $836 $1,283 $730 $1,177 $677 $1,177
Other Current Assets $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260
Total Current Assets $2,799 $4,651 $8,579 $9,029 $11,757 $14,390 $17,815 $19,476 $23,889 $26,176 $30,397 $32,044 $35,780
Long-term Assets
Long-term Assets $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
Accumulated Depreciation $0 $13 $25 $38 $51 $64 $77 $90 $103 $116 $129 $139 $150
Total Long-term Assets $9,000 $8,988 $8,975 $8,963 $8,950 $8,937 $8,924 $8,911 $8,898 $8,885 $8,872 $8,862 $8,851
Total Assets $11,799 $13,638 $17,554 $17,992 $20,707 $23,326 $26,738 $28,386 $32,787 $35,061 $39,269 $40,906 $44,631
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 $644 $1,954 $694 $1,665 $1,147 $1,944 $984 $2,144 $1,177 $2,143 $1,020 $1,993
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 $644 $1,954 $694 $1,665 $1,147 $1,944 $984 $2,144 $1,177 $2,143 $1,020 $1,993
Long-term Liabilities $10,960 $10,860 $10,760 $10,660 $10,560 $10,460 $10,360 $10,260 $10,160 $10,060 $9,960 $9,860 $9,760
Total Liabilities $10,960 $11,504 $12,714 $11,354 $12,225 $11,607 $12,304 $11,244 $12,304 $11,237 $12,103 $10,880 $11,753
Paid-in Capital $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
Retained Earnings ($161) ($161) ($161) ($161) ($161) ($161) ($161) ($161) ($161) ($161) ($161) ($161) ($161)
Earnings $0 $1,296 $4,001 $5,799 $7,643 $10,880 $13,595 $16,303 $19,644 $22,985 $26,327 $29,186 $32,038
Total Capital $839 $2,135 $4,840 $6,638 $8,482 $11,719 $14,434 $17,142 $20,483 $23,824 $27,166 $30,025 $32,877
Total Liabilities and Capital $11,799 $13,638 $17,554 $17,992 $20,707 $23,326 $26,738 $28,386 $32,787 $35,061 $39,269 $40,906 $44,631
Net Worth $839 $2,135 $4,840 $6,638 $8,482 $11,719 $14,434 $17,142 $20,483 $23,824 $27,166 $30,025 $32,877