Hey all, quick question about DCF valuation. If you're valuing a company right now (mid-2015), do you discount cash flows back to 2015, or do you account for the fact that it's the middle of the year? In other words, should you discount back to 2015.5?
Thank you all in advance!
| +407 | Evercore Intern Seizure | 62 | 14h |
| +126 | UBS IB Americas has failed, now behind Santander and Stiffel | 34 | 3h |
| +79 | deleted deleted deleted deleted deleted | 44 | 7h |
| +60 | How do I understand vs. just memorizing? | 11 | 18h |
| +55 | Some banks are overrated as fuck | 16 | 1h |
| +49 | The good and bad with Wells Fargo | 15 | 6h |
| +48 | Associate & Above IB exits | 18 | 20h |
| +44 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 25 | 1h |
| +36 | Incoming IB Analyst: Best Ways to Prepare? | 13 | 16h |
| +32 | Tech to IB Pivot | 20 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
When are you predicting "the deal" closes?
Do you want to know what the company is in theory worth tomorrow or at the end of a sellside process?
Right now I'm looking to see what the company is worth tomorrow, which is why I'd think to use mid-year discounting--what's the appropriate way to approach this?
Stub-year fraction
You discount by the number of years in your period. It shouldn't matter when you start. If you know ahead of time that your discount period will be a fraction of a year (e.g. September 1, 2015 through February 28, 2026) then you utilize a fraction (e.g. 10.5 years).
Thanks guys, really appreciate the help.
Mid-Year Discount (Originally Posted: 03/03/2016)
Hi WSO Community,
I had a conceptual question related to the mid-year discount Definition.
In reading the Mid Year Discount definition posted on the WSO site, it reads, "To account for this, a mid-year discount is used to assume that all the cash comes in halfway through the year to average it out."
Why exactly would this be averaging out the cash flow cycle? Could someone please explain?
Thank you!
If you're valuing a company using a DCF and not using a mid-year convention, you effectively are saying that all cash flows are received at the end of the year. Also, you are understating the value of the company (assuming free cash flow is positive).
As we all know, a dollar of cash flow earned on 1/1/16 is more valuable than a dollar of cash flow earned on 12/31/16. Because we don't know exactly when every dollar is earned during the year, we use the mid-year convention (e.g. 6/30/16) instead of year-end, which effectively allows you to assume that free cash flow is generated equally throughout the year.
Valuation Date: 3/31/16
5-Year Projections Period 1: 12/31/16 Period 2: 12/31/17 Period 3: 12/31/18 Period 4: 12/31/19 Period 5: 12/31/20 Period 6 (stub): 3/31/21
Should the discount period for CF1 equal 0.25?
Formula is: (12/31/16-3/31/16)/365-0.5 = 0.25
Period 1 = 0.25 2 = 1.25 3 = 2.25 4 = 3.25 5 = 4.26 6 = 4.50
And the Residual Value in Terminal Year I'm using a discount period of 5.0.
Is this correctly calculating the mid-year discount period?
Thanks!
This is correct assuming you're using the full year for 2016. If you're only using the remaining 9 months, it is different.
Why is period 6 4.50? Shouldn't it be the average of (end of period 5) and (end of period 6)?
Otherwise looks good
Unde aliquam odit illum et in iusto eos nisi. Et quis fugit sunt est aut non. Sunt illum corrupti voluptas libero quo dolor provident. Quaerat amet magni facere.
Atque voluptas dolores velit. Velit similique qui fugit. Repellendus fugit voluptatibus cum sed. Facilis libero modi consequatur ut. Maxime nostrum saepe alias dolores. Consequatur assumenda ab eveniet nesciunt vel quos.
Explicabo quo fugit et deserunt. Culpa impedit rerum et suscipit. Qui eum quo commodi repellendus minus. Voluptatum reprehenderit sit laudantium sed occaecati.
Aut deserunt mollitia recusandae autem qui excepturi harum quo. Omnis fugit totam sit commodi. Soluta nam velit iste pariatur odio in. Sint et molestias labore reiciendis architecto aliquid et. Rem ea placeat sit neque et dolores reiciendis. Fuga pariatur blanditiis quos explicabo quis rem dignissimos quam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...