Relatively new to building DCF's and was looking for advice on how I would calculate the Terminal value using the Gordon Growth Model.
I have the company's WACC, growth rate, and final year FCF that I am projecting. Would appreciate any help with what function/formula I would use to calculate this on Excel.
| +325 | Evercore Intern Seizure | 50 | 12m |
| +58 | JPM M&A is Gone??? Purely Coverage Banking??? | 26 | 50m |
| +57 | Is DCM actually underrated ? | 24 | 27m |
| +48 | Losing my personality in Banking | 9 | 32m |
| +46 | Are all Tech / TMT groups sweaty? | 38 | 1h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 2d |
| +39 | Associate & Above IB exits | 16 | 3d |
| +31 | Incoming IB Analyst: Best Ways to Prepare? | 9 | 2m |
| +27 | Which groups are ideal for laterals? | 12 | 3m |
| +26 | Technical question prep for FT recruiting | 5 | 4d |
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.
Pretty sure it's your last year cash flow divided by (WACC - Long term growth rate). The larger your growth rate, the smaller the denominator, and thus the larger the terminal value.
Ut et impedit expedita perferendis. Consequatur est amet labore blanditiis enim officiis omnis tempore. Reiciendis ratione iste voluptas iusto cum et. Enim assumenda rerum voluptatem qui voluptatem dolore omnis. Et aut voluptas et natus fugit enim et.
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...