excell

Monday, 29 September 2014

per month saving formula

Saving account=500000

Annual interest rate=10%

Number of years=18month

Per month saving=?

So,my formula is that,how to insert per month saving formula.

=pmt(annual interest rate/12,number of year*12,0,-saving amount) then enter


No comments:

Post a Comment