17 Below is Challenge Homework 18 19 Internal Rate of Return (IRR) 20 Since there is significant judgement/discretion in what the appropriate discount rate is in calculating the present value an alternative approach is to calculate the 'Internal Rate of Return' (IRR) 21 22 A company makes an investment of $500 in the current year that generates a return in the next 10 future years. 23 24 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 25 Cash Flows -500 100 110 121 133 146 161 177 195 214 236 26 27 The Internal Rate of Return (IRR) function calculates the discount rate that reduces the cash flow stream to a Net Present Value of zero. 28 An IRR can only be calculated if at least one of the cash flows is negative and at least one is positive. 29 Click on the Function in the box immediately below to see the expression '=IRR(B125:M125)'. 30 31 Write a formula in the green cell below to calculate the Internal Rate of Return of the following series of cash flows in which the initial investment was $1000 rather than $500 above. 32 33 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 34 Cash Flows -1000 100 110 121 133 146 161 177 195 214 236 35 IRR 36 24%