Product Combo (DCF + HFA) Model (Annual Subscription)

Historical Financial Analysis Model: This model assists in analysing the financial statements of a company. The model will allow you to:

– Adjust for leases, capitalise R&D and calculate the value of employee options.

– Automatically compute trailing twelve month numbers and common form income statements and balance sheets; and

– View graphical representation of important metrics such as profitability, leverage, efficiency, valuations, growth, etc. to form a holistic view of the company’s historical statements

DCF Model: This is a comprehensive discounted cash flow valuation model which gives you the options to:

• Use normalised earnings of the company over a cycle;
• Capitalise operating leases;
• Capitalise any expenses that you believe provide benefit to the company over more than one year;

Apart from the above, the model uses a database to automatically compute:

• Risk free rate for the currency in which the valuation is being done;
• Bottom up beta for the industries in which your company operates;
• Implied equity risk premium;
• Cost of debt based on a synthetic rating for your company;
• Value of employee options based on a modified Black-Scholes and adjust the same in the value of your company.

Another feature of the model is that it would allow you to run Scenario Analysis and Monte Carlo Simulations on some of the value drivers of your company.