Please include all the details and how to solve

$0 1 Solving for N in an Annuity 2 Present Value 3 Future Value 10,000.00 4 Annual Payment 1,846.27 5 Annual Rate 4.00% 6 Number of Years 8 Hint: make PMT a nagative number. 9 Use NPER function. 70 11 Excel also offers the built-in NPER function, which also works with lump sums, to solve 12 problems of this type directly. This function is defined as: 13 NPER(RATE, PMT, PV, FV, TYPE) 14 where all of the arguments are as previously defined. To use this function, you must know 15 the payment, per period interest rate, and either the present value or future value or both. 16 17 KEY: (1) you can see PMT as negative and future value as positive 18 (2) Or you can see FV as negative and PMT as positive 21