Allensburg's Food and Gas
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 | |||||||||||||
Gasoline | 0% | $40,000 | $40,000 | $48,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 |
Food, Drinks, and Produce | 0% | $10,000 | $12,000 | $14,000 | $15,000 | $16,000 | $16,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 |
Total Sales | $50,000 | $52,000 | $62,000 | $70,000 | $71,000 | $71,000 | $72,000 | $72,000 | $72,000 | $72,000 | $72,000 | $72,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 | |
Gasoline | $35,000 | $35,000 | $42,000 | $48,000 | $48,000 | $48,000 | $48,000 | $48,000 | $48,000 | $48,000 | $48,000 | $48,000 | |
Food, Drinks, and Produce | $2,000 | $2,500 | $2,900 | $3,000 | $3,200 | $3,200 | $3,400 | $3,400 | $3,400 | $3,400 | $3,400 | $3,400 | |
Subtotal Direct Cost of Sales | $37,000 | $37,500 | $44,900 | $51,000 | $51,200 | $51,200 | $51,400 | $51,400 | $51,400 | $51,400 | $51,400 | $51,400 |
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 | ||
Robert Cole | 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 |
Store/Deli Staff | 0% | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Gas Attendants | 0% | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
Total Payroll | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 |
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 | $50,000 | $52,000 | $62,000 | $70,000 | $71,000 | $71,000 | $72,000 | $72,000 | $72,000 | $72,000 | $72,000 | $72,000 | |
Direct Cost of Sales | $37,000 | $37,500 | $44,900 | $51,000 | $51,200 | $51,200 | $51,400 | $51,400 | $51,400 | $51,400 | $51,400 | $51,400 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $37,000 | $37,500 | $44,900 | $51,000 | $51,200 | $51,200 | $51,400 | $51,400 | $51,400 | $51,400 | $51,400 | $51,400 | |
Gross Margin | $13,000 | $14,500 | $17,100 | $19,000 | $19,800 | $19,800 | $20,600 | $20,600 | $20,600 | $20,600 | $20,600 | $20,600 | |
Gross Margin % | 26.00% | 27.88% | 27.58% | 27.14% | 27.89% | 27.89% | 28.61% | 28.61% | 28.61% | 28.61% | 28.61% | 28.61% | |
Expenses | |||||||||||||
Payroll | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $952 | $952 | $952 | $952 | $952 | $952 | $952 | $952 | $952 | $952 | $952 | $952 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Insurance | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Rent | $0 | $0 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | |
Payroll Taxes | 15% | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $12,822 | $12,822 | $14,122 | $14,122 | $14,122 | $14,122 | $14,122 | $14,122 | $14,122 | $14,122 | $14,122 | $14,122 | |
Profit Before Interest and Taxes | $178 | $1,678 | $2,978 | $4,878 | $5,678 | $5,678 | $6,478 | $6,478 | $6,478 | $6,478 | $6,478 | $6,478 | |
EBITDA | $1,130 | $2,630 | $3,930 | $5,830 | $6,630 | $6,630 | $7,430 | $7,430 | $7,430 | $7,430 | $7,430 | $7,430 | |
Interest Expense | $1,229 | $1,208 | $1,188 | $1,167 | $1,146 | $1,125 | $1,104 | $1,083 | $1,063 | $1,042 | $1,021 | $1,000 | |
Taxes Incurred | ($315) | $141 | $537 | $1,113 | $1,360 | $1,366 | $1,612 | $1,618 | $1,625 | $1,631 | $1,637 | $1,643 | |
Net Profit | ($736) | $329 | $1,253 | $2,598 | $3,173 | $3,187 | $3,762 | $3,776 | $3,791 | $3,805 | $3,820 | $3,835 | |
Net Profit/Sales | -1.47% | 0.63% | 2.02% | 3.71% | 4.47% | 4.49% | 5.22% | 5.24% | 5.27% | 5.29% | 5.31% | 5.33% |
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 | $50,000 | $52,000 | $62,000 | $70,000 | $71,000 | $71,000 | $72,000 | $72,000 | $72,000 | $72,000 | $72,000 | $72,000 | |
Subtotal Cash from Operations | $50,000 | $52,000 | $62,000 | $70,000 | $71,000 | $71,000 | $72,000 | $72,000 | $72,000 | $72,000 | $72,000 | $72,000 | |
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 | $50,000 | $52,000 | $62,000 | $70,000 | $71,000 | $71,000 | $72,000 | $72,000 | $72,000 | $72,000 | $72,000 | $72,000 | |
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 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | |
Bill Payments | $2,356 | $69,710 | $42,025 | $58,309 | $63,158 | $57,288 | $57,082 | $57,698 | $57,471 | $57,457 | $57,442 | $57,427 | |
Subtotal Spent on Operations | $12,156 | $79,510 | $51,825 | $68,109 | $72,958 | $67,088 | $66,882 | $67,498 | $67,271 | $67,257 | $67,242 | $67,227 | |
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 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
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 | $14,656 | $82,010 | $54,325 | $70,609 | $75,458 | $69,588 | $69,382 | $69,998 | $69,771 | $69,757 | $69,742 | $69,727 | |
Net Cash Flow | $35,344 | ($30,010) | $7,675 | ($609) | ($4,458) | $1,412 | $2,618 | $2,002 | $2,229 | $2,243 | $2,258 | $2,273 | |
Cash Balance | $53,844 | $23,834 | $31,509 | $30,900 | $26,442 | $27,855 | $30,472 | $32,474 | $34,703 | $36,946 | $39,204 | $41,476 |
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 | $18,500 | $53,844 | $23,834 | $31,509 | $30,900 | $26,442 | $27,855 | $30,472 | $32,474 | $34,703 | $36,946 | $39,204 | $41,476 |
Inventory | $10,000 | $40,700 | $41,250 | $49,390 | $56,100 | $56,320 | $56,320 | $56,540 | $56,540 | $56,540 | $56,540 | $56,540 | $56,540 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $28,500 | $94,544 | $65,084 | $80,899 | $87,000 | $82,762 | $84,175 | $87,012 | $89,014 | $91,243 | $93,486 | $95,744 | $98,016 |
Long-term Assets | |||||||||||||
Long-term Assets | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 |
Accumulated Depreciation | $0 | $952 | $1,904 | $2,856 | $3,808 | $4,760 | $5,712 | $6,664 | $7,616 | $8,568 | $9,520 | $10,472 | $11,424 |
Total Long-term Assets | $80,000 | $79,048 | $78,096 | $77,144 | $76,192 | $75,240 | $74,288 | $73,336 | $72,384 | $71,432 | $70,480 | $69,528 | $68,576 |
Total Assets | $108,500 | $173,592 | $143,180 | $158,043 | $163,192 | $158,002 | $158,463 | $160,348 | $161,398 | $162,675 | $163,966 | $165,272 | $166,592 |
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 | $68,328 | $40,087 | $56,197 | $61,248 | $55,386 | $55,159 | $55,783 | $55,556 | $55,542 | $55,528 | $55,514 | $55,500 |
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 | $68,328 | $40,087 | $56,197 | $61,248 | $55,386 | $55,159 | $55,783 | $55,556 | $55,542 | $55,528 | $55,514 | $55,500 |
Long-term Liabilities | $150,000 | $147,500 | $145,000 | $142,500 | $140,000 | $137,500 | $135,000 | $132,500 | $130,000 | $127,500 | $125,000 | $122,500 | $120,000 |
Total Liabilities | $150,000 | $215,828 | $185,087 | $198,697 | $201,248 | $192,886 | $190,159 | $188,283 | $185,556 | $183,042 | $180,528 | $178,014 | $175,500 |
Paid-in Capital | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 |
Retained Earnings | ($101,500) | ($101,500) | ($101,500) | ($101,500) | ($101,500) | ($101,500) | ($101,500) | ($101,500) | ($101,500) | ($101,500) | ($101,500) | ($101,500) | ($101,500) |
Earnings | $0 | ($736) | ($407) | $846 | $3,444 | $6,617 | $9,804 | $13,566 | $17,342 | $21,133 | $24,938 | $28,758 | $32,593 |
Total Capital | ($41,500) | ($42,236) | ($41,907) | ($40,654) | ($38,056) | ($34,883) | ($31,696) | ($27,934) | ($24,158) | ($20,367) | ($16,562) | ($12,742) | ($8,907) |
Total Liabilities and Capital | $108,500 | $173,592 | $143,180 | $158,043 | $163,192 | $158,002 | $158,463 | $160,348 | $161,398 | $162,675 | $163,966 | $165,272 | $166,592 |
Net Worth | ($41,500) | ($42,236) | ($41,907) | ($40,654) | ($38,056) | ($34,883) | ($31,696) | ($27,934) | ($24,158) | ($20,367) | ($16,562) | ($12,742) | ($8,907) |