show using Microsoft ExCelShow using Microsoft ExCel

A borrower is evaluating a loan $100,000 with annual rate of interest at 12%. He anticipates making monthly payments of $2,000 then a lump sum payment of $10,000. How long is he expecting to be paying this loan (rounded to the nearest number years / months)? A. 66 months B. 5 years C. 5 years and 3 months D. 63 months