MillenniumMart

Start your own business plan »

Convenience Store 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
Drinks 0% $28,000 $33,040 $38,987 $46,005 $54,286 $64,057 $75,588 $89,193 $105,248 $124,193 $146,547 $172,926
Snacks 0% $25,000 $29,500 $34,810 $41,076 $48,469 $57,194 $67,489 $79,637 $93,971 $110,886 $130,846 $154,398
Magazines/newspapers 0% $6,000 $7,080 $8,354 $9,858 $11,633 $13,727 $16,197 $19,113 $22,553 $26,613 $31,403 $37,056
General grocery items 0% $8,000 $9,440 $11,139 $13,144 $15,510 $18,302 $21,596 $25,484 $30,071 $35,484 $41,871 $49,407
Other 0% $4,000 $4,720 $5,570 $6,572 $7,755 $9,151 $10,798 $12,742 $15,035 $17,742 $20,935 $24,704
Total Sales $71,000 $83,780 $98,860 $116,655 $137,653 $162,431 $191,668 $226,169 $266,879 $314,917 $371,602 $438,491
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
Drinks $21,560 $25,441 $30,020 $35,424 $41,800 $49,324 $58,202 $68,679 $81,041 $95,628 $112,841 $133,153
Snacks $19,250 $22,715 $26,804 $31,628 $37,321 $44,039 $51,966 $61,320 $72,358 $85,382 $100,751 $118,887
Magazines/newspapers $4,620 $5,452 $6,433 $7,591 $8,957 $10,569 $12,472 $14,717 $17,366 $20,492 $24,180 $28,533
General grocery items $6,160 $7,269 $8,577 $10,121 $11,943 $14,093 $16,629 $19,623 $23,155 $27,322 $32,240 $38,044
Other $3,080 $3,634 $4,289 $5,061 $5,971 $7,046 $8,315 $9,811 $11,577 $13,661 $16,120 $19,022
Subtotal Direct Cost of Sales $54,670 $64,511 $76,123 $89,825 $105,993 $125,072 $147,585 $174,150 $205,497 $242,486 $286,134 $337,638
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
Mr. Bean 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
Mrs. Tuck 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
Mr. Takeda 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
Office manager 0% $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700
Technicians 0% $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $3,000 $3,000 $4,500 $4,500 $4,500 $4,500
Total People 5 5 5 5 5 5 6 6 7 7 7 7
Total Payroll $12,700 $12,700 $12,700 $12,700 $12,700 $12,700 $14,200 $14,200 $15,700 $15,700 $15,700 $15,700
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 $71,000 $83,780 $98,860 $116,655 $137,653 $162,431 $191,668 $226,169 $266,879 $314,917 $371,602 $438,491
Direct Cost of Sales $54,670 $64,511 $76,123 $89,825 $105,993 $125,072 $147,585 $174,150 $205,497 $242,486 $286,134 $337,638
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $54,670 $64,511 $76,123 $89,825 $105,993 $125,072 $147,585 $174,150 $205,497 $242,486 $286,134 $337,638
Gross Margin $16,330 $19,269 $22,738 $26,831 $31,660 $37,359 $44,084 $52,019 $61,382 $72,431 $85,469 $100,853
Gross Margin % 23.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00%
Expenses
Payroll $12,700 $12,700 $12,700 $12,700 $12,700 $12,700 $14,200 $14,200 $15,700 $15,700 $15,700 $15,700
Sales and Marketing and Other Expenses $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Depreciation $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Leased equipment $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $6,000
Rent $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
Utilities $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400
Accounting/bookeeping $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $750 $750
Insurance $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $3,000 $4,000 $5,000 $10,000
Total Operating Expenses $35,400 $35,400 $35,400 $35,400 $35,400 $35,400 $36,900 $36,900 $39,400 $40,400 $41,650 $48,650
Profit Before Interest and Taxes ($19,070) ($16,131) ($12,662) ($8,569) ($3,740) $1,959 $7,184 $15,119 $21,982 $32,031 $43,819 $52,203
EBITDA ($18,470) ($15,531) ($12,062) ($7,969) ($3,140) $2,559 $7,784 $15,719 $22,582 $32,631 $44,419 $52,803
Interest Expense $958 $1,375 $1,375 $1,375 $1,375 $1,375 $1,375 $1,375 $1,417 $1,417 $1,417 $1,417
Taxes Incurred ($6,008) ($5,252) ($4,211) ($2,983) ($1,534) $175 $1,743 $4,123 $6,170 $9,184 $12,721 $15,236
Net Profit ($14,020) ($12,254) ($9,826) ($6,961) ($3,580) $409 $4,066 $9,621 $14,396 $21,430 $29,681 $35,550
Net Profit/Sales -19.75% -14.63% -9.94% -5.97% -2.60% 0.25% 2.12% 4.25% 5.39% 6.80% 7.99% 8.11%
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 $71,000 $83,780 $98,860 $116,655 $137,653 $162,431 $191,668 $226,169 $266,879 $314,917 $371,602 $438,491
Subtotal Cash from Operations $71,000 $83,780 $98,860 $116,655 $137,653 $162,431 $191,668 $226,169 $266,879 $314,917 $371,602 $438,491
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 $5,000 $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 $50,000 $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 $50,000 $0 $0 $0 $0 $0 $0 $4,000
Subtotal Cash Received $71,000 $133,780 $98,860 $116,655 $187,653 $162,431 $191,668 $226,169 $271,879 $314,917 $371,602 $442,491
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 $12,700 $12,700 $12,700 $12,700 $12,700 $12,700 $14,200 $14,200 $15,700 $15,700 $15,700 $15,700
Bill Payments $12,062 $120,914 $94,045 $108,734 $126,066 $146,518 $170,637 $198,680 $232,293 $272,239 $319,734 $375,955
Subtotal Spent on Operations $24,762 $133,614 $106,745 $121,434 $138,766 $159,218 $184,837 $212,880 $247,993 $287,939 $335,434 $391,655
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 $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 $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 $24,762 $133,614 $106,745 $121,434 $138,766 $159,218 $184,837 $212,880 $247,993 $287,939 $335,434 $391,655
Net Cash Flow $46,238 $166 ($7,885) ($4,779) $48,887 $3,212 $6,831 $13,289 $23,886 $26,979 $36,168 $50,835
Cash Balance $160,058 $160,225 $152,340 $147,561 $196,448 $199,661 $206,492 $219,780 $243,667 $270,645 $306,813 $357,649
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 $113,820 $160,058 $160,225 $152,340 $147,561 $196,448 $199,661 $206,492 $219,780 $243,667 $270,645 $306,813 $357,649
Inventory $10,000 $60,137 $70,962 $83,735 $98,807 $116,592 $137,579 $162,343 $191,565 $226,047 $266,735 $314,747 $371,402
Other Current Assets $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Total Current Assets $131,820 $228,195 $239,186 $244,074 $254,368 $321,040 $345,239 $376,835 $419,345 $477,713 $545,380 $629,561 $737,050
Long-term Assets
Long-term Assets $72,000 $72,000 $72,000 $72,000 $72,000 $72,000 $72,000 $72,000 $72,000 $72,000 $72,000 $72,000 $72,000
Accumulated Depreciation $0 $600 $1,200 $1,800 $2,400 $3,000 $3,600 $4,200 $4,800 $5,400 $6,000 $6,600 $7,200
Total Long-term Assets $72,000 $71,400 $70,800 $70,200 $69,600 $69,000 $68,400 $67,800 $67,200 $66,600 $66,000 $65,400 $64,800
Total Assets $203,820 $299,595 $309,986 $314,274 $323,968 $390,040 $413,639 $444,635 $486,545 $544,313 $611,380 $694,961 $801,850
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 $8,000 $117,795 $90,440 $104,554 $121,209 $140,862 $164,052 $190,981 $223,271 $261,643 $307,280 $361,179 $428,518
Current Borrowing $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $20,000 $20,000 $20,000 $20,000
Other Current Liabilities $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
Subtotal Current Liabilities $33,000 $142,795 $115,440 $129,554 $146,209 $165,862 $189,052 $215,981 $248,271 $291,643 $337,280 $391,179 $458,518
Long-term Liabilities $100,000 $100,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000
Total Liabilities $133,000 $242,795 $265,440 $279,554 $296,209 $315,862 $339,052 $365,981 $398,271 $441,643 $487,280 $541,179 $608,518
Paid-in Capital $320,000 $320,000 $320,000 $320,000 $320,000 $370,000 $370,000 $370,000 $370,000 $370,000 $370,000 $370,000 $374,000
Retained Earnings ($249,180) ($249,180) ($249,180) ($249,180) ($249,180) ($249,180) ($249,180) ($249,180) ($249,180) ($249,180) ($249,180) ($249,180) ($249,180)
Earnings $0 ($14,020) ($26,274) ($36,100) ($43,061) ($46,641) ($46,232) ($42,166) ($32,545) ($18,150) $3,280 $32,962 $68,512
Total Capital $70,820 $56,800 $44,546 $34,720 $27,759 $74,179 $74,588 $78,654 $88,275 $102,670 $124,100 $153,782 $193,332
Total Liabilities and Capital $203,820 $299,595 $309,986 $314,274 $323,968 $390,040 $413,639 $444,635 $486,545 $544,313 $611,380 $694,961 $801,850
Net Worth $70,820 $56,800 $44,546 $34,720 $27,759 $74,179 $74,588 $78,654 $88,275 $102,670 $124,100 $153,782 $193,332