HCA Holdings Inc Complete Fundamental Analysis Excel Model
Originally published: 11/03/2021 12:59
Publication number: ELQ-11790-1
View all versions & Certificate
certified

HCA Holdings Inc Complete Fundamental Analysis Excel Model

Formula Based Excel Model for Fundamental analysis of HCA Holdings Inc Shares

Description
The Model covers all the major fundamental aspects of the company over a few years period. The model is easy to edit and update for the future years as well when the company releases its new annual report. It includes

1. Income Statement 2. Balance Sheet 3. Cashflow Statement

Units are USD Million

The fundamental analysis includes formula based excel model and visualizations of the following as shown in the images attached:

1. Growth Ratios
2. Profitability Ratios
3. Cash Flow Ratios
4. Liquidity and Solvency Ratios
5. Efficiency Ratios
6. Valuation Multiples (EV/EBIT, Market Cap/EBIT and EV/EBITDA)
7. ROE (Du Pont Analysis)
8. Common Size analysis
9. Enterprise Valuation
10. Financial Strength Analysis

About the company:
HCA Healthcare is an American for-profit operator of health care facilities that was founded in 1968.

The aim is to provide a thorough outlook into the company's financial position. This will help you in projects as well as learning fundamental analysis on their own. This can also be used by Investors who are looking to do their own due diligence before investing in the Indian Stock Markets

(Note: All the research done by us is only for educational purposes and should not be seen as Investment recommendations. We are not Registered Investment Advisors)

This Best Practice includes
1 Microsoft Excel Model

Acquire nonprofit license for $4.00

Add to cart

Add to bookmarks

Discuss

Further information

The aim is to provide a thorough outlook into the company's financial position. This will help the students in projects and learning fundamental analysis. This can also be used by Investors who are looking to do their own due diligence before investing in the US Stock Markets

Equity Research, Fundamental Analysis, Valuation, Long Term Investing


0.0 / 5 (0 votes)

please wait...