All Templates

Negative vs Positive Net present Value
(0)
1,904
127
if the net present value of project or investments,is negative it means the expected rate of return that will be…
Effective Annual Interest Rate Excel Calculator Effective Annual Interest Rate Excel Calculator
(0)
2,120
152
Effective annual interest rate (EAR), also referred to as effective interest rate or effective rate, is the interest rate adjusted…
Asset Performance Calculator Asset Performance Calculator
(0)
1,879
160
Asset Performance Calculator For Mutual Fund Industry Written in Visual Basic with Live Data Query.
AutoSum Excel Template AutoSum Excel Template
(0)
2,401
142
The AutoSum function in Excel is a useful shortcut to help save time in financial modeling. Instead of manually typing…
Simple Interest Excel Calculator Simple Interest Excel Calculator
(0)
1,869
153
This simple interest template will calculate the ending balance of a deposit that earns yearly simple interest that is paid…
Justified Price-to-Earnings (P/E) Ratio Template Justified Price-to-Earnings (P/E) Ratio Template
(0)
1,956
161
This price to earnings ratio template is a great tool that shows you how to perform the calculation for the…
Effective Annual Rate Excel Calculator Effective Annual Rate Excel Calculator
(0)
2,070
156
Effective annual rate (EAR), also referred to as effective interest rate or effective rate, is the rate of interest at…
Earnings Per Share Example Template Earnings Per Share Example Template
(0)
2,231
141
This Earnings per Share (EPS) template calculates the metric for a fictitious company, ABC Ltd. This is a basic EPS…
Fixed Charge Coverage Ratio Template Fixed Charge Coverage Ratio Template
(0)
2,453
157
The fixed charge coverage ratio (FCCR) is a financial ratio which evaluates how well a company meets its fixed charge…
Coupon Rate Excel Template Coupon Rate Excel Template
(0)
3,317
143
The coupon rate is the amount of annual interest income a bondholder receives based on the face value of the…
Analysing data in Excel Analysing data in Excel
(0)
2,120
173
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
Geometric Mean Excel Template Geometric Mean Excel Template
(0)
1,916
130
This geometric mean template will take the inputted data-set and calculate the geometric mean. This is done by multiplying all…
Personal Budget Template Personal Budget Template
(0)
2,086
150
This personal budget template is a basic tracker for your daily, monthly, and yearly personal finances! Use this budget if…
Opportunity Cost Template Opportunity Cost Template
(0)
2,110
149
This opportunity cost template is a fun tool you can use to calculate the opportunity cost of purchase. This tool…
Charts and Dashboards in Excel (short version) Charts and Dashboards in Excel (short version)
(0)
1,342
148
This is an introductory part to creating professional charts which:   - defines key chart elements and explains how to…