The template will take your unique inputs and assumptions to automatically calculate and build your Income Statement (Profit & Loss), Balance Sheet, and Cash Flow statement. Any change you make on the input tabs will automatically be calculated and updated on your financial statements making for easy changes and experimentation. The financial statements are easily exported or printed for lenders.

Financial Statements Included:

• 5 Year Income Statement Annual Summary
• 5 Year Income Statement Monthly Breakdown
• 5 year Cash Flow Statement Annual Summary
• 5 year Cash Flow Statement Monthly Breakdown
• 5 Year Projected Balance Sheet Annual Summary
• 5 Year Projected Balance Sheet Monthly Breakdown

The At-A-Glance tab serves up a comprehensive financial snapshot. Visualize your data with key financial ratios, startup cost estimations, and break-even points. Infographics, charts, and summaries will enhance your presentations, making them compelling for stakeholders, lenders, or investors.

Tables, charts, graphs and dashboards include:

• Profit and loss summary
• Home care startup cost graph
• Key industry financial ratios ​​
• Cash flow from operations graph
• 5 years of monthly and annual profit and loss, cash flow and balance sheet forecasts

The tailored revenue tab is designed specifically for home healthcare businesses. Estimate patient acquisition, list of services provided, what percent of patients require each service, the hourly rate per service provider, and how many hours per week on average they will be providing service. Tweak factors such as the services offered, providers available, price, and cost of each service to generate your five-year revenue projections. These forecasted numbers are then integrated directly into your financial statements.

Expenses:

• Begin with a prefilled list of common home healthcare costs.
• Easily adjust for specific expenses such as monthly overheads, equipment purchases, and promotional efforts.
• For startups, initial months are separated to account for non recurring startup expenses.

Staffing:

• Budget for your direct labor providers, based on their hourly rates and costs.
• Also plan for any salaried positions including admin or executives.
• Include essential details like salaries, taxes, and benefits.

The general assumptions page will enable you to provide balance sheet items such as fixed assets, loans, investments, and accounts receivable assumptions. The model automatically calculate the difficult things for you like loan amortization, interest expense, depreciation expense, inventory purchases, etc and all you have to do is provide the basic info to get started.