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