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
The revenues for [Company Name] will come from the fees it will charge the residents and their insurance for the health care services it provides.
The cost drivers for the company will be the payroll of the staff, lease on the building, office supplies and equipment, food, beverages, social event supplies, decorations, fitness equipment, and marketing and advertising costs.
Capital Requirements and Use of Funds
[Company Name] is seeking $250,000 in funding to launch its nursing home. The capital will be used for funding capital expenditures, construction build-out, staffing, training, marketing and advertising expenses, and working capital.
The breakout of the funding may be seen below:
- Facility design/build-out: $100,000
- Capital expenditures: $20,000
- Furniture, fixture, and equipment: $35,000
- Marketing and advertising: $10,000
- Staffing costs: $75,000
- Working capital: $10,000
Key Assumptions
The following table reflects the key revenue and cost assumptions made in the financial model:
Number of patients per month | Per location |
---|---|
Year 1 | 1200 |
Year 2 | 1300 |
Year 3 | 1450 |
Year 4 | 1550 |
Year 5 | 1750 |
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 |