Barton Interiors
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 Consulting | 0% | $800 | $900 | $1,000 | $1,200 | $1,400 | $1,600 | $1,800 | $2,000 | $2,400 | $2,800 | $3,200 | $3,600 |
Commercial Consulting | 0% | $0 | $0 | $0 | $240 | $280 | $320 | $360 | $400 | $440 | $560 | $640 | $720 |
Product Sales | 0% | $400 | $600 | $800 | $1,000 | $1,200 | $1,400 | $1,600 | $1,800 | $2,000 | $2,400 | $3,000 | $3,600 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $1,200 | $1,500 | $1,800 | $2,440 | $2,880 | $3,320 | $3,760 | $4,200 | $4,840 | $5,760 | $6,840 | $7,920 | |
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 Consulting | $120 | $135 | $150 | $180 | $210 | $240 | $270 | $300 | $360 | $420 | $480 | $540 | |
Commercial Consulting | $0 | $0 | $0 | $36 | $42 | $48 | $54 | $60 | $66 | $84 | $96 | $108 | |
Product Sales | $220 | $330 | $440 | $550 | $660 | $770 | $880 | $990 | $1,100 | $1,320 | $1,650 | $1,980 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $340 | $465 | $590 | $766 | $912 | $1,058 | $1,204 | $1,350 | $1,526 | $1,824 | $2,226 | $2,628 |
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.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | |
Long-term Interest Rate | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | |
Tax Rate | 30.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.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 | $1,200 | $1,500 | $1,800 | $2,440 | $2,880 | $3,320 | $3,760 | $4,200 | $4,840 | $5,760 | $6,840 | $7,920 | |
Direct Cost of Sales | $340 | $465 | $590 | $766 | $912 | $1,058 | $1,204 | $1,350 | $1,526 | $1,824 | $2,226 | $2,628 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $340 | $465 | $590 | $766 | $912 | $1,058 | $1,204 | $1,350 | $1,526 | $1,824 | $2,226 | $2,628 | |
Gross Margin | $860 | $1,035 | $1,210 | $1,674 | $1,968 | $2,262 | $2,556 | $2,850 | $3,314 | $3,936 | $4,614 | $5,292 | |
Gross Margin % | 71.67% | 69.00% | 67.22% | 68.61% | 68.33% | 68.13% | 67.98% | 67.86% | 68.47% | 68.33% | 67.46% | 66.82% | |
Expenses | |||||||||||||
Payroll | $1,200 | $1,200 | $1,200 | $1,500 | $1,500 | $1,500 | $1,800 | $1,800 | $1,800 | $2,100 | $2,100 | $2,100 | |
Sales and Marketing and Other Expenses | $2,165 | $615 | $615 | $885 | $625 | $625 | $685 | $685 | $935 | $685 | $2,425 | $615 | |
Depreciation | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | |
Insurance | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | |
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 | $3,515 | $1,965 | $1,965 | $2,535 | $2,275 | $2,275 | $2,635 | $2,635 | $2,885 | $2,935 | $4,675 | $2,865 | |
Profit Before Interest and Taxes | ($2,655) | ($930) | ($755) | ($861) | ($307) | ($13) | ($79) | $215 | $429 | $1,001 | ($61) | $2,427 | |
EBITDA | ($2,630) | ($905) | ($730) | ($836) | ($282) | $12 | ($54) | $240 | $454 | $1,026 | ($36) | $2,452 | |
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,655) | ($930) | ($755) | ($861) | ($307) | ($13) | ($79) | $215 | $429 | $1,001 | ($61) | $2,427 | |
Net Profit/Sales | -221.25% | -62.00% | -41.94% | -35.29% | -10.66% | -0.39% | -2.10% | 5.12% | 8.86% | 17.38% | -0.89% | 30.64% |
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 | $840 | $1,050 | $1,260 | $1,708 | $2,016 | $2,324 | $2,632 | $2,940 | $3,388 | $4,032 | $4,788 | $5,544 | |
Cash from Receivables | $0 | $12 | $363 | $453 | $546 | $736 | $868 | $1,000 | $1,132 | $1,266 | $1,461 | $1,739 | |
Subtotal Cash from Operations | $840 | $1,062 | $1,623 | $2,161 | $2,562 | $3,060 | $3,500 | $3,940 | $4,520 | $5,298 | $6,249 | $7,283 | |
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 | $210 | $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 | $840 | $1,062 | $1,623 | $2,371 | $2,562 | $3,060 | $3,500 | $3,940 | $4,520 | $5,298 | $6,249 | $7,283 | |
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 | $1,200 | $1,200 | $1,200 | $1,500 | $1,500 | $1,500 | $1,800 | $1,800 | $1,800 | $2,100 | $2,100 | $2,100 | |
Bill Payments | $88 | $2,583 | $1,209 | $1,345 | $1,772 | $1,667 | $1,815 | $2,019 | $2,174 | $2,588 | $2,705 | $4,729 | |
Subtotal Spent on Operations | $1,288 | $3,783 | $2,409 | $2,845 | $3,272 | $3,167 | $3,615 | $3,819 | $3,974 | $4,688 | $4,805 | $6,829 | |
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 | $1,288 | $3,783 | $2,409 | $2,845 | $3,272 | $3,167 | $3,615 | $3,819 | $3,974 | $4,688 | $4,805 | $6,829 | |
Net Cash Flow | ($448) | ($2,721) | ($786) | ($474) | ($710) | ($106) | ($114) | $122 | $546 | $611 | $1,444 | $454 | |
Cash Balance | $9,332 | $6,612 | $5,826 | $5,352 | $4,642 | $4,536 | $4,421 | $4,543 | $5,089 | $5,700 | $7,143 | $7,597 |
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 | $9,780 | $9,332 | $6,612 | $5,826 | $5,352 | $4,642 | $4,536 | $4,421 | $4,543 | $5,089 | $5,700 | $7,143 | $7,597 |
Accounts Receivable | $0 | $360 | $798 | $975 | $1,254 | $1,572 | $1,831 | $2,091 | $2,350 | $2,670 | $3,132 | $3,722 | $4,360 |
Other Current Assets | $1,000 | $1,000 | $1,000 | $1,000 | $790 | $790 | $790 | $790 | $790 | $790 | $790 | $790 | $790 |
Total Current Assets | $10,780 | $10,692 | $8,410 | $7,801 | $7,396 | $7,004 | $7,157 | $7,302 | $7,683 | $8,549 | $9,621 | $11,656 | $12,747 |
Long-term Assets | |||||||||||||
Long-term Assets | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Accumulated Depreciation | $0 | $25 | $50 | $75 | $100 | $125 | $150 | $175 | $200 | $225 | $250 | $275 | $300 |
Total Long-term Assets | $3,000 | $2,975 | $2,950 | $2,925 | $2,900 | $2,875 | $2,850 | $2,825 | $2,800 | $2,775 | $2,750 | $2,725 | $2,700 |
Total Assets | $13,780 | $13,667 | $11,360 | $10,726 | $10,296 | $9,879 | $10,007 | $10,127 | $10,483 | $11,324 | $12,371 | $14,381 | $15,447 |
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 | $2,542 | $1,165 | $1,286 | $1,717 | $1,607 | $1,748 | $1,947 | $2,088 | $2,500 | $2,546 | $4,617 | $3,256 |
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 | $2,542 | $1,165 | $1,286 | $1,717 | $1,607 | $1,748 | $1,947 | $2,088 | $2,500 | $2,546 | $4,617 | $3,256 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $2,542 | $1,165 | $1,286 | $1,717 | $1,607 | $1,748 | $1,947 | $2,088 | $2,500 | $2,546 | $4,617 | $3,256 |
Paid-in Capital | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
Retained Earnings | ($11,220) | ($11,220) | ($11,220) | ($11,220) | ($11,220) | ($11,220) | ($11,220) | ($11,220) | ($11,220) | ($11,220) | ($11,220) | ($11,220) | ($11,220) |
Earnings | $0 | ($2,655) | ($3,585) | ($4,340) | ($5,201) | ($5,508) | ($5,521) | ($5,600) | ($5,385) | ($4,956) | ($3,955) | ($4,016) | ($1,589) |
Total Capital | $13,780 | $11,125 | $10,195 | $9,440 | $8,579 | $8,272 | $8,259 | $8,180 | $8,395 | $8,824 | $9,825 | $9,764 | $12,191 |
Total Liabilities and Capital | $13,780 | $13,667 | $11,360 | $10,726 | $10,296 | $9,879 | $10,007 | $10,127 | $10,483 | $11,324 | $12,371 | $14,381 | $15,447 |
Net Worth | $13,780 | $11,125 | $10,195 | $9,440 | $8,579 | $8,272 | $8,259 | $8,180 | $8,395 | $8,824 | $9,825 | $9,764 | $12,191 |
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 | ||
Jill Barton | 0% | $1,200 | $1,200 | $1,200 | $1,500 | $1,500 | $1,500 | $1,800 | $1,800 | $1,800 | $2,100 | $2,100 | $2,100 |
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 | $1,200 | $1,200 | $1,200 | $1,500 | $1,500 | $1,500 | $1,800 | $1,800 | $1,800 | $2,100 | $2,100 | $2,100 |