Create a Free Home Health Care Invoice Template for Enterprises

Free home health care invoice template for enterprises

in home healthcare Excel financial model template presented by o business consultant is an financial model which will help you forecast up to 16 month operating budget and cash flows with relevant set of assumptions first we have the input sheet all these or cells are those sales which can be changed or updated as per the requirement of your business and all other sales and calculation will be updated automatically if I'm changing this from 60 to 40 you can see the change in the monthly installment then you have the revenue assumptions we have divided the segment into the four segments General checkup Physical Therapy skilled nursing and Specialized Care you have to put some inputs here for all of these segments then you have the client's assumptions moving on to the cugs Assumption then you have payroll assumptions in which we have the in which you can input the employe position like the department from uh from the dropdown and you have the some annual salary and other otherwise it will be calculated then we have a capital expenditure in which you will list down all the fixed assets that you have and when did you purchase it and what is going to be their asset life then we have the operating expenses the day-to-day expenses then we have this Revenue sheet it is a detailed sheet where you will know that how you earning Revenue we are showing revenue from each segment so you can judge the profitability of each segment we have started with the initial visits and then we have converted those into a journal checkups that how many checkups are going to be there the physical therapy skill nursing and all those things at the end we have some cogs we have startup summary it is a one year snapshot where you will know that what is going to be a total funding in the first year and the total expenses and whether you need more money or not then we have the financial statement the first statement is statement of profit and loss also called income statement here we will start with total revenue and cosos from the revenue analysis sheet and we will get net income at the end which will tell you the profitability of your company then we have cash flow statement it shows inflows and outflows from different activities including operating activity investing activity financing activity at the end you will get the net cash here then we have the statement of financial position which shows the value of your assets your liabilities and your Equity at a specific point of time so you can judge the position or you can judge the liquidity solvency and other important aspects of your business then you have the financial analysis is starting with break even analysis this is a point where your Revenue equals to your cost then we have the company valuation which judges the companies or the business's worth and whether it is profitable to invest or not we have IR and npv if IR is greater than the cost of equity and uh npv is greater than the nvb is positive it means it is a worthwh then we have the sensitivity analysis in which we are changing the number of visit to see the changes in other elements see if I'm changing this from minus 20 you can see the change in the number of visits here then we have the kpis and the ratios here we have the different ratios like profitability liquidity and solvency and efficiency ratios at the end we have the dashboard which is a graphical snapshot so you can know where your business is leading so this is all about this template thank you for watching