The Art Sentry

Start your own business plan »

Art Packaging Installation 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
Residential 0% $0 $410 $495 $559 $900 $1,241 $1,276 $1,423 $1,490 $1,684 $1,824 $2,025
Corporate 0% $0 $546 $660 $745 $1,200 $1,654 $1,701 $1,897 $1,987 $2,245 $2,432 $2,700
Total Sales $0 $956 $1,155 $1,304 $2,100 $2,895 $2,977 $3,320 $3,477 $3,929 $4,256 $4,725
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
Residential $0 $20 $25 $28 $45 $62 $64 $71 $75 $84 $91 $101
Corporate $0 $27 $33 $37 $60 $83 $85 $95 $99 $112 $122 $135
Subtotal Direct Cost of Sales $0 $48 $58 $65 $105 $145 $149 $166 $174 $196 $213 $236
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 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Name or Title 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or Title 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 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
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 $956 $1,155 $1,304 $2,100 $2,895 $2,977 $3,320 $3,477 $3,929 $4,256 $4,725
Direct Cost of Sales $0 $48 $58 $65 $105 $145 $149 $166 $174 $196 $213 $236
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $48 $58 $65 $105 $145 $149 $166 $174 $196 $213 $236
Gross Margin $0 $908 $1,097 $1,239 $1,995 $2,750 $2,828 $3,154 $3,303 $3,732 $4,043 $4,489
Gross Margin % 0.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00%
Expenses
Payroll $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Sales and Marketing and Other Expenses $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Depreciation $39 $39 $39 $39 $39 $39 $39 $39 $39 $39 $39 $39
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Licenses and Bonding $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Insurance $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
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,789 $2,789 $2,789 $2,789 $2,789 $2,789 $2,789 $2,789 $2,789 $2,789 $2,789 $2,789
Profit Before Interest and Taxes ($2,789) ($1,881) ($1,692) ($1,550) ($794) ($39) $39 $365 $514 $943 $1,254 $1,700
EBITDA ($2,750) ($1,842) ($1,653) ($1,511) ($755) ($0) $78 $404 $553 $982 $1,293 $1,739
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 ($2,789) ($1,881) ($1,692) ($1,550) ($794) ($39) $39 $365 $514 $943 $1,254 $1,700
Net Profit/Sales 0.00% -196.89% -146.47% -118.92% -37.81% -1.36% 1.31% 10.99% 14.79% 24.01% 29.47% 35.97%
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 $956 $1,155 $1,304 $2,100 $2,895 $2,977 $3,320 $3,477 $3,929 $4,256 $4,725
Subtotal Cash from Operations $0 $956 $1,155 $1,304 $2,100 $2,895 $2,977 $3,320 $3,477 $3,929 $4,256 $4,725
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 $956 $1,155 $1,304 $2,100 $2,895 $2,977 $3,320 $3,477 $3,929 $4,256 $4,725
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,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Bill Payments $8 $252 $298 $308 $317 $356 $395 $399 $416 $425 $447 $464
Subtotal Spent on Operations $2,508 $2,752 $2,798 $2,808 $2,817 $2,856 $2,895 $2,899 $2,916 $2,925 $2,947 $2,964
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,508 $2,752 $2,798 $2,808 $2,817 $2,856 $2,895 $2,899 $2,916 $2,925 $2,947 $2,964
Net Cash Flow ($2,508) ($1,796) ($1,643) ($1,504) ($717) $38 $82 $420 $561 $1,004 $1,309 $1,761
Cash Balance $9,542 $7,746 $6,102 $4,598 $3,882 $3,920 $4,002 $4,422 $4,983 $5,987 $7,296 $9,058
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 $12,050 $9,542 $7,746 $6,102 $4,598 $3,882 $3,920 $4,002 $4,422 $4,983 $5,987 $7,296 $9,058
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $12,050 $9,542 $7,746 $6,102 $4,598 $3,882 $3,920 $4,002 $4,422 $4,983 $5,987 $7,296 $9,058
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $39 $78 $117 $156 $195 $234 $273 $312 $351 $390 $429 $468
Total Long-term Assets $0 ($39) ($78) ($117) ($156) ($195) ($234) ($273) ($312) ($351) ($390) ($429) ($468)
Total Assets $12,050 $9,503 $7,668 $5,985 $4,442 $3,687 $3,686 $3,729 $4,110 $4,632 $5,597 $6,867 $8,590
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 $242 $288 $297 $305 $343 $382 $386 $402 $410 $432 $447 $470
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 $242 $288 $297 $305 $343 $382 $386 $402 $410 $432 $447 $470
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $242 $288 $297 $305 $343 $382 $386 $402 $410 $432 $447 $470
Paid-in Capital $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Retained Earnings ($2,950) ($2,950) ($2,950) ($2,950) ($2,950) ($2,950) ($2,950) ($2,950) ($2,950) ($2,950) ($2,950) ($2,950) ($2,950)
Earnings $0 ($2,789) ($4,670) ($6,362) ($7,912) ($8,706) ($8,746) ($8,707) ($8,342) ($7,828) ($6,884) ($5,630) ($3,930)
Total Capital $12,050 $9,261 $7,380 $5,688 $4,138 $3,344 $3,304 $3,343 $3,708 $4,222 $5,166 $6,420 $8,120
Total Liabilities and Capital $12,050 $9,503 $7,668 $5,985 $4,442 $3,687 $3,686 $3,729 $4,110 $4,632 $5,597 $6,867 $8,590
Net Worth $12,050 $9,261 $7,380 $5,688 $4,138 $3,344 $3,304 $3,343 $3,708 $4,222 $5,166 $6,420 $8,120