Downloads

Debt Amortization Model

An excel based financial model for computing the present value and future value of an investment with different interest rates for number of years and frequency.

Enterprise Value

A document that tells what is an Enterprise Value (EV) and lists the steps to compute the same.

Present & Future Value Calculation

An excel based financial model for computing the present value and future value of an investment with different interest rates for number of years and frequency.

Synergy Valuation

Synergy, the increase in value generated from the combination of two different entities to create a more valuable entity, which is a key determinant of purchase premium paid by an acquirer, at times results in billions of dollars and acquirer doesn’t even hesitate to shell out. This model explains the route sources of Financial Synergies for an M&A.

Interest Factor Table

An excel based financial model for computing the present value and future value of an investment with different interest rates for number of years and frequency.

M&A Exercise

Mergers and acquisitions are expected to result in improved productivity and profits of the company and at the same time minimizing the expenses. This model explains a quick and approximate form of Accretion/Dilution effects, in other words comparing pre and post EPS impact for the shareholders of an acquirer.

Ratio Analysis Model

A favorite of vindicators of fundamental analysis who swear by this tool for quantitative analysis to ascertain the performance of a company by comparing with historical figures or that of other companies, industry or economy. This model explains the introductory approach of financial statement analysis, including Common sizing, Time series and Du-Pont analysis.

Sample Questions on Valuation

A small set of questions to ascertain the technical understanding of few important valuation concepts and their applications, which form the foundation of a successful career in finance domain.