PETRONET- Complete Stock Analysis ( With Forecasting and Valuations)

Description
This Tool is preapred for the purpose of Fundamental analysis of any company. In this Financial model i have explained what are the key parameter that we need to prime related to company, Industry Demand, and Economic Growth. This model is comprised of 12 tabs.
 Dashboard
Income Statement
Balance Sheet
Cash Flow
Ratios Analysis
Common Size Income statement
ownership Trend
Revenue and cost bifurcation
Cost of capital
Assumptions (Sales Forecast)
Valuations
Product overview
This model is not any buy or sell recommendation. But the purpose of this tool is spread financial modelling awareness like how you can preopare a model and what are the forecasting assumptions how we forecast cash flow, balance sheet, income statement. What is FCFF and FCFE how do we calculate. 


For valuation purpose i have explained 3 valuation methods. DCF, Residual Value and Relative valuation. which is very popular nowadays. With the help of this model you can learn ho to create dashboard, Key Ratios, How to do DCF analysis, How to do sales forecast and much more. You can use any company data and put that into the model for its fundamental analysis. 


With the help of this model i wanted to explain the forecasting and valuation assumption which should be reasonable in numbers. 
# financial Modelling