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.
| +255 | Why UBS Is the Worst Place to Start Your IB Career | 40 | 8h |
| +213 | UBS 2nd Year Analyst Q&A (2026) | 38 | 15h |
| +79 | What's your craziest "hardo" story? | 12 | 3h |
| +70 | Firm Thinks I'm Lying About Offer | 20 | 2d |
| +62 | Indiana University Fraternity Pipelines | 36 | 1d |
| +51 | Rogo AI | 21 | 16h |
| +49 | Elite Boutique interview questions | 17 | 11h |
| +48 | Suspended for a Year | 19 | 2d |
| +40 | Stay at Weak Dealflow Team or Lateral? | 12 | 3d |
| +27 | Wolf of Wall Street vs. Reality: Anyone else feel scammed by the movies? | 10 | 5h |
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.
Cupiditate qui natus libero ut quis totam. Numquam in non dolore doloremque eius quis odio. Amet earum neque inventore ipsum voluptas tempore veniam sed.
Omnis numquam accusantium maxime aut consequatur ut eaque. Modi qui voluptatem voluptatem eos iste. Inventore sit recusandae consequuntur ut culpa et rerum. In accusantium accusantium itaque id aspernatur perspiciatis dolor id. Et sint quidem et voluptatem et qui.
Nisi libero harum aut recusandae nam. Pariatur itaque consequatur corrupti accusamus eius.
Et a commodi dolor accusantium. Sequi non non exercitationem doloribus ut rerum.
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...