Profit and Loss Template
Download CFI’s free P&L template and Excel file. Enter your own numbers and edit both the monthly and annual worksheets.
Waterfall Chart Template
Get the free Excel waterfall chart template, a great way to graph changes and impacts of financial metrics in Excel
Budget Template
For effective business planning, it is critical to have a good budget template that tracks revenues and expenses and is easy to use
3 Statement Financial Model
Download CFI’s free 3 statement financial model to learn how the income statement, balance sheet, and cash flow statement are linked
Cash Flow Statement
Download the cash flow statement template to portray a company’s cash from operations, investing, and financing
DCF Model
Download a free DCF model template to calculate the net present value (NPV) of a business using a discount rate and free cash flow
List of Financial Model Templates
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 world-class financial analyst.
Financial Models and Schedules
| 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 early-stage 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 |
| Personal Finance Budget | This personal budget template will help you determine the state of your finances and help plan your monthly or annual spending. | financial_model personal_budget finance_budget |
| Capital Investment Model | This capital investment model helps you calculate key valuation metrics of a capital investment including the cash flows, net present value (NPV), internal rate of return (IRR), and payback period. | financial_model capital_investment npv irr payack |
| Financial Synergy Valuation Model | This Financial Synergy Valuation Excel Model enables you – with the beta, pre-tax cost of debt, tax rate, debt to capital ratio, revenues, operating income (EBIT), pre-tax return on capital, reinvestment rate and length of growth period – to compute the value of the global synergy in a merger. | financial_model valuation financial_synergy |
| Stable Growth vs 2 Stage Valuation Model | This Stable Growth vs 2 Stage Valuation Model will help you determine firm value based on different growth assumptions for a business. | financial_model valuation growth FCFF FCFE |
| Airline Industry Comps Template | This free airline industry comps template allows the user to perform a simple comparable company analysis within the airline industry. | financial_model template valuation comparables comps |
| Retail Industry Comps Template | This free retail industry comps template allows the user to perform a simple comparable company analysis within the retail industry. | financial_model template valuation comparables comps |
| Pharmaceutical Industry Comps Template | This free pharmaceutical industry comps template allows the user to perform a simple comparable company analysis within the pharmaceutical industry. | financial_model template valuation comparables comps |
Premium Templates
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.
Financial Calculations
| 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 risk-free 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 NOPAT. | 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 risk-free 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 short-term and long-term 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 break-even 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 risk-free 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 last-twelve-month revenue. | financial_measure revenue |
| Sharpe Ratio Table | This sharpe ratio table template demonstrates the calculation of sharpe ratio given the expected portfolio return, risk-free 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 column-based 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 one-time items from EBITDA. | financial_measure ebitda |
| CVP Analysis | This CVP analysis template helps you perform a break-even 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 pre-tax price of a good or service when the total price and tax rate are known. | financial_calculation pre-tax |
| Net Debt Calculator | This net debt calculator helps you compute the net debt using the formula: Net debt = Short-term debt + Long-term 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, short-term and long-term debt. | 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 |
| Activity-Based Costing Calculator | This Activity-based costing calculator template is a great tool to break-down 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 |
| Justified Price-to-Earnings Ratio | This Justified P/E Ratio template will allow you to calculate and compare justified price-to-earnings ratio and the standard price-to-earnings ratio in Excel. | financial_ratio justified_PE_ratio |
| P/E Ratio | This P/E ratio template will show you how to calculate the Price-to-Earnings multiple using share price and earnings per share. | financial_ratio valuation PE_ratio |
| Net Profit Margin | This Net Profit Margin template will show you how to calculate the net profit margin using a company's income statement line items. | financial_ratio net_profit_margin |
| ROCE Template | This Return on Capital Employed (ROCE) template will help you calculate the profitability ratio used to measure how efficiently a company is using its capital. | profitability_ratio financial_ratio roce |
| Interest Coverage Ratio | This Interest Coverage Ratio template will guide you through the calculation of interest coverage ratio using an income statement. | leverage_ratio interest_coverage_ratio |
| Net Debt/EBITDA Ratio | This Net Debt/EBITDA Ratio template will show how to calculate the interest coverage ratio using the formula: (Short Term Debt + Long Term Debt - Cash and Cash Equivalent) / EBITDA. | leverage_ratio net_debt_EBITDA_ratio |
| Operating Cash Flow Ratio | This Operating Cash Flow Ratio template will show you how to calculate the operating cash flow ratio, deriving from the formula: operating cash flow divided by current liabilities. | liquidity_ratio operating_cash_flow_ratio |
| Year to Date (YTD) Template | This Year to Date (YTD) template will guide you on how to calculate the year to date return on a portfolio or a stock for different end dates. | year_to_date portfolio_return |
| Days Inventory Outstanding | This Days Inventory Outstanding Template will show you how to arrive at the number of days inventory outstanding using the formula: Average Annual Inventory / Cost of Sales x # of Days in Period. | days_inventory_outstanding DIO |
| Cash Conversion Ratio | This Cash Conversion Ratio Template will demonstrate how to calculate the cash conversion rate using the income statement and cash flow statement. | cash_conversion_ratio liquidity_ratio |
| Dividend Coverage Ratio | This Dividend Coverage Ratio Template will show you the calculation for dividend coverage ratios for common shareholders and preferred shareholders. | dividend_coverage_ratio common_shareholders preferred_shareholders |
| Accounts Payable Turnover Ratio | This Accounts Payable Turnover Ratio Template will show you how to calculate payable turnover ratio and payable turnover in days. | accounts_payable_turnover working_capital |
| Accounts Receivable Turnover Ratio | This Accounts Receivable Turnover Ratio Template will show you how to calculate receivable turnover ratio and receivable turnover in days. | accounts_receivable_turnover working_capital |
| Cash Ratio | This Cash Ratio Template will show you how to calculate the cash ratio which measures a company’s ability to pay off short-term debt obligations with cash and cash equivalents. | financial_ratio cash_ratio liquidity_ratio |
| Fixed Charge Coverage Ratio | This Fixed Charge Coverage Ratio Template will show you how to compute the fixed charge coverage ratio using annual expenses and EBIT figures. | financial_ratio fixed_charge coverage_ratio |
| Acid Test Ratio | This Acid Test Ratio Template will show you how to calculate the acid test ratio the formula: (Current Assets - Inventory) / Current Liabilities. | financial_ratio acid_test quick_ratio |
| Dividend Payout Ratio | This Dividend Payout Ratio Template will show you how to calculate the dividend payout ratio using the formula: DPR = Total dividends / Net income. | financial_ratio dividend_payout_ratio |
| Present Value Calculator | This Present Value Calculator will help you compute the correct present value for an annuity or future investment. | cash_flows present_value annuity |
| T-Accounts | This T-Accounts Template will help you grasp how to use T-Accounts to track transactions. | t_accounts accounting journal_entries bookkeeping |
| Cost of Debt Calculator | This cost of debt calculator will help you use Excel to find the cost of debt using information from a company's issued debt. | cost_of_debt fixed_income bonds yield_to_maturity |
| Journal Entry Guide | This journal entries guide will help you learn the structure of a general ledger and enter journal entries yourself. | accounting journal_entries general_ledger |
| Inventory Turnover Calculator | This inventory turnover calculator can be used to compute both an inventory turnover ratio and inventory days from an income statement and balance sheet. | inventory_turnover ratios accounting finance |
| Double Declining Balance Depreciation Template | This double declining balance depreciation template will help you find depreciation expense using one of the most common depreciation methods. | depreciation double_declining_balance |
| FIFO Calculator | This FIFO calculator will help you determine the cost of goods sold and the remaining inventory value after an amount of sales based on the FIFO method. | accounting FIFO first_in_first_out |
| LIFO Calculator | This LIFO calculator will help you determine the cost of goods sold and the remaining inventory value after an amount of sales based on the LIFO method. | accounting LIFO last_in_first_out |
| Pre Money Post Money Valuation Analysis Template | This Pre Money Post Money Valuation Analysis Template will help you calculate the post money valuation of a company undergoing a Series X funding round. | pre_money post_money valuation equity_value |
| Equity Template | This Equity Template will allow you to calculate a company's book value and market value of equity using the accounting method and financial analysis method. | equity market_value book_value accounting_method financial_analysis |
| Inflation Calculator | This Inflation Calculator will help you determine the true value of money over time after accounting for inflation. | finance inflation time_value_of_money |
| Excel Invoice Template | This excel invoice template will provide a guideline to help you create a sales invoice to keep record of transactions. Use and modify this template to create your own invoice! | invoice sales_invoice transaction |
| Black Scholes Calculator | This Black Scholes calculator uses the Black-Scholes option pricing method to help you calculate the fair value of a call or put option. | black_scholes_option_pricing black_scholes option put call |
| Portfolio Beta Template | This portfolio beta template will help you calculate the weighted average beta of all of the stocks in your investment portfolio. | beta portfolio_beta capm |
| Piotroski F Score Calculator | This Piotroski F score calculator will help you assess the strength of a company’s financial state. | piotroski_f_score stocks investing |
| Aging Report Template | This aging report template will help you categorize accounts receivables by how long invoices have been outstanding, as well as calculate your allowance for doubtful accounts. | accounting aging aging_report accounts_receivables |
| Capital Adequacy Ratio (CAR) Calculator | This Capital Adequacy Ratio (CAR) calculator determines the CAR as a percentage to help evaluate a bank's financial strength based on the ability to absorb losses. | financial_ratio Capital_Adequacy_Ratio |
| Put-Call Parity Calculator | The put-call parity is an important concept in options pricing which shows how the prices of puts, calls, and the future underlying asset must be consistent with one another. | Put_Call_Parity Option Put Call |
| Interest Rate Parity (IRP) Calculator | Interest rate parity (IRP) shows the relationship between the spot exchange rate and expected exchange rate for two countries, based on interest rates. | Interest_rate_parity financial_calculator |
| Bank Balance Sheet Ratio Calculator | The Bank Balance Sheet Ratio Calculator is a tool that you can use to determine a bank's financial stability and liquidity using items found on a balance sheet. Using the inputs, the calculator will produce ratios that are important for the analysis of a bank's balance sheet. | Bank_Balance_Sheet_Ratio_Calculator |
| Bank Income Statement Ratio Calculator | The Bank Income Statement Ratio Calculator can determine a bank's profitability, efficiency, and growth through information found on an income statement. | Bank_Income_Statement_Ratio_Calculator |
| Bank Mixed Statement Ratio Calculator | The Bank Mixed Statement Ratio Calculator can be used to determine a bank's profitability and financial strength using items found on an income statement and balance sheet. | Bank_Mixed_Statement_Ratio_Calculator |
| Home Equity Line of Credit (HELOC) Calculator | The Home Equity Line of Credit (HELOC) calculator can calculate the maximum line of credit available for a homeowner. | Home_Equity_Line_of_Credit_(HELOC)_Calculator |
| Telecommunication Industry Comps Template | The telecommunication industry comps template allows investors to compare one telecommunication company to other ones in the same industry. | Telecommunication_Industry_Comps_Template |
| Banking Industry Comps Template | The banking industry comps template allows investors to compare one banking company to other ones in the same industry. | Banking_Industry_Comps_Template |
| Cable Industry Comps Template | The cable industry comps template allows investors to compare one cable company to other ones and to the industry as a whole. | Cable_Industry_Comps_Template |
Charts and Graphs
| 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 step-by-step 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 |
Functions and Shortcuts
| 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 |
| RATE Function | This RATE function template will help you find the interest rate of an annuity in Excel | excel rate interest_rate annuity |
Premium Templates
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.
Additional Resources
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.
