Templates

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

IF AND Excel – Template

IF AND Excel template demonstrating the use of IF&AND functions in Excel for logical analysis and decision-making.

Learn More
CFA Study Planner – Template

Prepare for your CFA Level 1 Exam with our FREE CFA Study Planner, fully customizable and adaptable for your needs. Down...

Learn More
15 Ways to Visualize Revenue in Excel – Template

Download for FREE our Revenue in Excel template and visualize your financial data effectively.

Learn More
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
Top