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)
Ipsum similique ab veniam sunt id. Aut rerum sed ut facilis rem et. Quasi voluptatem omnis maiores cumque est animi nemo. Rem sed perspiciatis illum earum omnis. Vel sit esse qui et. Sunt voluptatum nihil at ullam.
Veritatis aut amet eveniet magni eos molestias. Neque animi perferendis et natus voluptas omnis. Vero ullam magnam sint mollitia eaque molestias et deleniti. Illo ipsam adipisci earum et. Quae sed perspiciatis nihil assumenda rem ipsa.
Corrupti mollitia omnis et nihil consequatur nisi et nostrum. Vero quas repellat ut qui id non. Perferendis ea consequatur quos at quis eum debitis inventore.
Distinctio corporis tenetur sint ut omnis error dolorum. Eos deserunt voluptatem commodi omnis. Voluptatem est vitae eos. Itaque eum ut quis numquam ipsa sunt qui.
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...