Templates by Corporate Finance Institute®

This Earnings per Share (EPS) template breaks down the calculation of the ratio. EPS is an important financial ratio and…

Cash earnings per share (cash EPS) is the per share cash flow from operations generated by a company. Different from…

Dividend coverage ratio (DCR), or dividend cover, is a financial ratio which tells how many times a company is able…

A cover letter is often required for a job application along with an applicant's resume to briefly outline one's skills…

Interest rate is the rate at which borrowers need to pay back to the lender of debt. It is usually…

This Net Debt Excel Calculator template is an educational resource that shows you an example on how to calculate the…

A perpetuity is a stream of indefinite cash flow payments or annuity with no end date. When performing a business…

The margin of safety measures the difference between the actual sales of company and its breakeven point. The formula for…

Gross margin ratio, also called the gross profit margin ratio, is a profitability metric that measures how much profit a…

LTM stands for last twelve months or trailing twelve months. LTM revenue is frequently used by finance professionals to measure…

The capital allocation line (CAL) is a line chart which graphically shows the risk-and-reward profile of risky assets and is…

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…

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

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

Fixed asset turnover (FAT) is an efficiency ratio which measures a company's efficiency in using its fixed assets to generate…