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 major revenue will come from the sales of snow cones to its customers. The Company will also earn from the sale of other products like soft drinks and snacks. As the company grows and revenues are able to support it, the store will add a drive-thru window as another option for serving its customer base.
The major costs for the company will be sourcing the fresh ingredients and production of the snow cones and other products. Other cost drivers will be the salaries of the staff, company overhead, and advertising costs.
Capital Requirements and Use of Funds
[Company Name] is currently seeking $170,000 to launch its snow cone business. Specifically, these funds will be used as follows:
- Store design/build: $120,000
- Working capital: $50,000 to pay for marketing, salaries, and lease costs until [Company Name] reaches break-even
Key Assumptions
The following table reflects the key revenue and cost assumptions made in the financial model:
| Number of customers per day | Per location |
|---|---|
| FY 1 | 100 |
| FY 2 | 105 |
| FY 3 | 110 |
| FY 4 | 116 |
| FY 5 | 122 |
| Average order price | $7.00 |
| Annual increase in order price | 5.00% |
| Annual Lease ( per location) | $60,000 |
| Yearly Lease Increase % | 2.50% |
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 |
