From the course: Google Sheets: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Calculate the internal rate of return (IRR) of an investment - Google Sheets Tutorial
From the course: Google Sheets: Advanced Formulas and Functions
Calculate the internal rate of return (IRR) of an investment
- [Instructor] Calculating an investment's internal rate of return enables you to identify the interest rate at which the investment's 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 generated by risk-free investments, you should take the plunge. If not, then you should pass on the opportunity. This workbook contains a single worksheet, and it contains some information regarding two investments. I'll look at the investment cash flows first and then get back to what guess is at the top of the worksheet. These two investments will return a series of cash flows over the course of five years. You can see here that for investment one we start out by investing $100,000, and then we receive cash flows of $20,000 a year for the first four years, followed by a cash flow of 40,000 in year five. So that's a total of…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Determine loan payments2m 34s
-
(Locked)
Determine the principal and interest components of loan payments4m 21s
-
(Locked)
Calculate cumulative principal and interest paid4m 39s
-
(Locked)
Calculate the present value of an investment3m 32s
-
(Locked)
Calculate the future value of an investment3m
-
(Locked)
Calculate the effect of interest4m 1s
-
Calculate the incremental effect of inflation4m 17s
-
(Locked)
Calculate the net present value (NPV) of an investment3m 57s
-
(Locked)
Calculate the internal rate of return (IRR) of an investment2m 57s
-
(Locked)
-
-
-
-