Allensburg's Food and Gas

Start your own business plan »

Convenience Store Gas Station Business Plan

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)