{"id":32927,"date":"2023-11-10T19:37:54","date_gmt":"2023-11-10T18:37:54","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=32927"},"modified":"2024-05-09T19:39:46","modified_gmt":"2024-05-09T17:39:46","slug":"compound-interest-calculator-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/compound-interest-calculator-in-excel\/","title":{"rendered":"How to Create Compound Interest Calculator in Excel &#8211; 2 Easy Methods"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-33124\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-1024x576.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Compound interest is a concept in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/other\/financial\/\" target=\"_blank\" rel=\"noopener\"><strong>finance<\/strong><\/a> that refers to the<strong> interest on a loan or deposit that is calculated based on both the initial principal amount and the accumulated interest<\/strong> from previous periods. In other words, it&#8217;s <strong>interest on interest<\/strong>.<\/p>\n<p>There are <strong>two methods<\/strong> that can be used to create a compound interest <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-mirr-function\/\" target=\"_blank\" rel=\"noopener\">calculator in Excel<\/a> &#8211;<\/p>\n<p>Let us look at two methods in detail.<\/p>\n<h4>Download the Excel Workbook below to follow along and understand How to Create a Compound Interest Calculator in Excel \u2013 <a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-in-Excel.xlsx\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel <\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">Compound-Interest-Calculator-in-Excel.xlsx<\/span><\/a><\/h4>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"1\" style=\"color: #ff0000\">Method 1 \u2013 Compound Interest Formula<\/span><\/strong><\/h3>\n<p>Suppose you wish to<strong> invest $10,000 in your savings account for 3 years<\/strong>. Your account offers a return of <strong>6.5%,<\/strong> subject to<strong> semi-annual compounding<\/strong>. You want to know the future value of your investment using the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/opportunity-cost-calculator\/\" target=\"_blank\" rel=\"noopener\">compound interest calculator in<\/a> Excel.<\/p>\n<p>The <strong><a class=\"wpil_keyword_link\" title=\"formula\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">formula<\/a><\/strong> for this approach will be &#8211;<\/p>\n<p><strong>P&#8217; = P*(1+R\/N)^NT<\/strong><\/p>\n<p>where.<\/p>\n<ul>\n<li>P&#8217; is the future value of the investment, including interest.<\/li>\n<li>P is the principal amount.<\/li>\n<li>R is the annual interest rate (in decimal form).<\/li>\n<li>N is the number of times that interest is compounded per unit t.<\/li>\n<li>T is the time the money is invested for, in years.<\/li>\n<\/ul>\n<p>Follow the steps below to learn how to use the compound <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-rate-function-ideal-formula-for-interest-calculations\/\" target=\"_blank\" rel=\"noopener\">interest calculator in Excel<\/a> &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Enter the initial principal amount i.e. P. Here, it is <strong>10000<\/strong>.<\/p>\n<p><strong>=10000<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32938\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-1.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"486\" height=\"219\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-1.png 486w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-1-300x135.png 300w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2<\/span><\/strong><strong><span style=\"color: #ff0000\">:<\/span><\/strong> Enter the <strong>multiplication sign(*).<\/strong><\/p>\n<p><strong>=10000*<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32939\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-2.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"489\" height=\"211\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-2.png 489w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-2-300x129.png 300w\" sizes=\"(max-width: 489px) 100vw, 489px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3<\/span><\/strong><strong><span style=\"color: #ff0000\">:<\/span><\/strong> Enter <strong>1 + 0.065\/2 within brackets.<\/strong><\/p>\n<p><strong>=10000*(1+0.065\/2)<\/strong><\/p>\n<p>where,<\/p>\n<ul>\n<li>o.o65 is the annual interest rate in decimal form i.e. R<\/li>\n<li>2 is the number of times the interest is compounded i.e. N<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32940\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-3.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"485\" height=\"212\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-3.png 485w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-3-300x131.png 300w\" sizes=\"(max-width: 485px) 100vw, 485px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4<\/span><\/strong><strong><span style=\"color: #ff0000\">:<\/span><\/strong> Enter the <strong>^<\/strong> sign.<\/p>\n<p><strong>=10000*(1+0.065\/2)^<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32941\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-4.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"484\" height=\"214\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-4.png 484w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-4-300x133.png 300w\" sizes=\"(max-width: 484px) 100vw, 484px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5<\/span><\/strong><strong><span style=\"color: #ff0000\">:<\/span><\/strong> Now, enter the <strong>2*3 within brackets.<\/strong><\/p>\n<p><strong>=10000*(1+0.065\/2)^(2*3)<\/strong><\/p>\n<p>where<\/p>\n<ul>\n<li>2 is the number of times the interest is compounded i.e. N<\/li>\n<li>3 is the time the money is invested for i.e. T years.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32942\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-5.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"564\" height=\"214\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-5.png 564w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-5-300x114.png 300w\" sizes=\"(max-width: 564px) 100vw, 564px\" \/><\/a><\/p>\n<p>The resultant amount will be the future value of the amount invested, compounded semi-annually.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32943\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-6.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"571\" height=\"219\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-6.png 571w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-6-300x115.png 300w\" sizes=\"(max-width: 571px) 100vw, 571px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"2\" style=\"color: #ff0000\">Method 2 \u2013 FV Formula<\/span><\/strong><\/h3>\n<p><span style=\"font-weight: 400\">The <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-compound-interest-excels-fv-formula\/\" target=\"_blank\" rel=\"noopener\"><strong>FV<\/strong><\/a> function in Microsoft Excel assists in calculating the future worth of a company&#8217;s investments, assuming periodic, consistent payments with a constant interest rate.\u00a0 Let\u2019s use Microsoft Excel\u2019s FV Function that will help us to create a compound interest calculator in Excel.<\/span><\/p>\n<p><span style=\"font-weight: 400\">The syntax for the FV function is &#8211;<\/span><\/p>\n<p><strong>=FV(rate,nper,pmt,[pv],[type])<\/strong><\/p>\n<ul>\n<li><b>Rate: <\/b><span style=\"font-weight: 400\">The interest rate per period.\u00a0<\/span><\/li>\n<li><b>Nper: <\/b><span style=\"font-weight: 400\">The total number of payment periods in an annuity.<\/span><\/li>\n<li><b>Pmt:<\/b><span style=\"font-weight: 400\"> The payment made each period. It cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. If pmt is omitted, you must include the pv argument.\u00a0<\/span><\/li>\n<li><b>Pv:<\/b><span style=\"font-weight: 400\"> The present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero), and you must include the pmt argument. Type: <em>This is an optional argument.<\/em><\/span><\/li>\n<li><strong>Type<\/strong>: <span style=\"font-weight: 400\">The number 0 or 1 indicates when payments are due. <\/span>0 if the amount is being added to the investment at the end of the period or 1 if the amount is being added to the investment at the beginning of the period. <em>This is an optional argument.<\/em><\/li>\n<\/ul>\n<p>Follow the steps below to use the FV function to calculate compound interest &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1<\/span><\/strong><strong><span style=\"color: #ff0000\">:<\/span><\/strong> Enter the FV function.<\/p>\n<p><strong>=FV<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32944\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-7.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"564\" height=\"211\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-7.png 564w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-7-300x112.png 300w\" sizes=\"(max-width: 564px) 100vw, 564px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2<\/span><\/strong><strong><span style=\"color: #ff0000\">:<\/span><\/strong> Enter the first argument i.e. rate. Here, it is 0.0065\/2 i.e.<\/p>\n<p><strong>=FV(0.065\/2<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32945\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-8.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"566\" height=\"214\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-8.png 566w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-8-300x113.png 300w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3<\/span><\/strong><strong><span style=\"color: #ff0000\">:<\/span><\/strong> Enter the second argument i.e. nper. Here, it is 3*2 i.e. 6.<\/p>\n<p><strong>=FV(0.065\/2,3*2<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32946\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-9.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"571\" height=\"211\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-9.png 571w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-9-300x111.png 300w\" sizes=\"(max-width: 571px) 100vw, 571px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4<\/span><\/strong><strong><span style=\"color: #ff0000\">:<\/span><\/strong> Enter the third argument i.e. pmt. Here, it is 0 as there were no deposits made in between the period.<\/p>\n<p><strong>=FV(0.065\/2,3*2,0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32947\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-10.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"568\" height=\"217\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-10.png 568w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-10-300x115.png 300w\" sizes=\"(max-width: 568px) 100vw, 568px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5<\/span><\/strong><strong><span style=\"color: #ff0000\">:<\/span><\/strong> Enter the fourth argument i.e. pv. Here, it is -10,000.<\/p>\n<p><strong>=FV(0.065\/2,3*2,0,-10000)<\/strong><\/p>\n<p><em>You will have to use a negative sign as it is a cash outflow.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32948\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-11.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"652\" height=\"217\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-11.png 652w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-11-300x100.png 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/a><\/p>\n<p>The resultant amount is the future value of your investment.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-32949\" title=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-12.png\" alt=\"How to Create Compound Interest Calculator in Excel - 2 Easy Methods\" width=\"643\" height=\"212\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-12.png 643w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Compound-Interest-Calculator-12-300x99.png 300w\" sizes=\"(max-width: 643px) 100vw, 643px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-as-time-value-of-money-calculator\/\" target=\"_blank\" rel=\"noopener\"><strong>Click here<\/strong><\/a> to learn 5 ways of Using Excel as a Time Value of Money calculator.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000\">Conclusion<\/span><\/strong><\/p>\n<p>In <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/interest-receivable\/\" target=\"_blank\" rel=\"noopener\">conclusion, understanding and utilizing compound interest calculator<\/a> is crucial for maximizing returns on investments over time. By employing either the Compound Interest Formula or the FV Formula in Excel, investors can project the future value of their investments more accurately.<\/p>\n<p>These tools empower individuals to make informed financial decisions and harness the power of compound interest for long-term financial growth.<\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/financial-functions-reference-5658d81e-6035-4f24-89c1-fbf124c2b1d8\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Click here<\/strong><\/a> to learn more about Finance Formulas in Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Compound interest is a concept in finance that refers to the interest on a loan or deposit that is calculated based on both the initial principal amount and the accumulated interest from previous periods. In other words, it&#8217;s interest on interest. There are two methods that can be used to create a compound interest calculator [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33124,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Create Compound Interest Calculator in Excel - 2 Easy Methods","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,319],"tags":[1449,1450,1452,1451],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/32927"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=32927"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/32927\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33124"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=32927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=32927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=32927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}