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!
Dividend Discount Model Template Dividend Discount Model Template
(0)
22,979
3201
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Interest Rate Parity (IRP) Calculator Interest Rate Parity (IRP) Calculator
(0)
18,685
2098
The interest rate parity (IRP) demonstrates the relationship between the interest rates and the exchange rate of two countries. This…
Put-Call Parity Calculator Put-Call Parity Calculator
(0)
18,274
2028
The put-call parity shows the relationship between European call options and put options. This concept is important to understand in…
CAPM Excel Template CAPM Excel Template
(0)
14,607
1317
The CAPM Excel template is a great tool to calculate the required rate of return for investing in a security…
Return on Investment Analysis Return on Investment Analysis
(0)
11,247
1329
This excel model allows you to calculate return on investment easily using different methods based on information that you have.…
Earnings Before Interest Tax Depreciation & Amortization (EBITDA) Template Earnings Before Interest Tax Depreciation & Amortization (EBITDA) Template
(0)
12,280
1131
Earnings before interest, taxes, depreciation, and amortization (EBITDA) is one of the most frequently used financial metric by finance professionals…
Debt Capacity Excel Model Template Debt Capacity Excel Model Template
(0)
13,405
1095
Debt capacity is the total amount of debt a business can take on and repay based on the terms of…
Net Working Capital Calculator Net Working Capital Calculator
(0)
12,150
1100
Net working capital (NWC) is the difference between a company's current assets and current liabilities on its balance sheet. It…
Contribution Analysis Excel Template Contribution Analysis Excel Template
(0)
12,086
1015
Contribution analysis is a type of financial analyses used to measure the impact of direct and variable costs affect the…
Compound Annual Growth Rate (CAGAR) Template Compound Annual Growth Rate (CAGAR) Template
(0)
12,534
1002
Compound annual growth rate (CAGR) measures a company's or an investment's annual growth rate over a time horizon, taken into…
EBIT vs EBITDA Excel Template EBIT vs EBITDA Excel Template
(0)
12,182
972
This EBIT vs EBITDA Excel Template has an example on how to use the income statement to calculate both EBIT…
Leveraged Finance Excel Template Leveraged Finance Excel Template
(0)
11,665
956
Leveraged finance is used to increase an investment's potential returns by purchasing assets with more debt than equity or cash.…
FCFF vs FCFE Reconciliation Excel Template FCFF vs FCFE Reconciliation Excel Template
(0)
11,104
926
FCFF and FCFE can both be used as the cash flow metric for a discounted cash flow analysis. This template…
Common Size Analysis Excel Template Common Size Analysis Excel Template
(0)
12,066
890
Common size analysis (or vertical analysis) is a type of financial analyses used by financial analysts or managers to evaluate…
Black Scholes Calculator Black Scholes Calculator
(0)
11,514
855
This Black Scholes calculator uses the Black-Scholes option pricing method to calculate the fair market value of an option. This…
Economic Order Quantity (EOQ) Excel Template Economic Order Quantity (EOQ) Excel Template
(0)
26,077
793
Economic order quantity (EOQ) is an operational metric used to determine the volume and frequency of orders a company should…

Finance Templates and Excel Models

What is Finance?

Finance refers to the providing of funding and management of money for individuals, corporations, and governments through various finance activities including investing, lending, borrowing, forecasting, budgeting, and saving. There are three main categories of finance – personal, corporate, and public or government. CFI’s Finance Templates were created to help you on your daily tasks as an analyst.

Corporate Finance

Corporate finance focuses on the activities undertaken by a company which would affect the capital structure and ultimately maximize the value of the business. These activities include capital investments, capital financing, and dividends and return of capital.

  1. Capital investments: deciding which project, asset or business to invest in to earn the highest possible risk-adjusted return
  2. Capital financing: determining the optimal capital structure (debt vs equity financing)
  3. Dividends & return of capital: deciding on whether or not to return capital to investors

Careers in corporate finance would typically require the use finance templates and models in Excel to aid financial analysis, modeling and decision making. Take a look at the various corporate finance templates we have on our library.

Finance Topics You Should Know

While there is a wide range of finance concepts and theories, anyone working in the finance industry should be familiar with the following common topics:

  • Financial statements: income statement, balance sheet, cash flow statement
  • Cash flow: earnings before interest and tax (EBIT), earnings before interest, tax, depreciation and amortization (EBITDA), free cash flow, free cash flow to the firm (FCFF), free cash flow to equity (FCFE), cash from operations
  • Revenue, profit, and margins: sales, gross margin, operating margin, net profit margin, net income
  • Costs: cost of goods sold (COGS), selling, general and administrative (SG&A) expenses, marketing, interest expense, depreciation
  • Financial ratios:
  • Profitability ratios – gross margin, operating margin, return on assets, return on equity
  • Liquidity ratios – current ratio, acid-test ratio, cash ratio
  • Leverage ratios – debt ratio, debt to equity ratio, interest coverage ratio
  • Efficiency ratios – asset turnover ratio, inventory turnover ratio, receivables turnover ratio
  • Market value ratios – book value per share, dividend yield ratio, earnings per share EPS ratio, pricing-earnings P/E ratio
  • Rates of return: internal rate of return (IRR), return on investment (ROI), return on assets (ROA)
  • Interest rates and spreads: the percentage of the principal charged by a lender to a borrower for debt, directly proportional to the amount of risk associated with the borrowing
  • Dividends and return of capital: cash dividends is one of the main ways a company returns its profits to shareholders
  • Cost of capital (WACC): the minimum rate of return a company must earn before turning a profit, consists of both the cost of debt and cost of equity used for financing
  • Risk and return: since risk and return are highly correlated especially in investing, investments with high return are more likely to be associated with higher risk

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
70,856
25686
An operating budget consists of all revenues and expenses over a specific period of time (usually quarterly or annually) which…
Financial Projection Template
3
25,147
5467
This Financial Projection Template is an extensive tool for both Financial analysts and Financial Planning and Analysis professionals. The template…
Cash Budget Template
16,428
2558
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
13,547
1391
Operating profit margin, also referred to as EBIT (short for earnings before interest and tax) margin, is a profitability ratio…
Advanced Personal Budget Template Preview Advanced Personal Budget Template
11,330
936
This advanced personal budget template includes everything you need to keep track of your daily, monthly, and yearly personal finances!…
Daily Cash Flow Template
15,018
971
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
11,557
875
Free Weekly Cash Flow Template. 1 Click to Get It! Free Weekly Cash Projections Excel Template. Free Cash Flow Spreadsheet.…
Personal Budget Template
11,611
718
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
7,022
681
Free Cash Flow Statement Excel Template. 1 Click to Get It! Free Cash Flow Statement Excel Template. Free Cash Flow…
Actual vs. Budget by Department (Fully Dynamic)
1
14,864
501
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
14,308
472
The file presents the actual vs budget results using pivot table. Unlike my previous budget vs. actual comparison, this file…
Retail Inventory
6,408
438
Enter and manage up to 2000 different Products Set custom re-order points for each product Simple and Easy data entry…

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
29,384
3285
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
16,060
2118
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
17,025
1702
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
16,500
1672
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
14,130
1544
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
15,501
1406
Supply chain is the flow of product creation or service delivery from sourcing raw materials, manufacturing, distributing, retail to finally…
3 YEAR CASH FLOW PROJECTION TEMPLATE
15,671
1561
Free 3 Year Cash Flow Projection Template in Excel. 1 Click to Get It! Free 3 Year Cash Flow Projection…
Financial model Free Excel Template to fight COVID-19
1
13,255
1452
The coronavirus has turned many small and big companies upside down.   Check this Video Tutorial The decrease in sales,…
Gantt Chart Template
12,225
1316
A gantt chart is a project management tool used to arrange the schedule of a project. It is built with…
Discounted Cash Flow Model Excel Template
14,993
1295
DCF MODEL - DISCOUNTED CASH FLOW EXCEL CALCULATOR   Free DCF Model - Discounted Cash Flow Excel Calculator Template. 1…
12 month cash flow statement template
11,317
1291
Free 12 Month Cash Flow Statement Template. 1 Click to Get It! Free 12 Month Cash Flow Statement Template. Free…
Revenue Run Rate Template
12,404
1119
Revenue run rate is the annualized figure of a company's current revenue in a specified time period (week, month, quarter,…

Personal Finance Templates

Browse and download free personal finance templates from CFI Marketplace.
personal-financial-statement-template-excel Personal Financial Statement Excel Template
1
22,327
2048
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
14,606
1161
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
12,947
856
This Annual Income Converter Excel template, will assist you on easily converting your hourly, daily, weekly, or monthly income to…
Opportunity Cost Template
12,890
722
This opportunity cost template is a fun tool you can use to calculate the opportunity cost of purchase. This tool…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
13,641
672
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
10,778
615
The Piotroski F Score calculator is a tool that you can use to determine whether or not a company is…
Investment feasibility analysis
8,902
574
If you want to decide if your investment good or no , if you want to now if you have…
PERSONAL FINANCES MANAGEMENT (NEW RELEASE)
8,093
545
A useful tool to help you take control of your finances by organizing and aggregating all relevant information in one…
Personal Financial Planner
5,246
357
A simple & flexible personal financial planner with all you need to plan your future cash flow decisions in one…
RENT VS. BUY CALCULATOR
5,878
335
The model compares the net value generated by buying a home vs. renting one, until mortgage pay-off, assuming availability of…
ASSET PORTFOLIO REBALANCING TOOL (2022 RELEASE)
4,979
267
THIS TEMPLATE MAKES IT EASY TO PERFORM PORTFOLIO REBALANCING CALCULATIONS, IN ORDER TO DETERMINE QUANTITIES TO BE PURCHASED OR SOLD…
TRADING SYSTEM (ENHANCED 2022 VERSION)
5,442
242
Designed to support medium term investors who hold onto positions for days, weeks or even months. Best suited for investors…

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
4
32,065
10715
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
23,478
3299
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
16,500
2319
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
16,836
2135
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
14,273
1680
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
13,137
1647
This Debt to Equity Excel Template Ratio is an educational resource that shows you an example on how to calculate…
Operating Cash Flow Ratio Template
12,087
1579
Operating cash flow ratio is a liquidity ratio used to assess a company's ability to meet its short-term obligations with…
Return on Invested Capital (ROIC) Template
11,632
1548
This Return on Invested Capital (ROIC) Template shows how to arrive at the value of the previous period book of…
Cash Conversion Ratio Excel Template
11,585
1452
This Cash Conversion Excel Template is a financial management tool used to determine the ratio of the cash flows of…
Return on Assets Excel Template
13,304
1314
Return on assets (ROA) is a financial metric used to assess how profitable a company is in relation to its…
Cash Ratio Excel Template
12,478
1286
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
11,436
1294
The debt to asset ratio is a type of leverage financial ratios that measure the proportion of a company's assets…