Finance Templates

Start exploring CFI marketplace to find your desired finance templates and Excel models which would help you create your own version of professional models!
Effective Annual Interest Rate Excel Calculator Effective Annual Interest Rate Excel Calculator
(0)
4,268
286
Effective annual interest rate (EAR), also referred to as effective interest rate or effective rate, is the interest rate adjusted…
LTM Revenue Excel Template LTM Revenue Excel Template
(0)
4,249
288
LTM stands for last twelve months or trailing twelve months. LTM revenue is frequently used by finance professionals to measure…
Perpetuity Excel Calculator Perpetuity Excel Calculator
(0)
3,679
281
A perpetuity is a stream of indefinite cash flow payments or annuity with no end date. When performing a business…
Dividend Per Share Excel Calculator Dividend Per Share Excel Calculator
(0)
4,764
272
Dividend per share (DPS) is the total amount of dividend that can be claimed by shareholder per share outstanding of…
Net Debt Excel Calculator Net Debt Excel Calculator
(0)
4,177
279
This Net Debt Excel Calculator template is an educational resource that shows you an example on how to calculate the…
AutoSum Excel Template AutoSum Excel Template
(0)
4,540
269
The AutoSum function in Excel is a useful shortcut to help save time in financial modeling. Instead of manually typing…
Coupon Rate Excel Template Coupon Rate Excel Template
(0)
6,275
275
The coupon rate is the amount of annual interest income a bondholder receives based on the face value of the…
NPV, IRR & Payback Calculator NPV, IRR & Payback Calculator
(0)
2,611
307
General overview   The template is constructed to evaluate potential major projects or investments that would require capital budgeting before…
Effective Annual Rate Excel Calculator Effective Annual Rate Excel Calculator
(0)
4,142
277
Effective annual rate (EAR), also referred to as effective interest rate or effective rate, is the rate of interest at…
Simple Interest Excel Calculator Simple Interest Excel Calculator
(0)
3,705
272
This simple interest template will calculate the ending balance of a deposit that earns yearly simple interest that is paid…
Negative vs Positive Net present Value
(0)
3,858
240
if the net present value of project or investments,is negative it means the expected rate of return that will be…
Earnings Per Share Example Template Earnings Per Share Example Template
(0)
4,316
255
This Earnings per Share (EPS) template calculates the metric for a fictitious company, ABC Ltd. This is a basic EPS…
Non-directional Trading Strategies Template Non-directional Trading Strategies Template
(0)
5,993
37
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
Geometric Mean Excel Template Geometric Mean Excel Template
(0)
3,791
240
This geometric mean template will take the inputted data-set and calculate the geometric mean. This is done by multiplying all…
Accounts Receivable Analysis Accounts Receivable Analysis
(0)
2,459
243
General overview   The Accounts Receivable Analysis template is an efficient tool to evaluate a company’s Debtors and Accounts Receivable.…
Directional Trading Strategies Template Directional Trading Strategies Template
(0)
6,042
25
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…

Budgeting Templates

Download pre-built budgeting templates from CFI Marketplace to start planning, tracking, and measuring your financial goals!
operating-budget-template-excel Operating Budget Excel Template
15
31,767
11212
An operating budget consists of all revenues and expenses over a specific period of time (usually quarterly or annually) which…
Financial Projection Template
3
12,068
2689
This Financial Projection Template is an extensive tool for both Financial analysts and Financial Planning and Analysis professionals. The template…
Cash Budget Template
8,036
1408
A cash budget template is a financial model built to plan for future funding needed based on historical cash inflows…
Operating Profit Margin Excel Calculator
6,026
776
Operating profit margin, also referred to as EBIT (short for earnings before interest and tax) margin, is a profitability ratio…
Actual vs. Budget by Department (Fully Dynamic)
1
6,303
468
This template is used to compare budget with actual results per department, per month, monthly or YTD. BY choosing among…
Monthly Finance Report (Pivot Table)
2
6,068
447
The file presents the actual vs budget results using pivot table. Unlike my previous budget vs. actual comparison, this file…
Advanced Personal Budget Template Preview Advanced Personal Budget Template
5,805
481
This advanced personal budget template includes everything you need to keep track of your daily, monthly, and yearly personal finances!…
Personal Budget Template
4,515
341
This personal budget template is a basic tracker for your daily, monthly, and yearly personal finances! Use this budget if…
Simple Cash Flow Statement Template
1,945
276
Free Cash Flow Statement Excel Template. 1 Click to Get It! Free Cash Flow Statement Excel Template. Free Cash Flow…
Cash Flow Dashboard Template
3,215
269
Get free nicely built Cash Flow Dashboard for your business. Analyze the movements of cash inside your business smart and…
Daily Cash Flow Template
2,767
262
Free Daily Cash Flow Template Excel. 1 Click to Get It!   Free Daily Cash Flows Projection Template. Free daily…
WEEKLY CASH FLOW TEMPLATE - 9 WEEKS
2,054
204
Free Weekly Cash Flow Template. 1 Click to Get It! Free Weekly Cash Projections Excel Template. Free Cash Flow Spreadsheet.…
See all

Financial Planning & Analysis (FP&A) Templates

Browse around the CFI marketplace to find the best Financial Planning & Analysis (FP&A) model for your finance role and impress management with a detailed financial analysis and forecast!
Capital Expenditures Template Product image Capital Expenditures Budget Template
12,888
1476
This Capital Expenditures Budget Template can be used by Financial Planning & Analysis Professionals to budget the investment outlays for…
project-budget-template-excel Project Budget Excel Template
1
8,131
1163
This Project Budget Excel Template is a ready-to-use budget template to help managing projects to better evaluate the costs that…
multi-criteria-analysis-balance-scorecard-template-ppt1 Multi-Criteria Analysis (Balance Scorecard) Template
8,843
949
Why Use a Multi-Criteria Analysis or Balance Scorecard? Strategic analysis refers to the process of conducting research on a company…
Cost-Volume-Profit (CVP) Analysis Excel Template
7,589
878
Cost-volume-profit analysis (CVP analysis), also commonly referred to as breakeven analysis, is a method to evaluate how profitability is impacted…
Year over Year Analysis (YoY) Excel Template
6,560
820
This Year over Year (YOY) excel template is a great tool to analyze time-series data. This type of analysis is…
suppy-chain-template-ppt Supply Chain Template
6,934
765
Supply chain is the flow of product creation or service delivery from sourcing raw materials, manufacturing, distributing, retail to finally…
Gantt Chart Template
5,263
727
A gantt chart is a project management tool used to arrange the schedule of a project. It is built with…
Revenue Run Rate Template
5,768
590
Revenue run rate is the annualized figure of a company's current revenue in a specified time period (week, month, quarter,…
Value Added Excel Template
5,594
550
This Value Added Template is an useful tool to calculate the important concept of Value Added both in economic terms…
Financial model Free Excel Template to fight COVID-19
3,852
563
The coronavirus has turned many small and big companies upside down.   Check this Video Tutorial The decrease in sales,…
Discounted Cash Flow Model Excel Template
5,335
541
DCF MODEL - DISCOUNTED CASH FLOW EXCEL CALCULATOR   Free DCF Model - Discounted Cash Flow Excel Calculator Template. 1…
Analysing data in Excel
4,584
433
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
See all

Personal Finance Templates

Browse and download free personal finance templates from CFI Marketplace.
personal-financial-statement-template-excel Personal Financial Statement Excel Template
1
10,119
1012
This Personal Financial Statement Excel Template is a ready-to-use template to help you track and record your personal finances. It…
Personal Finance Budget Template Personal Finance Budget Template
7,028
594
This Personal Finance Budget Template is a great tool for individuals to assess their financial status and plan spendings on…
Annual Income Calculator Excel Template
5,285
466
This Annual Income Converter Excel template, will assist you on easily converting your hourly, daily, weekly, or monthly income to…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
5,733
376
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…
Piotroski F Score Calculator Example Piotroski F Score Calculator
4,479
360
The Piotroski F Score calculator is a tool that you can use to determine whether or not a company is…
Opportunity Cost Template
4,603
339
This opportunity cost template is a fun tool you can use to calculate the opportunity cost of purchase. This tool…
Investment feasibility analysis
3,244
274
If you want to decide if your investment good or no , if you want to now if you have…
PERSONAL FINANCES MANAGEMENT
1,487
128
A useful tool to help you take control of your finances by organizing and aggregating all relevant information in one…
Option Profit Calculator
3,239
53
This template will help you analyse the profitability of your Option Trading strategies. The template works with MarketXLS.com product which…
RENT VS. BUY CALCULATOR
551
43
The model compares the net value generated by buying a home vs. renting one, until mortgage pay-off, assuming availability of…
Bachelor / Bachelorette (Hen / Stag) Party Event Budget Planner
3,727
1
Template for preparing and managing budgets for stag, hen parties, and other events. The user will have the ability to…
Remaining mortgage calculator
3,711
1
Want to know how much is left on your mortgage? Or planning to take out a mortgage but not sure…
See all

Ratios Templates

This is a marketplace of Financial Ratios Templates and Tools. Here you will find an extensive library of Excel Tools and Templates to help you save time!
Financial Ratios Calculator
2
12,548
4087
Simple calculation & Visual representations of the different financial liquidity, solvency, price, return & cash flow ratios. Just feed in…
beneish m score calculator preview Beneish M Score Calculator
1
10,290
1389
The Beneish M Score calculator is used to determine if a company has manipulated its reported earnings in its financial…
leverage-finance-excel-template-image Leverage Ratios Excel Model Template
7,035
1168
Leverage ratios are types of financial ratios used to show the level of debt that a business may have against…
Return on Investment (ROI) Excel Template
7,408
1068
Return on investment (ROI) is a financial metric intended for the measurement of benefits an investor receives for the amount…
quick-ratio-template-excel Quick Ratio Excel Calculator
6,265
844
This is a ready-to-use Quick Ratio Excel template, which helps to indicate how well a company can pay off its…
Debt/Equity Ratio Excel Template
6,287
841
This Debt to Equity Excel Template Ratio is an educational resource that shows you an example on how to calculate…
Cash Conversion Ratio Excel Template
5,156
764
This Cash Conversion Excel Template is a financial management tool used to determine the ratio of the cash flows of…
Return on Invested Capital (ROIC) Template
5,076
774
This Return on Invested Capital (ROIC) Template shows how to arrive at the value of the previous period book of…
Operating Cash Flow Ratio Template
5,360
765
Operating cash flow ratio is a liquidity ratio used to assess a company's ability to meet its short-term obligations with…
Cash Ratio Excel Template
5,886
683
Cash ratio, also known as the cash asset ratio, is a liquidity ratio used to measure how well a company…
Debt/Asset Ratio Excel Template
4,926
655
The debt to asset ratio is a type of leverage financial ratios that measure the proportion of a company's assets…
Contribution Margin Ratio Excel Template
5,156
644
Contribution margin (CM) ratio is a measure of a company's marginal benefit of producing an additional unit of product. The…
See all