DCF Format: Standard Valuation Layout, Worked Example, and Data Tools

Our team's DCF format is a three-block spreadsheet layout with an assumptions table, a multi-year cash flow schedule, and a valuation summary that discounts future cash flows to find value per share. According to the U.S. Bureau of Labor Statistics Occupational Outlook Handbook, the 443,100 financial analysts employed in the United States in 2025 examine financial statements and use mathematics and financial modeling to determine security values and forecast future growth. For survey and census data processing, the U.S. Census Bureau provides the Census and Survey Processing System (CSPro).

Updated

Two contexts for DCF format: financial modeling and data software

Searchers looking up DCF format are typically building a financial valuation model or working with survey data software. According to the U.S. Bureau of Labor Statistics Occupational Outlook Handbook, financial and investment analysts conduct quantitative analyses of information involving investment programs or financial data of public or private institutions, and use financial modeling to forecast earnings growth or price movements. In our team's modeling guide below, we structure a Discounted Cash Flow (DCF) format to project operating cash flows, discount them to present value, and bridge to an implied share price.

In government statistics and survey processing, researchers use the U.S. Census Bureau's Census and Survey Processing System (CSPro) to enter, edit, tabulate, and disseminate census and survey data. Sections two through seven walk through our team's financial DCF model format and worked example, and section eight covers CSPro and U.S. Census Bureau technical documentation.

Standard DCF layout: our team's unlevered vs. levered template

To keep your model easy to audit, organize your DCF sheet from top to bottom and left to right with no hardcoded numbers hidden inside formulas. We recommend dividing the tab into three vertical blocks: operating and discount rate assumptions at the top, historical and projected free cash flows in the middle, and the valuation bridge with sensitivity tables at the bottom. Map one fiscal year per column and align columns across your Income Statement, Balance Sheet, Cash Flow Statement, and DCF tabs.

Use consistent color coding so another analyst can review your file quickly: blue font for hardcoded inputs, black font for same-sheet formulas, and green font for links from other tabs. For U.S. public companies, pull reported statements directly from periodic reports, registration statements, and XBRL financial statement data in the SEC EDGAR database.

Before writing formulas, choose whether to build an unlevered DCF format or a levered DCF format. In our team's modeling framework, an unlevered DCF values operating cash flows before debt service, while a levered DCF projects cash flows after debt service.

  • Block 1 (Assumptions and Discount Rate): Revenue growth, margin targets, effective tax rate, CapEx and working capital ratios, and discount rate inputs.
  • Block 2 (Cash Flow Schedule): Historical actuals from SEC EDGAR filings on the left and explicit annual projections down to Free Cash Flow on the right.
  • Block 3 (Valuation and Sensitivities): Present value of explicit cash flows and Terminal Value, enterprise-to-equity bridge, diluted share count, implied share price, and two-way sensitivity matrices.

Our team's comparison of unlevered vs. levered DCF modeling setups

Our team's comparison of unlevered vs. levered DCF modeling setups
Model ElementUnlevered DCF Setup (Our Template)Levered DCF Setup (Our Template)
Cash flow projectedUnlevered Free Cash Flow (before debt service)Levered Free Cash Flow (after debt service)
Starting profit metricOperating income (EBIT) less taxes on EBIT (NOPAT)Net income after interest expense and taxes
Debt interest and principalLeft out of cash flows (handled in discount rate and bridge)Subtract interest and debt repayments, add new debt borrowings
Discount rate appliedBlended cost of debt and equity (WACC)Cost of equity
Immediate valuation outputImplied Enterprise Value (then bridged to Equity Value)Implied Equity Value directly

Unlevered free cash flow schedule: row-by-row template

In our team's unlevered DCF template, we project the cash left for all capital providers after operating expenses, taxes on operating profit, capital expenditures (CapEx), and working capital changes.

When you build this schedule, watch two details in your formulas. First, apply your effective tax rate directly to EBIT rather than copying levered income tax expense, so you keep financing effects out of operating cash flow. Second, track Net Working Capital (NWC) as non-cash current assets minus non-debt current liabilities, subtracting an increase in NWC and adding a decrease.

  • Row 1: Revenue = Prior Year Revenue * (1 + Revenue Growth Rate), or unit volume times average price.
  • Row 2: Less COGS and SG&A (excluding D&A) = EBITDA.
  • Row 3: Less Depreciation and Amortization (D&A) = Operating Income (EBIT).
  • Row 4: Less Taxes on EBIT (EBIT * Effective Tax Rate) = Net Operating Profit After Tax (NOPAT).
  • Row 5: Plus D&A (added back as a non-cash charge).
  • Row 6: Less Capital Expenditures (CapEx).
  • Row 7: Less Increase in Net Working Capital (Current Year NWC minus Prior Year NWC).
  • Row 8: Equals Unlevered Free Cash Flow = NOPAT + D&A, CapEx, Change in NWC.

Discounting, terminal value, and the equity value bridge

In our template, we discount projected unlevered cash flows using a Weighted Average Cost of Capital (WACC) that blends the cost of equity and after-tax cost of debt. When discounting in a spreadsheet, make sure your present value formula starts in Forecast Year 1 rather than the historical base year.

Once your explicit forecast reaches a steady state, estimate Terminal Value at the end of the projection window and discount it to present value. We recommend running both a perpetuity growth formula and an exit multiple formula side by side to cross-check your assumptions. When picking a long-run perpetual growth rate g, compare your assumption against inflation benchmarks. Consumer Price Index data from the U.S. Bureau of Labor Statistics show a September 2026 12-month percent change (not seasonally adjusted) of 3.7% for all items and 2.6% for all items less food and energy, following a 2.9% annual CPI increase from December 2023 to December 2024 and a 0.4% seasonally adjusted monthly rise in October 2026.

Finally, sum the present values of explicit cash flows and Terminal Value to get Implied Enterprise Value, bridge to Equity Value by subtracting debt-like claims and adding cash, and divide by diluted shares.

  • WACC formula in our template: WACC = (E / (E + D)) * Cost of Equity + (D / (E + D)) * Pre-Tax Cost of Debt * (1, Tax Rate).
  • Year-end discount factor formula: =1 / ((1 + $C$5) ^ G$8), where $C$5 is WACC and Row 8 holds forecast period numbers 1, 2, 3, 4, 5.
  • Mid-year discount factor formula: =1 / ((1 + $C$5) ^ (G$8, 0.5)), which discounts cash flows half a period earlier than year-end.
  • Perpetuity growth Terminal Value formula: Terminal Value = Final Year UFCF * (1 + g) / (WACC, g).
  • Implied Enterprise Value = Present Value of Forecast UFCFs + Present Value of Terminal Value.
  • Implied Equity Value = Enterprise Value, Total Debt, Preferred Stock, Noncontrolling Interest + Cash + Non-Operating Assets.
  • Option dilution formula: Net New Shares = In-the-Money Options, ((In-the-Money Options * Strike Price) / Implied Share Price).

Worked DCF model example: Harborline Industrial Corp.

Invented example written by our team. Harborline Industrial Corp. and all figures below are hypothetical case data showing our DCF math step by step.

Harborline reported $200.00 million of Year 0 revenue and adds $20.00 million per year over a 5-year forecast to reach $300.00 million in Year 5. EBITDA margin holds at 25.0%, D&A is 5.0% of revenue (leaving a 20.0% EBIT margin), the effective tax rate is 25.0%, CapEx is 6.0% of revenue, and NWC increases by 10.0% of annual dollar revenue growth ($2.00 million per year). With a 4.40% risk-free rate, 1.10 beta, and 6.00% equity risk premium, Cost of Equity is 4.40% + (1.10 * 6.00%) = 11.00%. At an 8.00% pre-tax cost of debt and 25.0% tax rate, after-tax cost of debt is 6.00%. Weighting 80.0% equity and 20.0% debt yields WACC = (0.80 * 11.00%) + (0.20 * 6.00%) = 10.00%.

Discounting the five UFCF years at 10.00% year-end produces a stage-one present value of $128.39 million (summing the two-decimal rounded rows gives $128.40 million). Switching to mid-year discounting multiplies $128.39 million by 1.10^0.5, adding $6.27 million to reach $134.65 million. Under Perpetuity Growth at g = 2.00%, Year 6 UFCF is $40.80 million, Year 5 Terminal Value is $40.80 million / (0.10, 0.02) = $510.00 million, and its year-end present value is $510.00 million / 1.10^5 = $316.67 million. Adding $128.39 million and $316.67 million gives an Enterprise Value of $445.06 million (71.2% from Terminal Value). Cross-checking with a 7.00x Year 5 EBITDA ($75.00 million) Exit Multiple gives a $525.00 million Terminal Value (implying 2.21% perpetual growth), $325.98 million present value, and $454.37 million Enterprise Value.

On the $445.06 million Perpetuity Growth valuation, Harborline carries $80.00 million of debt, $25.00 million of cash, $10.00 million of preferred stock, and $5.00 million of noncontrolling interest (a $70.00 million net subtraction), yielding $375.06 million in Equity Value. With 14.50 million basic shares and 1.00 million options at a $12.50 strike, option proceeds repurchase 0.50 million shares at $25.00 per share, leaving 15.00 million diluted shares and an intrinsic value of $25.00 per share ($25.62 under the 7.00x Exit Multiple).

Worked 5-year Unlevered Free Cash Flow schedule: Harborline Industrial Corp. (invented example, $ millions)

Worked 5-year Unlevered Free Cash Flow schedule: Harborline Industrial Corp. (invented example, $ millions)
Line Item ($M)Year 0Year 1Year 2Year 3Year 4Year 5
Revenue200.00220.00240.00260.00280.00300.00
EBITDA (25.0% margin)Base year55.0060.0065.0070.0075.00
Less: D&A (5.0% of sales)Base year-11.00-12.00-13.00-14.00-15.00
EBIT (20.0% margin)Base year44.0048.0052.0056.0060.00
Less: Cash Taxes (25.0%)Base year-11.00-12.00-13.00-14.00-15.00
NOPATBase year33.0036.0039.0042.0045.00
Plus: D&A add-backBase year11.0012.0013.0014.0015.00
Less: CapEx (6.0% of sales)Base year-13.20-14.40-15.60-16.80-18.00
Less: Increase in NWCBase year-2.00-2.00-2.00-2.00-2.00
Unlevered Free Cash FlowBase year28.8031.6034.4037.2040.00
PV of UFCF (10.0% WACC, year-end)Base year26.1826.1225.8525.4124.84

Two-way sensitivity matrix for DCF valuation

Do not stop at a single point estimate. Add two 2D sensitivity tables at the bottom of your DCF tab: one flexing WACC against the perpetual growth rate g, and a second flexing WACC against the exit EV/EBITDA multiple. Put your tested g values across the top row and WACC rates down the left column so the reader can see how your share price moves across assumptions.

In our Harborline worked example, using the same cash flows, $70.00 million net bridge deduction, and 15.00 million diluted shares, the implied share price spans $20.57 to $31.46 across the grid below.

Harborline Industrial Corp. implied share price sensitivity across WACC and perpetual growth (invented example)

Harborline Industrial Corp. implied share price sensitivity across WACC and perpetual growth (invented example)
WACC / Perpetual Growth (g)g = 1.5%g = 2.0% (Base)g = 2.5%
WACC = 9.0%$27.58$29.38$31.46
WACC = 10.0% (Base)$23.66$25.00$26.52
WACC = 11.0%$20.57$21.60$22.75
Ten-point checklist to audit your DCF format

Building and checking valuation models is core analyst work. Occupational Outlook Handbook projections show overall financial analyst employment growing 7 percent from 2025 to 2035, generating about 29,500 openings per year on average, with a bachelor's degree as the typical entry-level education. By our calculation from that 2025 employment table, financial and investment analysts accounted for 85.1% of the 443,100 financial analyst jobs (377,200 roles, alongside 66,000 financial risk specialists). In May 2025, the median annual wage was $103,570 for all financial analysts ($102,740 for financial and investment analysts, rising to $124,370 in securities, commodity contracts, and other financial investments), which by our calculation from the May 2025 wage table was 2.03 times the $50,980 median annual wage across all U.S. occupations.

Before sharing a file in technical investment banking interviews, private equity modeling tests, or consulting case study examples with a valuation exhibit, run our ten-point checklist below and pair model drills with behavioral interview practice so you can defend your assumptions clearly.

  • 1. Unlevered taxes: Verify NOPAT taxes are calculated on EBIT, never copied from levered Income Statement taxes.
  • 2. Terminal reinvestment: Confirm terminal D&A does not exceed CapEx unless the asset base is shrinking.
  • 3. Working capital sign: Verify an increase in Net Working Capital is subtracted and a decrease is added.
  • 4. Discount rate match: Pair Unlevered Free Cash Flow with WACC and Levered Free Cash Flow with Cost of Equity.
  • 5. Forecast discounting start: Confirm your discounting formula starts in Forecast Year 1, never Historical Year 0.
  • 6. Mid-year vs. year-end consistency: Apply your chosen discounting timing convention consistently across all explicit forecast years.
  • 7. Implied terminal cross-check: Compute the implied EV/EBITDA multiple from Perpetuity Growth and implied g from your Exit Multiple.
  • 8. Balance sheet bridge dates: Pull debt, cash, preferred stock, and noncontrolling interest from the latest balance sheet as of the valuation date.
  • 9. Dynamic option dilution: Confirm your dilution formula counts only options with strike prices below the implied share price.
  • 10. Formula hygiene: Check every formula row to verify zero hardcoded numbers hide inside black formula cells.

Census and Survey Processing System (CSPro) and government data tools

If you are looking up DCF in the context of survey data processing rather than corporate valuation, the U.S. Census Bureau develops and supports the Census and Survey Processing System (CSPro). Released as CSPro 8.1.4 in August 2026, CSPro is a public domain software package used by hundreds of organizations and tens of thousands of individuals for entering, editing, tabulating, and disseminating census and survey data. Funding for the development and maintenance of CSPro is primarily provided by the U.S. Department of State's Bureau of Global Health Security and Diplomacy (GHSD).

CSPro is designed for Microsoft Windows, combining the features of two previous DOS-based software packages, IMPS and ISSA, and has been actively used worldwide since 2000 across over 160 countries. It processes censuses and surveys of any size, from Djibouti (less than one million people) to Indonesia (more than 235 million), as well as the Demographic and Health Surveys (DHS), Living Standards Measurement Study (LSMS), and Multiple Indicator Cluster Survey (MICS). CSPro also supports data collection on Android phones and tablets through the CSEntry Android app and synchronizes data from Android or Windows devices to a server running CSWeb. To activate the built-in help system in the CSPro desktop application, press F1 or use the Help menu from the main program or any of its tools.

Alongside CSPro, analysts use three federal data platforms to source inputs and benchmarks for models: SEC EDGAR for public company filings, the U.S. Bureau of Labor Statistics Business Employment Dynamics (BDM) program for establishment age and survival data across private sector industries, and the U.S. Census Bureau Population and Housing Unit Estimates technical documentation (including Vintage 2025 and Vintage 2020 methodology statements and file layouts).

Official U.S. government data and software platforms for analysts and researchers

Official U.S. government data and software platforms for analysts and researchers
Platform or ProgramSponsoring AgencyPrimary Capability and Access
Census and Survey Processing System (CSPro 8.1.4)U.S. Census BureauPublic domain software for entering, editing, tabulating, and disseminating census and survey data on Windows and Android (press F1 for built-in help)
EDGAR Search Filings and APIsU.S. Securities and Exchange CommissionFree public access to registration statements, periodic reports, 20+ years of full-text search, and RESTful APIs with XBRL financial statement data
Business Employment Dynamics (BDM)U.S. Bureau of Labor StatisticsNational and state tables on private sector gross job gains and losses, employment, and establishment survival by opening year and age
Population and Housing Unit Estimates DocumentationU.S. Census BureauMethodology statements, release notes, and file layouts for Vintage 2025, Vintage 2020, and intercensal population and housing estimates

From U.S. Bureau of Labor Statistics, Occupational Outlook Handbook: Financial Analysts, U.S. Bureau of Labor Statistics, Consumer Price Index (CPI) Home, U.S. Bureau of Labor Statistics, Establishment Age and Survival Data (BDM), U.S. Securities and Exchange Commission, EDGAR Search Filings, U.S. Census Bureau, Census and Survey Processing System (CSPro), U.S. Census Bureau, CSPro Documentation and U.S. Census Bureau, Population and Housing Unit Estimates Methodology.

1 practice question and sample answer

Say your answer out loud first, then read the sample answer.

Practice question

  1. Walk me through how you structure an unlevered DCF format from top to bottom, and explain how you check whether your Terminal Value makes sense.

    Sample answer. Example answer written by our team. The applicant is invented. I structure an unlevered DCF tab into three vertical blocks: assumptions and WACC at the top, a five-year Unlevered Free Cash Flow forecast in the middle, and the Enterprise-to-Equity bridge with two-way sensitivity tables at the bottom. In the cash flow block, I project revenue and subtract operating expenses and D&A to reach EBIT. Next, I apply the effective cash tax rate directly to EBIT for NOPAT, add back D&A, subtract CapEx, and subtract increases in Net Working Capital to get Unlevered Free Cash Flow. I discount each year's cash flow at WACC using the mid-year convention since cash arrives throughout the year. For Terminal Value at Year 5, I run both the Perpetuity Growth Method and the Exit EV/EBITDA Multiple Method, cross-checking the implied exit multiple and implied perpetual growth rate against each other. Finally, I sum the present values of explicit cash flows and Terminal Value for Enterprise Value, subtract net debt, preferred stock, and noncontrolling interest for Equity Value, and divide by diluted shares.

    It names the three spreadsheet blocks in order, states exact Unlevered Free Cash Flow lines without double-counting the interest tax shield, specifies mid-year discounting, cross-checks both Terminal Value methods, and completes the bridge to diluted share price.

Practice your interview answers out loud

Soreno's AI interviewer asks behavioral and case questions out loud, follows up like a real interviewer, and scores every answer, quoting your own words.

Questions people ask

What are the main sections of a standard DCF format?

In our team's template, a DCF sheet has three vertical blocks: an assumptions and discount rate table at the top, a historical and projected cash flow schedule in the middle, and a valuation summary at the bottom. The valuation summary discounts explicit cash flows and Terminal Value to find Enterprise Value, bridges to Equity Value, divides by diluted shares, and tests assumptions in two-way sensitivity tables.

What role does financial modeling play for financial analysts?

According to the U.S. Bureau of Labor Statistics Occupational Outlook Handbook, financial analysts examine a company's financial statements to determine its value and growth prospects. They use mathematics and financial modeling to determine the value of financial securities, assess risks, and forecast future growth, earnings growth, or price movements.

Where do financial analysts get company filings to populate a DCF format?

For U.S. public companies, analysts pull audited statements from periodic reports and registration statements in the SEC EDGAR system, which offers full-text search across more than 20 years of filings and RESTful APIs containing XBRL financial statement data.

How do I access documentation in CSPro for census and survey applications?

According to U.S. Census Bureau documentation for CSPro 8.1.4, the desktop application includes a built-in help system that you activate by pressing F1 or selecting the Help menu from the main program or any of its tools. The Census Bureau also publishes the Data Entry User's Guide for Android, the CSPro Android CAPI Getting Started Guide, and the Data Transfer Guide.

Keep going