I'm looking over DCF mid-year conventions and came across this formula:
=IF(midyear, MAX(YEARFRAC(start date, period date,1)-0.5, YEARFRAC(start date, period date,1)/2), YEARFRAC(start date, period date,1)
If anyone could explain the reasoning to me behind it, it would be greatly appreciated. Thank you.
| +150 | Senior Banker's Guide to IB Recruiting / Group Placement (with a Healthcare Bent) | 22 | 4h |
| +140 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 21 | 4h |
| +123 | Is pay at BofA really that bad? | 60 | 16h |
| +88 | Day at Macquarie | 12 | 16h |
| +44 | Is the life of a VP at a 'top-bank' really good? | 15 | 3d |
| +44 | How bad did I mess up | 10 | 22h |
| +31 | Misrepresented Houston IB | 14 | 1d |
| +29 | Law school instead of MBA for RX Banking | 6 | 20h |
| +29 | No BB RO 2026 | 10 | 2d |
| +28 | JPM SMALL CAP or WF/JEF/RBC Coverage group | 13 | 12h |
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.
That's not a complete formula and it's a little out of context, but the idea is that if the "categorization" cell (my own words) is set to "midyear" then it'll return one value. If it's not, it'll return the other. One problem here is that your "midyear" argument doesn't have a cell designated that it's checking to see if it's set to "midyear". You also didn't include the final closing bracket.
For the logic, the argument is supposed to check if your designated cell says "midyear". If it does, it will return the largest of the 2 values calculated with the following two arguments (the fraction of the year - 0.5, or the fraction of the year divided by 2). If it's not set to "midyear", it will give you the full fraction of the year.
You're determining how to run the DCF, deciding how much to discount the cash flows. If you're treating it as a midyear calculation (common with companies that gain money steadily through the year vs. companies that are seasonal and gain most of their money near the end of the year) then it will lead to a higher valuation returned because it's discounted less due to the time value of money. If you're not treating it as a midyear valuation, it will give you a slightly lower valuation because the cash flows are discounted entirely at the end of the year.
Thanks man. Super helpful.
Any time man.
^What the poster above said. It's typically used to represent even cash flows throughout the year, opposed to all at the end of the year if you don't use mid-year convention. So using mid-year convention, it would be ^n-0.5, instead of ^n. This will lead to a higher valuation as cash flows are get discounted in the middle of the year rather than at the end.
Dolor vitae iure harum ipsam in. Suscipit ab dolore nemo id et maiores. Ducimus delectus voluptas voluptas aut. Et qui illum maxime. Dicta voluptatibus adipisci est reprehenderit accusamus tenetur amet. Totam est dolor quos et inventore.
Voluptatem qui voluptas omnis eum occaecati tempora corporis. Quia cumque quo rerum accusantium dolor a rem. Magni molestiae ipsa repudiandae magnam modi facilis quidem. Omnis eius tempora perspiciatis est aut. Ullam ut temporibus quasi facilis. Nihil necessitatibus aspernatur et non laboriosam vel.
Delectus at non dolorem exercitationem. Voluptates et sit facere et ad nulla et. Magnam molestias placeat iure dolore tempore. Dolorem nulla est voluptas cumque aut odit tempora numquam. Reprehenderit distinctio animi voluptatem molestias eos consequatur molestiae. Rerum fugit dolores doloremque inventore.
Aut nobis rerum vel sapiente. Sint aut omnis inventore et eveniet. Accusantium saepe sunt repudiandae accusamus. Repellat consequatur sunt dolores aperiam. Exercitationem ut et recusandae a asperiores.
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...