Skip to main content

Estimate Monthly Mortgage Payments

Powerful math in a simple calculator

Michael Schwabe avatar
Written by Michael Schwabe
Updated over a month ago

While Asset-Map's inline calculator is designed for quick calculations, allowing advisors to stay within the application (see more here), it is also capable of handling more complex formulas, such as estimating monthly mortgage payments in a value field on the Asset-Map platform. Here is an example.

((r)*P / (1 - ((1 + r)) ^ (-N)))

If you precede the equation with an "=" in a value field, you can derive a rough estimate of what a monthly payment could be. (Of course, there are other considerations like insurance and escrow, to name a few, which aren't considered in Asset-Map.) Once the monthly amount is computed, multiply it by 12 to get an annualized value.

Here's an example using the formula:

((r)*P / (1 - ((1 + r)) ^ (-N)))

=((6.5 / 100 / 12) * 200000) / (1 - ((1 + (6.5 / 100 / 12)) ^ (-30 * 12)))

  • r is the monthly interest rate = 6.5% / 12

  • P is the principal = $200000

  • N is the number of monthly payments = 30*12 = 360

  • Tapping "enter" will display $1264 / month in the value field.

Since Asset-Map Platform uses annualized amounts in value fields the monthly dollar amount should be multiplied by 12 to get the annual figure.

Please note: Asset-Map does not calculate amortization. This is a demonstration of the calculator feature within the value fields of Asset-Map Platform only. Accuracy and other compliance considerations must be evaluated by the Financial Professional.

Visit our Financial Calculators resource page to find a variety of financial calculators (including a Loan Amortization Calculator) that may be useful to you. Please note that these link to third-party sites, and we do not guarantee their accuracy or endorse their services. πŸ‘‰πŸΌ Financial Calculators

tags: amortization, loan, mortgage, property, calculator

7/2025

Did this answer your question?