Missing a template? Request it →
Rental Mortgage & Refinance Calculator, the Refinance tab

The refinance tab: keep this loan, refinance, or refinance and keep paying the same, with the month the closing costs come back.

№ · Spreadsheets · Property

Keep this loan, or refinance? One sentence.

Enter the rental's mortgage and the rent once. The payment, the payoff date, what extra payments save and the refinance verdict work themselves out, with the month the closing costs come back.

  • Google Sheets
  • Excel .xlsx
  • Blank + filled example
Language

Instant download. Permanent link in your account.

Open it live, read‑only

Instant download. Permanent link in your account. Yours forever, no subscription.

Mortgage

One rental mortgage, worked out.

The payment, what the rent covers, the balance today, the payoff date and total interest, and what extra each month and one-off payments save.

Rental Mortgage & Refinance Calculator, the Mortgage tab

Schedule

Every month to the last payment.

The full amortization table month by month, extra payments included, with the standard schedule beside it.

Rental Mortgage & Refinance Calculator, the Schedule tab

Start here

The first tab you open.

Every tab in one line, then the order to fill it in. The only instructions you need.

Rental Mortgage & Refinance Calculator, the Start here tab
The honest split of labour

You enter the loan. It does the sums.

You type

  • The loan's balance, rate and term, once
  • The rent the property brings in
  • Any extra you pay, each month or one-off
  • The new rate and closing costs to compare

It works out

  • The payment and what the rent covers
  • The payoff date and total interest
  • What extra payments save
  • Keep or refinance, and the month the costs come back
Both apps, one price

Google Sheets or Excel. You do not have to choose.

The download carries both: the Sheets copy link and the native .xlsx. Every formula is chosen to work identically in the two, and we test the round trip on every build.

Google Sheets
Blank and filled-example copies, one click into your Drive.
Excel .xlsx
Native files, not exports. Blank and filled example included.
How buying works

A link, not a file to babysit.

One

Buy it once

¥198, no subscription. Your order email and your account both carry the download, permanently.

Two

Copy it into your Drive

One click and it is yours, in your own Google account, forever. We keep no access to your copy and nothing in it phones home.

Three

Start in the example

The filled copy shows every tab already working. Poke it, break it, then open your blank and type your own.

№ · Bought together

Add the rest of the set.

Rental Mortgage & Refinance Calculator This item · ¥198
All three, the full set ¥728 was ¥994

All three goes in as the Landlord Kit at ¥728, not three separate items. You keep ¥266.

Before you ask

The questions we actually get

Is there a year printed in it?

No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year.

Does it work in Excel?

Yes. The same workbook comes as native .xlsx files, one blank and one filled with an example, checked in Excel with every formula recalculated.

Do I need spreadsheet skills?

No. Every formula is already built. Open the example copy first to see every tab working, then type into your blank one.

What exactly do I receive?

A small PDF with your links: the Google Sheets copy links, blank and filled example, and the native Excel files of both. Buying once covers your personal use in both apps, forever.

Rental Mortgage & Refinance Calculator

Know what the loan costs you.

One rental mortgage, in Google Sheets and Excel, no subscription, no year baked in.

Get the calculator · ¥198

Still deciding? Open it live, read‑only. Not the sheet you need? See every spreadsheet template or ask at Templacity Hall.

№ · Reviews

Be the first to say something.

Nobody has written about this one yet. If it is on your device, yours is the first thing the next person reads.

Read by a person before it goes up, usually within a day. Your email stays with us and never appears on the page.

Instant download.

Your file is in your account the moment you check out, yours to re-download any time. A receipt lands in your inbox, too.

One-time purchase.

No subscription, no annual renewal, no upgrade nags. Pay once and the file is yours.

Quiet, secure checkout.

Stripe. Apple Pay. No spam, no “partners,” no reselling your details. Receipt, file, done.