Скачать
how to use Goal seek analysis to find internal rate of return
Автор: Intermediate Financial Accounting I
Загружено: 2024-11-28
Просмотров: 62
Описание:
The video discusses the calculation of Net Present Value (NPV) and Internal Rate of Return (IRR) for an investment project. It explains that with a discount rate of 4%, the NPV is positive. The presenter illustrates the process of finding the discount rate that makes the NPV zero, using a trial and error method to test various rates. The video then introduces the "Goal Seek" feature in Excel, demonstrating how to set a cell to reach zero NPV by adjusting the discount rate. Ultimately, the internal rate of return for the project is determined to be approximately 7.93%.
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
