Excel Basics for Finance

(a) Enter 5% as the interest rate. NPV = $113,822 (b) Enter 8% as the interest rate. NPV = $105,625 (c) Enter 11% as the interest rate. NPV = $98,355 (d) Now enter 100,000 as Flow 0, by editing the cash flow list or reentering all the flows if your calculator does not scroll through the list. Then: IRR = 10.29%. 52 Chapter 5. The Time Value of ... ................
................