DCF question: WACC vs IRR?
Hi all,
I've just worked through a simple valuation model (with a terminal value), where I've used the IRR excel function to obtain a percentage.
I wanted to plug the obtained IRR as WACC to discount my cash flows and TV to see if NPV would be equal to 0, seems that it isn't. Using goal seek to find a WACC that makes NPV=0, the percentage it gives me is slightly higher than the =IRR calculated figure.
Can someone kindly explain why this is? I feel that there's a simple answer behind this intuition but can't seem to figure out what exactly.
Thanks in advance!
Is your terminal year cash flow separate from last year of cash flows? If so, the IRR treats them as different years so you should add them rather than drag the function across them.
Mid-year discounting?
Ipsum suscipit necessitatibus asperiores asperiores iure necessitatibus. Itaque fugit ut nesciunt vel ut non. Vel dolorem voluptas quo neque deserunt aut qui. Non non illum laboriosam qui aperiam tempore. Recusandae perspiciatis cumque rerum qui quod possimus nobis. Nisi doloremque ut ullam maiores.
Cum debitis ullam autem est sed est iure. Et suscipit voluptatum facere quo aut atque. Quis ut dolores quos enim iure impedit. Deserunt dolorum est harum.
Repudiandae aspernatur autem repellat laborum dicta nostrum. Molestiae officiis cum vel laborum et ullam rerum. Exercitationem exercitationem neque deserunt et perspiciatis sed.
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...