Industry Analysis Excel Model
Originally published: 19/09/2018 07:29
Last version published: 29/10/2018 09:19
Publication number: ELQ-60981-5
View all versions & Certificate

Industry Analysis Excel Model

A 10 tab excel model to analyse 10 industries from the "Nifty Index"

This seems to be a good tool to identify or for the analysis of INDUSTRY because as per TOP-DOWN approach of analysis it is the second most important factor that is to be considered before making an investment decision in this analysis I have collected historical data of all the sectors that are in working along with "Nifty Index", sectors are as follows..

1.Nifty Auto
2.Nifty Bank
3.Nifty Financial Services
4.Nifty IT
5.Nifty Media
6.Nifty Metal
7.Nifty Pharma
8.Nifty Pvt. Bank
9.Nifty Realty

After properly analyzing the data we would be in a situation where we can identify each and every sector's average risk and return on the basis of their utilities - on the basis of past 18 years historical data.

This is very helpful in the case of "portfolio management" after analyzing price we would be having findings of each INDUSTRY "Beta" and their correlations with nifty & others sectors as well.

Their utility which shows that what returns can be expected on each and every unit of risk made. Then, we will be having a third sheet where there is a little shown combination of two sectors portfolio their risk and return as well - Weights which are used can differ according to each investor's appetite for risk.

This Best Practice includes
1 Excel Model

Acquire business license for $30.00

Add to cart

Add to bookmarks


Further information

Useful tool for industry analysis and portfolio management

Portfolio Management & Investment



  • Be the first to review this Downloadable Best Practice

    Write a review


More Best Practices from Jatin Goel

See all

Any questions on Industry Analysis Excel Model?

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

0.0 / 5 (0 votes)

please wait...