For example, if your payment for the PV formula is made monthly, then you’ll need to convert your annual interest rate to monthly by dividing by 12. Also, for NPER, which is the number of periods, if you’re collecting an annuity payment monthly for four years, the NPER is 12 time...