Calculating Commercial Mortgage Payments: Principal and Interest
Calculating commercial mortgage payments starts with principal, a periodic interest rate, and the number of amortization periods—not necessarily the number of periods until maturity. For the fixed-rate, monthly model here, those inputs produce one level P&I payment. Each payment then divides into interest and principal reduction.
This tutorial works through a hypothetical $1 million loan at a fixed 6% nominal annual rate, with 25-year amortization and a five-year term. You will reproduce the payment, check its spreadsheet equivalent, and reconcile the first two payment components.
The example assumes end-of-month payments and excludes fees, escrows, prepayments, and interest-only periods. It is educational, not a financing offer, payoff quote, or personalized financial advice. Actual loan payments require confirmation against the documents and lender schedule.
In this guide: Inputs · Formula · Worked calculation · Payment split · Error checks
What inputs determine a monthly mortgage payment?
Principal, nominal interest rate, and payment frequency
Principal is the starting amount being amortized. In this example it is $1,000,000. The nominal annual interest rate is 6.00%, which is 0.06 as a decimal.
The model uses 12 monthly periods per year, so its periodic rate is:
r = 0.06 ÷ 12 = 0.005.
That is 0.5% per month. Do not divide by 12 again after entering 0.005 as the monthly rate. Equally, do not use the number 6 in a formula field that expects a decimal annual rate.
A nominal rate and APR are not interchangeable inputs by default. Use the rate appropriate to the stated calculation. If the actual schedule uses daily accrual or a different payment frequency, this monthly convention needs to be replaced or reconciled—not assumed correct because the annual percentage looks similar.
Amortization periods rather than loan-term periods
The payment is calculated over 25 × 12 = 300 amortization periods. The five-year term contains 60 monthly payments, but 60 is not the payment formula’s period input for this structure.
Term months identify where to measure the maturity balance. Amortization months size the regular installment. Using 60 in the formula would instead calculate a payment intended to repay principal across five years.
Before calculating, write both numbers down with labels. This simple separation prevents a technically correct formula from answering the wrong financing question.
How to use the fixed-rate principal-and-interest formula
Define P, r, n, and A
For positive periodic interest, use:
A = P × r / (1 − (1 + r)^(−n))
| Variable | Meaning | Example input or output |
|---|---|---|
| P | Principal being amortized | $1,000,000 |
| r | Interest rate per monthly period | 0.005 |
| n | Number of amortization payments | 300 |
| A | Regular monthly P&I payment | Calculated below |
The exponent is negative: −n. The denominator is the entire expression 1 − (1 + r)^(−n). Missing parentheses or changing the exponent’s sign changes the equation rather than creating a small rounding discrepancy.
The formula sizes a constant payment that would reduce the balance to approximately zero after n payments under unchanged assumptions. When maturity occurs sooner, it still supplies the regular installment, but it does not eliminate the residual at that earlier date.
Handle zero interest and payment timing
At a zero rate, do not use the positive-rate expression directly because it produces a division by zero. Instead use:
A = P/n.
For $1 million over 300 periods at 0%, the payment is $3,333.33 when displayed to cents. After 60 payments calculated with internal precision, the remaining balance is $800,000.00.
All examples here assume payments at the end of each period. A beginning-of-period payment setting is a different timing assumption. Check it explicitly in software instead of allowing a default to determine the model unnoticed.
Calculating commercial mortgage payments step by step
Substitute the $1 million, 6%, 25-year inputs
Substitute the defined values:
A = 1,000,000 × 0.005 / (1 − (1.005)^(−300))
The numerator is $5,000. The denominator accounts for the full 300-period repayment calculation. Evaluating the expression produces:
A = $6,443.014014855…, displayed as $6,443.01 monthly P&I.
A full year of unchanged payments is calculated using the unrounded amount:
12 × $6,443.014014855… = $77,316.17, rounded for display.
Multiplying the displayed $6,443.01 by 12 gives $77,316.12 instead. The five-cent difference is caused by when rounding occurs, not by a different interest rate. State the convention and apply it consistently through payment, schedule, and annual totals.
The payment alone is not a complete five-year loan model. Under these assumptions, principal remaining after payment 60 is $899,320.87. That amount is a separate maturity output rather than an extra component inside the regular P&I formula.
Cross-check the result in a spreadsheet
For a spreadsheet using the standard PMT argument order, the proposed cross-check is:
=-PMT(6%/12,25*12,1000000,0,0)
The arguments specify monthly rate, amortization periods, present principal, zero future balance at the amortization endpoint, and end-of-period payments. Where those last two arguments default to zero, the shorter expression is:
=-PMT(6%/12,25*12,1000000)
With principal entered as a positive receipt, PMT represents the repayment as a negative cash flow. The leading minus sign presents the payment as a positive outflow amount for this tutorial. An alternative is to enter principal as negative and omit the leading minus; keep signs consistent rather than applying both changes.
The formula’s expected result is $6,443.014014855… under the stated argument convention, matching the direct annuity calculation. Verify syntax, argument defaults, and the result in the spreadsheet application actually used, including any locale-specific separators.
A useful cross-check changes one input as well as testing the baseline. With 240 amortization months and all other assumptions unchanged, the payment becomes $7,164.31. This confirms that the worksheet references the amortization field rather than accidentally hard-coding 300.
Commercial real estate principal and interest breakdown
Interest equals opening balance times periodic rate
The first payment’s interest uses the initial principal:
$1,000,000 × 0.005 = $5,000.00.
This is the month’s interest component, not the full payment. Using original principal for every future month would model a constant interest amount rather than the declining-balance amortization described here.
Principal equals payment less interest
Subtract interest from the unrounded regular payment:
$6,443.014014855… − $5,000 = $1,443.014014855…
The displayed principal component is $1,443.01. The closing balance becomes $998,556.99 after display rounding.
[IMAGE: Commercial real estate principal and interest example: $1,443.01 principal plus $5,000 interest equals a $6,443.01 payment.]The payment reconciliation is straightforward: $5,000.00 interest plus $1,443.01 principal equals $6,443.01. The balance reconciliation subtracts principal only. Subtracting the whole installment from the balance would incorrectly treat interest as repayment of borrowed money.
Repeat with the new opening balance
Month two begins with the prior closing balance at internal precision. Multiplying that balance by 0.005 produces $4,992.78 of displayed interest. Subtracting interest from the regular payment produces $1,450.23 of displayed principal. The new closing balance is $997,106.76.
The smaller interest portion leaves more of the fixed installment available for principal. To follow principal and interest across the schedule, repeat the same linked-row process rather than recalculating the payment from scratch each month.
These month-two outputs also provide an error check: if interest is still $5,000 in this unchanged amortizing scenario, the worksheet may be referencing original principal instead of the current opening balance.
What costs and calculation limits should you check?
Taxes, insurance, escrows, reserves, and fees
The P&I formula includes only its defined repayment components. Taxes, insurance, escrow collections, reserves, and fees are outside this simplified calculation. Their treatment must be established separately in an actual cash-flow model.
Do not add unrelated property expenses to the interest rate to force them into the formula. Instead, keep a clearly labeled reconciliation between loan P&I, any other financing cash outflows, and other property costs.
From a monthly payment to debt-service analysis
Once the payment is verified, apply payments to a debt-service calculation using the correct reporting period. Twelve identical monthly payments can be annualized; changing payments and partial years need period-by-period sums.
This handoff matters because an accurate installment does not guarantee an accurate annual worksheet. The model can still omit a loan obligation, include the wrong months, or confuse pre-debt-service property income with cash remaining after payments.
Percent-versus-decimal errors, period mismatches, and early rounding
| Potential error | Check |
|---|---|
| Using 6 instead of 0.06 | Confirm whether the field expects percent or decimal |
| Using annual rate with monthly periods | Use a compatible periodic rate |
| Using 60 instead of 300 | Separate term months from amortization months |
| Wrong payment timing | Confirm end-of-period settings |
| Early or inconsistent rounding | Document precision and display conventions |
| Subtracting all P&I from principal | Subtract only the principal component |
Floating rates, IO, daily accrual, and irregular payment dates
A floating-rate structure, interest-only phase, daily accrual method, or irregular interval needs a compatible model. The simple formula does not verify those structures merely because it can accept a different rate or period count.
Use this tutorial to reproduce the stated fixed-rate calculation, then compare the result with the actual schedule. Unexplained differences should remain visible for lender or professional review rather than being hidden with an arbitrary adjustment.
FAQ
Why use 300 periods when the term is five years?
The example amortizes payments over 25 years. The 60-month term identifies the maturity checkpoint, not the repayment formula’s full period count.
Why is PMT negative?
With positive principal received, the spreadsheet represents repayments as opposite-direction cash flows. The leading minus sign displays a positive payment amount here.
Does monthly P&I include all property costs?
No. The simplified calculation excludes taxes, insurance, reserves, fees, and other cash outflows.
What changes at a zero rate?
Use principal divided by amortization periods. No interest component is included, and each payment reduces principal by the payment amount under the model.