A 100,000 loan agreement has payments and inputs as follows. Calculate the XNPV, XIRR, NPV and IRR of the resulting cash flows Item Notes Initial Cash Flow (PV) 10,000.00 Start Date 01-Jan-2008 Interval (Months) 6 Year One 1,000.00 Year Two 1,500.00 Year Three 2,000.00 Salvage Value (FV) 100.00 Total Periods (N) 12.00 Discount Rate % (INT) 10.00
Calculate each in excel & show your work