Templates by Corporate Finance Institute®

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

The fixed charge coverage ratio (FCCR) is a financial ratio which evaluates how well a company meets its fixed charge…

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

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

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

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

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 non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…

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 Amazon Case Study - Advanced Business Valuation Model is built to value AMZN's businesses and determine its target share…

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