Last Frontier Market
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% | $26,000 | $29,000 | $30,000 | $34,000 | $36,000 | $38,000 | $34,000 | $33,000 | $35,000 | $39,000 | $43,000 | $46,000 |
Others | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $26,000 | $29,000 | $30,000 | $34,000 | $36,000 | $38,000 | $34,000 | $33,000 | $35,000 | $39,000 | $43,000 | $46,000 | |
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 | |
Sales | $9,000 | $9,500 | $9,600 | $10,200 | $10,500 | $11,300 | $10,000 | $10,000 | $11,000 | $12,000 | $12,120 | $13,000 | |
Others | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $9,000 | $9,500 | $9,600 | $10,200 | $10,500 | $11,300 | $10,000 | $10,000 | $11,000 | $12,000 | $12,120 | $13,000 |
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 | ||
Mary Stevens | 0% | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 |
Josh Wingard | 0% | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 |
Cashiers | 0% | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 |
Produce Staff | 0% | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
Total Payroll | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 |
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 | $26,000 | $29,000 | $30,000 | $34,000 | $36,000 | $38,000 | $34,000 | $33,000 | $35,000 | $39,000 | $43,000 | $46,000 | |
Direct Cost of Sales | $9,000 | $9,500 | $9,600 | $10,200 | $10,500 | $11,300 | $10,000 | $10,000 | $11,000 | $12,000 | $12,120 | $13,000 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $9,000 | $9,500 | $9,600 | $10,200 | $10,500 | $11,300 | $10,000 | $10,000 | $11,000 | $12,000 | $12,120 | $13,000 | |
Gross Margin | $17,000 | $19,500 | $20,400 | $23,800 | $25,500 | $26,700 | $24,000 | $23,000 | $24,000 | $27,000 | $30,880 | $33,000 | |
Gross Margin % | 65.38% | 67.24% | 68.00% | 70.00% | 70.83% | 70.26% | 70.59% | 69.70% | 68.57% | 69.23% | 71.81% | 71.74% | |
Expenses | |||||||||||||
Payroll | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | |
Sales and Marketing and Other Expenses | $1,000 | $1,000 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Depreciation | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Insurance | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Rent | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | |
Payroll Taxes | 15% | $2,490 | $2,490 | $2,490 | $2,490 | $2,490 | $2,490 | $2,490 | $2,490 | $2,490 | $2,490 | $2,490 | $2,490 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $22,910 | $22,910 | $22,410 | $22,410 | $22,410 | $22,410 | $22,410 | $22,410 | $22,410 | $22,410 | $22,410 | $22,410 | |
Profit Before Interest and Taxes | ($5,910) | ($3,410) | ($2,010) | $1,390 | $3,090 | $4,290 | $1,590 | $590 | $1,590 | $4,590 | $8,470 | $10,590 | |
EBITDA | ($5,790) | ($3,290) | ($1,890) | $1,510 | $3,210 | $4,410 | $1,710 | $710 | $1,710 | $4,710 | $8,590 | $10,710 | |
Interest Expense | $410 | $403 | $396 | $389 | $382 | $375 | $368 | $361 | $354 | $347 | $340 | $333 | |
Taxes Incurred | ($1,896) | ($1,144) | ($722) | $300 | $812 | $1,174 | $367 | $69 | $371 | $1,273 | $2,439 | $3,077 | |
Net Profit | ($4,424) | ($2,669) | ($1,684) | $701 | $1,896 | $2,740 | $855 | $160 | $865 | $2,970 | $5,691 | $7,180 | |
Net Profit/Sales | -17.01% | -9.20% | -5.61% | 2.06% | 5.27% | 7.21% | 2.52% | 0.49% | 2.47% | 7.62% | 13.23% | 15.61% |
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 | $6,500 | $7,250 | $7,500 | $8,500 | $9,000 | $9,500 | $8,500 | $8,250 | $8,750 | $9,750 | $10,750 | $11,500 | |
Cash from Receivables | $0 | $650 | $19,575 | $21,775 | $22,600 | $25,550 | $27,050 | $28,400 | $25,475 | $24,800 | $26,350 | $29,350 | |
Subtotal Cash from Operations | $6,500 | $7,900 | $27,075 | $30,275 | $31,600 | $35,050 | $35,550 | $36,650 | $34,225 | $34,550 | $37,100 | $40,850 | |
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 | $4,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $6,500 | $7,900 | $27,075 | $30,275 | $35,600 | $35,050 | $35,550 | $36,650 | $34,225 | $34,550 | $37,100 | $40,850 | |
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 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | $16,600 | |
Bill Payments | $457 | $13,745 | $14,949 | $15,018 | $16,606 | $17,423 | $18,469 | $16,414 | $16,163 | $17,478 | $19,353 | $20,640 | |
Subtotal Spent on Operations | $17,057 | $30,345 | $31,549 | $31,618 | $33,206 | $34,023 | $35,069 | $33,014 | $32,763 | $34,078 | $35,953 | $37,240 | |
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 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | |
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 | $17,890 | $31,178 | $32,382 | $32,451 | $34,039 | $34,856 | $35,902 | $33,847 | $33,596 | $34,911 | $36,786 | $38,073 | |
Net Cash Flow | ($11,390) | ($23,278) | ($5,307) | ($2,176) | $1,561 | $194 | ($352) | $2,803 | $629 | ($361) | $314 | $2,777 | |
Cash Balance | $30,810 | $7,532 | $2,224 | $49 | $1,609 | $1,804 | $1,452 | $4,254 | $4,883 | $4,522 | $4,836 | $7,614 |
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 | $42,200 | $30,810 | $7,532 | $2,224 | $49 | $1,609 | $1,804 | $1,452 | $4,254 | $4,883 | $4,522 | $4,836 | $7,614 |
Accounts Receivable | $0 | $19,500 | $40,600 | $43,525 | $47,250 | $51,650 | $54,600 | $53,050 | $49,400 | $50,175 | $54,625 | $60,525 | $65,675 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $42,200 | $50,310 | $48,132 | $45,749 | $47,299 | $53,259 | $56,404 | $54,502 | $53,654 | $55,058 | $59,147 | $65,361 | $73,289 |
Long-term Assets | |||||||||||||
Long-term Assets | $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 |
Accumulated Depreciation | $0 | $120 | $240 | $360 | $480 | $600 | $720 | $840 | $960 | $1,080 | $1,200 | $1,320 | $1,440 |
Total Long-term Assets | $10,000 | $9,880 | $9,760 | $9,640 | $9,520 | $9,400 | $9,280 | $9,160 | $9,040 | $8,920 | $8,800 | $8,680 | $8,560 |
Total Assets | $52,200 | $60,190 | $57,892 | $55,389 | $56,819 | $62,659 | $65,684 | $63,662 | $62,694 | $63,978 | $67,947 | $74,041 | $81,849 |
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 | $13,247 | $14,451 | $14,465 | $16,027 | $16,805 | $17,922 | $15,877 | $15,582 | $16,834 | $18,666 | $19,903 | $21,364 |
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 | $13,247 | $14,451 | $14,465 | $16,027 | $16,805 | $17,922 | $15,877 | $15,582 | $16,834 | $18,666 | $19,903 | $21,364 |
Long-term Liabilities | $50,000 | $49,167 | $48,334 | $47,501 | $46,668 | $45,835 | $45,002 | $44,169 | $43,336 | $42,503 | $41,670 | $40,837 | $40,004 |
Total Liabilities | $50,000 | $62,414 | $62,785 | $61,966 | $62,695 | $62,640 | $62,924 | $60,046 | $58,918 | $59,337 | $60,336 | $60,740 | $61,368 |
Paid-in Capital | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $84,000 | $84,000 | $84,000 | $84,000 | $84,000 | $84,000 | $84,000 | $84,000 |
Retained Earnings | ($77,800) | ($77,800) | ($77,800) | ($77,800) | ($77,800) | ($77,800) | ($77,800) | ($77,800) | ($77,800) | ($77,800) | ($77,800) | ($77,800) | ($77,800) |
Earnings | $0 | ($4,424) | ($7,093) | ($8,777) | ($8,076) | ($6,180) | ($3,440) | ($2,585) | ($2,424) | ($1,559) | $1,411 | $7,101 | $14,281 |
Total Capital | $2,200 | ($2,224) | ($4,893) | ($6,577) | ($5,876) | $20 | $2,760 | $3,615 | $3,776 | $4,641 | $7,611 | $13,301 | $20,481 |
Total Liabilities and Capital | $52,200 | $60,190 | $57,892 | $55,389 | $56,819 | $62,659 | $65,684 | $63,662 | $62,694 | $63,978 | $67,947 | $74,041 | $81,849 |
Net Worth | $2,200 | ($2,224) | ($4,893) | ($6,577) | ($5,876) | $20 | $2,760 | $3,615 | $3,776 | $4,641 | $7,611 | $13,301 | $20,481 |