{"id":15355,"date":"2026-10-29T13:45:37","date_gmt":"2026-10-29T13:45:37","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=15355"},"modified":"2026-11-02T16:05:53","modified_gmt":"2026-11-02T16:05:53","slug":"rental-mortgage-calculator-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/es\/product\/rental-mortgage-calculator-spreadsheet\/","title":{"rendered":"Rental Mortgage &#038; Refinance Calculator Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p>A mortgage and refinance calculator for landlords with a loan on a rental. Enter the loan and the rent once; the payment, the payoff date, what extra payments save and the refinance verdict work themselves out.<\/p>\n<ul>\n<li><strong>Mortgage<\/strong>: one rental mortgage: 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.<\/li>\n<li><strong>Refinance<\/strong>: keep this loan, refinance, or refinance and keep paying the same: payment, payoff date, interest still to pay, closing costs and the month the costs come back.<\/li>\n<li><strong>Schedule<\/strong>: the full amortization table month by month, extra payments included, with the standard schedule beside it.<\/li>\n<\/ul>\n<p><strong>What you get:<\/strong> a one-page PDF with two buttons. One makes a blank copy of the Google Sheet in your own Drive, the other a copy filled with an example so you can see every tab working first. The same workbook comes as two Excel files, blank and example, checked in Excel with every formula recalculated. No year is printed anywhere, so it starts the day you do.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Should you keep this loan or refinance? Enter the rental&#8217;s mortgage once and the sheet answers in one sentence, with the month the closing costs come back.<\/p>\n","protected":false},"featured_media":15357,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Rental Mortgage Calculator Spreadsheet with Refinance Break-Even | Templacity","rank_math_description":"A rental mortgage calculator spreadsheet for Google Sheets and Excel: payment, payoff date, extra-payment savings, and whether to refinance, with the break-even month.","rank_math_seo_score":"51","_templacity_copy_live":"","_templacity_faq":[]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-15355","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/product\/15355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/comments?post=15355"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/media\/15357"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/media?parent=15355"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/niche?post=15355"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/template_type?post=15355"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/templacity_topic?post=15355"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/product_brand?post=15355"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/product_cat?post=15355"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/product_tag?post=15355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}