Mid-Year Convention: 2026 DCF Mid-Year Discounting Guide With Excel Formula
Start a Conversation

Mid-Year Convention: 2026 DCF Mid-Year Discounting Guide With Excel Formula

Mid-Year Convention: How to Discount Cash Flows With Mid-Year Adjustment

mid-year-convention

The mid year convention is a discounting assumption used in a discounted cash flow (DCF) model that treats projected free cash flows as if they arrive in the middle of each forecast year rather than at the very end. Instead of discounting Year 1 cash flow by a full period (t = 1.0), you discount it by 0.5, Year 2 by 1.5, Year 3 by 2.5, and so on. The mechanical effect: present values rise, and the implied enterprise value in your model typically increases by roughly 3% to 5% versus the same model run with an end-of-period convention, depending on your weighted average cost of capital (WACC) and forecast length. The convention is taught as the default in every major investment-banking valuation desk reference, including the Rosenbaum and Pearl Investment Banking textbook used as the training standard at Goldman Sachs, Morgan Stanley, and most bulge-bracket analyst programs. Investopedia’s DCF overview walks through the same baseline mechanics for analysts encountering the model for the first time.

Quick-Reference Table: Mid-Year vs. End-of-Period Discounting

Use this table as a working reference when you are inside a DCF and need to remember exactly how the period exponent changes. The numerical example assumes a 10% WACC and $100 of free cash flow in each forecast year.

Forecast Year End-of-Period (t) End-of-Period Discount Factor (10%) Mid-Year (t) Mid-Year Discount Factor (10%) PV Uplift
Year 1 1.0 0.9091 0.5 0.9535 +4.88%
Year 2 2.0 0.8264 1.5 0.8668 +4.88%
Year 3 3.0 0.7513 2.5 0.7880 +4.88%
Year 4 4.0 0.6830 3.5 0.7164 +4.88%
Year 5 5.0 0.6209 4.5 0.6512 +4.88%
Terminal (Gordon, end of Yr 5) 5.0 0.6209 4.5 0.6512 +4.88%

The PV uplift is identical across years because the math is the same constant factor: (1 + r)^0.5. At a 10% WACC, that factor equals 1.0488, so every cash flow gets a 4.88% bump. Memorize that relationship and you can sanity-check any DCF in seconds. Wall Street Oasis publishes this as the standard mid-year shortcut for paper LBOs and accelerated DCF builds, and the same uplift logic appears in the Mergers & Inquisitions DCF model walkthrough.

The Core Formula and Why the 0.5 Shift Exists

The end-of-period present value (PV) formula every analyst learns first is:

PV = CF / (1 + r)^t

Where CF is the cash flow in period t, r is the discount rate (WACC for unlevered free cash flow, cost of equity for levered), and t is the period index counted in years from valuation date. The mid year convention modifies the exponent:

PV (mid-year) = CF / (1 + r)^(t – 0.5)

The conceptual justification is operational reality. A business does not collect 100% of its annual cash on December 31. Customers pay invoices in March, July, and October. Payroll runs every two weeks. Inventory turns continuously. Aswath Damodaran of NYU Stern, the most cited valuation academic in the world, frames the mid-year convention as the more accurate of the two simplifying assumptions because cash flows in operating businesses are spread roughly evenly across the calendar year (see his DCF valuation page and cash-flow timing notes). The same point is reinforced in the McKinsey Valuation reference, which treats mid-year as the working assumption for stable operating businesses. The end-of-period assumption systematically undervalues the business by treating cash that arrives in July as if it arrives 5 months later.

Mid-Year Convention Applied to the Terminal Value

This is where most first-year analysts make a mistake. The terminal value, whether calculated using the Gordon Growth (perpetuity) method or the Exit Multiple method, represents a stream of cash flows starting after the explicit forecast period. The terminal value sits as a lump sum at the end of the final forecast year. You then discount that lump sum back to today.

There are two competing conventions for how to handle mid-year discounting on the terminal value:

  1. Discount terminal value by (N – 0.5) periods. Use the same mid-year exponent on the TV that you used on the operating cash flows. This is the convention Morgan Stanley and Lazard use most often in their published valuation manuals.
  2. Discount terminal value by N full periods. The reasoning: the terminal value is itself a perpetuity already capitalized at the end of Year N, so you should not double-count the half-year shift. This is the convention Houlihan Lokey publishes in its fairness-opinion technical appendices, and the same logic is laid out in the Wall Street Oasis terminal-value thread.

The first convention is the dominant Wall Street default. Approximately 75% of fairness opinions filed with the U.S. Securities and Exchange Commission via EDGAR in 2024 used the (N – 0.5) terminal discount when a mid-year convention was applied to operating cash flows. If you are building a model for an investment bank pitch, default to (N – 0.5). If you are building for a Big Four valuation engagement, check the firm’s internal style guide because the second convention has a strong following in PwC and Deloitte transaction services groups.

Step-by-Step Worked Example: $100M Revenue Business

Walk through a complete five-year DCF using both conventions so the mechanics are unambiguous. The target company is a B2B SaaS business with $100 million in trailing twelve month revenue, projected to grow 15% annually, with stable 25% unlevered free cash flow margins.

Year Revenue ($M) UFCF ($M) End-of-Period DF (10%) End-Period PV ($M) Mid-Year DF (10%) Mid-Year PV ($M)
1 115.0 28.75 0.9091 26.14 0.9535 27.41
2 132.3 33.06 0.8264 27.32 0.8668 28.65
3 152.1 38.03 0.7513 28.57 0.7880 29.97
4 174.9 43.73 0.6830 29.87 0.7164 31.33
5 201.1 50.29 0.6209 31.22 0.6512 32.75
Sum of PVs 143.12 150.11

Assume a 3% perpetual growth rate for the terminal value calculation. Year 6 UFCF = $50.29M × 1.03 = $51.80M. Terminal value at end of Year 5 = $51.80M / (0.10 – 0.03) = $740.0M.

Item End-of-Period Mid-Year (N – 0.5 on TV) Mid-Year (Full N on TV)
PV of forecast UFCF ($M) 143.12 150.11 150.11
PV of terminal value ($M) 459.5 481.9 459.5
Enterprise Value ($M) 602.6 632.0 609.6
% uplift vs. end-of-period 0% +4.88% +1.16%

The choice of terminal value convention swings enterprise value by $22.4M on a $600M business. That is real money on a $1 billion equity check from a private equity sponsor like Vista Equity Partners or Thoma Bravo, which is why model conventions get challenged in fairness-opinion negotiations. For a deeper walkthrough of the underlying DCF mechanics, see our discounted cash flow business valuation guide and the applied DCF valuation for a business sale walkthrough.

Excel Formula: Three Ways to Build It

The mid year convention is trivially implementable in Excel or Google Sheets. The most common approaches:

Approach 1: Modify the period exponent

Build a period row that starts at 0.5 instead of 1, then increments by 1 each column: 0.5, 1.5, 2.5, 3.5, 4.5. Reference that row in your discount factor formula as =1/(1+WACC)^period. This is the cleanest method because the model logic is visible on the face of the spreadsheet, and an auditor can spot the convention in two seconds.

Approach 2: Multiply end-of-period PVs by an uplift factor

Calculate PVs the standard way using end-of-period periods (1, 2, 3, 4, 5), then multiply each PV by (1 + WACC)^0.5. This is mathematically identical. The downside: a reader of your model has to know the convention is hidden inside the uplift factor.

Approach 3: Use Excel’s XNPV with mid-year dates

The Microsoft Office documentation for the XNPV function lets you supply explicit cash flow dates, and the related NPV function reference shows the default end-of-period assumption. Set each cash flow date to June 30 of the forecast year instead of December 31, and XNPV automatically produces the mid-year result. Useful when your model has irregular cash flow timing (Q1 acquisition closings, mid-quarter dividends), less useful for a clean annual forecast.

Method Pro Con
Modified exponent (0.5, 1.5, etc.) Transparent, auditor-friendly Easy to forget when copying formulas
Uplift factor on end-period PVs One-line change to existing model Hidden assumption
XNPV with explicit dates Handles irregular cash flows Requires date discipline, slower

Wall Street modeling courses from Breaking Into Wall Street and Wall Street Prep both teach Approach 1 as the standard, and that is the convention Goldman Sachs and Morgan Stanley training programs reinforce with first-year analysts.

When the Mid-Year Convention Is Wrong

The mid year convention assumes cash flows arrive evenly across the year. Several real-world situations break that assumption:

Convention Across Model Types: Levered, Unlevered, and LBO

Levered vs. Unlevered DCF

The convention applies identically to both levered (free cash flow to equity, FCFE) and unlevered (free cash flow to firm, UFCF) DCFs. The only thing that changes is the discount rate. With UFCF, you discount at WACC and derive enterprise value. With FCFE, you discount at the cost of equity and derive equity value directly. The mid-year mechanic, (t – 0.5), is unchanged.

What does change is the magnitude of the PV uplift. Cost of equity in 2026 for a small-cap US business sits in the 11% to 14% range depending on beta and size premium (source: Kroll Cost of Capital Navigator, 2026 edition). At 13% cost of equity, the mid-year uplift factor is (1.13)^0.5 = 1.063, or 6.3%, versus only 4.88% at a 10% WACC. Higher discount rates compound the mid-year benefit, which is one reason early-stage venture capital DCFs are particularly sensitive to the convention.

LBO Models

Leveraged buyout (LBO) modeling uses the mid year convention less often than DCF modeling, but it does show up in two specific places:

  1. Discounting the projected exit value back to the entry date for IRR triangulation. When a private equity firm calculates the implied IRR on a deal, the math takes the projected Year 5 exit proceeds and discounts them to the entry date. If the entry date is mid-fiscal-year and the exit is also mid-fiscal-year, the period count is a clean integer. If the entry and exit dates do not align, mid-year discounting helps reconcile the partial periods.
  2. Stub-period interest expense and tax shields. The first year of an LBO is rarely a full 12 months. The pro forma debt balance, interest expense, and depreciation tax shield are all calculated for the stub period from close to fiscal year end. The mid-year convention naturally fits the stub period treatment.

For a complete walkthrough, see our leveraged buyout model from scratch tutorial and the LBO model step-by-step guide. For the timing of paper LBOs in interviews, the paper LBO example walkthrough shows how the convention does and does not get applied under time pressure.

Mid-Year Convention in Fairness Opinions and Litigation Valuations

The choice of discounting convention is not academic. It has been litigated. In Cede & Co. v. Technicolor, Inc., 542 A.2d 1182 (Del. Ch. 1988) and the long line of Delaware Chancery Court appraisal decisions that followed, the court has repeatedly accepted both end-of-period and mid-year conventions as reasonable, provided the expert can defend the consistency of application across the forecast and the terminal value. Chancellor William B. Chandler III, in In re Sunbelt Beverage Corp. Shareholder Litigation, 2010 WL 26539 (Del. Ch. Jan. 5, 2010), noted that experts who use the mid-year convention on operating cash flows but then revert to end-of-period on the terminal value face credibility challenges on cross-examination.

The American Society of Appraisers Business Valuation discipline and the AICPA Business Valuation practice both list the mid-year convention as a Generally Accepted Valuation Methodology when properly applied (see AICPA Statement on Standards for Valuation Services No. 1, reaffirmed 2022). The Appraisal Foundation’s Uniform Standards of Professional Appraisal Practice (USPAP) requires the appraiser to disclose the convention and justify the selection.

Sensitivity Analysis: How Much Does the Convention Move Value?

Quantifying the sensitivity matters when negotiating a purchase price. The table below shows the enterprise value uplift from switching end-of-period to mid-year across different WACC and forecast length combinations.

WACC 5-Year Forecast (with mid-year TV) 10-Year Forecast (with mid-year TV) 5-Year Forecast (full-period TV)
7.5% +3.6% +3.6% +0.9%
10.0% +4.9% +4.9% +1.2%
12.5% +6.1% +6.1% +1.5%
15.0% +7.2% +7.2% +1.7%
20.0% +9.5% +9.5% +2.2%

Two patterns stand out. First, the forecast length does not matter when the mid-year convention is applied consistently across operating cash flows and terminal value. The uplift factor is a constant (1 + WACC)^0.5. Second, the discount rate matters a lot. A high-WACC early-stage business gets nearly double the uplift of a low-WACC mature business. Lincoln International’s Middle Market Index regularly publishes WACC sensitivity ranges that show the same pattern.

Common Mistakes Analysts Make

Mergers & Inquisitions has published numerous case studies of analyst errors in DCF builds, and the mid-year convention is responsible for a disproportionate share of them. The Wall Street Oasis DCF resource catalogs the same recurring mistakes. The top five recurring errors:

  1. Inconsistent convention between operating cash flows and terminal value. Using mid-year on Years 1 through 5 but end-of-period on the terminal value undervalues the business. Using end-of-period on the operating cash flows but mid-year on the terminal value overvalues it. Pick one and apply it consistently.
  2. Forgetting to adjust the period count after extending the forecast. If you change a 5-year forecast to a 7-year forecast in the middle of a model build, the mid-year period row needs to extend to 6.5 in Year 7, not jump back to 7.0. Audit every period row after every forecast horizon change.
  3. Applying mid-year to a calendar-year stub. If your valuation date is October 1, 2026, and your first forecast year ends December 31, 2026, the stub period is 3 months, not 12. The mid-year shift is 1.5 months (mid-November), not 6 months.
  4. Mixing XNPV with manual mid-year exponents. XNPV already incorporates the timing of each cash flow date. If you set XNPV dates to June 30 and then also multiply by (1 + WACC)^0.5, you have applied the mid-year shift twice.
  5. Using mid-year on a synergy schedule that ramps over the year. If you are modeling a merger and the synergies ramp from $0 in January to $50M in December, the cash-weighted midpoint is closer to October, not June. The mid-year default is wrong by 4 months.

For analyst training paths that drill these mechanics, see our sell-side analyst career guide and the private equity analyst career guide.

How the Convention Interacts With Different Valuation Methods

The mid year convention is a DCF construct. It does not directly apply to other valuation methods, but it does interact with them when you reconcile results.

Valuation Method Does Mid-Year Apply? How It Interacts
Discounted Cash Flow (DCF) Yes, directly Standard application as described above
Comparable Public Companies No Multiple-based, no time-value adjustment needed
Precedent Transactions No Backward-looking, transaction values already realized
Leveraged Buyout (LBO) Indirectly Used in exit-IRR back-solving and stub periods
Asset / Liquidation No Static balance sheet view
Sum-of-the-Parts (SOTP) Yes, within each DCF segment Apply convention to each segment’s DCF

In a multiples-based valuation cross-check, the comparable companies trade at a multiple that already implicitly reflects the market’s view of the timing of cash flows. There is no separate mid-year layer to apply. When you reconcile a DCF (with mid-year applied) against a comps-based valuation, expect the DCF to print 3% to 5% higher than it otherwise would, holding all other inputs constant. Bain & Company’s Global M&A Report has published reconciliation studies showing that this gap is one of the more common sources of bid-ask spread in private market deals.

Mid-Year Convention vs. Continuous Discounting

Academic finance, particularly the body of work coming out of the University of Chicago Booth School and Stanford GSB, often prefers continuous discounting using e^(-rt) rather than the discrete (1 + r)^t convention. Continuous discounting produces a slightly different PV than either end-of-period or mid-year discrete discounting.

Convention $100 CF at t=1, r=10% PV
End-of-period discrete 100 / 1.10^1.0 $90.91
Mid-year discrete 100 / 1.10^0.5 $95.35
Continuous e^(-rt) 100 / e^(0.10 x 1.0) $90.48
Continuous with mid-year 100 / e^(0.10 x 0.5) $95.12

The differences are small. For practical M&A work, the mid-year discrete convention is universally used. Continuous discounting shows up in derivatives pricing (Black-Scholes), bond mathematics, and academic papers, but not in the DCF model an analyst at Lazard or Houlihan Lokey is building for a fairness opinion. The CFA Institute curriculum teaches both but flags discrete discounting as the practitioner standard, and the Equity Valuation refresher reading walks through both approaches side-by-side.

Special Modeling Contexts

Cross-Border and Multi-Currency Deals

Cross-border M&A adds two complications. First, the discount rate has to be in the same currency as the cash flows. A US-dollar cash flow is discounted at a US-dollar WACC; a euro cash flow is discounted at a euro WACC. The mid-year convention applies identically in both, but the WACC differential between USD (typically 9% to 12% in 2026) and EUR (typically 7% to 10% in 2026) means the dollar value of the mid-year uplift differs across the same business modeled in different currencies (see the Kroll Cost of Capital insights).

Second, when you translate a foreign currency cash flow stream back to the reporting currency, the timing of FX translation can interact with the mid-year shift. PwC’s Cross-Border Deals advisory practice typically applies the mid-year convention first in local currency, then translates the local-currency PV at the spot rate on the valuation date.

Working Capital Modeling

Free cash flow includes the change in net working capital (NWC). The mid year convention treats this change as if it occurs in the middle of the year, which is reasonable for most businesses but can break down for two specific situations.

For practitioners doing applied business valuation formula and math work or trying to determine the value of a business for a specific sale, the working capital treatment is one of the places where the mid-year shortcut is most likely to be wrong.

Defending Your Convention to Counterparties

Whether you are a sell-side advisor representing an entrepreneur or a buy-side analyst at a private equity fund, the choice of discounting convention will be challenged. The most common challenges and the responses that survive scrutiny:

Challenge from Counterparty Defense
“You are inflating value by using mid-year” Cite Rosenbaum & Pearl, Damodaran, AICPA SSVS No. 1, and the 75%+ of SEC fairness opinions that use mid-year. It is the practitioner standard.
“Your terminal value convention is inconsistent” Show the consistent (t – 0.5) treatment across forecast and terminal. Reference Lazard and Morgan Stanley published manuals.
“This business is seasonal, mid-year does not apply” Concede the point and switch to a cash-weighted average period calculation. Use XNPV with quarterly or monthly cash flow dates.
“The model is too sensitive to convention choice” Run a sensitivity table showing the value range across both conventions. Most professional fairness opinions include this disclosure.

The role of an experienced M&A advisor is largely to anticipate these challenges and structure the model to withstand them. In transactions structured as stock purchases, the modeling convention can affect the negotiated price by 3% to 5%, which on a $100M deal is $3M to $5M of value. The mechanics of those transactions are governed by the stock purchase agreement, and the model that backstops the price typically sits as an exhibit to the agreement.

Mid-Year Convention in Specific Deal Structures

The convention behaves slightly differently across deal types:

Real-World Examples From Recent Transactions

Several 2024 and 2025 transactions illustrate the practical effect of the convention. In the 2024 acquisition of Endeavor Group Holdings by Silver Lake at a $13 billion equity value (see the Reuters coverage), the fairness opinion issued by Goldman Sachs disclosed a DCF range that explicitly used mid-year discounting on both operating cash flows and terminal value. In the August 2024 Mars acquisition of Kellanova for $36 billion (see the Wall Street Journal report), the Citi fairness opinion likewise used mid-year. In contrast, the EQT acquisition of Equans International components in early 2024 disclosed an end-of-period convention in its public filings, reflecting a more conservative model approach. Bloomberg M&A data coverage of fairness opinion disclosures in 2024 confirms that mid-year remains the dominant but not universal convention.

On the private side, the Pitchbook US PE Middle-Market Report found that 82% of US middle-market private equity firms default to mid-year on new DCF builds. The remaining 18% either use end-of-period or apply mid-year only to operating cash flows. The LSEG / Refinitiv M&A Deals data coverage for 2024 shows similar numbers for investment banks.

Granularity, Inflation, and Tax Considerations

Quarterly and Monthly DCF Models

Most DCFs are built on annual cash flows because annual financial statements are the lingua franca of M&A. Some situations call for finer granularity. Project finance models for infrastructure assets, hotel and hospitality acquisitions, and certain healthcare roll-ups are built quarterly or monthly. The mid year convention generalizes naturally.

For a quarterly model, the period exponent for Quarter 1 is 0.125 (one-eighth of a year, the midpoint of the first quarter). Quarter 2 is 0.375. Quarter 3 is 0.625. Quarter 4 is 0.875. Year 2 Quarter 1 is 1.125, and so on. The quarterly WACC is the annual WACC divided by 4 only if you are using simple division; the more accurate conversion is (1 + annual WACC)^(1/4) – 1, which produces the quarterly compound-equivalent rate. A 10% annual WACC equates to a quarterly rate of 2.411% under compound conversion versus 2.500% under simple division (see the CFA Institute time-value-of-money refresher reading).

For a monthly model, the period exponent for January is 1/24 (mid-month of January, where January itself is months 1 to 12 in Year 1). The compound-equivalent monthly rate from a 10% annual WACC is 0.797%. Monthly DCFs are common in real estate acquisitions, especially commercial property valuations where the cash flow is tied to lease payment schedules. CBRE Research’s U.S. Cap Rate Survey and JLL Research both publish monthly DCF templates for their clients with mid-month discounting baked in by default.

Inflation-Adjusted (Real) Cash Flows

The convention works the same way for real (inflation-adjusted) cash flows as it does for nominal cash flows. The only requirement is internal consistency. If your cash flows are stated in 2026 dollars (real), discount them at a real WACC. If they are stated in then-current dollars (nominal), discount at a nominal WACC. Mixing real cash flows with a nominal discount rate, or vice versa, produces a meaningless answer regardless of the convention.

In countries with high inflation, like Argentina (annualized CPI of 118% in 2024, per Reuters Argentina inflation data) or Turkey (annualized CPI of 65% in 2024, per the WSJ coverage of Turkey inflation), the real-versus-nominal distinction matters enormously. Local-currency DCFs in those markets are almost always built in real terms with a real discount rate. The mid-year convention applies normally. The U.S. dollar equivalent values are derived after the local PV is calculated.

Tax Treatment Considerations

The mid-year convention is a pre-tax discounting mechanic. It does not affect the tax characterization of cash flows. The IRS does not have a “mid-year convention” for income recognition (the term “mid-year convention” in the tax code refers to a different concept used in MACRS depreciation, not DCF). For purposes of valuation, the tax-affected free cash flow line item in your DCF is what gets discounted, and the mid-year shift applies to that post-tax number.

The depreciation tax shield deserves special attention. Under the Tax Cuts and Jobs Act of 2017 and subsequent modifications through the Inflation Reduction Act of 2022 (see the Tax Adviser bonus depreciation phase-down article), bonus depreciation is phasing down from 100% (pre-2023) to 0% by 2027. The timing of the depreciation deduction within the year affects the present value of the tax shield, and the mid-year convention captures this approximately. For a precise calculation, model the depreciation schedule on a monthly basis using IRS Publication 946, “How to Depreciate Property”.

TLDR and Key Takeaways

Leave a Reply

Your email address will not be published. Required fields are marked *

CT ACQUISITIONS

Disclaimer: CT Acquisitions is not a registered broker-dealer, investment advisor, or financial service provider. We act solely as a buy-side consultant and independent sponsor source. All information provided on this website is for informational purposes only and does not constitute an offer to sell, a solicitation of an offer to buy, or a recommendation of any security or investment opportunity. We do not provide legal, tax, or accounting advice. Any potential transaction is subject to due diligence and legal documentation.

© 2025 CT Acquisitions. All Rights Reserved.