Complete Stock Analysis Excel Model
  • Complete Stock Analysis Excel Model
  • Complete Stock Analysis Excel Model
  • Complete Stock Analysis Excel Model
  • Complete Stock Analysis Excel Model
  • Complete Stock Analysis Excel Model
  • Complete Stock Analysis Excel Model
  • Complete Stock Analysis Excel Model
Originally published: 28/09/2018 15:39
Last version published: 01/10/2018 08:16
Publication number: ELQ-46839-3
View all versions & Certificate
certified

Complete Stock Analysis Excel Model

A 6 tab Excel Model for a complete company analysis in one place.

altman z-scorefinancial marketsfundamental analysisinvestment bankingmodified c-scorepitroski f-scorequalitative analysisquantitative analysisstock analysissum of the parts method

Description
This tool is designed to make a comprehensive analysis of a company. This tool values the company not as a whole but divides it into separate parts and works on the technique of "sum of the parts".

This considers filters known as C1 (Qualitative analysis) and C2 (Quantitative analysis).

In C1(Qualitative analysis) we check some parameters which help us identify the management of the company. This is because a good management is the key for your financial returns. We apply "SUM OF THE PARTS " Model to identify the management as a whole.

We predetermine the cut off criteria as per the investor's risk appetite.

Then we move to other tabs that are designed to check the insolvency of the business i,e. Altman Z-score

It was used by banks to check the credit worthiness of the entities whom they are going to lend Money to.

Afterwards we move to the 3rd tab that is designed to check the company's performance compared to previous year i,e. Pitroski F-Score Model after that

The 4th tab checks the accounts manipulation i,e. Modified-C Score Model.

The 5th tab checks the company's performance consistency known as "TIME SERIES MODEL"

Finally, the 6th tab helps to check the Free Cash Flow of the company to determine that wether the stock is fit to the criteria -> BUY/SELL/HOLD

This business tool includes
1 Excel Model

Acquire business license for $55.00

Add to cart

Add to bookmarks

Discuss

Further information

Investment with the understanding of FUNDAMENTAL ANALYSIS

Equity Investment, Medium to Long term Investment.

Equity Trading, Swing Trading

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Complete Stock Analysis Excel Model?

The user community and author are here to help. Go ahead!

please wait...