Related Courses
Home » Courses » Finance » Financial Modeling » Hospital Sector Financial Modeling
Healthcare sector comprises of medical related infrastructure & devices, Medical equipment’s, health insurance etc. Hospital sector has seen a tremendous growth in past years. In 2012 total value of healthcare sector in India was USD 79 billion and it is expected to advance at a CAGR of 15 % to reach USD160 billion by 2017.
View More . . .View Less . . .
With the tremendous growth healthcare sector has shown it is competing with the IT as well as pharmaceutical sector.
The course includes understanding of Hospital sector and preparation of financial model of a company of Hospital sector.
This course throws light on:
These tutorial help you create professional Financial Modeling and valuation analysis of Hospital through Excel.
Sachin Nikam, Pune
View More . . .View Less . . .This course has been taught Very well, in a way that makes it easy to grasp technical information well. The tutor was knowledgeable on the subject and presented well putting everyone at ease and was very inclusive and generally excellent at insuring information was learnt. It was an enjoyable, worthwhile and productive. It is recommended to all those who wish to learn financial modeling of hospital sector along with the excel base required by the analyst.
Overall experience for this course was really good. It is a great learning experience with high flexibility which is helping me to enhance my skills and gain knowledge in a convenient way. This was my first experience for learning online but he tutor was engaging making it lively. The training provided a complete overview of the hospital sector and then moved onto the modeling involved and how it is done, making the learning complete in itself. I would definitely recommend this course to my other friends who wish to make career in this domain.
Binay Gupta, Mumbai
It was a great learning experience, especially one like me who is from an engineering background learnt a lot from this online training, and it gives a good knowledge of finance. Starting from basics of finance, and also through this one can have a good knowledge of MS Excel and the structure of this industry. The financial modeling has been explained with the help of case studies which makes the conceptual understanding better.
| 1 | Formatting a Financial Model |
| 2 | Paste Special Function |
| 3 | Logical functions – AND/OR/IF |
| 4 | Arithmetic functions – ABS‚ INT‚ LARGE‚ MAX‚ MIN‚ SMALL‚ TRUNCATE |
| 5 | Date functions – DATE‚ WEEKDAY |
| 6 | Learn to convert text to string |
| 7 | Auto Filter |
| 8 | Pivot Tables |
| 9 | Printing Setup Options |
| 10 | Comments |
| 11 | Grouping Tabs |
| 12 | Conditional Formatting |
| 13 | Protecting Worksheet |
| 14 | Data Validation |
| 15 | Cell Information |
| 16 | Creating text to column |
| 17 | Learn to convert text to string |
| 18 | Learn subtotal function |
| 19 | Check Boxes |
| 20 | Hyperlinks |
| 21 | List Boxes and Combo Boxes |
| 22 | Scroll Bar and Spinners |
| 23 | Group Boxes and Options Button |
| 24 | Download all Excel and PDF files |
| 25 | Indian Healthcare Delivery Services Part 1 |
| 26 | Indian Healthcare Delivery Services Part 2 |
| 27 | Indian Healthcare Delivery Services Part 3 |
| 28 | Indian Healthcare Delivery Services Part 4 |
| 29 | Indian Healthcare Delivery Services Part 5 |
| 30 | Hospital Market in India Part 1 |
| 31 | Hospital Market in India Part 2 |
| 32 | Hospital Market in India Part 3 |
| 33 | Hospital Market in India Part 4 |
| 34 | Hospital Market in India Part 5 |
| 35 | Medical Diagnostics Market Part 1 |
| 36 | Medical Diagnostics Market Part 2 |
| 37 | Medical Diagnostics Market Part 3 |
| 38 | Wellness Services Market � India I Part 1 |
| 39 | Wellness Services Market � India I Part 2 |
| 40 | Wellness Services Market � India II |
| 41 | Wellness Services Market � India III |
| 42 | Health Care Sector In India Part 1 |
| 43 | Health Care Sector In India Part 2 |
| 44 | Health Care Sector In India Part 3 |
| 45 | Health Care Sector In India Part 4 |
| 46 | Health Care Sector In India Part 5 |
| 47 | Health Care Sector In India Part 6 |
| 48 | Comparables for Hospital Companies Part 1 |
| 49 | Comparables for Hospital Companies Part 2 |
| 50 | Comparables for Hospital Companies Part 3 |
| 51 | Comparable Company Analysis – Pharma – part 1 |
| 52 | Comparable Company Analysis – Pharma – part 2 |
| 53 | Comparable Company Analysis – Pharma – part 3 |
| 54 | Comparable Company Analysis – Pharma – part 4 |
| 55 | Hospital – Business Plan Part 1 |
| 56 | Hospital – Business Plan Part 2 |
| 57 | Hospital – Business Plan Part 3 |
| 58 | Hospital – Business Plan Part 4 |
| 59 | Hospital – Business Plan Part 5 |
| 60 | Parkway acquisition of Apollo Hospital Mini Merger Model 1 |
| 61 | Parkway acquisition of Apollo Hospital Mini Merger Model 2 |
| 62 | Parkway acquisition of Apollo Hospital Mini Merger Model 3 |
| 63 | Parkway acquisition of Apollo Hospital Mini Merger Model 4 |
| 64 | Parkway acquisition of Apollo Hospital Mini Merger Model 5 |
| 65 | Parkway acquisition of Apollo Hospital Mini Merger Model 6 |
| 66 | Parkway acquisition of Apollo Hospital Mini Merger Model 7 |
| 67 | Parkway acquisition of Apollo Hospital Mini Merger Model 8 |
| 68 | Parkway acquisition of Apollo Hospital Mini Merger Model 9 |
| 69 | Download all Excel and PDF files |