Templates by Corporate Finance Institute®

Dividend per share (DPS) is the total amount of dividend that can be claimed by shareholder per share outstanding of…

This simple interest template will calculate the ending balance of a deposit that earns yearly simple interest that is paid…

The AutoSum function in Excel is a useful shortcut to help save time in financial modeling. Instead of manually typing…

The coupon rate is the amount of annual interest income a bondholder receives based on the face value of the…

Effective annual rate (EAR), also referred to as effective interest rate or effective rate, is the rate of interest at…

This Earnings per Share (EPS) template calculates the metric for a fictitious company, ABC Ltd. This is a basic EPS…

This geometric mean template will take the inputted data-set and calculate the geometric mean. This is done by multiplying all…

The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…

This Startup/ E-Commerce Financial Model Excel Template has a variety of components, enabling the user to model their business with…

A complete Mergers and Acquisitions (M&A) model that includes: (1) stand-alone target DCF model, (2) stand-alone acquirer DCF model, (3)…

SaaS stands for Software as a Service, it is a type of eCommerce businesses which offers purely software products to…

This Real Estate Financial Model template allows investors to determine the cash flow generated from a real estate development project…

This REIT financial model template acts as a guideline for modeling a real estate investment trust (REIT). This model will…