Comprehensive Financial Model

Description
Will cover different types of financial analysis on the basis of the company's historical financials.
Buyer will have to input the historical data in the 'Input' tab basis which the entire model will operate. It's optional to edit the assumptions tab (assumptions calculated on historical averages).

Basis the input, the model will conduct various financial analysis mentioned below and calculate the valuation of the company.

Analysis Inclusive of :
Ratio analysis (Liquidity, profitability, turnover, leverage, valuation)
Growth rates and other important metrics
DuPont Analysis
Altman Z score
Piotroski F score
Beneish M score

Will also include a dynamic graphs dashboard

The excel comprises of a 3 statement model inclusive of forecasts and assumptions as well as an analysis of the forecasted financials. It provides complete football field valuation of the selected company using multiple methods* (DCF with exit, FCFF, FCFE, DDM, trading range, PVFSP. trading comparables, transaction comparables, Monte Carlo simulation of stock price). WACC and beta calculation also provided in detail. Dynamic charts and dashboard are dynamic interactive.

Please note: This is simply a financial model and not a recommendation to buy any stock basis the valuation done. Valuation metrics that should be used will vary basis company and industry selected.