Company Analysis Excel Model Template
  • Company Analysis Excel Model Template
  • Company Analysis Excel Model Template
  • Company Analysis Excel Model Template
  • Company Analysis Excel Model Template
  • Company Analysis Excel Model Template
  • Company Analysis Excel Model Template
  • Company Analysis Excel Model Template
  • Company Analysis Excel Model Template
Originally published: 21/01/2019 18:02
Last version published: 31/03/2019 06:40
Publication number: ELQ-13308-4
View all versions & Certificate
certified

Company Analysis Excel Model Template

Macros and VBA enabled excel model to analyse any company in the world in under 5 minutes.

Description
This tool is designed to make a comprehensive analysis of a company. It is a macros and VBA enabled tool which will analyse all key information in just 5 minutes and in ONE CLICK.

This considers filters known as Management Check (Qualitative analysis) and Fundamentals checks (Quantitative analysis).

In Management Check (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.

All you have to do is just fill in the INPUTS sheet then click "pull financial statements" wait for a few seconds until the data has downloaded then click the "ANALYSE" button and you're all set.

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

1) Then we move to the other tabs that are designed to check the insolvency of the business i,e. Altman Z-score. It was used by New York banks to check the credit worthiness of the entities whom they are going to lend Money.

2) 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. Which will be helpful for us to determine is the company doing good in this year as compared to previous year i.e when we are going to invest in which is not only just depends on historical performance.

3) The 4th tab checks the accounts manipulation i,e. Modified-C Score Model. This is because most businesses try to be a little creative with their accounts so that investors don't take to their heels.

4) The 5th tab checks the company's performance consistency through "TIME SERIES MODEL" where it checks key performance ratios of the company.

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

This is a technical model any person whether in a finance or non-finance background can use.

I do provide 2 online 1 hour free sessions on how to use the model: you're welcome to private message me on the platform.

NOTE: Password to open the model: 12

This business tool includes
1 Excel Model

Acquire business license for $39.00

Add to cart

Add to bookmarks

Discuss

Further information

Quick Fundamental analysis (Just One Click)

Investment ( Long Term )

Trading

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Jatin Goel

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Company Analysis Excel Model Template?

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

please wait...