background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wall Street Prep

Mid-Year Convention

Step-by-Step Guide to Understanding the Mid-Year Convention Concept

Last Updated February 28, 2024

Learn Online Now

Mid-Year Convention

How to Calculate Mid-Year Convention

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

How Does the Mid-Year Convention Affect Valuation?

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 Number0.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 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 consider 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 on to a modeling exercise, which you can access by filling out the form below.

dl

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

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.

2. Mid-Year Convention Calculation Example

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
Comments
0 Comments
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.