Calculation Methodology

Overview

This document provides a comprehensive explanation of the mathematical formulas, computational methods, and data sources used by Amortio to generate loan amortization schedules, calculate monthly payments, estimate total interest costs, and produce all related financial outputs. Every calculation described here is implemented in our client-side JavaScript code, meaning all computation happens directly in your browser.

Our methodology is based on established financial mathematics as described in academic literature and used by financial institutions worldwide. We reference standard texts including Kellison's The Theory of Interest (Third Edition, Society of Actuaries), Broverman's Mathematics of Investment and Credit, and Fabozzi's Fixed Income Mathematics, as well as regulatory guidance from the Consumer Financial Protection Bureau (CFPB), the Federal Reserve, and the Government Accountability Office (GAO).

We believe that users who want to verify our calculations should have everything they need to do so. That is the purpose of this page.

The Standard Amortization Formula

The foundation of all Amortio loan calculations is the standard fixed-rate amortization formula, which computes the periodic payment required to fully repay a loan over a specified number of periods at a fixed interest rate. This formula is derived from the present value of an ordinary annuity and is universally used in consumer lending.

Monthly Payment Formula

The monthly payment (M) for a fixed-rate fully amortizing loan is calculated as:

Where:

• M = Monthly payment amount (principal + interest)
• P = Principal (original loan amount, which is the purchase price minus the down payment)
• r = Monthly interest rate (annual rate divided by 12, expressed as a decimal)
• n = Total number of monthly payments (loan term in years multiplied by 12)

This formula assumes equal monthly payments over the entire life of the loan, a fixed interest rate that does not change, and no additional fees or costs included in the payment calculation. It produces the exact payment amount required to reduce the loan balance to zero after the final payment.

Mathematical Derivation

The formula is derived from the present value of an ordinary annuity equation. The present value (PV) of a series of n equal payments of amount M, discounted at rate r per period, equals:

Since the present value of all payments must equal the original loan principal (P = PV), solving for M yields the standard amortization formula above. This derivation is found in every financial mathematics textbook and is the same formula used by banks, credit unions, and mortgage servicers to calculate loan payments.

Edge Case: Zero Interest Rate

When the interest rate is zero, the standard formula produces a division by zero. In this case, our calculator correctly defaults to the simple division: M = P / n. This is mathematically equivalent to the limit of the standard formula as r approaches zero and ensures accurate results for interest-free loans.

How We Generate Amortization Schedules

An amortization schedule is a period-by-period table showing how each payment is allocated between interest and principal, and the remaining balance after each payment. Our schedule generation follows the standard actuarial method:

For Each Payment Period (month k):

• Interest Payment (I_k): The interest portion equals the remaining balance from the previous period multiplied by the monthly interest rate. I_k = Balance_(k-1) x r. This reflects that interest accrues on the outstanding principal only.
• Principal Payment (P_k): The principal portion equals the total monthly payment minus the interest portion. P_k = M - I_k. This amount directly reduces the loan balance.
• Remaining Balance (Balance_k): The remaining balance equals the previous balance minus the principal payment. Balance_k = Balance_(k-1) - P_k.

As the loan progresses, the interest portion decreases and the principal portion increases, even though the total payment remains constant. This is because each payment reduces the outstanding balance, which in turn reduces the interest charged in subsequent periods. This characteristic amortization curve is fundamental to understanding how fixed-rate loans work.

Total Interest Calculation

The total interest paid over the life of the loan is calculated as:

This formula calculates total interest as the sum of all payments minus the original principal. Equivalently, it equals the sum of all interest portions (I_k) across all n periods. Both methods produce identical results, and our calculator uses both as a cross-check to ensure accuracy.

Rounding Precision

Financial calculations require careful handling of rounding. Our calculator uses full floating-point precision for intermediate calculations and rounds only the final displayed values to two decimal places (cents). The final payment in an amortization schedule is adjusted to exactly zero out the remaining balance, which may result in a final payment that differs by a few cents from the regular monthly payment. This is standard practice in the lending industry and reflects how actual loan servicers handle the final payment.

Extra Payment Calculations

Our Extra Payment Calculator models the impact of additional payments applied directly to principal reduction. The methodology is straightforward but produces significant results:

How Extra Payments Work

When an extra payment is made, the entire additional amount is applied to principal reduction (assuming no prepayment penalty, which our calculator notes as a consideration). The recalculated schedule proceeds as follows:

• The extra payment reduces the outstanding balance immediately.
• In the next period, interest is calculated on the reduced balance, resulting in a lower interest charge.
• Because the regular payment amount remains the same but less goes to interest, more goes to principal in every subsequent period.
• This compounding effect accelerates loan payoff and reduces total interest paid.

Our calculator supports monthly extra payments (a fixed additional amount added to each regular payment), one-time lump sum payments (applied to a specific month), and annual extra payments. For each scenario, the full amortization schedule is regenerated to show the exact impact on total interest savings and loan payoff date.

Interest Savings Calculation

Interest savings are computed as the difference between total interest paid under the original payment schedule and total interest paid under the extra payment schedule. We also calculate the number of months by which the loan is shortened, providing users with both the dollar savings and the time savings.

Debt-to-Income and Affordability Methodology

Our DTI Calculator and Affordability Calculator use industry-standard ratios established by the major government-sponsored enterprises (GSEs) and federal housing agencies.

Debt-to-Income Ratio

The debt-to-income (DTI) ratio is calculated as:

Housing expenses include the mortgage payment (principal and interest), property taxes (estimated), homeowner's insurance (estimated), and PMI if applicable. The thresholds used in our calculator (28% front-end, 36% back-end for conventional loans) are based on Fannie Mae Selling Guide Section B3-6 and Freddie Mac Seller/Servicer Guide Chapter 5501. FHA guidelines allow higher ratios (31% front-end, 43% back-end) with compensating factors. We present both conventional and FHA thresholds.

Affordability Estimation

The affordability calculator works backward from income to determine the maximum loan amount a borrower can likely qualify for. Starting with the gross monthly income and the selected DTI threshold, it calculates the maximum allowable housing expense, subtracts estimated taxes, insurance, and PMI, and uses the resulting figure as the maximum monthly principal and interest payment. The standard amortization formula is then solved for P (principal) to determine the maximum loan amount, which, combined with the specified down payment, yields the maximum purchase price.

Private Mortgage Insurance (PMI) Methodology

Our PMI Calculator estimates monthly PMI costs based on the loan-to-value (LTV) ratio, which is calculated as:

PMI is typically required when LTV exceeds 80% (down payment less than 20%). Our PMI rate estimates are based on published industry averages ranging from 0.3% to 1.5% of the original loan amount annually, depending on LTV ratio and credit score tier. We source these ranges from the Urban Institute's Housing Finance Policy Center publications and Mortgage Bankers Association industry reports.

The calculator also estimates when PMI can be removed. Under the Homeowners Protection Act of 1998, lender-paid PMI must be automatically terminated when the LTV ratio reaches 78% of the original value based on the original amortization schedule. Borrowers can request PMI removal at 80% LTV. Our calculator shows both milestones with the corresponding payment number and date.

Refinance Break-Even Methodology

Our Refinance Calculator determines whether refinancing is financially beneficial by computing the break-even period, which is the number of months until the cumulative savings from the lower rate exceed the costs of refinancing.

Simple Break-Even

This simplified method provides a quick estimate. However, our calculator also performs a month-by-month comparison of the original and refinanced loan schedules to show cumulative savings over time, accounting for the fact that refinancing resets the amortization clock and may change the total interest paid even if the monthly payment decreases.

Net Present Value Analysis

For a more accurate comparison, our calculator optionally applies net present value (NPV) analysis, discounting future savings to present dollars. This approach, recommended by the CFPB in their refinancing guidance materials, accounts for the time value of money and provides a more economically rigorous break-even calculation than the simple division method.

Rent vs. Buy Comparison Methodology

Our Rent vs. Buy Calculator compares the total cost of renting versus buying over a specified time horizon. The comparison accounts for:

• Buying costs: Down payment, closing costs (estimated at 2-5% of purchase price), monthly mortgage payments (principal + interest), property taxes, homeowner's insurance, PMI if applicable, maintenance costs (estimated at 1% of home value annually), and opportunity cost of the down payment.
• Renting costs: Monthly rent, renter's insurance, annual rent increases (user-configurable, default based on BLS CPI rent component).
• Building equity: The portion of each mortgage payment that goes to principal, plus projected home appreciation, represents wealth accumulation that has no equivalent in renting.
• Tax implications: While we do not provide tax advice, the calculator includes an optional field for the estimated tax benefit of mortgage interest deduction, clearly noting that the actual benefit depends on the user's tax situation and whether they itemize deductions.

The calculator produces a year-by-year comparison showing cumulative costs for each option and identifies the crossover point where buying becomes more financially advantageous than renting, if such a crossover exists within the analysis period.

Data Sources for Mortgage Rates

Amortio's mortgage rate data comes exclusively from authoritative, publicly available sources. We do not use proprietary or unverifiable rate data. Our primary sources are:

Federal Reserve Economic Data (FRED)

Operated by the Federal Reserve Bank of St. Louis, FRED provides access to hundreds of thousands of economic data series. For mortgage rates, we reference:

• MORTGAGE30US: 30-Year Fixed Rate Mortgage Average, sourced from Freddie Mac's PMMS
• MORTGAGE15US: 15-Year Fixed Rate Mortgage Average
• DGS10: 10-Year Treasury Constant Maturity Rate (used for spread analysis)
• FEDFUNDS: Federal Funds Effective Rate (for contextualizing rate environment)

Freddie Mac Primary Mortgage Market Survey (PMMS)

The PMMS has been published weekly since April 1971 and is the most widely cited source for current U.S. mortgage rates. The survey collects rate data from a sample of lenders nationwide for conventional conforming loans. We reference the PMMS for current national average rates displayed on our rate pages and clearly attribute the data with the survey date.

U.S. Census Bureau and Bureau of Labor Statistics

Local housing data on our city and state pages, including median home values, median household incomes, and homeownership rates, comes from Census Bureau surveys (primarily the American Community Survey 1-Year and 5-Year estimates) and BLS metropolitan area data. We specify the survey vintage when presenting this data.

How City and State Pages Combine Data

Our mortgage rate city and state pages combine national-level rate data with localized housing market data. The rate shown on each page is the current national average (from PMMS), displayed alongside local context such as the median home value and median household income for that city or state. We explicitly state that the displayed rate is a national average and that rates available to individual borrowers depend on credit score, down payment, loan type, and lender.

This approach provides useful local context without fabricating localized rate data that we cannot verify. We believe this is more honest and helpful than sites that present pseudo-local rates derived from opaque proprietary models.

Calculator Accuracy and Limitations

Amortio's calculators are designed to produce results that match, to the cent, the output of industry-standard financial software for the same inputs and assumptions. However, users should be aware of the following limitations:

What Our Calculators Include

• Exact principal and interest calculations using the standard amortization formula
• Complete period-by-period amortization schedule with running balances
• Total interest computation verified by two independent methods
• Extra payment scenarios with accurate interest savings calculations
• PMI estimation based on published industry rate ranges

What Our Calculators Do Not Include

• Lender-specific fees: Origination fees, application fees, underwriting fees, and other charges vary by lender and are not included in our standard calculations.
• Escrow details: While we estimate property taxes and insurance for affordability calculations, actual escrow amounts depend on specific property tax assessments and insurance coverage chosen.
• Adjustable-rate mortgage resets: Our standard calculator assumes a fixed rate. ARM calculations beyond the initial fixed period require rate adjustment assumptions that introduce significant uncertainty.
• Mortgage points: The trade-off between paying discount points and receiving a lower rate is not modeled in our basic calculator, as it depends on individual financial circumstances and time horizons.
• Tax implications: We do not calculate individual tax benefits from mortgage interest deductions, as these depend on filing status, income level, and itemization decisions.

Accuracy Benchmarks

We regularly test our calculator outputs against results from:

• Federal Reserve published amortization tables
• CFPB mortgage calculator examples from their consumer resources
• Microsoft Excel PMT, IPMT, and PPMT financial functions
• HP 12C financial calculator (the industry standard for financial professionals)
• Published examples in financial mathematics textbooks

In all cases, our results match to within rounding precision (typically less than $0.01 difference attributable to rounding methodology differences between systems). Discrepancies exceeding $0.01 trigger an investigation and are resolved before the code is deployed.

Privacy: Client-Side Computation

All Amortio calculations are performed entirely in your web browser using JavaScript. Your financial data, including loan amounts, interest rates, income figures, and debt amounts, is never transmitted to our servers or any third party. This architectural decision is deliberate and non-negotiable:

• No server-side processing: When you enter loan details and click "Calculate," the computation happens on your device using your browser's JavaScript engine. No data is sent to Amortio servers.
• No data collection: We do not log, store, or transmit the inputs or outputs of your calculations. There is no database of user calculations on our servers because we never receive the data.
• No accounts required: You do not need to create an account, provide an email address, or log in to use any Amortio calculator. This eliminates the possibility of linking calculations to personal identities.
• Verifiable architecture: Because our calculators run as client-side JavaScript, technically inclined users can verify our calculation logic by inspecting the source code in their browser's developer tools.

This approach means that even if our servers were compromised, no user financial data would be at risk because we never had it in the first place. For full details on our privacy practices, see our Privacy Policy.

How We Compare to Industry Tools

Users often ask how Amortio compares to calculators from Bankrate, NerdWallet, Zillow, and similar financial media sites. While all reputable mortgage calculators use the same underlying amortization formula, there are meaningful differences in implementation, business model, and transparency:

• Business Model: Most major financial media calculator sites monetize through lender referral commissions, affiliate links, and lead generation. This creates an inherent incentive to steer users toward specific products. Amortio's advertising-only model eliminates this conflict of interest.
• Methodology Transparency: Few competing sites publish their full calculation methodology. Amortio provides complete documentation of every formula, data source, and computational method on this page, enabling independent verification.
• Privacy: Many competing calculators collect user data through account creation, email capture, and server-side processing. Amortio processes all calculations client-side with zero data collection.
• Calculation Accuracy: All sites using the standard amortization formula will produce identical results for the same inputs. Where differences appear, they are typically due to different assumptions about taxes, insurance, and fees, which underscores the importance of understanding each calculator's assumptions (hence this methodology page).
• Extra Features: Some competing sites offer pre-qualification, rate shopping, and lender matching, which Amortio does not provide. These features require sharing personal financial data with lenders, which conflicts with our privacy-first approach. We focus exclusively on calculation tools and educational content.

References and Further Reading

The mathematical foundations and data sources referenced throughout this methodology page include:

Academic and Professional References

• Kellison, S.G. The Theory of Interest, Third Edition. Society of Actuaries / McGraw-Hill, 2009.
• Broverman, S.A. Mathematics of Investment and Credit, Seventh Edition. ACTEX Publications, 2017.
• Fabozzi, F.J. Fixed Income Mathematics: Analytical and Statistical Techniques, Fourth Edition. McGraw-Hill, 2006.
• Ross, S.M., Westerfield, R.W., and Jordan, B.D. Fundamentals of Corporate Finance, Thirteenth Edition. McGraw-Hill, 2022.

Government and Regulatory Sources

• Federal Reserve Bank of St. Louis, FRED Economic Data: fred.stlouisfed.org
• Freddie Mac Primary Mortgage Market Survey: freddiemac.com/pmms
• Consumer Financial Protection Bureau (CFPB) Mortgage Resources: consumerfinance.gov
• Fannie Mae Selling Guide, Section B3-6: Liability Assessment
• U.S. Census Bureau, American Community Survey: census.gov
• Bureau of Labor Statistics, Consumer Price Index: bls.gov/cpi

Industry Sources

• Urban Institute Housing Finance Policy Center: Analysis and research on mortgage markets and housing policy.
• Mortgage Bankers Association: Industry data on mortgage originations, delinquencies, and market trends.
• National Association of Realtors: Home sales data and market statistics.