EcoAquatics

Start your own business plan »

Aquarium Services 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
Iniital client 0% $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
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
Unbilled minor accessories, testing supplies, etc. $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4
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
Owner 75% $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
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 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
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 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Direct Cost of Sales $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4
Gross Margin $196 $196 $196 $196 $196 $196 $196 $196 $196 $196 $196 $196
Gross Margin % 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00%
Expenses
Payroll $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $100 $100
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Website hosting $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $30
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
Payroll Taxes 0% $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 $180 $180 $180 $180 $180 $180 $180 $180 $180 $180 $280 $280
Profit Before Interest and Taxes $16 $16 $16 $16 $16 $16 $16 $16 $16 $16 ($84) ($84)
EBITDA $16 $16 $16 $16 $16 $16 $16 $16 $16 $16 ($84) ($84)
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 $16 $16 $16 $16 $16 $16 $16 $16 $16 $16 ($84) ($84)
Net Profit/Sales 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% -42.00% -42.00%
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 $0 $0 $0 $0 $0 $0 $0 $0
Cash from Receivables $0 $7 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Subtotal Cash from Operations $0 $7 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
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) $200 $150 $150 $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 $200 $157 $350 $200 $200 $200 $200 $200 $200 $200 $200 $200
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 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Bill Payments $1 $34 $34 $34 $34 $34 $34 $34 $34 $34 $37 $134
Subtotal Spent on Operations $151 $184 $184 $184 $184 $184 $184 $184 $184 $184 $187 $284
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 $151 $184 $184 $184 $184 $184 $184 $184 $184 $184 $187 $284
Net Cash Flow $49 ($27) $166 $16 $16 $16 $16 $16 $16 $16 $13 ($84)
Cash Balance $49 $22 $188 $204 $220 $236 $252 $268 $284 $300 $312 $228
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 $0 $49 $22 $188 $204 $220 $236 $252 $268 $284 $300 $312 $228
Accounts Receivable $0 $200 $393 $393 $393 $393 $393 $393 $393 $393 $393 $393 $393
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $0 $249 $415 $581 $597 $613 $629 $645 $661 $677 $693 $706 $622
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $0 $249 $415 $581 $597 $613 $629 $645 $661 $677 $693 $706 $622
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 $33 $33 $33 $33 $33 $33 $33 $33 $33 $33 $130 $130
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $200 $350 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Subtotal Current Liabilities $0 $233 $383 $533 $533 $533 $533 $533 $533 $533 $533 $630 $630
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $233 $383 $533 $533 $533 $533 $533 $533 $533 $533 $630 $630
Paid-in Capital $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Retained Earnings ($50) ($50) ($50) ($50) ($50) ($50) ($50) ($50) ($50) ($50) ($50) ($50) ($50)
Earnings $0 $16 $32 $48 $64 $80 $96 $112 $128 $144 $160 $76 ($8)
Total Capital $0 $16 $32 $48 $64 $80 $96 $112 $128 $144 $160 $76 ($8)
Total Liabilities and Capital $0 $249 $415 $581 $597 $613 $629 $645 $661 $677 $693 $706 $622
Net Worth $0 $16 $32 $48 $64 $80 $96 $112 $128 $144 $160 $76 ($8)