Luna's Convenience Store

Start your own business plan »

Convenience Store Cafe 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
Fresh Foods, Dairy and Drinks 0% $2,750 $3,524 $3,978 $4,206 $4,718 $5,227 $4,693 $4,011 $3,829 $3,640 $3,685 $3,848
Packaged Foods 0% $5,789 $8,438 $9,177 $9,508 $10,378 $10,653 $10,332 $9,369 $9,351 $9,020 $8,448 $8,430
Hard Goods 0% $2,700 $2,819 $2,946 $3,802 $4,077 $3,786 $3,551 $3,730 $3,921 $3,125 $4,344 $4,578
Beer, Wine and Cigarettes 0% $8,750 $9,088 $9,442 $13,450 $14,288 $13,216 $11,046 $11,498 $11,973 $12,471 $12,995 $12,545
Rental Income 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Prepackaged Meals 0% $942 $1,071 $1,188 $1,821 $2,282 $2,184 $1,784 $1,824 $1,832 $1,856 $2,192 $2,264
Total Sales $21,931 $25,940 $27,731 $33,786 $36,742 $36,066 $32,406 $31,432 $31,906 $31,112 $32,664 $32,665
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
Fresh Foods $1,375 $1,762 $1,989 $2,103 $2,359 $2,614 $2,346 $2,006 $1,914 $1,820 $1,842 $1,924
Packaged Foods $659 $749 $831 $1,275 $1,597 $1,529 $1,249 $1,277 $1,282 $1,299 $1,534 $1,585
Hard Goods $10,965 $12,970 $13,866 $16,893 $18,371 $18,033 $16,203 $15,716 $15,953 $15,556 $16,332 $16,333
Drinks (inc. beer and wine) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Prepackaged Meals $413 $529 $597 $631 $708 $784 $704 $602 $574 $546 $553 $577
Subtotal Direct Cost of Sales $13,412 $16,010 $17,283 $20,902 $23,035 $22,959 $20,502 $19,600 $19,724 $19,221 $20,261 $20,419
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
Heidi Renner 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Thomas Renner 0% $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Cashiers 0% $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,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 $21,931 $25,940 $27,731 $33,786 $36,742 $36,066 $32,406 $31,432 $31,906 $31,112 $32,664 $32,665
Direct Cost of Sales $13,412 $16,010 $17,283 $20,902 $23,035 $22,959 $20,502 $19,600 $19,724 $19,221 $20,261 $20,419
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $13,412 $16,010 $17,283 $20,902 $23,035 $22,959 $20,502 $19,600 $19,724 $19,221 $20,261 $20,419
Gross Margin $8,519 $9,930 $10,448 $12,885 $13,707 $13,106 $11,904 $11,832 $12,182 $11,891 $12,402 $12,247
Gross Margin % 38.84% 38.28% 37.68% 38.14% 37.31% 36.34% 36.73% 37.64% 38.18% 38.22% 37.97% 37.49%
Expenses
Payroll $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600
Sales and Marketing and Other Expenses $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Rent $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Utilities $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Insurance $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Payroll Taxes 10% $760 $760 $760 $760 $760 $760 $760 $760 $760 $760 $760 $760
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $12,710 $12,710 $12,710 $12,710 $12,710 $12,710 $12,710 $12,710 $12,710 $12,710 $12,710 $12,710
Profit Before Interest and Taxes ($4,191) ($2,780) ($2,262) $175 $997 $396 ($806) ($878) ($528) ($819) ($308) ($464)
EBITDA ($3,691) ($2,280) ($1,762) $675 $1,497 $896 ($306) ($378) ($28) ($319) $192 $37
Interest Expense $414 $412 $409 $407 $404 $402 $399 $397 $394 $392 $389 $387
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($4,606) ($3,192) ($2,671) ($232) $593 ($5) ($1,205) ($1,275) ($922) ($1,211) ($697) ($850)
Net Profit/Sales -21.00% -12.31% -9.63% -0.69% 1.61% -0.01% -3.72% -4.06% -2.89% -3.89% -2.13% -2.60%
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 $21,931 $25,940 $27,731 $33,786 $36,742 $36,066 $32,406 $31,432 $31,906 $31,112 $32,664 $32,665
Subtotal Cash from Operations $21,931 $25,940 $27,731 $33,786 $36,742 $36,066 $32,406 $31,432 $31,906 $31,112 $32,664 $32,665
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 $21,931 $25,940 $27,731 $33,786 $36,742 $36,066 $32,406 $31,432 $31,906 $31,112 $32,664 $32,665
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 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600
Bill Payments $167 $5,024 $5,022 $5,019 $5,549 $21,223 $27,719 $22,835 $23,656 $24,825 $23,761 $26,378
Subtotal Spent on Operations $7,767 $12,624 $12,622 $12,619 $13,149 $28,823 $35,319 $30,435 $31,256 $32,425 $31,361 $33,978
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 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
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 $30,000 $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 $38,067 $12,924 $12,922 $12,919 $13,449 $29,123 $35,619 $30,735 $31,556 $32,725 $31,661 $34,278
Net Cash Flow ($16,137) $13,016 $14,810 $20,867 $23,293 $6,943 ($3,213) $697 $349 ($1,613) $1,003 ($1,613)
Cash Balance $41,963 $54,979 $69,788 $90,656 $113,949 $120,891 $117,678 $118,375 $118,724 $117,112 $118,115 $116,502
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 $58,100 $41,963 $54,979 $69,788 $90,656 $113,949 $120,891 $117,678 $118,375 $118,724 $117,112 $118,115 $116,502
Inventory $100,000 $86,588 $70,578 $53,295 $32,393 $25,338 $25,255 $22,552 $21,560 $21,696 $21,143 $22,288 $22,460
Other Current Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Total Current Assets $163,100 $133,551 $130,557 $128,083 $128,049 $144,287 $151,146 $145,230 $144,935 $145,421 $143,255 $145,402 $143,962
Long-term Assets
Long-term Assets $30,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
Accumulated Depreciation $0 $500 $1,000 $1,500 $2,000 $2,500 $3,000 $3,500 $4,000 $4,500 $5,000 $5,500 $6,000
Total Long-term Assets $30,000 $59,500 $59,000 $58,500 $58,000 $57,500 $57,000 $56,500 $56,000 $55,500 $55,000 $54,500 $54,000
Total Assets $193,100 $193,051 $189,557 $186,583 $186,049 $201,787 $208,146 $201,730 $200,935 $200,921 $198,255 $199,902 $197,962
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 $4,857 $4,854 $4,852 $4,849 $20,294 $26,959 $22,048 $22,828 $24,036 $22,881 $25,525 $24,735
Current Borrowing $50,000 $49,700 $49,400 $49,100 $48,800 $48,500 $48,200 $47,900 $47,600 $47,300 $47,000 $46,700 $46,400
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $50,000 $54,557 $54,254 $53,952 $53,649 $68,794 $75,159 $69,948 $70,428 $71,336 $69,881 $72,225 $71,135
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $50,000 $54,557 $54,254 $53,952 $53,649 $68,794 $75,159 $69,948 $70,428 $71,336 $69,881 $72,225 $71,135
Paid-in Capital $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000
Retained Earnings ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900) ($6,900)
Earnings $0 ($4,606) ($7,797) ($10,468) ($10,700) ($10,107) ($10,112) ($11,318) ($12,592) ($13,515) ($14,726) ($15,422) ($16,273)
Total Capital $143,100 $138,494 $135,303 $132,632 $132,400 $132,993 $132,988 $131,782 $130,508 $129,585 $128,374 $127,678 $126,827
Total Liabilities and Capital $193,100 $193,051 $189,557 $186,583 $186,049 $201,787 $208,146 $201,730 $200,935 $200,921 $198,255 $199,902 $197,962
Net Worth $143,100 $138,494 $135,303 $132,632 $132,400 $132,993 $132,988 $131,782 $130,508 $129,585 $128,374 $127,678 $126,827