All Templates

Perpetuity Excel Calculator Perpetuity Excel Calculator
(0)
1,576
136
A perpetuity is a stream of indefinite cash flow payments or annuity with no end date. When performing a business…
Margin of Safety Excel Template Margin of Safety Excel Template
(0)
1,608
151
The margin of safety measures the difference between the actual sales of company and its breakeven point. The formula for…
Gross Margin Ratio Excel Template Gross Margin Ratio Excel Template
(0)
2,451
155
Gross margin ratio, also called the gross profit margin ratio, is a profitability metric that measures how much profit a…
Efficient Frontier and Capital Allocation Line (CAL) Template Efficient Frontier and Capital Allocation Line (CAL) Template
(0)
2,283
136
The capital allocation line (CAL) is a line chart which graphically shows the risk-and-reward profile of risky assets and is…
LTM Revenue Excel Template LTM Revenue Excel Template
(0)
1,758
137
LTM stands for last twelve months or trailing twelve months. LTM revenue is frequently used by finance professionals to measure…
Altman z score formula(Excel) Altman z score formula(Excel)
(0)
1,821
113
if the result of altman z score formula <1.81 then the excel will give you Explanation of altman ratio as…
Dividend Per Share Excel Calculator Dividend Per Share Excel Calculator
(0)
1,938
128
Dividend per share (DPS) is the total amount of dividend that can be claimed by shareholder per share outstanding of…
Effective Annual Interest Rate Excel Calculator Effective Annual Interest Rate Excel Calculator
(0)
1,739
130
Effective annual interest rate (EAR), also referred to as effective interest rate or effective rate, is the interest rate adjusted…
Simple Interest Excel Calculator Simple Interest Excel Calculator
(0)
1,471
133
This simple interest template will calculate the ending balance of a deposit that earns yearly simple interest that is paid…
Unlocking Full Potential of Excel Data Table (Part 1) Unlocking Full Potential of Excel Data Table (Part 1)
(0)
1,229
153
A conventional data table is a one- or two-dimensional table showing the results of a calculation (model outputs) at various…
Negative vs Positive Net present Value
(0)
1,522
104
if the net present value of project or investments,is negative it means the expected rate of return that will be…
AutoSum Excel Template AutoSum Excel Template
(0)
1,967
122
The AutoSum function in Excel is a useful shortcut to help save time in financial modeling. Instead of manually typing…
Advanced Personal Budget Template Advanced Personal Budget Template
(0)
2,143
149
This advanced personal budget template includes everything you need to keep track of your daily, monthly, and yearly personal finances!…
Fixed Asset Turnover Excel Template Fixed Asset Turnover Excel Template
(0)
1,893
148
Fixed asset turnover (FAT) is an efficiency ratio which measures a company's efficiency in using its fixed assets to generate…
Effective Annual Rate Excel Calculator Effective Annual Rate Excel Calculator
(0)
1,734
133
Effective annual rate (EAR), also referred to as effective interest rate or effective rate, is the rate of interest at…
Coupon Rate Excel Template Coupon Rate Excel Template
(0)
2,417
126
The coupon rate is the amount of annual interest income a bondholder receives based on the face value of the…