• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Send to a friend

• linkedin
• twitter
• facebook
• code

Originally published: 18/05/2018 14:12
Last version published: 03/03/2019 11:58
Publication number: ELQ-19680-2
View all versions & Certificate

Startup Home Health Care Financial Projections

Detailed financial model for your startup home health care project and projections

by Mahender K. Punhani
Freelance Financial Analyst experienced in Excel Financial Modelling , Equity Research, Investment Banking and Start-ups.Follow 67

16 reviews758 views|6 comments|Bookmark download for free

revenuesfinancial projectionsfinancial statementcapexgross profitdepreciationhome health carestartup financehealth care financestartup financial projections

Description
This is a very detailed and in depth financial model for modelling the financial performance and projections of your home health care projects.

The model is made up of 10 functional tabs, allowing you to conduct a thorough analysis of your finances. These tabs are:

- Summary
- Cover
- Manpower
- Revenues
- Input
- Costs
- Capex & Depreciation
- Financial Statements
- Working Capital
- Loan Calculation

The summary tab provides two charts which will visualise your key financials. These charts represent your revenues, net income and operating cash flows as well as your cash balance and net worth. This tab is a great way of quickly visualising your financial performance.

The manpower tab will allow you to keep track of your manpower count and the compensation. This will allow you the space to log all of your staff and potential expenditure on these staff. The revenues tab will allow you to track and monitor your revenues for the project based on different types of patients on a yearly basis.
The costs tab will allow you to map all of the costs for your project based on: general & administrative expenses, vehicle running and maintenance as well as cost of material and medicines. You will also be able to monitor the depreciation of your assets and capital expenditure in the capex & depreciation tab.


You will also be able to construct a detailed financial statement in the financial statements tab, to monitor the following:

- Sales Revenues
- Gross Profit
- EBITDA
- EBIT
- Cash Flows
- Balance Sheet

Ultimately, this Excel spreadsheet offers the perfect template to model the finances of your startup home health care projects.

This Best Practice includes
1 Excel Spreadsheet

Mahender K. Punhani offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

• • 
    4.3 / 5 (16 votes)

    • 69%
    • 13%
    • 6%
    • 6%
    • 6%
  • Rate this Downloadable Tool
    

    Write a review

• Nikolaus Permana Tri Rahmanto(last updated: 14/02/2020 04:20)
  
• Mohammed Halaseh(last updated: 10/01/2020 20:29)
  
• Thuy Trang Tran(last updated: 23/12/2019 08:45)
  
• Dalbir Bains(last updated: 12/11/2019 19:44)
  
• Monica Lumban Gaol(last updated: 17/10/2019 07:18)
  
• Tonny Setiadi(last updated: 04/10/2019 03:21)
  
• Ganis(last updated: 31/08/2019 19:49)
  
• Ramiro Salgado(last updated: 29/08/2019 12:23)
  
• Charles.HA. Chen(last updated: 29/08/2019 08:12)
  
• Ricardo Mantovani Assis(last updated: 26/07/2019 11:52)
  

  Excellent model

  Excellent model
• Aek Ninchuawong(last updated: 19/07/2019 16:02)
  
• Sanjay Rathi(last updated: 28/05/2019 12:47)
  
• Hanz Hargianto(last updated: 28/05/2019 04:54)
  
• Saeed Hosseini(last updated: 10/04/2019 19:41)
  
• pamela barnes(last updated: 23/03/2019 05:20)
  
• George Frank(last updated: 14/03/2019 18:22)
  

keyboard_arrow_downShow all

People using this Best Practice also downloaded

Post Comment

• 

  AlexHF 1 year ago
  Eloquens Member

  Hello Mahender,
  I am looking to build out a template for an operational home health agency. We are few years old. Want something fairly specific and robust. Can you assist. Thank you.

  arrow_drop_uparrow_drop_downReply reply

  • 

    Mahender K. Punhani 1 year ago
    Downloadable Tool Authorstar

    Hi Alex, Thanks for your message. Yes, I create financial models as per client requirements and can create a template for your home health agency. I have quite a lot of experiencce in financial modelling for healthcare sector and I the model that I will develop will be quite specific and robust. I look forward to further details from you. Thanks! Mahender

    arrow_drop_uparrow_drop_downReply reply

    • 

      AlexHF 1 year ago
      Eloquens Member

      Yes I would be interested in getting a quote for this project. There are some specifics that I am looking for due to our industry, such as, our clinicians are paid per visit and thus im looking for cost per visit for each specific discipline. How would we go about discussing this further.

      arrow_drop_uparrow_drop_downReply reply

      • 

        Mahender K. Punhani 1 year ago
        Downloadable Tool Authorstar

        Can you please provide more details like your historical financial, website or business model that helps in understanding the business. Once I go through it I can provide you a quote. We can discuss further through sharing of document on my email mahenderp21@gmail.com We can also discuss on skype mahenderp21

        arrow_drop_uparrow_drop_downReply reply
• 

  Tony T 1 year ago
  Eloquens Member

  I am looking for realistic information. I speaking with franchise HHC companies (pretty much ruled out), consultants (not likely), startup from scratch (pretty much ruled out), and membership organizations like AHI out of Irvine California (most likely route) but they only give broad stroke info on financials prior to joining. I would like this info ahead of time. Thoughts?

  arrow_drop_uparrow_drop_downReply reply

  • 

    Mahender K. Punhani 1 year ago
    Downloadable Tool Authorstar

    Hi Tony, are you planning to start a HHC and for that you need estimated figures of different expenses and revenue estimates?

    arrow_drop_uparrow_drop_downReply reply