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) |