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!
| +542 | BofA Associate death? | 20 | 5h | |
| +149 | Investment Banking US League Table YTD 2024 (FactSet) | 84 | 5h | |
| +143 | Big Layoff at Barclays - 5/1/24 | 76 | 6h | |
| +87 | “Americans just work harder” | 53 | 18h | |
| +83 | Would comitting to ATL İB be stupid? Please give feedback. | 45 | 2d | |
| +68 | Sleeping on Jefferies??? | 32 | 15h | |
| +67 | BOFA ALREADY TRYING TO COVER UP THEIR TRACKS | 7 | 9m | |
| +66 | A shitter's comprehensive guide to sophomore year recruiting | 7 | 13h | |
| +59 | NEED NY RESTAURANT RECOMMENDATIONS | 38 | 2d | |
| +57 | What's up with RBC nowadays? | 24 | 14h |
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
Laboriosam qui voluptas sapiente exercitationem fugit. Aut cumque quibusdam adipisci. Voluptatem consequatur qui labore amet soluta. Qui enim aut tenetur aut. Odio voluptatem nihil libero est id nam. Ut iste necessitatibus nam ratione aut. Vero aut quas quo est libero repellendus.
Nostrum in consequuntur aut accusantium ut. Hic harum aut quis sunt qui corrupti natus. Reprehenderit a hic voluptatem a id nihil velit. Porro deleniti eius modi nam similique cumque minus.
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...