Loan calculator sheetExcel

Loan and mortgage repayment calculator sheet

Usually ready in 15 minutesRevisions includedQuality check
Packages
Payment protectionDetails
  • Revisions within the package are free.
  • If you do not respond within 3 days of delivery, the work is accepted automatically.

The money is reserved when you pay and released only once you accept the work.

Loan and mortgage repayment calculator sheet

Example result

Example for the Standard package

Loan repayment calculator: a mortgage sheet with extra payments

Inputs

FieldValue
Home price$380,000
Down payment$76,000 (20%)
Loan$304,000
Rate6.4% fixed
Term30 years
Extra payment$200 a month

Formulas

  • Monthly payment: =PMT(B4/12,B5*12,-B3) → $1,901.54
  • Each row of the schedule: interest =F9*$B$4/12, principal =B10-C10, balance =MAX(F9-D10-E10,0)
  • The table stops by itself in the month the balance reaches zero

Schedule with the extra $200 (first months)

MonthPaymentInterestPrincipalExtraBalance
1$1,901.54$1,621.33$280.20$200$303,519.80
2$1,901.54$1,618.77$282.77$200$303,037.03
3$1,901.54$1,616.20$285.34$200$302,551.69

Result

Without extraWith $200 extra
Paid off in30 years23 years 2 months
Total interest$380,554$279,235

They save $101,319 in interest. Taxes and insurance are not included; they can be added in one extra cell.

Client: a couple buying their first home for $380,000 with a 30-year fixed-rate mortgage at 6.4% Task: a Google Sheets calculator with the monthly payment, a full repayment schedule and how much they save by paying an extra $200 a month

The client and all details are made up.

About this service

Banks show you one monthly payment, but not how much of each payment is interest, what an extra payment saves or how a rate change shifts the schedule. We write the formulas for a loan or mortgage repayment sheet in Excel or Google Sheets: payment with PMT, a full amortization schedule and totals of interest paid. In Premium the sheet also handles extra payments, rate changes and payment holidays; it is a calculator, not financial advice.

What is included

  • What you getFormulas for the payment and schedule, the sheet layout (columns, headers and sample rows as CSV text) and setup steps; in Premium also extra payment and rate change logic. Everything comes as text on the order page; we do not send a ready spreadsheet file.
  • Monthly paymentAnnuity or differentiated
  • Amortization scheduleInterest and principal by month
  • TotalsInterest paid and payoff date
  • Extra paymentsIn Premium: shorter term or lower payment
  • Rate changesIn Premium: from a given month

How it works

  1. 1
    BriefYou give an example loan
  2. 2
    FormulasWe write the schedule and totals
  3. 3
    FixesIf something fails on your data, we fix it within your package

What we need from you

Excel or Google Sheets, the loan type (annuity or differentiated), and an example: amount, rate, term and start date.

We will ask you:

  • Do you use Excel or Google Sheets?
  • Is the payment annuity or differentiated?
  • What are the amount, rate, term and start date?
  • Do you plan extra payments?

Compare packages

PackagesBasic$10Standard$25Premium$49
What is includedPayment formulasRepayment scheduleSchedule with extras
Deadline1 day2 days3 days
Revisions123
Formulasup to 3up to 10up to 15
Schedule templateNoYesYes
Extra payments and rate changesNoNoYes
Order BasicOrder StandardOrder Premium

Payment protection

You pay when you order, but the money is released only for accepted work.

  • Fixed priceThe package price does not change after you pay.
  • The money is reservedWhen you pay, the amount is only reserved. It is released to the service once you accept the work.
  • Checked before deliveryEvery result goes through a quality check before it reaches you, and you see it on the order page before accepting it.
  • Free revisionsAsk for changes within your brief as many times as the package allows.
  • Acceptance after 3 daysIf within 3 days of delivery you neither accept the work nor ask for changes, it is accepted automatically. If you write in the order chat after delivery, the order waits; once we answer, we may start the 3 days again and will say so in the chat.
  • Redo or a full refundIf the result does not match your brief and the revisions did not fix it, or the work takes more than twice its deadline, write in the order chat: we will redo the work or refund the payment in full.
How it works →

Questions and answers

Will the numbers match my bank exactly?

Usually close; banks may round differently or count days their own way. Compare the first rows with your bank schedule.

Should I refinance or pay early?

The sheet shows the numbers for each option, but the decision is yours. This is not financial advice.

Can it compare two loans?

Yes, in Standard and Premium the template can hold two offers side by side.

Did not find your answer?

Packages