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!
CAPM Excel Template
(0)
506
109
The CAPM Excel template is a great tool to calculate the required rate of return for investing in a security…
Interest Rate Parity (IRP) Calculator
(0)
846
96
The interest rate parity (IRP) demonstrates the relationship between the interest rates and the exchange rate of two countries. This…
EBIT vs EBITDA Excel Template
(0)
426
104
This EBIT vs EBITDA Excel Template has an example on how to use the income statement to calculate both EBIT…
Contribution Analysis Excel Template
(0)
413
99
Contribution analysis is a type of financial analyses used to measure the impact of direct and variable costs affect the…
Net Working Capital Calculator
(0)
475
99
Net working capital (NWC) is the difference between a company's current assets and current liabilities on its balance sheet. It…
Economic Order Quantity (EOQ) Excel Template
(0)
465
93
Economic order quantity (EOQ) is an operational metric used to determine the volume and frequency of orders a company should…
Earnings Before Interest Tax Depreciation & Amortization (EBITDA) Template
(0)
501
90
Earnings before interest, taxes, depreciation, and amortization (EBITDA) is one of the most frequently used financial metric by finance professionals…
Leveraged Finance Excel Template
(0)
423
89
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
(0)
396
92
FCFF and FCFE can both be used as the cash flow metric for a discounted cash flow analysis. This template…
Debt Capacity Excel Model Template
(0)
442
91
Debt capacity is the total amount of debt a business can take on and repay based on the terms of…
Inventory Turnover Excel Calculator
(0)
496
91
Inventory turnover, or the inventory turnover ratio, measures the number of times a company is able to sell and replace…
Equity Risk Premium Excel Template
(0)
501
88
This equity risk premium (ERP) template shows the calculation of the equity risk premium of individual security based on the…
Compound Annual Growth Rate (CAGAR) Template
(0)
475
89
Compound annual growth rate (CAGR) measures a company's or an investment's annual growth rate over a time horizon, taken into…
Equity Excel Template
(0)
433
84
Equity refers to the value contributed by the owners of a company, and the owners can be either the shareholders,…
Capital Gains Yield Calculator
(0)
455
81
Capital gains yield (CGY) measures how much the market price of an investment or security appreciates over a certain period…
Common Size Analysis Excel Template
(0)
435
81
Common size analysis (or vertical analysis) is a type of financial analyses used by financial analysts or managers to evaluate…

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
6,420
1,728
An operating budget consists of all revenues and expenses over a specific period of time (usually quarterly or annually) which…
Financial Projection Template
2
1,477
622
This Financial Projection Template is an extensive tool for both Financial analysts and Financial Planning and Analysis professionals. The template…
Cash Budget Template
852
403
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
582
241
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
422
106
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)
1
338
93
The file presents the actual vs budget results using pivot table. Unlike my previous budget vs. actual comparison, this file…
Monthly Finance Report (MFR)
247
68
The template designed using Pivot Table, allows you to present a comparison between actual results and budgeted results in a…
Simple Management Monthly Report (Single Year)
337
65
This file presents the financial statements, expense by department, sales analysis, and common analysis for a single year by month.…
Comprehensive Monthly Management Finance Report (Fully Integrated)
213
1
There are two files: the first one is the mapping for the second file. Convert your TB into your special…
Budget Template
265
0
This is long term budget covering the time of year or 12-period showing performance analysis versus previous year in addition…

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!
project-budget-template-excel Project Budget Excel Template
1
893
316
This Project Budget Excel Template is a ready-to-use budget template to help managing projects to better evaluate the costs that…
suppy-chain-template-ppt Supply Chain Template
643
222
Supply chain is the flow of product creation or service delivery from sourcing raw materials, manufacturing, distributing, retail to finally…
multi-criteria-analysis-balance-scorecard-template-ppt1 Multi-Criteria Analysis (Balance Scorecard) Template
1,032
276
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
512
220
Cost-volume-profit analysis (CVP analysis), also commonly referred to as breakeven analysis, is a method to evaluate how profitability is impacted…
Gantt Chart Template
387
201
A gantt chart is a project management tool used to arrange the schedule of a project. It is built with…
Revenue Run Rate Template
550
150
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
579
146
This Value Added Template is an useful tool to calculate the important concept of Value Added both in economic terms…
Year over Year Analysis (YoY) Excel Template
707
223
This Year over Year (YOY) excel template is a great tool to analyze time-series data. This type of analysis is…
Capital Expenditures Template Product image Capital Expenditures Budget Template
903
307
This Capital Expenditures Budget Template can be used by Financial Planning & Analysis Professionals to budget the investment outlays for…
Tariff Setting Methodology - Oil & Gas Downstream Business
342
0
The template is a financial model for a new Oil and Gas company in a downstream sector that will provide…
Feasibility Study Screenshot Image Financial planning
323
0
This financial model is prepared using simple Excel formulas that are easy to understand and explain to your customers. It…
Contracting project financial plan
330
60
The Contracting project contains many finance elements such as advance payment and retention and performance bond, bank grantee, and subcontractors,…

Personal Finance Templates

Browse and download free personal finance templates from CFI Marketplace.
personal-financial-statement-template-excel Personal Financial Statement Excel Template
1
853
214
This Personal Financial Statement Excel Template is a ready-to-use template to help you track and record your personal finances. It…
Annual Income Calculator Excel Template
432
137
This Annual Income Converter Excel template, will assist you on easily converting your hourly, daily, weekly, or monthly income to…
Personal Finance Budget Template Personal Finance Budget Template
732
155
This Personal Finance Budget Template is a great tool for individuals to assess their financial status and plan spendings on…
Piotroski F Score Calculator Example Piotroski F Score Calculator
373
90
The Piotroski F Score calculator is a tool that you can use to determine whether or not a company is…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
399
105
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…

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!
quick-ratio-template-excel Quick Ratio Excel Calculator
464
169
This is a ready-to-use Quick Ratio Excel template, which helps to indicate how well a company can pay off its…
leverage-finance-excel-template-image Leverage Ratios Excel Model Template
610
241
Leverage ratios are types of financial ratios used to show the level of debt that a business may have against…
Acid Test Ratio Excel Template
403
114
Acid-Test Ratio, also referred to as the quick ratio, measures the short-term liquidity of a company by looking at how…
Cash Conversion Ratio Excel Template
426
171
This Cash Conversion Excel Template is a financial management tool used to determine the ratio of the cash flows of…
Cash Ratio Excel Template
599
133
Cash ratio, also known as the cash asset ratio, is a liquidity ratio used to measure how well a company…
Contribution Margin Ratio Excel Template
407
128
Contribution margin (CM) ratio is a measure of a company's marginal benefit of producing an additional unit of product. The…
Current Ratio Excel Template
432
89
Current ratio, also called the working capital ratio, is a liquidity ratio that measures how well a company meets its…
Debt/Asset Ratio Excel Template
471
127
The debt to asset ratio is a type of leverage financial ratios that measure the proportion of a company's assets…
Debt/Equity Ratio Excel Template
603
167
This Debt to Equity Excel Template Ratio is an educational resource that shows you an example on how to calculate…
Debt Service Coverage Ratio Excel Template
450
97
This Debt Service Coverage Ratio (DCSR) Template includes a debt schedule and income statement for a sample calculation of the…
Dividend Coverage Ratio Excel Template
407
74
Dividend coverage ratio (DCR), or dividend cover, is a financial ratio which tells how many times a company is able…
Dividend Payout Ratio Excel Template
411
79
This Dividend Payout Ratio Excel Template is an educational tool that shows you how to calculate the dividend payout ratio…