Skip navigation

IRR: Calculating internal rate of return

IRR: Calculating internal rate of return: Excel 2016: Financial Functions in Depth
IRR: Calculating internal rate of return: Excel 2016: Financial Functions in Depth

Calculating an investment’s internal rate of return enables you to identify the interest rate at which the investment future cash flows have a net present value of zero. In other words, your formula tells you the discount rate at which you would break even on a given investment. If the IRR formula returns a value greater than the interest rate of risk-free investments, you should take the plunge.

Resume Transcript Auto-Scroll
Skill Level Intermediate
2h 38m
Duration
68,701
Views
Show More Show Less
Skills covered in this course
Business Spreadsheets Excel

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now