IX. Financial Plan
This Section's Contents
You can download our Business Plan Template (including a full, customizable financial model) to your computer here.
Revenue and Cost Drivers
[Company Name]’s revenues will come primarily from the grocery items sold.
As with most businesses, cost of goods sold and labor expenses are the key cost drivers for grocery stores. Employees are paid through a combination of salaries and bonuses, rewarding them for performance and making them an active part in business retention and development.
The major cost drivers for the company’s operation will consist of:
- Cost of goods sold
- Salaries
- Lease
Ongoing marketing expenditures are also notable cost drivers for [Company Name].
Capital Requirements and Use of Funds
[Company Name] is seeking total funding of $260,000 of debt capital to launch its grocery store. The capital will be used for funding capital expenditures and location build-out, hiring initial employees, marketing expenses and working capital.
Specifically, these funds will be used as follows:
- Store design/build: $140,000
- Working capital: $120,000 to pay for marketing, salaries, and lease costs until [Company Name] is cash-flow positive
Key Assumptions
The following table reflects the key revenue and cost assumptions made in the financial model.
Number of customers per day | |
---|---|
FY 1 | 75 |
FY 2 | 100 |
FY 3 | 125 |
FY 4 | 150 |
FY 5 | 175 |
Annual Lease ( per location) | $50,000 |
5 Year Annual Income Statement
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
---|---|---|---|---|---|---|
Revenues | ||||||
Product/Service A | $151,200 | $333,396 | $367,569 | $405,245 | $446,783 | |
Product/Service B | $100,800 | $222,264 | $245,046 | $270,163 | $297,855 | |
Total Revenues | $252,000 | $555,660 | $612,615 | $675,408 | $744,638 | |
Expenses & Costs | ||||||
Cost of goods sold | $57,960 | $122,245 | $122,523 | $128,328 | $134,035 | |
Lease | $60,000 | $61,500 | $63,038 | $64,613 | $66,229 | |
Marketing | $20,000 | $25,000 | $25,000 | $25,000 | $25,000 | |
Salaries | $133,890 | $204,030 | $224,943 | $236,190 | $248,000 | |
Other Expenses | $3,500 | $4,000 | $4,500 | $5,000 | $5,500 | |
Total Expenses & Costs | $271,850 | $412,775 | $435,504 | $454,131 | $473,263 | |
EBITDA | ($19,850) | $142,885 | $177,112 | $221,277 | $271,374 | |
Depreciation | $36,960 | $36,960 | $36,960 | $36,960 | $36,960 | |
EBIT | ($56,810) | $105,925 | $140,152 | $184,317 | $234,414 | |
Interest | $23,621 | $20,668 | $17,716 | $14,763 | $11,810 | |
PRETAX INCOME | ($80,431) | $85,257 | $122,436 | $169,554 | $222,604 | |
Net Operating Loss | ($80,431) | ($80,431) | $0 | $0 | $0 | |
Income Tax Expense | $0 | $1,689 | $42,853 | $59,344 | $77,911 | |
NET INCOME | ($80,431) | $83,568 | $79,583 | $110,210 | $144,693 | |
Net Profit Margin (%) | - | 15.00% | 13.00% | 16.30% | 19.40% |
5 Year Annual Balance Sheet
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
---|---|---|---|---|---|---|
ASSETS | ||||||
Cash | $16,710 | $90,188 | $158,957 | $258,570 | $392,389 | |
Accounts receivable | $0 | $0 | $0 | $0 | $0 | |
Inventory | $21,000 | $23,153 | $25,526 | $28,142 | $31,027 | |
Total Current Assets | $37,710 | $113,340 | $184,482 | $286,712 | $423,416 | |
Fixed assets | $246,450 | $246,450 | $246,450 | $246,450 | $246,450 | |
Depreciation | $36,960 | $73,920 | $110,880 | $147,840 | $184,800 | |
Net fixed assets | $209,490 | $172,530 | $135,570 | $98,610 | $61,650 | |
TOTAL ASSETS | $247,200 | $285,870 | $320,052 | $385,322 | $485,066 | |
LIABILITIES & EQUITY | ||||||
Debt | $317,971 | $272,546 | $227,122 | $181,698 | $136,273 | |
Accounts payable | $9,660 | $10,187 | $10,210 | $10,694 | $11,170 | |
Total Liabilities | $327,631 | $282,733 | $237,332 | $192,391 | $147,443 | |
Share Capital | $0 | $0 | $0 | $0 | $0 | |
Retained earnings | ($80,431) | $3,137 | $82,720 | $192,930 | $337,623 | |
Total Equity | ($80,431) | $3,137 | $82,720 | $192,930 | $337,623 | |
TOTAL LIABILITIES & EQUITY | $247,200 | $285,870 | $320,052 | $385,322 | $485,066 |
5 Year Annual Cash Flow Statement
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
---|---|---|---|---|---|
CASH FLOW FROM OPERATIONS | |||||
Net Income (Loss) | ($80,431) | $83,568 | $79,583 | $110,210 | $144,693 |
Change in working capital | ($11,340) | ($1,625) | ($2,350) | ($2,133) | ($2,409) |
Depreciation | $36,960 | $36,960 | $36,960 | $36,960 | $36,960 |
Net Cash Flow from Operations | ($54,811) | $118,902 | $114,193 | $145,037 | $179,244 |
CASH FLOW FROM INVESTMENTS | |||||
Investment | ($246,450) | $0 | $0 | $0 | $0 |
Net Cash Flow from Investments | ($246,450) | $0 | $0 | $0 | $0 |
CASH FLOW FROM FINANCING | |||||
Cash from equity | $0 | $0 | $0 | $0 | $0 |
Cash from debt | $317,971 | ($45,424) | ($45,424) | ($45,424) | ($45,424) |
Net Cash Flow from Financing | $317,971 | ($45,424) | ($45,424) | ($45,424) | ($45,424) |
SUMMARY | |||||
Net Cash Flow | $16,710 | $73,478 | $68,769 | $99,613 | $133,819 |
Cash at Beginning of Period | $0 | $16,710 | $90,188 | $158,957 | $258,570 |
Cash at End of Period | $16,710 | $90,188 | $158,957 | $258,570 | $392,389 |