{"id":482941,"date":"2022-08-09T20:00:58","date_gmt":"2022-08-09T17:00:58","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-create-an-amortization-schedule-using-excel-templates\/"},"modified":"2022-08-09T20:00:58","modified_gmt":"2022-08-09T17:00:58","slug":"how-to-create-an-amortization-schedule-using-excel-templates","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-create-an-amortization-schedule-using-excel-templates\/","title":{"rendered":"#How to Create an Amortization Schedule Using Excel Templates"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2de5c38c8d8\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2de5c38c8d8\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-an-amortization-schedule-using-excel-templates\/#%E2%80%9CHow_to_Create_an_Amortization_Schedule_Using_Excel_Templates%E2%80%9D\" >&#8220;How to Create an Amortization Schedule Using Excel Templates&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-an-amortization-schedule-using-excel-templates\/#What_Is_an_Amortization_Schedule\" >What Is an Amortization Schedule?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-an-amortization-schedule-using-excel-templates\/#Simple_Loan_Calculator_and_Amortization_Table\" >Simple Loan Calculator and Amortization Table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-an-amortization-schedule-using-excel-templates\/#Third-Party_Amortization_Templates\" >Third-Party Amortization Templates<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-an-amortization-schedule-using-excel-templates\/#Home_Mortgage_Calculator\" >Home Mortgage Calculator<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Create_an_Amortization_Schedule_Using_Excel_Templates%E2%80%9D\"><\/span>&#8220;How to Create an Amortization Schedule Using Excel Templates&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\"\/><\/p>\n<p>If you want an easy way to view the schedule for your loan, you can create an amortization table in Microsoft Excel. We\u2019ll show you several templates that make creating this schedule easy so that you can track your loan.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"What_Is_an_Amortization_Schedule\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_0\">What Is an Amortization Schedule?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>An <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.investopedia.com\/terms\/a\/amortization_schedule.asp\">amortization schedule<\/a>, sometimes called an amortization table, displays the amounts of principal and interest paid for each of your loan payments. You can also see how much you still owe on the loan at any given time with the outstanding balance after a payment is made.<\/p>\n<p>This allows you to see the entire loan from start to finish. It\u2019s beneficial for auto, personal, and home loans, and can help you see the results of extra payments you make or consider making.<\/p>\n<p>With an amortization schedule template for Microsoft Excel, you can enter the basic loan details and view the entire schedule in just minutes.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Simple_Loan_Calculator_and_Amortization_Table\"><\/span>Simple Loan Calculator and Amortization Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>For most any type of loan, Microsoft offers a handy amortization table template for Excel. It also includes a loan repayment calculator if you\u2019re <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/805858\/goal-seek-excel\/\">thinking about paying off or refinancing your loan.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use Goal Seek in Microsoft Excel<\/em><\/strong><\/p>\n<p>You can <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/templates.office.com\/en-us\/simple-loan-calculator-and-amortization-table-tm16400462\">download the template<\/a>, use it in Excel for the web, or open it from the templates section of Excel on your desktop.<\/p>\n<p>For the latter, open Excel, go to the Home section, and select \u201cMore Templates.\u201d Type Amortization in the search box and you\u2019ll see the Simple Loan Calculator. Select the template and click \u201cCreate\u201d to use it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816274\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/MSSimpleLoanCalcuatorCreate-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Create button for the Microsoft Excel template\" width=\"650\" height=\"484\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see a tool tip in the top left corner of the sheet as well as when you select the cells containing the loan details at the top. The schedule has sample data that you can simply replace.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816275\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/MSSimpleLoanCalcuatorNote-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Simple Loan Calculator template with a tool tip\" width=\"517\" height=\"348\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Enter the values in the designated spot at the top of the sheet including loan amount, annual interest rate, loan period in years, and start date of the loan. The shaded amounts in the area beneath are calculated automatically.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816276\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/MSSimpleLoanCalcuatorTop-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Simple Loan Calculator loan details\" width=\"474\" height=\"320\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you enter the above details, you\u2019ll see the payment, interest, and cost section update along with the schedule at the bottom. You can then easily see how much of your payment goes toward the principal and interest with the ending balance after you make each payment.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816277\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/MSSimpleLoanCalcuatorFull-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Simple Loan Calculator Excel template\" width=\"633\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To manage additional loans or use the calculator to estimate another loan, you can copy the sheet to a new tab.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Third-Party_Amortization_Templates\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Third-Party Amortization Templates<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to go beyond basic, take a look at this next template <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/redirect.viglink.com\/?key=204a528a336ede4177fff0d84a044482&amp;u=https%3A%2F%2Fwww.vertex42.com%2FExcelTemplates%2Floan-amortization-schedule.html\">from Vertex42<\/a>. With it, you can manage your payment frequency, compound period, payment type, and rounding along with extra payments you make.<\/p>\n<p>You also have two additional workbook tabs where you can track your payments depending on if unpaid interest is added to the balance or accrued separately.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816279\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/VertexLoanAmortizationScheduleFull-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Vertex42 Loan Amortization Schedule template\" width=\"568\" height=\"493\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Start by entering the loan amount, annual interest rate, term in years, and first payment date. Then, use the drop-down boxes to select the additional details.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816280\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/VertexLoanAmortizationScheduleDropdown-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Dropdown boxes for additional loan details\" width=\"350\" height=\"273\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Optionally enter extra payments into the schedule by date or use one of the mentioned tabs to manage your payments. You\u2019ll also notice a handy Summary section on the top right for totals and estimated interest savings.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816281\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/VertexLoanAmortizationScheduleTop-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Loan details and summary at the top of the template\" width=\"650\" height=\"307\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you like the idea of a template that offers more like additional payments, payment frequency, and payment type, but appreciate a bit of visuals for your summary, this template is for you. <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.spreadsheet123.com\/calculators\/loan-amortization-schedule.html\">From Spreadsheet123<\/a>, this amortization schedule gives you those bonuses you want along with a convenient chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816284\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/123LoanAmortizationScheduleFull-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Spreadsheet123 Loan Amortization Schedule template\" width=\"504\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Enter your basic information in the Loan Terms section and then use the drop-down lists to pick those additional details. Optionally, switch between the Amortization Schedule and Payment Schedule views, and turn Rounding off or on.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816285\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/123LoanAmortizationScheduleDropdown-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Dropdown boxes for additional loan details\" width=\"354\" height=\"212\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Enter your additional payments in the schedule, check out the handy summary at the top, and see a clear picture of your loan with the combo chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816283\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/123LoanAmortizationScheduleTop-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Loan Amortization Schedule template top with chart\" width=\"650\" height=\"406\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Home_Mortgage_Calculator\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">Home Mortgage Calculator<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Specifically for mortgage loans, take a look at this template <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/redirect.viglink.com\/?key=204a528a336ede4177fff0d84a044482&amp;u=https%3A%2F%2Fwww.vertex42.com%2FCalculators%2Fhome-mortgage-calculator.html\">from Vertex42<\/a>. You have options for fixed or variable rate loans, can view your balance at the end of a specific year with interest and principal paid, and can enter tax deduction details.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-816286 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/VertexHomeMortageCalcuatorFull-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Vertex42 Home Mortgage Calculator template\" width=\"399\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The top of the template is packed with the information you need. Start by entering your basic mortgage information, select the compound period and payment frequency from the drop-down lists, and see your balance for any year.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-816289 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/VertexHomeMortageCalcuatorTop-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Home Mortgage Calculator loan details and summary\" width=\"631\" height=\"429\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the center of the template, you have handy charts for a quick glance at your balance by year and interest rate history.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-816288 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/VertexHomeMortageCalcuatorCharts-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Home Mortgage Calculator charts\" width=\"500\" height=\"190\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The amortization table at the bottom has spots for additional payments throughout the life of the loan. You\u2019ll also see tax-related amounts if you decide to include those details.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-816287\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/VertexHomeMortageCalcuatorTable-ExcelAmortization.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Home Mortgage Calculator amortization section\" width=\"640\" height=\"298\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For additional ways to use Excel for your finances, look at these functions for budgeting.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/816269\/amortization-schedule-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Create an Amortization Schedule Using Excel Templates&#8221; If you want an easy way to view the schedule for your loan, you can create an amortization table in Microsoft Excel. We\u2019ll show you several templates that make creating this schedule easy so that you can track your loan. What Is an Amortization Schedule? An&#8230;<\/p>\n","protected":false},"author":1,"featured_media":482942,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-482941","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/482941","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=482941"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/482941\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/482942"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=482941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=482941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=482941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}