Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Private Equity Certificate: Now Accepting Enrollment for January 29 - March 25, 2024 →
Wall Street Prep

Mid-Year Convention

Understand the Mid-Year Convention Concept

Learn Online Now

Mid-Year Convention

How to Calculate the Mid-Year Convention (Step-by-Step)

In the context of DCF modeling, if the mid-year convention adjustment is not used, the implicit assumption is that the projected cash flows of the company are received at year-end (i.e. December 31, in the context of a calendar year).

The mid-year convention assumes the FCF generation of a company occurs evenly, therefore resulting in a steadier inflow of cash throughout the fiscal year.

Mid-year discounting accounts for the fact that the free cash flows of a company are received throughout the year as opposed to only at year-end.

The mid-year convention can therefore be a necessary adjustment since, at times, the year-end assumption can be misleading in the portrayal of when cash flows are actually received.

In reality, the cash flows of a company are generated steadily throughout the year; however, the exact timing within a fiscal year tends to vary by the company in question (and industry).

Below is an illustrative diagram that depicts the mid-year convention in use – notice how 0.5 is subtracted from each time period:

Mid-Year Convention Stage 1

Valuation Implications of Mid-Year Convention Adjustment

If the unadjusted, year-end assumption is used, the period number for the 1st year of the projection is straightforward (i.e., one).

But under the mid-year convention, the discount period of 1 is adjusted to 0.5 since the assumption is that half of a year has passed before the cash is considered to be in the hands of the company.

The adjusted discount factor formula is as follows:

Discount Factor (Mid-Year Convention) = 1 / [(1 + Discount Rate) ^ (Period Number – 0.5)]

For mid-year discounting, the discount periods used are:

  • 1st Year → 0.5
  • 2nd Year → 1.5
  • 3rd Year → 2.5
  • 4th Year → 3.5
  • 5th Year → 4.5

Since the discount periods are of lower value, this means the cash flows are received earlier, which leads to higher present values (and implied valuations).

Occasionally, the percentage increase from mid-year discounting could seem insignificant for smaller-sized companies, but at scale, the implications on the valuation and the gap between the two methods become far more pronounced.

Because each annual cash flow amount is implied to have been earned mid-year, this increases the valuation of the company in theory, as cash flows received earlier hold more value under the time value of money.

Despite the adjustment, the practice of mid-year discounting remains an imperfect approach, since it still does not take into account if cash flows reach the company more sporadically (rather than evenly) through a given year. Nevertheless, mid-year discounting is still typically more practical (and realistic) when compared to end-of-year discounting.

Mid-Year Convention: Seasonal and Cyclical Companies

While using the mid-year convention in DCF modeling has relatively become standard practice, it can be improper for highly seasonal or cyclical companies.

Companies with inconsistent sales trends with irregular fluctuations necessitate a closer look before using the mid-year discount.

For example, many retail companies experience seasonal patterns in consumer demand, and sales are disproportionately received in the 3rd and 4th quarters around the holiday season.

Here, the unadjusted, period-end assumption could be a more accurate representation of the cash flows of the retail company.

Mid-Year Convention Calculator – Excel Template

We’ll now move to a modeling exercise, which you can access by filling out the form below.


Step 1. DCF Model Assumptions (“Mid-Year Toggle”)

To add the mid-year convention into our stage 1 DCF model, we will first create a mid-year toggle switch as seen at the top right corner of the image.

Also from the formula, we see that the logic in the “Period” cell is:

  • If the Mid-Year Toggle = 0, the output will be (Year # – 0.5)
  • If the Mid-Year Toggle = 1, the output will be (Year #)

Mid-Year Convention Period

Next, the discount factor formula will add 1 to the 10% discount rate, and raise it to the negative exponent of 0.5 since the mid-year toggle is switched to “ON” here (i.e., input zero into the cell).

Mid-Year Convention ON

And to calculate the present value of the Year 1 cash flow, we multiply the .95 discount factor by $100, which comes out to $95 as the PV.

Step 2. Mid-Year Convention Present Value (PV) Calculation

In the final section of our post, the output for the model with the mid-year convention set to “ON” has been posted below:

Mid-Year ON

And now, for comparison purposes, if the toggle was set to “OFF”:

Mid-Year Convention OFF

Here, the periods are left unadjusted (i.e., no deduction of 0.5, implying the standard year-end discounting convention), which has the impact of making the discount factor lower and thereby decreasing the implied PV each year.

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Inline Feedbacks
View all comments
Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.