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 auto repair and maintenance services.
The major costs of [Company Name] include:
- Salaries
- Lease on business location
- Equipment maintenance
Moreover, ongoing marketing expenditures are also notable cost mechanics for [Company Name].
Capital Requirements and Use of Funds
[Company Name] is seeking a total funding of $350,000 of debt capital to open its auto repair business. The capital will be used for funding capital expenditures and location build-out, salaries, marketing expenses and working capital.
Specifically, these funds will be used as follows:
- Headquarters design/build: $150,000
- Working capital: $200,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 | 10 |
| Year 2 | 15 |
| Year 3 | 20 |
| Year 4 | 25 |
| Year 5 | 30 |
| Average transaction | $200 |
| Annual Lease ( per location) | 50000 |
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 |
