FAANG Ratio Analysis (Q2 2020)
Originally published: 24/08/2020 08:03
Publication number: ELQ-99693-1
View all versions & Certificate

FAANG Ratio Analysis (Q2 2020)

FAANG stocks Ratio Analysis in Microsoft Excel.

The sheet provides complete ratio analysis of FAANG stocks as per the latest quarterly data. the template is extremely user friendly and intuitive and can be edited and used for any other company, just by changing the entries in the data sheet.

Few Features of the sheet are:
- Complete Analysis through 20 distinct and accurate ratios.
- Ratios arranged in 7 separate classes for easier understanding.
- Easily modifiable template.
- Interpretation of each ratio in depth with their uses.
- Visualization added to the ratios through graphs.
- The analysis is done as per latest data.

The different class of ratios used in the sheet are as follows:
- Liquidity Ratios - Current Ratio, Quick Ratio, Cash Ratio, Defense ratio
- Leverage Ratios - Debt to Asset, Debt to Equity
- Coverage Ratios - Debt Service Coverage, Interest Coverage
- Efficiency Ratios - Total Asset Turnover(COGS), Total Asset Turnover(Revenue), Capital Turnover
- Profitability Ratios - Gross Profit, Net Profit, Operating Profit
- Return Ratios - Return on Capital Employed, Return on Equity
- Cash Flow Ratios - 4 distinct ratios.

Disclaimer: Investment and trading in securities market is always subjected to market risks. The analysis in no way should be treated as an investment advice.

The author is not responsible for any kind of loss due to information preset in this sheet.

This Best Practice includes
1 Excel sheet.

Acquire business license for $5.00

Add to cart

Add to bookmarks


Further information

Ratio Analysis of Stocks.

Trading of Stocks

0.0 / 5 (0 votes)

please wait...