It can be used as a worksheet function WS and a VBA function VBA in Excel. FV one of the financial functions calculates the future value of an investment based on a constant interest rateYou can use FV with either periodic constant payments or a single lump sum payment. To calculate an estimated mortgage payment in Excel with a formula you can use the PMT function.
FV one of the financial functions calculates the future value of an investment based on a constant interest rateYou can use FV with either periodic constant payments or a single lump sum payment.
PMT B1 B2 B3 Please remember that the payment is returned. To calculate monthly mortgage payment you need to list some information and data as below screenshot shown. In Excel the PMTfunction returns the payment amount for a loan based on an interest rate and a constant payment schedule. Loan payment as a number.