Download CFI’s free P&L template and Excel file. Enter your own numbers and edit both the monthly and annual worksheets.
Get the free Excel waterfall chart template, a great way to graph changes and impacts of financial metrics in Excel
For effective business planning is critical to have a good budget template that tracks revenues and expenses and is easy to use
Download CFI’s free 3 statement financial model to learn how the income statement, balance sheet, and cash flow statement are linked
Download the cash flow statement template to portray a company’s cash from operations, investing and financing
Download a free DCF model template to calculate the net present value (NPV) of a business using a discount rate and free cash flow
Explore and download the free Excel templates below to perform different kinds of financial calculations, build financial models and documents, and create professional charts and graphs. CFI’s financial model template library has hundreds of free Excel file downloads to help you become a worldclass financial analyst.
Balance Sheet  This balance sheet template provides you with a foundation to build your own company's financial statement showing the total assets, liabilities and shareholders' equity. 
financial_model
balance_sheet

Income Statement  This income statement template provides you with a foundation to build your own monthly or annual summary of revenues and expenses. 
financial_model
income_statement

Profit and Loss (P&L) Statement  This profit and loss (P&L) statement template summarizes a company's income and expenses for a period of time to arrive at its net earnings for the period. 
financial_model
p&l

Cash Flow Statement  This cash flow statement template provides you with a foundation to record operating, investing and financing cash flows annually. 
financial_model
cash_flow_statement

DCF Model  This DCF model template provides you with a foundation to build your own discounted cash flow model with different assumptions. 
financial_model
dcf_model

Property Plant and Equipment Schedule  This property plant and equipment (PP&E) schedule template will help you keep track of PP&E balances and depreciation costs. 
financial_model
pp&e_schedule
depreciation

Bank Reconciliation Statement  This bank reconciliation statement template shows you how to calculate the adjusted cash balance using the bank statement and a company's accounting record. 
financial_model
bank_reconciliation

Operating Budget  This operating budget template helps you prepare your monthly and annual revenue, costs and expenses budget. 
financial_model
operating_budget

Project Budget  This project budget template provides you with a tool to summarize the cost budget for a project. 
financial_model
project_budget

Cash Budget  This cash budget template will help you plan your cash inflows and outflows on a monthly basis. 
financial_model
cash_budget

Personal Financial Statement  This personal financial statement template is a great tool to keep track your personal assets, liabilities, income and expenses. 
financial_model
financial_statement

Consolidation Model  This consolidation model template helps you summarize the financial performance of multiple business units into a consolidated model. 
financial_model
consolidation

Capitalization Table  This capitalization table template is a helpful tool for a startup company or earlystage venture to list all the company’s securities. 
cap_table

Cohort Analysis  This cohort analysis template is a useful tool for customer behavior analysis using a large data set. 
cohort_analysis

3 Statement Model  This 3 statement financial model links the income statement, balance sheet & cash flow. 
financial_model
financial_statements

Financial Projection Template  This financial projection template will help you forecast future revenues and expenses by building up from payroll schedules, operating expenses schedules and sales forecast to the three financial statements. 
financial_model
financial_projection
forecast

Debt Capacity Model  This Debt Capacity Model Template will help you assess the debt capacity based on various credit metrics and current earnings. 
financial_model
debt_capacity

Want some more advanced financial models? Get instant access to over 15 premium financial models in CFI’s Financial Modeling Templates Package.
CFI’s premium package is designed for professionals working in private equity, financial planning & analysis (FP&A), equity research, treasury, corporate development, investment banking, accounting, consulting, and other functions that require modeling skills.
Working Capital  This working capital template allows you to calculate working capital using the formula: Working capital = current assets – current liabilities 
financial_measure
calculation

CapEx Formula  This CapEx formula template helps you calculate the amount of capital expenditures using numbers in the income statement and balance sheet. 
financial_measure
calculation

Marginal Cost Calculator  This marginal cost calculator allows you to calculate the additional cost of producing more units using the formula: Marginal Cost = Change in Costs / Change in Quantity 
financial_measure
calculation

Cost of Goods Manufactured  This cost of goods manufactured template lays out a schedule of COGM using the amount of direct materials, direct labor, manufacturing overhead and work in process inventory. 
accounting_measure
calculation

CAPM Formula  This CAPM formula template will help you calculate the required rate of return for investing in a security given the riskfree return and risk premium. 
expected_return
risk
calculation

Equity Beta Asset Beta Conversion  This equity beta asset beta conversion template allows you to convert between equity beta and asset beta. 
financial_ratios
unlevered_beta
levered_beta
conversion

Market to Book (Price to Book) Ratio  This market to book ratio template allows you to calculate the Market/Book ratio using the market capitalization and the net book value. 
financial_valuation_metric
market_price
book_value

Discount Factor  This discount factor template helps you calculate the amount of discounted cash flows using explicit discount factors. 
calculation
cash_flow
discount

Return on Investment Calculator  This return on investment calculator will show you how to calculate ROI using four different approaches. 
financial_ratio
ROI

Market Value of Debt  This market value of debt template shows you how to calculate the market value of debt given the FV of total debt, interest expense, cost of debt and weighted average maturity. 
financial_measure
debt
calculation

Leverage Ratios  This leverage ratios template helps you calculate five commonly used leverage ratios. 
financial_ratios
leverage_ratios

Enterprise Value vs Equity Value Calculator  This enterprise value vs equity value calculator will allow you to compare the equity value of two companies with the same enterprise value but different capital structures. 
financial_measure
enterprise_value
equity_value

Sensitivity Analysis Table  This sensitivity analysis table template helps you predict sales revenue based on changes in input variables including traffic growth, unit price and sales volume. 
financial_analysis
variables
sensitivity

EBITDA Multiple  This EBITDA multiple template helps you find out the EBITDA multiple given the line items for determining the enterprise value. 
financial_ratio
valuation
calculation

WACC Calculator  This WACC calculator helps you calculate WACC based on capital structure, cost of equity, cost of debt and tax rate. 
financial_measure
cost_of_capital

Cash Flow Reconciliation  This cash flow reconciliation template will help you differentiate between EBITDA, CF, FCF and FCFF. 
cash_flows
reconciliation
calculation

Effective Annual Interest Rate Calculator  This effective annual interest rate calculator helps you calculate the EAR given the nominal interest rate and number of compounding periods. 
interest_rate
calculation

Tax Shield Example  This tax shield example template shows how interest tax shield and depreciated tax shield are calculated. 
tax_shield
calculation

Net Working Capital  This net working capital template allows you to compute the net working capital using the formula: Net Working Capital = Current Assets (less cash) – Current Liabilities (less debt) 
financial_measure
calculation

Accounting Rate of Return  This accounting rate of return template will demonstrate two examples of ARR calculation. 
financial_measure
rate_of_return

Return on Assets  This return on assets template will help you calculate return on assets using net income and the amount of start of period and end of period assets. 
financial_measure
return_on_assets

EV/EBITDA  This EV/EBITDA template guides you through the calculation of EV/EBITDA using figures from an Income Statement. 
financial_ratio
valuation_metric

Earnings Per Share  This earnings per share template helps you calculate basic and diluted EPS given information on common and preferred shares. 
financial_ratio
calculation

EBITDA Margin  This EBITDA margin template shows you how to calculate EBITDA margin using revenue amounts and EBITDA. 
financial_ratio
profitability_ratio

Economic Value Added  This economic value added template guides you to compute EVA using the amount of capital invested, WACC and NOPLAT. 
financial_measure
profitability

Market Risk Premium  This market risk premium template will show you how to compute the market risk premium using the expected rate of return and riskfree rate. 
financial_measure
market_risk_premium

Perpetuity Calculator  This perpetuity calculator shows you how to compute present value of perpetuity and perpetuity with growth. 
cash_flows
present_value
perpetuity

EBIT vs EBITDA  This EBIT vs EBITDA template will help you distinguish between EBIT and EBITDA calculations. 
financial_measure
ebit
ebitda

XIRR vs IRR  This XIRR vs IRR template allows you to differentiate between the use of IRR and XIRR functions to compute the internal rate of return. 
financial_measure
internal_rate_of_return

Debt Equity Ratio  This debt equity ratio template shows you how to calculate D/E ratio given the amounts of shortterm and longterm debt and shareholder's equity. 
financial_measure
valuation

Quick Ratio  This quick ratio template helps you calculate the quick ratio given the amount of cash, marketable securities, accounts receivable and accounts payable. 
financial_measure
liquidity_ratio

Diluted EPS Formula  This diluted EPS formula template shows you how to compute the diluted earnings per share using information from income statement and an employee option schedule. 
financial_measure
diluted_eps

Margin of Safety  This margin of safety template will allow you to calculate the margin of safety given the profits and breakeven point. 
financial_measure
profitability
breakeven_point

Exchange Ratio  This exchange ratio template shows you how to calculate an exchange ratio using the offer price for the target's shares and the acquirer's share price. 
financial_ratio
exchange_ratio

Comparable Company Analysis  This comparable company analysis template demonstrates how to compute and compare valuation ratios of industry competitors. 
financial_ratios
valuation

Present Value of Growth Opportunities  This present value of growth opportunities template shows you how to calculate the PVGO given the market price of stock, required rate of return and expected earnings. 
financial_measure
pvgo

Expected Return  This expected return template will demonstrate the calculation of expected return for a single investment and for a portfolio. 
financial_measure
expected_return

Adjusted Present Value  This adjusted present value template guides you through the calculation of APV starting with the value of unlevered project and PV of debt financing. 
valuation
financial_measure

Markup Calculator  This markup calculator shows you how to compute the markup amount and percentage given the selling price and cost of purchase. 
financial_ratio
markup

Crossover Rate  This crossover rate template will demonstrate how to calculate the NPV of different projects and plot the NPV profiles to identify the crossover rate. 
valuation_ratio
crossover_rate

Cost of Preferred Stock Calculator  This cost of preferred stock calculator shows you how to calculate the cost of preferred stock given the dividend, stock price and growth rate. 
financial_measure
calculation

Salvage Value  This salvage value template shows the calculation of salvage value of an equipment. 
financial_measure
salvage_value

Unlevered FCF  This unlevered FCF template will show you how to compute the unlevered free cash flows with EBIT, tax, depreciation & amortization, change in NWC and Capex. 
financial_measure
unlevered_fcf

Treasury Stock Method Calculator  This treasury stock method calculator helps you find the additional shares outstanding using the formula: Additional shares outstanding = Additional shares (1  Strike Price / Average Price) 
treasury_stock
calculator

Sharpe Ratio Calculator  This sharpe ratio calculator template demonstrates the calculation of sharpe ratio to determine an investment's performance relative to risk. 
financial_ratio
sharpe_ratio

Target Costing  This target costing template shows you how to find the target cost given the selling price and profit margin. 
financial_measure
target_costing

Operating Income  This operating income template shows you how to calculate operating income using line items from the income statement. 
financial_measure
operating_income

Straight Line Depreciation  This straight line depreciation template demonstrates how to calculate depreciation expense using the straight line depreciation method. 
financial_measure
depreciation

Return on Equity  This return on equity template helps you calculate the ROE using the formula: ROE = Net Income / Shareholder’s Equity 
financial_ratio
roe

Weighted Average Shares Outstanding  This weighted average shares outstanding template shows you how to calculate the weighted average shares outstanding using quarterly data. 
calculation
shares_outstanding

Cost of Goods Sold  This cost of goods sold template demonstrates three methods of COGS accounting: FIFO, LIFO and weighted average. 
financial_measure
cogs

Fixed Asset Turnover  This fixed asset turnover template teaches you how to calculate the fixed asset turnover ratio using the formula: Fixed Asset Turnover = Net Sales / Average Fixed Assets. 
financial_ratio

Unlevered Cost of Capital  This unlevered cost of capital template shows you how to compute the unlevered cost of capital given the risk free rate, unlevered beta and expected market return. 
financial_measure
cost_of_capital

Variance Formula  This variance formula template helps you find out the variance between actual and forecast financial figures. 
financial_measure
variance

Variance Analysis  This variance analysis template guides you through the process of variance analysis using the column method. 
financial_measure
variance

NOPAT  This NOPAT template shows you how to calculate the net operating profit after tax using the income statement. 
financial_measure
profit

Forward P/E Ratio  This forward P/E ratio template helps you find out the forward P/E ratio given the share price and earnings per share of stocks. 
financial_ratio
valuation

Economic Order Quantity  This economic order quantity template helps you identify the optimal order quantity which minimizes the cost of ordering and holding inventory. 
financial_measure
eoq

Geometric Mean  This geometric mean template helps you compare investment options by calculating the final value of investments using geometric mean. 
financial_calculation

Payback Period  This payback period template will help you visualize and determine the period of time a company takes to recoup its investment. 
financial_calculation
payback

Net Income  This net income template shows you the calculation of net income using line items from an income statement. 
financial_measure
net_income

Free Cash Flow  This free cash flow template shows you how to calculate free cash flow using a cash flow statement. 
financial_measure
fcf

Equity Risk Premium  This equity risk premium template shows you how to calculate equity risk premium given the riskfree rate, beta of stock and expected return on the market. 
financial_measure
capm

Days Sales Outstanding  This days sales outstanding template demonstrates the calculation of the number of days it takes to collect all accounts receivable. 
financial_measure
accounts_receivable

Capital Gains Yield Calculator  This capital gains yield calculator demonstrates how to calculate the capital gains yield using the purchase price and current price of a stock. 
financial_calculation
capital_gains_yield

Contribution Analysis  This contribution analysis template helps you calculate the total and per unit contribution margin. 
financial_measure
contribution_margin

Funds From Operations  This funds from operations template allows you to calculate the FFO using the formula: FFO = Net Income + (Depreciation expense + Amortization expense + Losses on sale of assets) – (Gains on sale of assets + Interest income) 
financial_measure
ffo

Net Identifiable Assets  This net identifiable assets template will show you how to calculate the net identifiable assets given the value of assets and liabilities of an acquired company. 
financial_measure
calculation

Earnings Before Tax  This earnings before tax template shows you how to calculate the earnings before tax using line items in the income statement. 
financial_measure
EBT

Leveraged Finance  This leveraged finance template shows the calculation of internal rate of return of an investment with different levels of leverage. 
financial_measure
leveraged_finance

LTM Revenue  This LTM revenue template demonstrates the calculation of lasttwelvemonth revenue. 
financial_measure
revenue

Sharpe Ratio Table  This sharpe ratio table template demonstrates the calculation of sharpe ratio given the expected portfolio return, riskfree rate and standard deviation of the portfolio return. 
financial_ratio
sharpe_ratio

Earnings Before Interest & Taxes  This earnings before interest & taxes template helps you calculate enterprise value, EBIT and the EV/EBIT ratio. 
financial_measure
EBIT

Cost Behavior Analysis  This cost behavior analysis template shows you how a cost changes with changes in the level of activity relating to that cost. 
cost_behavior_analysis

Revenue Variance Analysis  This revenue variance analysis template demonstrates how to use the columnbased approach to calculate the three different types of revenue variance. 
variance_analysis
revenue

Proforma Earnings Per Share  This proforma earnings per share template shows you how to calculate the earnings per share assuming a merger and acquisition takes place. 
financial_measure
eps

Price/Earnings to Growth Ratio Template  This price/earnings to growth ratio template shows you the calculation of PEG ratio given the share price, EPS and EPS growth rate. 
financial_ratio
peg_ratio

Contribution Margin Ratio  This contribution margin ratio template shows you how to calculate the contribution margin, CM percentage and breakeven point. 
financial_ratio
contribution_margin

Days Sales in Inventory  This days sales in inventory template will show you how to find average number of days or time required for a business to convert its inventory into sales. 
financial_measure
inventory

Liquidation Value  This liquidation value template helps you compute the liquidation value given a company's total liabilities and assets in auction value. 
financial_measure
liquidation_value

Additional Paid in Capital  This additional paid in capital template demonstrates the calculation of additional amount of capital paid by investors. 
share_value
capital

Burn Rate  This burn rate template demonstrates how to calculate the gross and net burn rate of cash of a company earning negative profit. 
financial_measure
cash_pool
burn_rate

Working Capital Cycle  This working capital cycle template shows you how to calculate the working capital cycle given the inventory days, receivable days and payable days. 
financial_measure
working_capital

Market Capitalization  This market capitalization template helps you differentiate between market capitalization and enterprise value. 
financial_measure
market_cap

Revenue Run Rate  This revenue run rate template shows you how to calculate the annualized revenue. 
financial_measure
revenue
run_rate

Adjusted EBITDA  This adjusted EBITDA template will guide you through the calculation of adjusted EBITDA by removing any onetime items from EBITDA. 
financial_measure
ebitda

CVP Analysis  This CVP analysis template helps you perform a breakeven analysis, calculate margin of safety and find the degree of operating leverage. 
financial_measure
analysis

Sales Tax Decalculator  This sales tax decalculator template will help you calculate the pretax price of a good or service when the total price and tax rate are known. 
financial_calculation
pretax

Net Debt Calculator  This net debt calculator helps you compute the net debt using the formula: Net debt = Shortterm debt + Longterm debt – Cash and equivalents 
financial_calculation
net_debt

Intrinsic Value  This intrinsic value template will demonstrate the calculation of intrinsic value using the discount rate method and certainty factor method. 
financial_measure
intrinsic_value

Dilution  This dilution template helps you identify the impact of dilutive securities on the share price. 
financial_measure
dilution

Depreciation Methods  This depreciation methods template will show you the calculation of depreciation expenses using four types of commonly use depreciation methods. 
financial_calculation
depreciation

Net Present Value  This net present value template helps you calculate net present value given the discount rate and undiscounted cash flows. 
financial_measure
npv

Marginal Cost of Production  This marginal cost of production template will show you how to calculate different types of marginal costs. 
financial_calculation
marginal_cost

Debt to Asset Ratio  This debt to asset ratio template will show how to calculate the Debt/Asset ratio given the amount of assets, shortterm and longterm debt. Here is a preview of the debt to asset ratio template: 
financial_ratio
debt_to_asset

Beta Calculator  This beta calculator allows you to measure the volatility of returns of an individual stock relative to the entire market. 
calculation
beta

Cost of Equity Calculator  This cost of equity calculator helps you calculate the cost of equity given the risk free rate, beta and equity risk premium. 
financial_ratio
cost_of_equity

Common Size Analysis  This common size analysis template allows you to compare the financial performance of companies in different sizes on the same scale. 
financial_analysis
common_size

Effective Annual Rate Calculator  This effective annual rate calculator will help you compute the effect annual rate given the nominal interest rate and the number of compounding periods. 
financial_measure
interest_rate

Profit Margin  This profit margin template will allow you to calculate the gross profit, EBITDA, and net profit margins. 
financial_measure
profit_margin

Value Added  This Value Added Excel Template, shows an example of a Gross Value Added and Net Value Added Calculation 
financial_measure
financial_calculation

ROIC Calculator  This ROIC Excel Template will aid you in calculating the NOPAT and Book Value of Invested Capital, and from these elements calculate the period ROIC. 
financial_measure
financial_ratio
profitability_ratio

ROI Calculator  This Return on Investment Excel Calculator will aid you in calculating the Return on investment for different scenarios. 
financial_measure
financial_ratio

Operating Margin Template  This Operating Margin Excel Template is a helpful tool to calculate Operating Margin, this will be done using a simplified version of the income statement 
financial_measure
financial_ratio
profitability_ratio

Cash EPS Calculator  This Cash EPS calculator will help you calculate the number of shares outstanding, the cash from operations, and from these elements calculate the Cash EPS 
financial_ratio
financial_measure

Coupon Rate Calculator  This coupon rate template will calculate a bonds coupon rate based on the total annual coupon payments and the face value of the bond. 
bond_calculator
calculation

Profitability Index Template  This Profitability Index template will help visualize the Present Value of future cash flows which will then be used to calculate the PI of the project. 
project_analysis
financial_calculator

LTV/CAC Ratio Template  This LTV/CAC Ratio Template will help calculate both the LTV and CAC of a company's user base. These will then be used to obtain the LTV/CAC Ratio. 
financial_calculation
Startup
eCommerce

Marginal Revenue Calculator  This Marginal Revenue Calculator will aid you in calculating the marginal revenue given the units of production of two consecutive periods. 
financial_calculations
financial_performance
marginal_revenue

Gross Margin Ratio Calculator  This Gross Margin Ratio Calculator template will compute the gross profit margin given the Revenue and the Cost of Goods Sold 
financial_calculations
financial_measure

Accumulated Depreciation Calculator  This Accumulated Depreciation Calculator will help you compute the period accumulated Depreciation, given the Purchase Price, Useful Life, and Salvage Value 
financial_calculation
Equipment

ActivityBased Costing Calculator  This Activitybased costing calculator template is a great tool to breakdown overhead costs through Activity Based Costing. 
financial_calculation
Overhead_costs

Alpha Calculator  This Alpha Calculator will compute the value of Alpha based on the Capital Asset Pricing Model. 
CAPM
financial_calculation

Interest Rate Calculator  This interest Rate Calculator will help you compute the effective interest rate based on the number of periods, type of interest rate (simple vs compound), and initial balance amount. 
financial_calculation
interest_rate

EV to Revenue Multiple  This Enterprise Value (EV) to Revenue Multiple Calculator will aid in determining the Enterprise Value based on both the Equity Value and Debt Value, from the EV it will then calculate the EV to Revenue multiple. 
EV_Multiple
financial_calculator

Current Ratio Calculator  This Current Ratio Calculator will help you calculate the current ratio given the sum of all current assets and current liabilities. 
financial_calculator
balance_sheet

DPS Calculator  This Dividend Per Share (DPS) Calculator template will help you calculate the total amount of dividend attributed to each individual share outstanding of a company. 
DPS
financial_calculation

Operating Profit Margin Calculator  This Operating Profit Margin calculator will help you determine the operating profit margin, given the operating profit and total revenue 
financial_calculation
financial_measure

CAGR Calculator  This CAGR calculator will help you determine the compound annual Growth rate of an investment 
financial_measure
financial_calculator

Gross Profit Calculator  This Gross Profit Calculator will help you visualize how to achieve the Gross Profit value on the Income Statement. 
income_statement
financial_calculation

Product Costs  This Product Costs Template will help break down the Product Costs into the costs of Direct Material (DM), Direct Labour and Manufacturing Overhead (MOH). 
financial_measure
cost_breakdown

Debt Service Coverage Ratio  This debt service coverage ratio template will help you calculate the debt service coverage ratio by both including and excluding Capex. 
financial_ratio
coverage_ratio

FCFF vs FCFE Reconciliation  This FCFF vs FCFE Reconciliation Template allows you to reconcile Free Cash Flow to Fim (FCFF) vs Free Cash Flow to Equity (FCFE). 
FCF
FCFF
FCFE
Reconciliation

Year over Year Analysis (YoY)  This Year over Year Analysis (YoY) template demonstrates how to perform a YoY analysis using financial data. 
year_over_year
yoy
financial_analysis

EBITDA  This EBITDA template will show you how to calculate EBITDA using the income statement and cash flow statement. 
EBITDA
financial_metric

Charts and Graphs Template  This charts and graphs template provides you with 10 different types of charts and graphs used in financial planning and analysis. 
charts
graphs

Efficient Frontier and CAL  This efficient frontier and CAL template demonstrates how to construct a portfolio frontier and CAL line chart to find the optimal portfolio. 
chart
capital_allocation_line

Waterfall Chart  This waterfall chart template guides you stepbystep to construct a waterfall chart using raw data. 
chart
waterfall

Football Field Chart  This football field chart template can be used to summarize a range of values for a business, based on different valuation methods. 
chart
football_field_chart

Gantt Chart  This Gantt chart template will help you build a project schedule using a bar chart. 
chart
gantt_chart

Bullet Chart  This bullet chart template teaches you how to create a bullet chart from scratch to compare actual versus forecasted performance. 
chart
bullet_chart

Bloomberg Functions  This Excel spreadsheet contains a list of some of the most common and important functions, keystrokes and shortcuts to know on the Bloomberg Terminal. 
functions
shortcuts
bloomberg

Excel for Finance Functions  This Excel template demonstrates sample calculations using the top 10 most important functions and formulas for finance professionals. 
excel
finance_functions

Sheet Name Code  This sheet name code template allows you to display the name of an Excel sheet in a cell using a combination of formulas. 
excel
sheet_name

Looking for more advanced models? Download over 15 premium financial model templates in CFI’s Financial Modeling Templates Package.
The library package includes a wide range of advanced spreadsheets that will help you accelerate your career in investment banking, equity research, corporate development, private equity, financial planning & analysis (FP&A) and other areas of corporate finance.
Thank you for browsing CFI’s free resource library! To continue learning and advancing your career as a financial analyst these additional resources will be helpful for you.