╨а╨░╤Б╤Б╤З╨╕╤В╨░╤В╤М IRR ╨▓ Excel
╨а╨░╤Б╤З╨╡╤В IRR ╨▓ Excel
IRR, ╨╕╨╗╨╕ ╨▓╨╜╤Г╤В╤А╨╡╨╜╨╜╤П╤П ╨╜╨╛╤А╨╝╨░ ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╨╕, ╨╕╤Б╨┐╨╛╨╗╤М╨╖╤Г╨╡╤В╤Б╤П ╨┤╨╗╤П ╤А╨░╤Б╤З╨╡╤В╨░ ╨▓╨╜╤Г╤В╤А╨╡╨╜╨╜╨╡╨╣ ╨┐╤А╨╕╨▒╤Л╨╗╨╕ ╨┤╨╗╤П ╨╜╨╡╨║╨╛╤В╨╛╤А╤Л╤Е ╨╕╨╜╨▓╨╡╤Б╤В╨╕╤Ж╨╕╨╣ ╨▓ ╤Д╨╕╨╜╨░╨╜╤Б╤Л. IRR тАФ ╤Н╤В╨╛ ╨▓╤Б╤В╤А╨╛╨╡╨╜╨╜╨░╤П ╤Д╤Г╨╜╨║╤Ж╨╕╤П ╨▓ Excel, ╨╕╤Б╨┐╨╛╨╗╤М╨╖╤Г╨╡╨╝╨░╤П ╨┤╨╗╤П ╤А╨░╤Б╤З╨╡╤В╨░ ╤В╨╛╨│╨╛ ╨╢╨╡ ╤Б╨░╨╝╨╛╨│╨╛. ╨н╤В╨╛ ╤В╨░╨║╨╢╨╡ ╤Д╨╕╨╜╨░╨╜╤Б╨╛╨▓╨░╤П ╤Д╨╛╤А╨╝╤Г╨╗╨░. ╨н╤В╨░ ╤Д╤Г╨╜╨║╤Ж╨╕╤П ╨┐╤А╨╕╨╜╨╕╨╝╨░╨╡╤В ╨┤╨╕╨░╨┐╨░╨╖╨╛╨╜ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╣ ╨▓ ╨║╨░╤З╨╡╤Б╤В╨▓╨╡ ╨▓╤Е╨╛╨┤╨╜╤Л╤Е ╨┤╨░╨╜╨╜╤Л╤Е, ╨┤╨╗╤П ╨║╨╛╤В╨╛╤А╤Л╤Е ╨╜╨░╨╝ ╨╜╤Г╨╢╨╜╨╛ ╤А╨░╤Б╤Б╤З╨╕╤В╨░╤В╤М ╨▓╨╜╤Г╤В╤А╨╡╨╜╨╜╤О╤О ╨╜╨╛╤А╨╝╤Г ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╨╕ ╨╕ ╨┐╤А╨╡╨┤╨┐╨╛╨╗╨░╨│╨░╨╡╨╝╨╛╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ ╨▓ ╨║╨░╤З╨╡╤Б╤В╨▓╨╡ ╨▓╤В╨╛╤А╨╛╨│╨╛ ╨▓╤Е╨╛╨┤╨╜╨╛╨│╨╛ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П.
╨Э╨░╨┐╤А╨╕╨╝╨╡╤А, ╨┐╤А╨╡╨┤╨┐╨╛╨╗╨╛╨╢╨╕╨╝, ╤З╤В╨╛ ╨▓╨░╤И╨░ ╨║╨╛╨╝╨┐╨░╨╜╨╕╤П ╤Б╨┤╨╡╨╗╨░╨╗╨░ ╨┐╨╡╤А╨▓╨╛╨╜╨░╤З╨░╨╗╤М╨╜╤Л╨╡ ╨╕╨╜╨▓╨╡╤Б╤В╨╕╤Ж╨╕╨╕ ╨▓ ╤А╨░╨╖╨╝╨╡╤А╨╡ 50 000 ╨┤╨╛╨╗╨╗╨░╤А╨╛╨▓ ╨╕ ╤А╨░╤Б╤Б╤З╨╕╤В╤Л╨▓╨░╨╡╤В ╨┐╨╛╨╗╤Г╤З╨░╤В╤М 10 000 ╨┤╨╛╨╗╨╗╨░╤А╨╛╨▓ ╨▓ ╨│╨╛╨┤ ╨▓ ╤В╨╡╤З╨╡╨╜╨╕╨╡ ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╤Е 10 ╨╗╨╡╤В. ╨Ь╤Л ╨╝╨╛╨╢╨╡╨╝ ╨╕╤Б╨┐╨╛╨╗╤М╨╖╨╛╨▓╨░╤В╤М ╤Н╤В╨╕ ╨┤╨░╨╜╨╜╤Л╨╡ ╨┤╨╗╤П ╤А╨░╤Б╤З╨╡╤В╨░ IRR ╤Н╤В╨╛╨╣ ╨╕╨╜╨▓╨╡╤Б╤В╨╕╤Ж╨╕╨╕, ╨║╨╛╤В╨╛╤А╨░╤П ╨┐╤А╨╡╨┤╤Б╤В╨░╨▓╨╗╤П╨╡╤В ╤Б╨╛╨▒╨╛╨╣ ╨╜╨╛╤А╨╝╤Г ╨┐╤А╨╕╨▒╤Л╨╗╨╕, ╨║╨╛╤В╨╛╤А╤Г╤О ╨▓╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╨┐╨╛╨╗╤Г╤З╨╕╤В╤М ╨╜╨░ ╤Б╨▓╨╛╨╕ ╨╕╨╜╨▓╨╡╤Б╤В╨╕╤Ж╨╕╨╕ ╨▓ ╤А╨░╨╖╨╝╨╡╤А╨╡ 100 ╨┤╨╛╨╗╨╗╨░╤А╨╛╨▓ ╨б╨и╨Р. ╨Т ╤А╨╡╨╖╤Г╨╗╤М╤В╨░╤В╨╡ IRR ╨┐╨╛╨╗╤Г╤З╨░╨╡╤В╤Б╤П ╤А╨░╨▓╨╜╤Л╨╝ 15%. ╨н╤В╨╛ ╤Н╨║╨▓╨╕╨▓╨░╨╗╨╡╨╜╤В╨╜╨╛ ╨┤╨╡╨╜╤М╨│╨░╨╝, ╨▓╨╗╨╛╨╢╨╡╨╜╨╜╤Л╨╝ ╨┐╨╛╨┤ 15% ╨╜╨░ 10 ╨╗╨╡╤В.
IRRIRR╨Т╨╜╤Г╤В╤А╨╡╨╜╨╜╤П╤П ╨╜╨╛╤А╨╝╨░ ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╨╕ (IRR) тАФ ╤Н╤В╨╛ ╤Б╤В╨░╨▓╨║╨░ ╨┤╨╕╤Б╨║╨╛╨╜╤В╨╕╤А╨╛╨▓╨░╨╜╨╕╤П, ╨║╨╛╤В╨╛╤А╨░╤П ╤Г╤Б╤В╨░╨╜╨░╨▓╨╗╨╕╨▓╨░╨╡╤В ╨╜╤Г╨╗╨╡╨▓╤Г╤О ╤З╨╕╤Б╤В╤Г╤О ╤В╨╡╨║╤Г╤Й╤Г╤О ╤Б╤В╨╛╨╕╨╝╨╛╤Б╤В╤М ╨▓╤Б╨╡╤Е ╨▒╤Г╨┤╤Г╤Й╨╕╤Е ╨┤╨╡╨╜╨╡╨╢╨╜╤Л╤Е ╨┐╨╛╤В╨╛╨║╨╛╨▓ ╨╛╤В ╨┐╤А╨╛╨╡╨║╤В╨░. ╨Ю╨╜ ╤Б╤А╨░╨▓╨╜╨╕╨▓╨░╨╡╤В ╨╕ ╨▓╤Л╨▒╨╕╤А╨░╨╡╤В ╨╗╤Г╤З╤И╨╕╨╣ ╨┐╤А╨╛╨╡╨║╤В, ╨┐╤А╨╕ ╤Н╤В╨╛╨╝ ╨▓╤Л╨▒╨╕╤А╨░╨╡╤В╤Б╤П ╨┐╤А╨╛╨╡╨║╤В ╤Б IRR, ╨┐╤А╨╡╨▓╤Л╤И╨░╤О╤Й╨╕╨╝ ╨╝╨╕╨╜╨╕╨╝╨░╨╗╤М╨╜╨╛ ╨┤╨╛╨┐╤Г╤Б╤В╨╕╨╝╤Г╤О ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╤М (╨▒╨░╤А╤М╨╡╤А╨╜╤Г╤О ╤Б╤В╨░╨▓╨║╤Г). ╨з╨╕╤В╨░╤В╤М ╨┤╨░╨╗╨╡╨╡ ╨▓ Excel ╨╛╨╖╨╜╨░╤З╨░╨╡╤В ╤П╨▓╨╜╤Г╤В╤А╨╡╨╜╨╜╨╕╨╣ ╤А╤Б╤К╨╡╨╗ ╨╕╨╖ ╤А╨▓╨╛╨╖╨▓╤А╨░╤Й╨╡╨╜╨╕╨╡. ╨н╤В╨╛ ╨╛╨┤╨╜╨░ ╨╕╨╖ ╨▓╤Б╤В╤А╨╛╨╡╨╜╨╜╤Л╤Е ╤Д╤Г╨╜╨║╤Ж╨╕╨╣, ╨┤╨╛╤Б╤В╤Г╨┐╨╜╤Л╤Е ╨▓ Microsoft Excel. ╨Ъ╤А╨╛╨╝╨╡ ╤В╨╛╨│╨╛, ╨╛╨╜ ╨┐╨╛╨┤╨┐╨░╨┤╨░╨╡╤В ╨┐╨╛╨┤ ╨║╨░╤В╨╡╨│╨╛╤А╨╕╤О ╤Д╨╕╨╜╨░╨╜╤Б╨╛╨▓╤Л╤Е ╤Д╤Г╨╜╨║╤Ж╨╕╨╣.
Программы для Windows, мобильные приложения, игры - ВСЁ БЕСПЛАТНО, в нашем закрытом телеграмм канале - Подписывайтесь:)
╨Т╨╜╤Г╤В╤А╨╡╨╜╨╜╤П╤П ╨╜╨╛╤А╨╝╨░ ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╨╕ тАУ ╤Н╤В╨╛ ╨┐╤А╨╛╤Ж╨╡╨╜╤В╨╜╨░╤П ╤Б╤В╨░╨▓╨║╨░, ╨┐╨╛╨╗╤Г╤З╨╡╨╜╨╜╨░╤П ╨╖╨░ ╤Б╨┤╨╡╨╗╨░╨╜╨╜╤Л╨╡ ╨╕╨╜╨▓╨╡╤Б╤В╨╕╤Ж╨╕╨╕. ╨Ю╨╜ ╤Б╨╛╤Б╤В╨╛╨╕╤В ╨╕╨╖ ╨┐╤А╨╛╨╕╨╖╨▓╨╡╨┤╨╡╨╜╨╜╤Л╤Е ╨┐╨╗╨░╤В╨╡╨╢╨╡╨╣, ╨┐╤А╨╡╨┤╤Б╤В╨░╨▓╨╗╨╡╨╜╨╜╤Л╤Е ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╤Л╨╝╨╕ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П╨╝╨╕, ╨╕ ╨┐╨╛╨╗╤Г╤З╨╡╨╜╨╜╨╛╨│╨╛ ╨┤╨╛╤Е╨╛╨┤╨░, ╨╛╨▒╨╛╨╖╨╜╨░╤З╨╡╨╜╨╜╨╛╨│╨╛ ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╤Л╨╝╨╕ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П╨╝╨╕, ╨║╨╛╤В╨╛╤А╤Л╨╡ ╨┐╤А╨╛╨╕╤Б╤Е╨╛╨┤╤П╤В ╤А╨╡╨│╤Г╨╗╤П╤А╨╜╨╛.
╨д╤Г╨╜╨║╤Ж╨╕╤П IRR ╨▓ Excel ╨▓╨╛╨╖╨▓╤А╨░╤Й╨░╨╡╤В ╨▓╨╜╤Г╤В╤А╨╡╨╜╨╜╤О╤О ╨╜╨╛╤А╨╝╤Г ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╨╕ ╨┤╨╗╤П ╤А╤П╨┤╨░ ╨┤╨╡╨╜╨╡╨╢╨╜╤Л╤Е ╨┐╨╛╤В╨╛╨║╨╛╨▓. ╨Ф╨╡╨╜╨╡╨╢╨╜╤Л╨╡ ╨┐╨╛╤В╨╛╨║╨╕ ╨Ф╨╡╨╜╨╡╨╢╨╜╤Л╨╣ ╨┐╨╛╤В╨╛╨║ тАФ ╤Н╤В╨╛ ╤Б╤Г╨╝╨╝╨░ ╨┤╨╡╨╜╨╡╨╢╨╜╤Л╤Е ╤Б╤А╨╡╨┤╤Б╤В╨▓ ╨╕╨╗╨╕ ╤Н╨║╨▓╨╕╨▓╨░╨╗╨╡╨╜╤В╨░ ╨┤╨╡╨╜╨╡╨╢╨╜╤Л╤Е ╤Б╤А╨╡╨┤╤Б╤В╨▓, ╤Б╨╛╨╖╨┤╨░╨╜╨╜╨░╤П ╨╕ ╨┐╨╛╤В╤А╨╡╨▒╨╗╨╡╨╜╨╜╨░╤П ╨║╨╛╨╝╨┐╨░╨╜╨╕╨╡╨╣ ╨╖╨░ ╨╛╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╜╤Л╨╣ ╨┐╨╡╤А╨╕╨╛╨┤. ╨н╤В╨╛ ╨╛╨║╨░╨╖╤Л╨▓╨░╨╡╤В╤Б╤П ╨┐╤А╨╡╨┤╨┐╨╛╤Б╤Л╨╗╨║╨╛╨╣ ╨┤╨╗╤П ╨░╨╜╨░╨╗╨╕╨╖╨░ ╤Б╨╕╨╗╤Л ╨▒╨╕╨╖╨╜╨╡╤Б╨░, ╨┐╤А╨╕╨▒╤Л╨╗╤М╨╜╨╛╤Б╤В╨╕ ╨╕ ╨▓╨╛╨╖╨╝╨╛╨╢╨╜╨╛╤Б╤В╨╡╨╣ ╨┤╨╗╤П ╤Г╨╗╤Г╤З╤И╨╡╨╜╨╕╤П. ╤З╨╕╤В╨░╤В╤М ╨┤╨░╨╗╨╡╨╡ ╨┐╤А╨╡╨┤╤Б╤В╨░╨▓╨╗╨╡╨╜╤Л ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╤Л╨╡ ╨╕ ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╤Л╨╡ ╤З╨╕╤Б╨╗╨░. ╨н╤В╨╕ ╨┤╨╡╨╜╨╡╨╢╨╜╤Л╨╡ ╨┐╨╛╤В╨╛╨║╨╕ ╨╜╨╡ ╨╛╨▒╤П╨╖╨░╤В╨╡╨╗╤М╨╜╨╛ ╨┤╨╛╨╗╨╢╨╜╤Л ╨▒╤Л╤В╤М ╨┐╨╛╤Б╤В╨╛╤П╨╜╨╜╤Л╨╝╨╕, ╨║╨░╨║ ╨▓ ╤Б╨╗╤Г╤З╨░╨╡ ╤Б ╨░╨╜╨╜╤Г╨╕╤В╨╡╤В╨╛╨╝. ╨Ю╨┤╨╜╨░╨║╨╛ ╨┤╨╡╨╜╨╡╨╢╨╜╤Л╨╡ ╨┐╨╛╤В╨╛╨║╨╕ ╨┤╨╛╨╗╨╢╨╡╨╜ ╨┐╤А╨╛╨╕╤Б╤Е╨╛╨┤╤П╤В ╤З╨╡╤А╨╡╨╖ ╤А╨╡╨│╤Г╨╗╤П╤А╨╜╤Л╨╡ ╨┐╤А╨╛╨╝╨╡╨╢╤Г╤В╨║╨╕ ╨▓╤А╨╡╨╝╨╡╨╜╨╕, ╨╜╨░╨┐╤А╨╕╨╝╨╡╤А, ╨╡╨╢╨╡╨╝╨╡╤Б╤П╤З╨╜╨╛, ╨╡╨╢╨╡╨║╨▓╨░╤А╤В╨░╨╗╤М╨╜╨╛ ╨╕╨╗╨╕ ╨╡╨╢╨╡╨│╨╛╨┤╨╜╨╛. ╨б╤Г╨╝╨╝╨░ ╨╜╨░╨╗╨╕╤З╨╜╤Л╤Е ╨╝╨╛╨╢╨╡╤В ╨▓╨░╤А╤М╨╕╤А╨╛╨▓╨░╤В╤М╤Б╤П ╨┤╨╗╤П ╨║╨░╨╢╨┤╨╛╨│╨╛ ╨╕╨╜╤В╨╡╤А╨▓╨░╨╗╨░.
╨Ю╨│╨╗╨░╨▓╨╗╨╡╨╜╨╕╨╡
- ╨а╨░╤Б╤З╨╡╤В IRR ╨▓ Excel
╨д╨╛╤А╨╝╤Г╨╗╨░, ╨╕╤Б╨┐╨╛╨╗╤М╨╖╤Г╨╡╨╝╨░╤П ╨┤╨╗╤П ╤А╨░╤Б╤З╨╡╤В╨░ IRR ╨▓ Excel
╨д╨╛╤А╨╝╤Г╨╗╨░ IRR ╨▓ Excel ╨▓╤Л╨│╨╗╤П╨┤╨╕╤В ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╝ ╨╛╨▒╤А╨░╨╖╨╛╨╝:
╨У╨┤╨╡,
- ╨┤╨╕╨░╨┐╨░╨╖╨╛╨╜ = ╨н╤В╨╛ ╨╛╨▒╤П╨╖╨░╤В╨╡╨╗╤М╨╜╤Л╨╣ ╨┐╨░╤А╨░╨╝╨╡╤В╤А. ╨Ф╨╕╨░╨┐╨░╨╖╨╛╨╜ ╤П╤З╨╡╨╡╨║ ╨╛╨▒╨╛╨╖╨╜╨░╤З╨░╨╡╤В ╤А╤П╨┤ ╨┤╨╡╨╜╨╡╨╢╨╜╤Л╤Е ╨┐╨╛╤В╨╛╨║╨╛╨▓, ╨┤╨╗╤П ╨║╨╛╤В╨╛╤А╤Л╤Е ╨╝╤Л ╤А╨░╤Б╤Б╤З╨╕╤В╤Л╨▓╨░╨╡╨╝ ╨▓╨╜╤Г╤В╤А╨╡╨╜╨╜╤О╤О ╨╜╨╛╤А╨╝╤Г ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╨╕.
- ╨┐╤А╨╡╨┤╨┐╨╛╨╗╨░╨│╨░╤В╤М = ╨н╤В╨╛ ╨╜╨╡╨╛╨▒╤П╨╖╨░╤В╨╡╨╗╤М╨╜╤Л╨╣ ╨┐╨░╤А╨░╨╝╨╡╤В╤А. ╨Ю╨╜ ╨╛╨▒╨╛╨╖╨╜╨░╤З╨░╨╡╤В ╤З╨╕╤Б╨╗╨╛, ╨║╨╛╤В╨╛╤А╨╛╨╡, ╨║╨░╨║ ╨▓╤Л ╨┐╤А╨╡╨┤╨┐╨╛╨╗╨░╨│╨░╨╡╤В╨╡, ╨▒╨╗╨╕╨╖╨║╨╛ ╨║ ╤А╨╡╨╖╤Г╨╗╤М╤В╨░╤В╤Г ╨▓╨╜╤Г╤В╤А╨╡╨╜╨╜╨╡╨╣ ╨╜╨╛╤А╨╝╤Л ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╨╕. ╨Х╤Б╨╗╨╕ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ ╨╜╨╡ ╤Г╨║╨░╨╖╨░╨╜╨╛, ╨┐╤А╨╕╨╜╨╕╨╝╨░╨╡╤В╤Б╤П ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ ╨┐╨╛ ╤Г╨╝╨╛╨╗╤З╨░╨╜╨╕╤О 0,1 ╨╕╨╗╨╕ 10%.
- тАЬ[ ]тАЭ ╨╛╨▒╨╛╨╖╨╜╨░╤З╨░╨╡╤В ╨╜╨╡╨╛╨▒╤П╨╖╨░╤В╨╡╨╗╤М╨╜╤Л╨╡ ╨┐╨░╤А╨░╨╝╨╡╤В╤А╤Л.
╨д╤Г╨╜╨║╤Ж╨╕╤П ╨▓╨╛╨╖╨▓╤А╨░╤Й╨░╨╡╤В ╤З╨╕╤Б╨╗╨╛╨▓╨╛╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡. ╨Ю╨╜ ╨╝╨╛╨╢╨╡╤В ╨▒╤Л╤В╤М ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╤Л╨╝ ╨╕╨╗╨╕ ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╤Л╨╝.
╨Ъ╨░╨║ ╤А╨░╤Б╤Б╤З╨╕╤В╨░╤В╤М IRR ╨▓ Excel? (╤Б ╨┐╤А╨╕╨╝╨╡╤А╨░╨╝╨╕)
.free_excel_div{╤Д╨╛╨╜:#d9d9d9;╤А╨░╨╖╨╝╨╡╤А ╤И╤А╨╕╤Д╤В╨░:16px;╤А╨░╨┤╨╕╤Г╤Б ╨│╤А╨░╨╜╨╕╤Ж╤Л:7px;╨┐╨╛╨╖╨╕╤Ж╨╕╤П:╨╛╤В╨╜╨╛╤Б╨╕╤В╨╡╨╗╤М╨╜╨░╤П;margin:30px;padding:25px 25px 25px 45px}.free_excel_div:before{content:»»;╤Д╨╛╨╜:url(╤Ж╨╡╨╜╤В╤А ╤Ж╨╡╨╜╤В╤А ╨▒╨╡╨╖ ╨┐╨╛╨▓╤В╨╛╤А╨░ #207245;╤И╨╕╤А╨╕╨╜╨░:70px;╨▓╤Л╤Б╨╛╤В╨░:70px;╨┐╨╛╨╖╨╕╤Ж╨╕╤П:╨░╨▒╤Б╨╛╨╗╤О╤В╨╜╨░╤П;╨▓╨╡╤А╤Е:50%;margin-top:-35px;╤Б╨╗╨╡╨▓╨░:-35px;╨│╤А╨░╨╜╨╕╤Ж╨░:5px ╤Б╨┐╨╗╨╛╤И╨╜╨░╤П #fff;╨│╤А╨░╨╜╨╕╤Ж╨░-╤А╨░╨┤╨╕╤Г╤Б:50%}
╨Т╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╤Б╨║╨░╤З╨░╤В╤М ╤Н╤В╨╛╤В ╤И╨░╨▒╨╗╨╛╨╜ Excel ╤Д╤Г╨╜╨║╤Ж╨╕╨╕ IRR ╨╖╨┤╨╡╤Б╤М — ╨и╨░╨▒╨╗╨╛╨╜ Excel ╤Д╤Г╨╜╨║╤Ж╨╕╨╕ IRR
╨Ь╤Л ╨╝╨╛╨╢╨╡╨╝ ╨▓╤Л╨┐╨╛╨╗╨╜╤П╤В╤М ╤А╨░╤Б╤З╨╡╤В╤Л IRR ╨▓ Excel ╤Б ╨┐╨╛╨╝╨╛╤Й╤М╤О ╤Д╤Г╨╜╨║╤Ж╨╕╨╕ ╤А╨░╨▒╨╛╤З╨╡╨│╨╛ ╨╗╨╕╤Б╤В╨░ (WS) ╨╕╨╗╨╕ ╤Д╤Г╨╜╨║╤Ж╨╕╨╕ VBA. ╨Х╨│╨╛ ╨╝╨╛╨╢╨╜╨╛ ╨▓╨▓╨╡╤Б╤В╨╕ ╨║╨░╨║ ╤З╨░╤Б╤В╤М ╤Д╨╛╤А╨╝╤Г╨╗╤Л ╨▓ ╤П╤З╨╡╨╣╨║╤Г ╤А╨░╨▒╨╛╤З╨╡╨│╨╛ ╨╗╨╕╤Б╤В╨░ ╨║╨░╨║ ╤Д╤Г╨╜╨║╤Ж╨╕╤О WS. ╨б ╨┤╤А╤Г╨│╨╛╨╣ ╤Б╤В╨╛╤А╨╛╨╜╤Л, ╨╡╨│╨╛ ╨╝╨╛╨╢╨╜╨╛ ╨╕╤Б╨┐╨╛╨╗╤М╨╖╨╛╨▓╨░╤В╤М ╨▓ ╨╝╨░╨║╤А╨╛╨║╨╛╨┤╨╡ ╨║╨░╨║ ╤Д╤Г╨╜╨║╤Ж╨╕╤О VBA. ╨д╤Г╨╜╨║╤Ж╨╕╤П VBA ╨д╤Г╨╜╨║╤Ж╨╕╨╕ VBA ╤Б╨╗╤Г╨╢╨░╤В ╨╛╤Б╨╜╨╛╨▓╨╜╨╛╨╣ ╤Ж╨╡╨╗╨╕ ╨┤╨╗╤П ╨▓╤Л╨┐╨╛╨╗╨╜╨╡╨╜╨╕╤П ╨╛╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╜╤Л╤Е ╨▓╤Л╤З╨╕╤Б╨╗╨╡╨╜╨╕╨╣ ╨╕ ╨▓╨╛╨╖╨▓╤А╨░╤В╨░ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П. ╨Я╨╛╤Н╤В╨╛╨╝╤Г ╨▓ VBA ╨╝╤Л ╨╕╤Б╨┐╨╛╨╗╤М╨╖╤Г╨╡╨╝ ╤Б╨╕╨╜╤В╨░╨║╤Б╨╕╤Б ╨┤╨╗╤П ╤Г╨║╨░╨╖╨░╨╜╨╕╤П ╨┐╨░╤А╨░╨╝╨╡╤В╤А╨╛╨▓ ╨╕ ╤В╨╕╨┐╨░ ╨┤╨░╨╜╨╜╤Л╤Е ╨┐╤А╨╕ ╨╛╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╕ ╤Д╤Г╨╜╨║╤Ж╨╕╨╕. ╨в╨░╨║╨╕╨╡ ╤Д╤Г╨╜╨║╤Ж╨╕╨╕ ╨╜╨░╨╖╤Л╨▓╨░╤О╤В╤Б╤П ╨┐╨╛╨╗╤М╨╖╨╛╨▓╨░╤В╨╡╨╗╤М╤Б╨║╨╕╨╝╨╕ ╤Д╤Г╨╜╨║╤Ж╨╕╤П╨╝╨╕. ╨Я╨╛╨┤╤А╨╛╨▒╨╜╨╡╨╡, ╨▓╨▓╨╛╨┤╨╕╨╝╤Л╨╝╨╕ ╤З╨╡╤А╨╡╨╖ ╤А╨╡╨┤╨░╨║╤В╨╛╤А Microsoft Visual Basic Editor, ╨╕╨╜╤В╨╡╨│╤А╨╕╤А╨╛╨▓╨░╨╜╨╜╤Л╨╣ ╨▓ MS Excel. ╨Ю╨▒╤А╨░╤В╨╕╤В╨╡╤Б╤М ╨║ ╤А╨░╤Б╤З╨╡╤В╤Г IRR ╨▓ ╨┐╤А╨╕╨╝╨╡╤А╨╡ Excel ╨╜╨╕╨╢╨╡, ╤З╤В╨╛╨▒╤Л ╨╗╤Г╤З╤И╨╡ ╨┐╨╛╨╜╤П╤В╤М. ╨Я╤А╨╕╨╝╨╡╤А тДЦ 1. ╨а╨░╤Б╤З╨╡╤В ╨▓╨╜╤Г╤В╤А╨╡╨╜╨╜╨╡╨╣ ╨╜╨╛╤А╨╝╤Л ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╨╕ ╨▓ ╤В╨░╨▒╨╗╨╕╤Ж╨╡ Excel
╨Т ╤Н╤В╨╛╨╝ ╨┐╤А╨╕╨╝╨╡╤А╨╡ ╤А╨░╤Б╤З╨╡╤В╨░ IRR -3000 ╨╛╨▒╨╛╨╖╨╜╨░╤З╨░╨╡╤В ╤Б╤Г╨╝╨╝╤Г ╨╕╨╜╨▓╨╡╤Б╤В╨╕╤А╨╛╨▓╨░╨╜╨╜╨╛╨│╨╛ ╨║╨░╨┐╨╕╤В╨░╨╗╨░. ╨б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╡ ╤З╨╕╤Б╨╗╨░, 2000 ╨╕ 5000, ╤Г╨║╨░╨╖╤Л╨▓╨░╤О╤В ╨╜╨░ ╨┤╨╛╤Е╨╛╨┤. ╨д╤Г╨╜╨║╤Ж╨╕╤П IRR ╨▓ Excel ╤А╨░╤Б╤Б╤З╨╕╤В╤Л╨▓╨░╨╡╤В╤Б╤П ╨┤╨╗╤П ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╣ -3000, 2000 ╨╕ 5000. ╨а╨╡╨╖╤Г╨╗╤М╤В╨░╤В 67%.
╨Я╤А╨╕╨╝╨╡╤А #2
╨Т ╤Н╤В╨╛╨╝ ╨┐╤А╨╕╨╝╨╡╤А╨╡ ╤А╨░╤Б╤З╨╡╤В╨░ IRR #╨з╨Ш╨б╨Ы╨Ю! ╨Ю╨╜ ╨╛╤В╨╛╨▒╤А╨░╨╢╨░╨╡╤В╤Б╤П ╨║╨░╨║ ╤А╨╡╨╖╤Г╨╗╤М╤В╨░╤В, ╨┐╨╛╤Б╨║╨╛╨╗╤М╨║╤Г ╨▓ ╨╜╨░╨▒╨╛╤А╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╣ ╨╜╨╡╤В ╨╜╨╕ ╨╛╨┤╨╜╨╛╨│╨╛ ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╨╛╨│╨╛ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П. ╨Ш╤В╨░╨║, ╨╜╨╡╤В ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П, ╤Г╨║╨░╨╖╤Л╨▓╨░╤О╤Й╨╡╨│╨╛ ╨╜╨░ ╨╛╨┐╨╗╨░╤В╤Г, ╨╜╨╛ ╨▓╤Б╨╡ ╤П╨▓╨╗╤П╤О╤В╤Б╤П ╨┤╨╛╤Е╨╛╨┤╨╛╨╝.
╨Я╤А╨╕╨╝╨╡╤А тДЦ3
╨Т ╤Н╤В╨╛╨╝ ╨┐╤А╨╕╨╝╨╡╤А╨╡ ╤А╨░╤Б╤З╨╡╤В╨░ IRR ╨▓╤Б╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╤Л╨╡. ╨в╨░╨║╨╕╨╝ ╨╛╨▒╤А╨░╨╖╨╛╨╝, ╤Н╤В╨╛ ╤Г╨║╨░╨╖╤Л╨▓╨░╨╡╤В ╨╜╨░ ╨╛╤В╤Б╤Г╤В╤Б╤В╨▓╨╕╨╡ ╨┤╨╛╤Е╨╛╨┤╨░. ╨б╨╗╨╡╨┤╨╛╨▓╨░╤В╨╡╨╗╤М╨╜╨╛, ╤Б╨│╨╡╨╜╨╡╤А╨╕╤А╨╛╨▓╨░╨╜╨╜╤Л╨╣ ╤А╨╡╨╖╤Г╨╗╤М╤В╨░╤В ╤А╨░╨▓╨╡╨╜ #╨з╨Ш╨б╨Ы╨Ю!
╨Я╤А╨╕╨╝╨╡╤А тДЦ4
╨Т ╤Н╤В╨╛╨╝ ╨┐╤А╨╕╨╝╨╡╤А╨╡ ╤А╨░╤Б╤З╨╡╤В╨░ IRR ╨╛╨▒╤Й╨╡╨╡ ╨║╨╛╨╗╨╕╤З╨╡╤Б╤В╨▓╨╛ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╣ ╤А╨░╨▓╨╜╨╛ ╨┐╤П╤В╨╕. -10 000 ╨╛╨▒╨╛╨╖╨╜╨░╤З╨░╨╡╤В ╨▓╤Л╨┐╨╛╨╗╨╜╨╡╨╜╨╜╤Л╨╣ ╨┐╨╗╨░╤В╨╡╨╢. ╨б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П ╨┐╤А╨╕╨▓╨╡╨┤╨╡╨╜╤Л ╨╖╨░ ╨│╨╛╨┤, ╤В. ╨╡. ╨┤╨╛╤Е╨╛╨┤, ╨┐╨╛╨╗╤Г╤З╨╡╨╜╨╜╤Л╨╣ ╨▓ 1-╨╝ ╨│╨╛╨┤╤Г, ╤А╨░╨▓╨╡╨╜ 2000, ╨▓╨╛ 2-╨╝ ╨│╨╛╨┤╤Г тАФ 5000, ╨▓ 3-╨╝ ╨│╨╛╨┤╤Г тАФ 4000 ╨╕ ╨▓ 5-╨╝ ╨│╨╛╨┤╤Г тАФ 6000.
╨з╤В╨╛╨▒╤Л ╤А╨░╤Б╤Б╤З╨╕╤В╨░╤В╤М ╨┤╨╛╤Е╨╛╨┤, ╨┐╨╛╨╗╤Г╤З╨╡╨╜╨╜╤Л╨╣ ╨▓ ╨║╨╛╨╜╤Ж╨╡ ╤В╤А╨╡╤Е ╨╗╨╡╤В, ╨┐╤А╨╕╨╝╨╡╨╜╨╕╤В╨╡ ╤Д╨╛╤А╨╝╤Г╨╗╤Г IRR ╨║ ╤П╤З╨╡╨╣╨║╨░╨╝ ╨▓ ╨┤╨╕╨░╨┐╨░╨╖╨╛╨╜╨╡ ╨╛╤В B2:B4. ╨а╨╡╨╖╤Г╨╗╤М╤В╨░╤В ╤Б╨╛╤Б╤В╨░╨▓╨╗╤П╨╡╤В -19%, ╤В╨░╨║ ╨║╨░╨║ ╤Б╤Г╨╝╨╝╨░ ╨┐╨╗╨░╤В╨╡╨╢╨░ ╨▓ ╨╜╨░╤З╨░╨╗╤М╨╜╤Л╨╣ ╨│╨╛╨┤ ╨▒╨╛╨╗╤М╤И╨╡, ╤З╨╡╨╝ ╨┤╨╛╤Е╨╛╨┤ ╨┐╤А╨╡╨┤╤Л╨┤╤Г╤Й╨╡╨│╨╛ ╨│╨╛╨┤╨░.
╨з╤В╨╛╨▒╤Л ╤А╨░╤Б╤Б╤З╨╕╤В╨░╤В╤М ╨┤╨╛╤Е╨╛╨┤, ╨┐╨╛╨╗╤Г╤З╨╡╨╜╨╜╤Л╨╣ ╨▓ ╨║╨╛╨╜╤Ж╨╡ ╨┐╤П╤В╨╕ ╨╗╨╡╤В, ╨┐╤А╨╕╨╝╨╡╨╜╨╕╤В╨╡ ╤Д╨╛╤А╨╝╤Г╨╗╤Г IRR ╨║ ╤П╤З╨╡╨╣╨║╨░╨╝ ╨▓ ╨┤╨╕╨░╨┐╨░╨╖╨╛╨╜╨╡ ╨╛╤В B2: B6. ╨а╨╡╨╖╤Г╨╗╤М╤В╨░╤В 22%. ╨а╨╡╨╖╤Г╨╗╤М╤В╨░╤В ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╤Л╨╣, ╨┐╨╛╤Б╨║╨╛╨╗╤М╨║╤Г ╨┤╨╛╤Е╨╛╨┤, ╨┐╨╛╨╗╤Г╤З╨╡╨╜╨╜╤Л╨╣ ╨▓ ╨┐╨╛╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╡ ╨│╨╛╨┤╤Л, ╨┐╤А╨╡╨▓╤Л╤И╨░╨╡╤В ╤Б╤Г╨╝╨╝╤Г ╨┐╨╗╨░╤В╨╡╨╢╨░, ╨▓╨╗╨╛╨╢╨╡╨╜╨╜╤Г╤О ╨▓ ╨┐╨╡╤А╨▓╤Л╨╣ ╨│╨╛╨┤.
╨Я╤А╨╕╨╝╨╡╤А тДЦ 5. ╨а╨░╤Б╤З╨╡╤В IRR ╨▓ Excel VBA
╨д╤Г╨╜╨║╤Ж╨╕╤О IRR ╨╝╨╛╨╢╨╜╨╛ ╨╕╤Б╨┐╨╛╨╗╤М╨╖╨╛╨▓╨░╤В╤М ╨▓ ╨║╨╛╨┤╨╡ VBA ╨Ъ╨╛╨┤ VBA ╨Ъ╨╛╨┤ VBA ╨╛╤В╨╜╨╛╤Б╨╕╤В╤Б╤П ╨║ ╨╜╨░╨▒╨╛╤А╤Г ╨╕╨╜╤Б╤В╤А╤Г╨║╤Ж╨╕╨╣, ╨╜╨░╨┐╨╕╤Б╨░╨╜╨╜╤Л╤Е ╨┐╨╛╨╗╤М╨╖╨╛╨▓╨░╤В╨╡╨╗╨╡╨╝ ╨╜╨░ ╤П╨╖╤Л╨║╨╡ ╨┐╤А╨╛╨│╤А╨░╨╝╨╝╨╕╤А╨╛╨▓╨░╨╜╨╕╤П ╨┐╤А╨╕╨╗╨╛╨╢╨╡╨╜╨╕╨╣ Visual Basic ╨▓ ╤А╨╡╨┤╨░╨║╤В╨╛╤А╨╡ Visual Basic (VBE) ╨┤╨╗╤П ╨▓╤Л╨┐╨╛╨╗╨╜╨╡╨╜╨╕╤П ╨╛╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╜╨╛╨╣ ╨╖╨░╨┤╨░╤З╨╕. ╨Я╨╛╨┤╤А╨╛╨▒╨╜╨╡╨╡ ╨▓ Microsoft Excel ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╝ ╨╛╨▒╤А╨░╨╖╨╛╨╝:
╨д╨╛╤А╨╝╤Г╨╗╨░ IRR ╨▓ Excel VBA:
╨д╨╛╤А╨╝╤Г╨╗╨░ Irr ╨▓ VBA ╨▓╤Л╨│╨╗╤П╨┤╨╕╤В ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╝ ╨╛╨▒╤А╨░╨╖╨╛╨╝.
╨У╨┤╨╡,
╨ж╨╡╨╜╨╜╨╛╤Б╤В╨╕ = ╨Ф╨╡╨╜╨╡╨╢╨╜╤Л╨╣ ╨┐╨╛╤В╨╛╨║
IRRval = ╨Т╨╜╤Г╤В╤А╨╡╨╜╨╜╤П╤П ╨╜╨╛╤А╨╝╨░ ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╨╕
IRR ╨▓ ╨┐╤А╨╕╨╝╨╡╤А╨╡ Excel VBA
╨Ф╨░╨▓╨░╨╣╤В╨╡ ╤А╨░╤Б╤Б╨╝╨╛╤В╤А╨╕╨╝ ╨┐╤А╨╕╨╝╨╡╤А ╨┤╨╗╤П Irr ╨▓ VBA.
╨Т ╤Н╤В╨╛╨╝ ╨┐╤А╨╕╨╝╨╡╤А╨╡ ╨▓╤Л╤З╨╕╤Б╨╗╨╡╨╜╨╕╤П IRR IRRal ╤П╨▓╨╗╤П╨╡╤В╤Б╤П ╨┐╨╡╤А╨╡╨╝╨╡╨╜╨╜╨╛╨╣ ╤В╨╕╨┐╨░ double. ╨Ю╨╜ ╤Б╨╛╨┤╨╡╤А╨╢╨╕╤В ╤А╨╡╨╖╤Г╨╗╤М╤В╨░╤В, ╨▓╨╛╨╖╨▓╤А╨░╤Й╨░╨╡╨╝╤Л╨╣ ╤Д╤Г╨╜╨║╤Ж╨╕╨╡╨╣ IRR. ╨Ч╨╜╨░╤З╨╡╨╜╨╕╤П ╨┐╤А╨╡╨┤╤Б╤В╨░╨▓╨╗╨╡╨╜╤Л ╨▓ ╨╝╨░╤Б╤Б╨╕╨▓╨╡ ╤В╨╕╨┐╨░ ╨┤╨░╨╜╨╜╤Л╤Е double, ╨│╨┤╨╡ ╨╜╨░╤З╨░╨╗╤М╨╜╨╛╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ ╤А╨░╨▓╨╜╨╛ -10000, ╤З╤В╨╛ ╤Г╨║╨░╨╖╤Л╨▓╨░╨╡╤В ╨╜╨░ ╨┐╨╗╨░╤В╨╡╨╢, ╤Б╨┤╨╡╨╗╨░╨╜╨╜╤Л╨╣ ╨▓ ╨┐╨╡╤А╨▓╤Л╨╣ ╨│╨╛╨┤. ╨Э╨░╨┐╤А╨╕╨╝╨╡╤А, ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П тАФ 2┬а000, 5┬а000, 4┬а000 ╨╕ 6┬а000 тАФ ╨┐╨╛╨║╨░╨╖╤Л╨▓╨░╤О╤В ╨│╨╛╨┤╨╛╨▓╨╛╨╣ ╨┤╨╛╤Е╨╛╨┤, ╨┐╨╛╨╗╤Г╤З╨╡╨╜╨╜╤Л╨╣ ╨▓ ╤В╨╡╤З╨╡╨╜╨╕╨╡ ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╤Е ╤З╨╡╤В╤Л╤А╨╡╤Е ╨╗╨╡╤В.
╨в╨╛, ╤З╤В╨╛ ╨╜╤Г╨╢╨╜╨╛ ╨╖╨░╨┐╨╛╨╝╨╜╨╕╤В╤М
- ╨Ь╨░╤Б╤Б╨╕╨▓ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╣ (╨┤╨╕╨░╨┐╨░╨╖╨╛╨╜) ╨┤╨╛╨╗╨╢╨╡╨╜ ╤Б╨╛╨┤╨╡╤А╨╢╨░╤В╤М ╨║╨░╨║ ╨╝╨╕╨╜╨╕╨╝╤Г╨╝ ╨╛╨┤╨╜╨╛ ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╨╛╨╡ ╨╕ ╨╛╨┤╨╜╨╛ ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╨╛╨╡ ╤З╨╕╤Б╨╗╨╛.
- ╨Ч╨╜╨░╤З╨╡╨╜╨╕╤П ╨┤╨╛╨╗╨╢╨╜╤Л ╨▒╤Л╤В╤М ╨▓ ╨┐╨╛╤Б╨╗╨╡╨┤╨╛╨▓╨░╤В╨╡╨╗╤М╨╜╨╛╨╝ ╨┐╨╛╤А╤П╨┤╨║╨╡. IRR ╨╕╤Б╨┐╨╛╨╗╤М╨╖╤Г╨╡╤В ╨┐╨╛╤А╤П╨┤╨╛╨║ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╣ ╨┤╨╗╤П ╨╕╨╜╤В╨╡╤А╨┐╤А╨╡╤В╨░╤Ж╨╕╨╕ ╨┐╨╛╤А╤П╨┤╨║╨░ ╨┤╨╡╨╜╨╡╨╢╨╜╤Л╤Е ╨┐╨╛╤В╨╛╨║╨╛╨▓. ╨Я╨╛╨╢╨░╨╗╤Г╨╣╤Б╤В╨░, ╨▓╨▓╨╡╨┤╨╕╤В╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П ╨┐╨╗╨░╤В╨╡╨╢╨░ ╨╕ ╨┤╨╛╤Е╨╛╨┤╨░ ╨▓ ╤В╨╛╨╣ ╨┐╨╛╤Б╨╗╨╡╨┤╨╛╨▓╨░╤В╨╡╨╗╤М╨╜╨╛╤Б╤В╨╕, ╨▓ ╨║╨╛╤В╨╛╤А╨╛╨╣ ╨╛╨╜╨╕ ╨┐╤А╨╛╨╕╤Б╤Е╨╛╨┤╤П╤В, ╨╕╨╗╨╕ ╨╡╤Б╨╗╨╕ ╨▓╤Л ╤Е╨╛╤В╨╕╤В╨╡, ╤З╤В╨╛╨▒╤Л ╤Н╤В╨╛ ╨┐╤А╨╛╨╕╨╖╨╛╤И╨╗╨╛.
- ╨н╤В╨╕ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П ╨╕╨│╨╜╨╛╤А╨╕╤А╤Г╤О╤В╤Б╤П, ╨╡╤Б╨╗╨╕ ╨░╤А╨│╤Г╨╝╨╡╨╜╤В ╨╝╨░╤Б╤Б╨╕╨▓╨░ ╨╕╨╗╨╕ ╤Б╤Б╤Л╨╗╨║╨╕ ╤Б╨╛╨┤╨╡╤А╨╢╨╕╤В ╤В╨╡╨║╤Б╤В, ╨╗╨╛╨│╨╕╤З╨╡╤Б╨║╨╕╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤П ╨╕╨╗╨╕ ╨┐╤Г╤Б╤В╤Л╨╡ ╤П╤З╨╡╨╣╨║╨╕.
- MS Excel ╨╕╤Б╨┐╨╛╨╗╤М╨╖╤Г╨╡╤В ╨╕╤В╨╡╤А╨░╤В╨╕╨▓╨╜╤Л╨╣ ╨╝╨╡╤В╨╛╨┤ ╨┤╨╗╤П ╤А╨░╤Б╤З╨╡╤В╨░ IRR ╤Б ╨┐╨╛╨╝╨╛╤Й╤М╤О Excel. ╨Э╨░╤З╨╕╨╜╨░╤П ╤Б ╨┐╤А╨╡╨┤╨┐╨╛╨╗╨╛╨╢╨╡╨╜╨╕╤П, IRR ╤Ж╨╕╨║╨╗╨╕╤З╨╡╤Б╨║╨╕ ╨┐╨╛╨▓╤В╨╛╤А╤П╨╡╤В ╤А╨░╤Б╤З╨╡╤В, ╨┐╨╛╨║╨░ ╤А╨╡╨╖╤Г╨╗╤М╤В╨░╤В ╨╜╨╡ ╨▒╤Г╨┤╨╡╤В ╤В╨╛╤З╨╜╤Л╨╝ ╨▓ ╨┐╤А╨╡╨┤╨╡╨╗╨░╤Е 0,00001 ╨┐╤А╨╛╤Ж╨╡╨╜╤В╨░; ╨╡╤Б╨╗╨╕ IRR ╨╜╨╡ ╨╝╨╛╨╢╨╡╤В ╨╜╨░╨╣╤В╨╕ ╤А╨╡╨╖╤Г╨╗╤М╤В╨░╤В, ╨║╨╛╤В╨╛╤А╤Л╨╣ ╤А╨░╨▒╨╛╤В╨░╨╡╤В ╨┐╨╛╤Б╨╗╨╡ 20 ╨┐╨╛╨┐╤Л╤В╨╛╨║, #╨з╨Ш╨б╨Ы╨Ю! ╨Т╨╛╨╖╨▓╤А╨░╤Й╨░╨╡╤В╤Б╤П ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ ╨╛╤И╨╕╨▒╨║╨╕.
- ╨Х╤Б╨╗╨╕ ╤Д╤Г╨╜╨║╤Ж╨╕╤П IRR ╨▓ Excel ╨▓╨╛╨╖╨▓╤А╨░╤Й╨░╨╡╤В ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ #╨з╨Ш╨б╨Ы╨Ю! ╨╕╨╗╨╕ ╤А╨╡╨╖╤Г╨╗╤М╤В╨░╤В ╨╜╨╡ ╤В╨░╨║╨╛╨╣, ╨║╨░╨║ ╨▓╤Л ╨╛╨╢╨╕╨┤╨░╨╗╨╕, ╨┐╨╛╨┐╤А╨╛╨▒╤Г╨╣╤В╨╡ ╤Б ╨┤╤А╤Г╨│╨╕╨╝ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡╨╝.
- ╨Т ╨▒╨╛╨╗╤М╤И╨╕╨╜╤Б╤В╨▓╨╡ ╤Б╨╗╤Г╤З╨░╨╡╨▓ ╨▓╨░╨╝ ╨╜╨╡ ╨╜╤Г╨╢╨╜╨╛ ╤Г╨║╨░╨╖╤Л╨▓╨░╤В╤М ╨┐╤А╨╡╨┤╨┐╨╛╨╗╨░╨│╨░╨╡╨╝╨╛╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ ╨┤╨╗╤П ╤А╨░╤Б╤З╨╡╤В╨░ IRR ╨▓ Excel. ╨Ю╨┤╨╜╨░╨║╨╛, ╨╡╤Б╨╗╨╕ ╨┐╨░╤А╨░╨╝╨╡╤В╤А ╤Г╨│╨░╨┤╤Л╨▓╨░╨╜╨╕╤П ╨┐╤А╨╛╨┐╤Г╤Й╨╡╨╜, ╨┐╤А╨╛╨│╤А╨░╨╝╨╝╨╜╨╛╨╡ ╨╛╨▒╨╡╤Б╨┐╨╡╤З╨╡╨╜╨╕╨╡ ╨┐╤А╨╕╨╜╨╕╨╝╨░╨╡╤В ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ 0,1, ╤В. ╨╡. 10%.
- IRR ╤В╨╡╤Б╨╜╨╛ ╤Б╨▓╤П╨╖╨░╨╜╨░ ╤Б NPV, ╤Д╤Г╨╜╨║╤Ж╨╕╨╡╨╣ ╤З╨╕╤Б╤В╨╛╨╣ ╨┐╤А╨╕╨▓╨╡╨┤╨╡╨╜╨╜╨╛╨╣ ╤Б╤В╨╛╨╕╨╝╨╛╤Б╤В╨╕. ╨Э╨╛╤А╨╝╨░ ╨┐╤А╨╕╨▒╤Л╨╗╨╕, ╤А╨░╤Б╤Б╤З╨╕╤В╨░╨╜╨╜╨░╤П ╤Б ╨┐╨╛╨╝╨╛╤Й╤М╤О IRR ╤Б ╨┐╨╛╨╝╨╛╤Й╤М╤О Excel, ╨┐╤А╨╡╨┤╤Б╤В╨░╨▓╨╗╤П╨╡╤В ╤Б╨╛╨▒╨╛╨╣ ╨┐╤А╨╛╤Ж╨╡╨╜╤В╨╜╤Г╤О ╤Б╤В╨░╨▓╨║╤Г, ╤Б╨╛╨╛╤В╨▓╨╡╤В╤Б╤В╨▓╤Г╤О╤Й╤Г╤О ╨╜╤Г╨╗╨╡╨▓╨╛╨╣ ╤З╨╕╤Б╤В╨╛╨╣ ╤В╨╡╨║╤Г╤Й╨╡╨╣ ╤Б╤В╨╛╨╕╨╝╨╛╤Б╤В╨╕. ╨╛╤В╤В╨╛╨║╨╕ ╨╖╨░ ╨┐╨╡╤А╨╕╨╛╨┤ ╤А╨╡╨░╨╗╨╕╨╖╨░╤Ж╨╕╨╕ ╨┐╤А╨╛╨╡╨║╤В╨░. ╨Х╤Б╨╗╨╕ ╤А╨░╨╖╨╜╨╕╤Ж╨░ ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╨░, ╨┐╤А╨╛╨╡╨║╤В ╨┐╤А╨╕╨▒╤Л╨╗╤М╨╜╤Л╨╣; ╨▓ ╨┐╤А╨╛╤В╨╕╨▓╨╜╨╛╨╝ ╤Б╨╗╤Г╤З╨░╨╡ ╤Н╤В╨╛ ╨╜╨╡ ╤В╨░╨║.╨Я╨╛╨┤╤А╨╛╨▒╨╜╨╡╨╡.
IRR ╨▓ ╨▓╨╕╨┤╨╡╨╛ Excel
╨а╨╡╨║╨╛╨╝╨╡╨╜╨┤╤Г╨╡╨╝╤Л╨╡ ╤Б╤В╨░╤В╤М╨╕
╨н╤В╨░ ╤Б╤В╨░╤В╤М╤П ╨┐╤А╨╡╨┤╤Б╤В╨░╨▓╨╗╤П╨╡╤В ╤Б╨╛╨▒╨╛╨╣ ╤А╤Г╨║╨╛╨▓╨╛╨┤╤Б╤В╨▓╨╛ ╨┐╨╛ ╤А╨░╤Б╤З╨╡╤В╤Г IRR ╨▓ Excel. ╨Ь╤Л ╨╛╨▒╤Б╤Г╨╢╨┤╨░╨╡╨╝ ╤Д╨╛╤А╨╝╤Г╨╗╤Г ╨╕ ╤Д╤Г╨╜╨║╤Ж╨╕╤О IRR ╨▓ Excel, ╤А╨░╤Б╤З╨╡╤В╤Л, ╨┐╤А╨╕╨╝╨╡╤А╤Л ╨╕ ╨╖╨░╨│╤А╤Г╨╢╨░╨╡╨╝╤Л╨╡ ╤И╨░╨▒╨╗╨╛╨╜╤Л. ╨Т╤Л ╤В╨░╨║╨╢╨╡ ╨╝╨╛╨╢╨╡╤В╨╡ ╨┐╨╛╤Б╨╝╨╛╤В╤А╨╡╤В╤М ╨╜╨░ ╤Н╤В╨╕ ╨┤╤А╤Г╨│╨╕╨╡ ╤Д╤Г╨╜╨║╤Ж╨╕╨╕ ╨┐╨╛╨╕╤Б╨║╨░ ╨╕ ╤Б╤Б╤Л╨╗╨╛╨║ ╨▓ Excel:
- ╨Я╤А╨╕╨╝╨╡╤А╤Л ╨▓╨╜╤Г╤В╤А╨╡╨╜╨╜╨╡╨╣ ╨╜╨╛╤А╨╝╤Л ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╨╕
- IRR ╨┐╤А╨╛╤В╨╕╨▓ ROI
- ╨Ь╨░╤В╨╡╨╝╨░╤В╨╕╤З╨╡╤Б╨║╨░╤П ╤Д╤Г╨╜╨║╤Ж╨╕╤П Excel
- ╨Я╨╛╨╗╤М╨╖╨╛╨▓╨░╤В╨╡╨╗╤М╤Б╨║╨╕╨╡ ╤Д╤Г╨╜╨║╤Ж╨╕╨╕ ╨▓ Excel
Программы для Windows, мобильные приложения, игры - ВСЁ БЕСПЛАТНО, в нашем закрытом телеграмм канале - Подписывайтесь:)