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 its ice skating session sales, followed by lesson/class membership sales, and concession/merchandise sales.
The facility maintenance, equipment, supplies, and labor expenses will be the key cost drivers of [Company Name]. The major cost drivers for the company’s operation will consist of:
- Salaries
- Ice rink maintenance, supplies, and equipment
- Business Insurance
- Lease or mortgage on business location and utilities
- Taxes
Capital Requirements and Use of Funds
[Company Name] is seeking a total funding of $200,000 of debt capital to open its skating rink. The capital will be used for funding capital expenditures and facility build-out, hiring initial employees, marketing and branding expenses, and working capital.
Specifically, these funds will be used as follows:
- Facility design/build-out: $100,000
- Equipment and supplies: $75,000
- Working capital: $25,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 |
---|---|
Year 1 | 50 |
Year 2 | 75 |
Year 3 | 125 |
Year 4 | 175 |
Year 5 | 250 |
Annual Rent | $90,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 |