Use the following information to calculate the mortgage payment at the end.
Most recent interest rate: 4.21
Historical maximum interest rate: 18.63
Time for the max (year/month/date): 1981-10-09
Historical minimum interest rate: 3.31
Time for the min (year/month/date): 2012-11-21
Median interest rate: 7.79
Mean (or average) interest rate: 8.23
Assume a 30-year fixed mortgage loan: $120,000
Calculate monthly mortgage payment based on: PMT (monthly)
using historical maximum interest rate:
using most recent interest rate :