Ice Dreams
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 | |||||||||||||
Sales | 0% | $2,751 | $2,751 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $2,751 | $2,751 | $1,376 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $2,751 | $2,751 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $2,751 | $2,751 | $1,376 | |
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 | |
Cost of Sales | $623 | $623 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $623 | $623 | $312 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $623 | $623 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $623 | $623 | $312 |
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 | ||
Assistant | 0% | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 |
Owner | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
Total Payroll | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 |
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 | $2,751 | $2,751 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $2,751 | $2,751 | $1,376 | |
Direct Cost of Sales | $623 | $623 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $623 | $623 | $312 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $623 | $623 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $1,330 | $623 | $623 | $312 | |
Gross Margin | $2,128 | $2,128 | $4,361 | $4,361 | $4,361 | $4,361 | $4,361 | $4,361 | $4,361 | $2,128 | $2,128 | $1,064 | |
Gross Margin % | 77.35% | 77.35% | 76.63% | 76.63% | 76.63% | 76.63% | 76.63% | 76.63% | 76.63% | 77.35% | 77.35% | 77.33% | |
Expenses | |||||||||||||
Payroll | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | |
Marketing/Promotion | $180 | $180 | $105 | $105 | $105 | $105 | $105 | $105 | $105 | $105 | $105 | $105 | |
Depreciation | $37 | $33 | $33 | $33 | $33 | $33 | $33 | $33 | $33 | $33 | $33 | $33 | |
Utilities | $85 | $85 | $85 | $85 | $85 | $185 | $185 | $185 | $185 | $185 | $185 | $185 | |
Insurance | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Payroll Taxes | 23% | $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 | $1,302 | $1,298 | $1,223 | $1,223 | $1,223 | $1,323 | $1,323 | $1,323 | $1,323 | $1,323 | $1,323 | $1,323 | |
Profit Before Interest and Taxes | $826 | $830 | $3,138 | $3,138 | $3,138 | $3,038 | $3,038 | $3,038 | $3,038 | $805 | $805 | ($259) | |
EBITDA | $863 | $863 | $3,171 | $3,171 | $3,171 | $3,071 | $3,071 | $3,071 | $3,071 | $838 | $838 | ($226) | |
Interest Expense | $343 | $336 | $328 | $321 | $314 | $306 | $299 | $292 | $284 | $277 | $270 | $263 | |
Taxes Incurred | $145 | $148 | $843 | $845 | $847 | $819 | $822 | $824 | $826 | $158 | $161 | ($156) | |
Net Profit | $338 | $346 | $1,967 | $1,972 | $1,977 | $1,912 | $1,917 | $1,922 | $1,927 | $369 | $375 | ($365) | |
Net Profit/Sales | 12.30% | 12.58% | 34.56% | 34.65% | 34.74% | 33.60% | 33.69% | 33.78% | 33.87% | 13.43% | 13.62% | -26.53% |
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 | $2,751 | $2,751 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $2,751 | $2,751 | $1,376 | |
Subtotal Cash from Operations | $2,751 | $2,751 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $2,751 | $2,751 | $1,376 | |
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 | $2,751 | $2,751 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $5,691 | $2,751 | $2,751 | $1,376 | |
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 | $900 | $900 | $900 | $900 | $900 | |
Bill Payments | $28 | $886 | $1,893 | $3,162 | $2,786 | $2,783 | $2,846 | $2,841 | $2,835 | $2,764 | $859 | $1,776 | |
Subtotal Spent on Operations | $928 | $1,786 | $2,793 | $4,062 | $3,686 | $3,683 | $3,746 | $3,741 | $3,735 | $3,664 | $1,759 | $2,676 | |
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 | $875 | $875 | $875 | $875 | $875 | $875 | $875 | $875 | $875 | $875 | $875 | $875 | |
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,803 | $2,661 | $3,668 | $4,937 | $4,561 | $4,558 | $4,621 | $4,616 | $4,610 | $4,539 | $2,634 | $3,551 | |
Net Cash Flow | $948 | $90 | $2,023 | $754 | $1,130 | $1,133 | $1,070 | $1,075 | $1,081 | ($1,788) | $117 | ($2,175) | |
Cash Balance | $10,948 | $11,038 | $13,061 | $13,814 | $14,945 | $16,077 | $17,148 | $18,223 | $19,304 | $17,516 | $17,633 | $15,458 |
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 | $10,000 | $10,948 | $11,038 | $13,061 | $13,814 | $14,945 | $16,077 | $17,148 | $18,223 | $19,304 | $17,516 | $17,633 | $15,458 |
Inventory | $1,325 | $702 | $1,079 | $1,463 | $1,463 | $1,463 | $1,463 | $1,463 | $1,463 | $1,463 | $840 | $1,217 | $905 |
Other Current Assets | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 |
Total Current Assets | $12,000 | $12,325 | $12,792 | $15,199 | $15,952 | $17,083 | $18,215 | $19,286 | $20,361 | $21,442 | $19,031 | $19,525 | $17,038 |
Long-term Assets | |||||||||||||
Long-term Assets | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Accumulated Depreciation | $0 | $37 | $70 | $103 | $136 | $169 | $202 | $235 | $268 | $301 | $334 | $367 | $400 |
Total Long-term Assets | $4,000 | $3,963 | $3,930 | $3,897 | $3,864 | $3,831 | $3,798 | $3,765 | $3,732 | $3,699 | $3,666 | $3,633 | $3,600 |
Total Assets | $16,000 | $16,288 | $16,722 | $19,096 | $19,816 | $20,914 | $22,013 | $23,051 | $24,093 | $25,141 | $22,697 | $23,158 | $20,638 |
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 | $824 | $1,787 | $3,069 | $2,693 | $2,688 | $2,751 | $2,746 | $2,741 | $2,736 | $798 | $1,760 | $480 |
Current Borrowing | $42,010 | $41,135 | $40,260 | $39,385 | $38,510 | $37,635 | $36,760 | $35,885 | $35,010 | $34,135 | $33,260 | $32,385 | $31,510 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $42,010 | $41,959 | $42,047 | $42,454 | $41,203 | $40,323 | $39,511 | $38,631 | $37,751 | $36,871 | $34,058 | $34,145 | $31,990 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $42,010 | $41,959 | $42,047 | $42,454 | $41,203 | $40,323 | $39,511 | $38,631 | $37,751 | $36,871 | $34,058 | $34,145 | $31,990 |
Paid-in Capital | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
Retained Earnings | ($36,010) | ($36,010) | ($36,010) | ($36,010) | ($36,010) | ($36,010) | ($36,010) | ($36,010) | ($36,010) | ($36,010) | ($36,010) | ($36,010) | ($36,010) |
Earnings | $0 | $338 | $684 | $2,651 | $4,623 | $6,600 | $8,512 | $10,430 | $12,352 | $14,280 | $14,649 | $15,024 | $14,659 |
Total Capital | ($26,010) | ($25,672) | ($25,326) | ($23,359) | ($21,387) | ($19,410) | ($17,498) | ($15,580) | ($13,658) | ($11,730) | ($11,361) | ($10,986) | ($11,351) |
Total Liabilities and Capital | $16,000 | $16,288 | $16,722 | $19,096 | $19,816 | $20,914 | $22,013 | $23,051 | $24,093 | $25,141 | $22,697 | $23,158 | $20,638 |
Net Worth | ($26,010) | ($25,672) | ($25,326) | ($23,359) | ($21,387) | ($19,410) | ($17,498) | ($15,580) | ($13,658) | ($11,730) | ($11,361) | ($10,986) | ($11,351) |