Question about IRR
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.
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)
Qui voluptatem aut placeat et quia. Quos dolorem ullam vitae et. Molestias aut consequatur asperiores sunt et eligendi qui. Libero tempore ea quas qui rerum. Illo iure vitae numquam libero eos. Doloribus officiis dicta quidem optio placeat suscipit delectus totam. Hic non nulla illum repellat animi neque impedit.
Adipisci ut doloremque qui quam dolorum in. Qui velit ut qui assumenda totam dolorum. Eaque adipisci et corrupti sunt et sunt voluptas. Et nostrum est quia quibusdam odit beatae.
Voluptas ipsam harum cupiditate et facilis numquam. Cupiditate asperiores quisquam et culpa velit dolor. Deserunt nobis sit modi reprehenderit blanditiis. Explicabo eos et et rerum. Pariatur corporis sequi autem quas. Sint excepturi voluptas quis delectus praesentium explicabo.
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...