Results
Monthly Payment
—
Principal & Interest
Total Principal
—
Total Interest
—
Total Payment
—
1
Loan Parameters
Loan Details
$
%
years
Term & Structure
years
years
2
Amortization Schedule
Total Payments
—
Total Interest
—
Total Amount Paid
—
| Payment # | Date | Type | Payment | Principal | Interest | Balance |
|---|---|---|---|---|---|---|
| Enter loan details above to see the amortization schedule | ||||||
NAI Long Island — Tools & Resources
How to Use the Mortgage Loan Calculator
Enter your loan details and click Calculate Payment to instantly see your estimated monthly payment, total interest cost, and a full month-by-month amortization schedule.
01
Loan Amount
Loan Amount
The total dollar amount you intend to borrow. For a commercial property purchase, this is typically the purchase price minus your down payment. Commercial lenders generally require a down payment of 20% to 35% of the purchase price, so the loan amount would be the remaining balance.
The total dollar amount you intend to borrow. For a commercial property purchase, this is typically the purchase price minus your down payment. Commercial lenders generally require a down payment of 20% to 35% of the purchase price, so the loan amount would be the remaining balance.
Example: A property priced at $2,000,000 with a 25% down payment ($500,000) would have a loan amount of $1,500,000.
02
Interest Rate
Interest Rate
The annual interest rate quoted by your lender, entered as a percentage. Enter the number only — for example, enter 7.25 for a 7.25% rate.
The annual interest rate quoted by your lender, entered as a percentage. Enter the number only — for example, enter 7.25 for a 7.25% rate.
Note: Commercial mortgage rates vary based on property type (office, industrial, retail), your credit profile, loan-to-value ratio, and current market conditions. Use the rate quoted in your term sheet or loan proposal for the most accurate estimate.
03
Loan Term
Loan Term
The amortization period of the loan in years — the number of years over which the loan payments are calculated and the balance is fully paid off. Enter a whole number such as 20 or 25.
The amortization period of the loan in years — the number of years over which the loan payments are calculated and the balance is fully paid off. Enter a whole number such as 20 or 25.
Commercial Loan Terms: Many commercial loans carry a 5- or 10-year note term but are amortized over 20 or 25 years to keep monthly payments manageable. To model this, enter the full amortization period (e.g., 25) as the loan term. This gives you the payment amount used to size the deal, even if a balloon payment is due at the end of the note term.
04
Start Date
Start Date
The date the first loan payment is due. This is used to populate the Date column in the amortization schedule so each payment row shows the correct calendar date. It does not affect the payment amount or interest calculation.
The date the first loan payment is due. This is used to populate the Date column in the amortization schedule so each payment row shows the correct calendar date. It does not affect the payment amount or interest calculation.
05
Calculate Payment
Once all four fields are filled in, click the Calculate Payment button. The results panel and amortization schedule will populate immediately.
To Run a Calculation
1
Enter the Loan Amount, Interest Rate, Loan Term, and Start Date.
Enter the Loan Amount, Interest Rate, Loan Term, and Start Date.
2
Click the Calculate Payment button.
Click the Calculate Payment button.
3
Review the summary results and scroll down to explore the full amortization schedule.
Review the summary results and scroll down to explore the full amortization schedule.
4
Adjust any field and click Calculate Payment again to compare different scenarios.
Adjust any field and click Calculate Payment again to compare different scenarios.
06
Reading the Results
After clicking Calculate Payment, four summary figures appear:
| Field | Description |
|---|---|
| Monthly Payment | The fixed amount due each month, covering both principal reduction and interest. This is your monthly debt service figure. |
| Total Principal | The original loan amount — the total borrowed sum that will be repaid over the life of the loan. |
| Total Interest | The cumulative interest paid over the entire loan term. This is the true cost of borrowing beyond the principal. |
| Total Payment | Total Principal plus Total Interest — the grand total you will pay over the full life of the loan. |
07
Amortization Schedule
Below the summary results, the full amortization schedule shows every payment over the life of the loan. Each row represents one monthly payment:
| Column | Description |
|---|---|
| Payment # | Sequential payment number, starting at 1. A 25-year loan will have 300 rows. |
| Date | The calendar date each payment is due, starting from the Start Date entered and incrementing monthly. |
| Payment | The total amount due for that month — equal to the Monthly Payment figure shown in the summary above. |
| Principal | The portion of that month’s payment applied to reducing the outstanding loan balance. This amount grows over time as the loan matures. |
| Interest | The portion of that month’s payment covering interest charges. This amount decreases over time as the outstanding balance declines. |
| Balance | The remaining loan balance after that payment is applied. Reaches zero on the final payment of the loan. |
The schedule is paginated. Use the Previous and Next navigation below the table to move through the pages, or jump to the first or last page using the First and Last links.
08
Download Excel
Click the Download Excel button above the amortization schedule to export the full payment schedule as a spreadsheet. The Excel file includes all payment rows with the Payment #, Date, Payment amount, Principal, Interest, and remaining Balance for every month of the loan — useful for sharing with clients, lenders, or for use in a financial model.
⚠ Calculate first: Run a calculation before clicking Download Excel. The export reflects whatever is currently displayed in the schedule — if no calculation has been run yet, the file will be empty.
09
Key Terms
Helpful definitions for the financial concepts used in this calculator:
Principal
The original sum of money borrowed. Each monthly payment reduces the outstanding principal balance until it reaches zero at loan maturity.
The original sum of money borrowed. Each monthly payment reduces the outstanding principal balance until it reaches zero at loan maturity.
Interest
The lender’s charge for providing the loan, expressed as an annual percentage rate (APR) and calculated monthly on the outstanding balance. Early payments are weighted heavily toward interest; later payments shift toward principal.
The lender’s charge for providing the loan, expressed as an annual percentage rate (APR) and calculated monthly on the outstanding balance. Early payments are weighted heavily toward interest; later payments shift toward principal.
Amortization
The process of paying off a loan through scheduled, regular payments over time. Each payment covers the interest due and reduces the principal balance, until the loan is fully paid off.
The process of paying off a loan through scheduled, regular payments over time. Each payment covers the interest due and reduces the principal balance, until the loan is fully paid off.
Debt Service
The total cash required to cover loan payments over a given period — typically quoted annually. The monthly payment figure from this calculator multiplied by 12 gives you the annual debt service.
The total cash required to cover loan payments over a given period — typically quoted annually. The monthly payment figure from this calculator multiplied by 12 gives you the annual debt service.
DSCR
Debt Service Coverage Ratio — a key metric commercial lenders use to evaluate loan applications. It measures a property’s ability to cover its debt obligations: Net Operating Income ÷ Annual Debt Service. Most commercial lenders require a minimum DSCR of 1.20 to 1.25.
Debt Service Coverage Ratio — a key metric commercial lenders use to evaluate loan applications. It measures a property’s ability to cover its debt obligations: Net Operating Income ÷ Annual Debt Service. Most commercial lenders require a minimum DSCR of 1.20 to 1.25.
Balloon Payment
A lump-sum payment of the remaining balance due at the end of the note term in many commercial loans. For example, a loan with a 10-year note term and 25-year amortization will have a balloon payment at year 10 equal to the outstanding balance at that time.
A lump-sum payment of the remaining balance due at the end of the note term in many commercial loans. For example, a loan with a 10-year note term and 25-year amortization will have a balloon payment at year 10 equal to the outstanding balance at that time.
Ready to take the next step? Contact an NAI Long Island advisor →