Templates

Hit the ground running with our ready-made and easy to use financial Excel templates, models and formula sheets!

Hit the ground running with our ready-made and easy to use financial Excel templates, models and formula sheets!

IF Function in Excel – Template

Download our FREE template exploring the IF function in Excel.

Learn More
CHOOSECOLS – Excel Template

The Excel CHOOSECOLS is a powerful function that allows you to retrieve specified columns from an array or range in...

Learn More
Calculate Enterprise Value (EV) – Excel Template

The enterprise value (EV) is a measure of a firm’s total worth. It equals the sum of the market value...

Learn More
EV to EBITDA – Excel Template

The EV/EBITDA is a financial ratio that compares a firm’s enterprise value (EV) to its earnings before interest, taxes...

Learn More
Two-Stage Dividend Discount Model – Excel Template

The two-stage dividend discount model is used to value growth companies that experience two growth phases. In the first ...

Learn More
Gordon Growth Model – Excel Template

The Gordon growth method is an extension of the dividend discount model and assumes that the stream of future dividends....

Learn More
Three-Stage Dividend Discount Model – Excel Template

The three-stage dividend discount model is used to value growth companies and assumes that those experience three distin...

Learn More
Return on Equity (ROE) – Excel Template

The return on equity (ROE) ratio measures the rate of return shareholders receive on their shares. To calculate the ROE,...

Learn More
Jensen’s Alpha – Excel Template

Jensen’s alpha calculates the difference between the portfolio actual return and the required return by the Capital As...

Learn More
Treynor Ratio – Excel Template

The Treynor Ratio is a portfolio performance measure that illustrates the excess return per unit of systematic risk. It ...

Learn More
M Squared Ratio – Excel Template

M squared (M²) is a risk-adjusted performance measure that evaluates the performance of an investment portfolio. The id...

Learn More
FILTER – Excel Template

FILTER is one of the most popular functions in Excel. It allows you to filter a range of data, based...

Learn More
SORTBY Function – Excel Template

The SORTBY function in Excel allows you to sort one range or array, based on the values of a corresponding...

Learn More
UNIQUE Function – Excel Template

In large datasets, you often find duplicate values—data entries that occur more than once. You must handle those caref...

Learn More
RANDARRAY Function – Excel Template

The Excel RANDARRAY function generates an array of random numbers that can be whole or decimal. The new dynamic array...

Learn More
SEQUENCE Function – Excel Template

The SEQUENCE function in Excel allows you to easily create a list of sequential numbers in an array—such as 10,...

Learn More
XMATCH Function – Excel Template

The Excel XMATCH dynamic function searches for a specified item in vertical or horizontal ranges. It is more flexible th...

Learn More
LET Function – Excel Template

The LET function in Excel is a powerful tool for those who work with lengthy formulas. It helps you define...

Learn More
Information Ratio – Excel Template

The information ratio measures the portfolio’s risk-adjusted return over a benchmark. It tracks the consistency of por...

Learn More
Sortino Ratio – Excel Template

The Sortino ratio measures the portfolio’s risk-adjusted return. Rational investors use it to maximize their rate of r...

Learn More
Top