Luna's Convenience Store
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 |