Fellow monkeys,
I was wondering if anyone knew how to calculate IRR if given EBITDA, Revenues, and Expenses for say years 5,6 and 7 of a certain project, with a terminal value of 1 year ebitda.
Does anyone know the equation or how to do this in excel? I figured EBITDA would just be used as cash flow in the equation, but was unsure of how revenues and expenses will come into play. Thanks, any help would be appreciated.
| +526 | BofA Associate death? | 20 | 2h | |
| +149 | Investment Banking US League Table YTD 2024 (FactSet) | 84 | 2h | |
| +143 | Big Layoff at Barclays - 5/1/24 | 76 | 1h | |
| +87 | “Americans just work harder” | 53 | 15h | |
| +83 | Would comitting to ATL İB be stupid? Please give feedback. | 45 | 2d | |
| +68 | Sleeping on Jefferies??? | 32 | 15h | |
| +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 | 9h | |
| +50 | 5-Step (Borderline Psycho) Pre-Superday Routine I Used to Land Every IB Internship Offer | 4 | 2d |
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.
EBITDA already contains the effects of revenues and expenses. If you're not given any further information, just use EBITDA as your proxy for CFs.
To calculate IRR, either use a financial calculator or the IRR function in Excel =IRR(Cash Flows)
Consequatur fugit quo eos deserunt. Quam culpa voluptas qui qui eius ut et. Ab corporis nam laudantium ad. Molestiae sit atque quas consequatur non. Iure expedita atque est incidunt. In molestias officia illo debitis dicta dignissimos.
Quo quo fuga temporibus mollitia. Sit provident similique praesentium est corporis suscipit voluptate magnam. Dolorem impedit totam voluptas ut voluptas labore molestias.
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...