{"id":4303,"date":"2020-04-11T19:40:53","date_gmt":"2020-04-11T19:40:53","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/mathforlibscoreq\/?post_type=chapter&#038;p=4303"},"modified":"2021-02-05T23:59:17","modified_gmt":"2021-02-05T23:59:17","slug":"compound-interest-calculator-certificates-of-deposit","status":"web-only","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/chapter\/compound-interest-calculator-certificates-of-deposit\/","title":{"raw":"Compound Interest Calculator: Certificates of Deposit","rendered":"Compound Interest Calculator: Certificates of Deposit"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Calculate interest compounded over time<\/li>\r\n \t<li>Analyze and compare interest in real-world applications<\/li>\r\n<\/ul>\r\n<\/div>\r\nCertificates of Deposit (CDs) are long-term savings instruments offered by banks. They come in increments such as one, three, five, or 10 years. The idea is that once you deposit your money, you\u2019ll leave it untouched for the duration of the CD term. Banks are usually willing to pay a higher interest in exchange for being assured of using your money longer. But CDs come with a hefty penalty for early withdrawal, so you\u2019ll want to be sure you have the cash to allocate to this type of savings.\r\n\r\nYou can find easily find annual percentage yields for CDs advertised on banking websites. See the sample below.\r\n\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/11182518\/Compound_Interest_03.jpg\"><img class=\"aligncenter wp-image-4297 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/11182518\/Compound_Interest_03.jpg\" alt=\"\" width=\"643\" height=\"429\" \/><\/a>\r\n\r\nNotice that the annual percentage yield is advertised rather than the rate. The APY will always be slightly larger than the rate due to compounding. That is, the interest on your deposit will be calculated at fixed periods throughout the year and reinvested. Recall the formula from earlier in the text.\r\n<div class=\"textbox\">\r\n<h3>Compound Interest<\/h3>\r\n[latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]\r\n<ul>\r\n \t<li><em>P<sub>N<\/sub><\/em> is the balance in the account after <em>N<\/em> years.<\/li>\r\n \t<li><em>P<sub>0 <\/sub><\/em> is the starting balance of the account (also called initial deposit, or principal)<\/li>\r\n \t<li><em>r<\/em> is the annual interest rate in decimal form<\/li>\r\n \t<li><em>k<\/em> is the number of compounding periods in one year<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div class=\"textbox exercises\">\r\n<h3>example<\/h3>\r\nUse the formula for compound interest to find the APY for a $1000 5-year CD with a rate of 1.44% compounded daily.\r\n\r\n[reveal-answer q=\"599399\"]Solution[\/reveal-answer]\r\n[hidden-answer a=\"599399\"]\r\n\r\n[latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]\r\n\r\nSince we are interested in annual yield, we can let [latex]N=1[\/latex] and [latex]P_{0}=1[\/latex]\r\n\r\n[latex]P_{1}=1\\left(1+\\frac{.0144}{365}\\right)^{365}=1.01450[\/latex]\r\n\r\nThe percent change in our investment over the year was [latex]0.01450 = 1.45[\/latex]%.\r\n\r\n[\/hidden-answer]\r\n\r\n<\/div>\r\n<div class=\"textbox shaded\">\r\n\r\n<strong><strong>Converting Interest Rate to APY<\/strong><\/strong>\r\n\r\nWe can generalize a formula for converting interest rate to APY:\r\n\r\n[latex]\\text{APY }=1\\left(1+\\frac{r}{k}\\right)^{k}-1[\/latex]\r\n\r\n<\/div>\r\nBanks will usually advertise just the APY since it is a more attractive number. You can find the rate by looking deeper into the details of the CD.\r\n\r\nSince CDs are designed for you to leave your money in savings for the entire term, they provide excellent examples for exploring compound interest.\r\n<h3>Spreadsheet\u00a0Hands-On: Create a Compound Interest Calculator<\/h3>\r\n<h3>Step 1: Create the calculator<\/h3>\r\nThe good news is that we've done much of the work to create our calculators already. Since our formulas involve many of the same variables, we can use copy and paste to create the next spreadsheet more quickly.\r\n<ol>\r\n \t<li>Make a copy of the Simple Interest spreadsheet by right-clicking on the tab containing its name at the bottom of the window, choose Move or Copy, and click the box to Create a copy. Choose (move to end) to place it at the end. Rename your new sheet \"Compound Interest\" by double-clicking its tab name and typing over it.<\/li>\r\n \t<li>Using the cells listed in the image below, change the formula in cell B8 to use the compound interest formula by typing into cell B8:\u00a0 =B3*(1+(B4\/B5))^(B5*B6).Note that the template formula to the right of that cell has been changed to compound interest as well.\u00a0<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/11190050\/Compound_Interest_04.jpg\"><img class=\"aligncenter wp-image-4298 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/11190050\/Compound_Interest_04.jpg\" alt=\"\" width=\"484\" height=\"183\" \/><\/a><\/li>\r\n \t<li>We'll need to change the formula in the Interest section, too, from simple interest to compound interest. Since compound interest is reinvested over the life of the CD, the interest accumulated is not constant from year to year. We will only need one interest line. Delete lines 11 and 12 by selecting them, right clicking, then choosing delete. Change the Interest description in C10 to \"total interest earned\"<\/li>\r\n \t<li>The response in cell B10 will be the difference between balance and principal : =B8-B3. When you are done, it should look like the image below.<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12010408\/Compound_Interest_04a.jpg\"><img class=\"aligncenter size-full wp-image-4317\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12010408\/Compound_Interest_04a.jpg\" alt=\"\" width=\"503\" height=\"222\" \/><\/a><\/li>\r\n<\/ol>\r\n<div class=\"textbox exercises\">\r\n<h3>example<\/h3>\r\nThere are often several good ways to represent a general formula. For instance, the difference between the CD balance at the end of term and the initial deposit is given above simply as the difference between cell B8 and B3. And the formula to the right of cell B12 for total interest earned is also a simple difference. Use algebra to simplify that formula to a general formula for total interest earned.\r\n\r\n[reveal-answer q=\"542902\"]Solution[\/reveal-answer]\r\n[hidden-answer a=\"542902\"]\r\n\r\nTotal interest, [latex]I[\/latex] is the difference between the balance and the principal.\r\n\r\n[latex]I=P_{N}-P_{0}[\/latex]\r\n\r\n[latex]I=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}-P_{0}[\/latex]\r\n\r\n[latex]I =P_{0}\\left(\\left(1+\\frac{r}{k}\\right)^{Nk}-1\\right)[\/latex]\u00a0 \u00a0 \u00a0 factor out a GCF of\u00a0 [latex]P_{0}[\/latex]\r\n\r\n[\/hidden-answer]\r\n\r\n<\/div>\r\nWe can also include cells to make speculations about compound interest situations. If we want to ask questions about rate or time given the other variables, we'll need to rearrange the formula. See the Examples below for the result and step-by-step solutions.\r\n<div class=\"textbox examples\">\r\n<h3>Recall the power rule for logarithms<\/h3>\r\n<strong>[latex]\\log (M^{n})=n\\log M[\/latex]<\/strong>\r\n\r\nThis enables you to take the log on both sides to bring the power down. Then, just divide away everything but the variable you wish to isolate.\r\n\r\n<\/div>\r\nRecall, the formula for compound interest. The balance in the account after [latex]N[\/latex] years depends on the principle, rate, compounding periods, and time invested.\r\n<p style=\"text-align: center\">[latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]<\/p>\r\n\r\n<div class=\"textbox exercises\">\r\n<h3>Example<\/h3>\r\n<p style=\"text-align: left\"><strong>Solve the formula [latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]\u00a0for [latex]P_{0}[\/latex]\u00a0<\/strong>\r\n[latex]P_{0}=\\dfrac{P_{N}}{\\left(1+\\frac{r}{k}\\right)^{Nk}}[\/latex]<\/p>\r\n[reveal-answer q=\"731529\"]Solution[\/reveal-answer]\r\n[hidden-answer a=\"731529\"]Solving for the principle is straightforward.This will answer the question\u00a0<em>how much will I need to deposit to have a certain balance given rate and time?\u00a0<\/em>We simply divide the account balance by the interest expression.[\/hidden-answer]\r\n\r\n<\/div>\r\n<div class=\"textbox exercises\">\r\n<h3>Example<\/h3>\r\n<strong>Solve the formula [latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]\u00a0for [latex]N[\/latex]\u00a0<\/strong>\r\n[latex]N=\\dfrac{\\log\\left[\\dfrac{P_{N}}{P_{0}}\\right]}{k\\log\\left[\\left(1+\\frac{r}{k}\\right)\\right]}[\/latex]\r\n\r\n[reveal-answer q=\"558693\"]Solution[\/reveal-answer]\r\n[hidden-answer a=\"558693\"]\r\n\r\nSolving for time requires us to use the power rule for logarithms.\r\n<p style=\"text-align: left\">\u00a0[latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]<\/p>\r\n[latex]\\log\\left[\\dfrac{P_{N}}{P_{0}}\\right]=\\log \\left[\\left(1+\\frac{r}{k}\\right)^{Nk}\\right][\/latex]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Take the common logarithm on both sides.\r\n\r\n[latex]\\log\\left[\\dfrac{P_{N}}{P_{0}}\\right]=Nk\\log\\left[\\left(1+\\frac{r}{k}\\right)\\right][\/latex]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Apply the power rule of logarithms.\r\n\r\n[latex]\\dfrac{\\log\\left[\\dfrac{P_{N}}{P_{0}}\\right]}{k\\log\\left[\\left(1+\\frac{r}{k}\\right)\\right]}=N[\/latex]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Divide on both sides to isolate [latex]N[\/latex]\r\n\r\n[\/hidden-answer]\r\n\r\n<\/div>\r\n<div class=\"textbox exercises\">\r\n<h3>Example<\/h3>\r\n<strong>Solve the formula [latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]\u00a0for [latex]r[\/latex]<\/strong>\r\n\r\n[latex]r=k\\left[\\left(\\dfrac{P_{N}}{P_{0}}\\right)^{\\left(\\frac{1}{Nk}\\right)}-1\\right][\/latex]\r\n\r\n[reveal-answer q=\"436120\"]Solution[\/reveal-answer]\r\n[hidden-answer a=\"436120\"]\r\n\r\nSolving the formula for the rate requires us to raise both sides to a fractional power.\r\n\r\n[latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]\r\n\r\n[latex]\\dfrac{P_{N}}{P_{0}}=\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]\u00a0 \u00a0 \u00a0Divide by [latex]P_{0}[\/latex] on both sides.\r\n\r\n[latex]\\left(\\dfrac{P_{N}}{P_{0}}\\right)^{\\left(\\frac{1}{Nk}\\right)}=\\left(\\left(1+\\frac{r}{k}\\right)^{\\cancel{\\left(Nk\\right)}}\\right)^ {\\left(\\cancel{\\frac{1}{Nk}}\\right)}[\/latex]\u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0 Raise both sides to [latex]\\left(\\dfrac{1}{Nk}\\right)[\/latex]\r\n\r\n[latex]\\left(\\dfrac{P_{N}}{P_{0}}\\right)^{\\left(\\frac{1}{Nk}\\right)}=1+\\frac{r}{k}[\/latex]\r\n\r\n[latex]\\left(\\dfrac{P_{N}}{P_{0}}\\right)^{\\left(\\frac{1}{Nk}\\right)}-1=\\frac{r}{k}[\/latex]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Subtract 1 to the left\r\n\r\n[latex]k\\left[\\left(\\dfrac{P_{N}}{P_{0}}\\right)^{\\left(\\frac{1}{Nk}\\right)}-1\\right]=r[\/latex]\u00a0 \u00a0 \u00a0 \u00a0 Multiply both sides by the denominator, [latex]k[\/latex].\r\n\r\n[\/hidden-answer]\r\n\r\n<\/div>\r\nNow we have the formulas to input for the second portion of the calculator.\r\n<ol>\r\n \t<li>First, we'll need to make a little room to include the Periods, since our formulas depend on the number of compounding periods. To add a row, right click on the shaded \"16\" in row 16 of the sheet. A menu should appear in which you can click \"insert\" to insert a new line below line 15. Label this line Periods.<\/li>\r\n \t<li>We'll need to populate these cells with values that will help us test our formulas. Use the known information from our CD example (see the image below).<\/li>\r\n \t<li>Also note the new formulas adjacent to B18 - B20. Change yours to match these, which we solved for in the examples above. Delete the simple interest formulas from cell B18, B19, and B20.<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12011851\/Compound_Interest_05.jpg\"><img class=\"aligncenter size-full wp-image-4321\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12011851\/Compound_Interest_05.jpg\" alt=\"\" width=\"553\" height=\"419\" \/><\/a><\/li>\r\n \t<li>Into cell B18, type =B15\/(1+(B13\/B16))^(B14*B16)<\/li>\r\n \t<li>Into cell B19, type =B16*((B15\/B12)^(1\/(B14*B16))-1)<\/li>\r\n \t<li>Into cell B20, type =LOG(B15\/B12)\/(B16*LOG(1+(B13\/B16)))<\/li>\r\n \t<li>The yellow cells should have populated automatically with $1000 for Principal, 0.0144 for Rate, and 5 for Years. If they didn't, you may have made an error typing in the formula. Check carefully that you have all the parentheses! Getting the formulas into a spreadsheet once may be tedious work, but it is a time-saver in the long run if you use the sheet repeatedly.<\/li>\r\n \t<li>We won't need the remaining cells for compound interest. You can delete those lines entirely by clicking on the first line number, dragging down to include them all, right-clicking, and choosing delete.The Compound Interest Calculator is complete!\u00a0<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12012443\/Compound_Interest_06.jpg\"><img class=\"aligncenter size-full wp-image-4323\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12012443\/Compound_Interest_06.jpg\" alt=\"\" width=\"547\" height=\"420\" \/><\/a><\/li>\r\n \t<li><\/li>\r\n<\/ol>\r\n<h3>Step 2: Use the calculator<\/h3>\r\nUse your calculator to investigate the situations that follow.\r\n<div class=\"textbox exercises\">\r\n<h3>example<\/h3>\r\nSuppose you deposit $7,395 into a 3 year CD paying\u00a00.9% interest, compounded monthly.\r\n\r\n(a) How much money will you have in your account when the CD matures?\r\n\r\n(b) How much total interest will you have earned?\r\n\r\n(c) If, on the day of maturity, you reinvest the account balance into a 5 year CD paying 1.29% interest compounded daily, how much money will you have in the account when the second CD matures?\r\n\r\n(d) How much will your initial investment of of $7,395 have grown over the 8 years it was invested?\r\n\r\n[reveal-answer q=\"162289\"]Solution[\/reveal-answer]\r\n[hidden-answer a=\"162289\"]\r\n\r\n(a) $8,103.20 (In your Compound Interest Calculator, enter 7395 for the Principal, 0.009 for the rate, 12 for the periods, and 3 for the years, then read the balance)\r\n\r\n(b)\u00a0 $215.78 (read this from the Interest box in line 10)\r\n\r\n(c) $8,643.07\r\n\r\n(d) $755.65 (215.78 + 539.87)\r\n\r\n[\/hidden-answer]\r\n\r\n<\/div>\r\n&nbsp;\r\n<div class=\"textbox exercises\">\r\n<h3>Example<\/h3>\r\nYou have $20,000 from an inheritance You would like to invest at least some of it in a CD.\r\n\r\n(a) You find a CD paying 1.39%, compounded daily for 3 years. What amount would you need to deposit if you want the account balance to be $10,000\r\n\r\n(b) What rate would you need to obtain to grow the entire $20,000 to $25,000 over 10 years? You can assume daily compounding.\r\n\r\n(c) If you'd like to spend $5,000 now but want the remaining $15,000 to grow back to $20,000 eventually, what maturity term would you need for a CD paying 1.89% compounded daily?\r\n\r\n[reveal-answer q=\"75310\"]Solution[\/reveal-answer]\r\n[hidden-answer a=\"75310\"]\r\n\r\n(a) $9591.58 (Enter 0.0139 for Rate, 3 for Years, $10,000 for Balance, and 365 for Periods in the second part of the sheet to find Principal, given r, t, A, and k)\r\n\r\n(b) 2.23% (Enter $20,000 for Principal, 10 for Years, $25,000 for Balance, and 365 for Periods in the second part of the sheet to find Rate, given [latex]P_{0}[\/latex], t, A, and k.\r\n\r\n(c) 15 years would yield $19,916.39. You'd need to settle for being $83.16 shy of your goal or find a short-term CD to invest in to reach $20k.\r\n\r\n[\/hidden-answer]\r\n\r\n<\/div>\r\n&nbsp;\r\n<div class=\"textbox key-takeaways\">\r\n<h3>try it<\/h3>\r\n[ohm_question]6680[\/ohm_question]\r\n\r\n<\/div>\r\n&nbsp;","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Calculate interest compounded over time<\/li>\n<li>Analyze and compare interest in real-world applications<\/li>\n<\/ul>\n<\/div>\n<p>Certificates of Deposit (CDs) are long-term savings instruments offered by banks. They come in increments such as one, three, five, or 10 years. The idea is that once you deposit your money, you\u2019ll leave it untouched for the duration of the CD term. Banks are usually willing to pay a higher interest in exchange for being assured of using your money longer. But CDs come with a hefty penalty for early withdrawal, so you\u2019ll want to be sure you have the cash to allocate to this type of savings.<\/p>\n<p>You can find easily find annual percentage yields for CDs advertised on banking websites. See the sample below.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/11182518\/Compound_Interest_03.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4297 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/11182518\/Compound_Interest_03.jpg\" alt=\"\" width=\"643\" height=\"429\" \/><\/a><\/p>\n<p>Notice that the annual percentage yield is advertised rather than the rate. The APY will always be slightly larger than the rate due to compounding. That is, the interest on your deposit will be calculated at fixed periods throughout the year and reinvested. Recall the formula from earlier in the text.<\/p>\n<div class=\"textbox\">\n<h3>Compound Interest<\/h3>\n<p>[latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]<\/p>\n<ul>\n<li><em>P<sub>N<\/sub><\/em> is the balance in the account after <em>N<\/em> years.<\/li>\n<li><em>P<sub>0 <\/sub><\/em> is the starting balance of the account (also called initial deposit, or principal)<\/li>\n<li><em>r<\/em> is the annual interest rate in decimal form<\/li>\n<li><em>k<\/em> is the number of compounding periods in one year<\/li>\n<\/ul>\n<\/div>\n<div class=\"textbox exercises\">\n<h3>example<\/h3>\n<p>Use the formula for compound interest to find the APY for a $1000 5-year CD with a rate of 1.44% compounded daily.<\/p>\n<div class=\"qa-wrapper\" style=\"display: block\"><span class=\"show-answer collapsed\" style=\"cursor: pointer\" data-target=\"q599399\">Solution<\/span><\/p>\n<div id=\"q599399\" class=\"hidden-answer\" style=\"display: none\">\n<p>[latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]<\/p>\n<p>Since we are interested in annual yield, we can let [latex]N=1[\/latex] and [latex]P_{0}=1[\/latex]<\/p>\n<p>[latex]P_{1}=1\\left(1+\\frac{.0144}{365}\\right)^{365}=1.01450[\/latex]<\/p>\n<p>The percent change in our investment over the year was [latex]0.01450 = 1.45[\/latex]%.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"textbox shaded\">\n<p><strong><strong>Converting Interest Rate to APY<\/strong><\/strong><\/p>\n<p>We can generalize a formula for converting interest rate to APY:<\/p>\n<p>[latex]\\text{APY }=1\\left(1+\\frac{r}{k}\\right)^{k}-1[\/latex]<\/p>\n<\/div>\n<p>Banks will usually advertise just the APY since it is a more attractive number. You can find the rate by looking deeper into the details of the CD.<\/p>\n<p>Since CDs are designed for you to leave your money in savings for the entire term, they provide excellent examples for exploring compound interest.<\/p>\n<h3>Spreadsheet\u00a0Hands-On: Create a Compound Interest Calculator<\/h3>\n<h3>Step 1: Create the calculator<\/h3>\n<p>The good news is that we&#8217;ve done much of the work to create our calculators already. Since our formulas involve many of the same variables, we can use copy and paste to create the next spreadsheet more quickly.<\/p>\n<ol>\n<li>Make a copy of the Simple Interest spreadsheet by right-clicking on the tab containing its name at the bottom of the window, choose Move or Copy, and click the box to Create a copy. Choose (move to end) to place it at the end. Rename your new sheet &#8220;Compound Interest&#8221; by double-clicking its tab name and typing over it.<\/li>\n<li>Using the cells listed in the image below, change the formula in cell B8 to use the compound interest formula by typing into cell B8:\u00a0 =B3*(1+(B4\/B5))^(B5*B6).Note that the template formula to the right of that cell has been changed to compound interest as well.\u00a0<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/11190050\/Compound_Interest_04.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4298 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/11190050\/Compound_Interest_04.jpg\" alt=\"\" width=\"484\" height=\"183\" \/><\/a><\/li>\n<li>We&#8217;ll need to change the formula in the Interest section, too, from simple interest to compound interest. Since compound interest is reinvested over the life of the CD, the interest accumulated is not constant from year to year. We will only need one interest line. Delete lines 11 and 12 by selecting them, right clicking, then choosing delete. Change the Interest description in C10 to &#8220;total interest earned&#8221;<\/li>\n<li>The response in cell B10 will be the difference between balance and principal : =B8-B3. When you are done, it should look like the image below.<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12010408\/Compound_Interest_04a.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4317\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12010408\/Compound_Interest_04a.jpg\" alt=\"\" width=\"503\" height=\"222\" \/><\/a><\/li>\n<\/ol>\n<div class=\"textbox exercises\">\n<h3>example<\/h3>\n<p>There are often several good ways to represent a general formula. For instance, the difference between the CD balance at the end of term and the initial deposit is given above simply as the difference between cell B8 and B3. And the formula to the right of cell B12 for total interest earned is also a simple difference. Use algebra to simplify that formula to a general formula for total interest earned.<\/p>\n<div class=\"qa-wrapper\" style=\"display: block\"><span class=\"show-answer collapsed\" style=\"cursor: pointer\" data-target=\"q542902\">Solution<\/span><\/p>\n<div id=\"q542902\" class=\"hidden-answer\" style=\"display: none\">\n<p>Total interest, [latex]I[\/latex] is the difference between the balance and the principal.<\/p>\n<p>[latex]I=P_{N}-P_{0}[\/latex]<\/p>\n<p>[latex]I=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}-P_{0}[\/latex]<\/p>\n<p>[latex]I =P_{0}\\left(\\left(1+\\frac{r}{k}\\right)^{Nk}-1\\right)[\/latex]\u00a0 \u00a0 \u00a0 factor out a GCF of\u00a0 [latex]P_{0}[\/latex]<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>We can also include cells to make speculations about compound interest situations. If we want to ask questions about rate or time given the other variables, we&#8217;ll need to rearrange the formula. See the Examples below for the result and step-by-step solutions.<\/p>\n<div class=\"textbox examples\">\n<h3>Recall the power rule for logarithms<\/h3>\n<p><strong>[latex]\\log (M^{n})=n\\log M[\/latex]<\/strong><\/p>\n<p>This enables you to take the log on both sides to bring the power down. Then, just divide away everything but the variable you wish to isolate.<\/p>\n<\/div>\n<p>Recall, the formula for compound interest. The balance in the account after [latex]N[\/latex] years depends on the principle, rate, compounding periods, and time invested.<\/p>\n<p style=\"text-align: center\">[latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]<\/p>\n<div class=\"textbox exercises\">\n<h3>Example<\/h3>\n<p style=\"text-align: left\"><strong>Solve the formula [latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]\u00a0for [latex]P_{0}[\/latex]\u00a0<\/strong><br \/>\n[latex]P_{0}=\\dfrac{P_{N}}{\\left(1+\\frac{r}{k}\\right)^{Nk}}[\/latex]<\/p>\n<div class=\"qa-wrapper\" style=\"display: block\"><span class=\"show-answer collapsed\" style=\"cursor: pointer\" data-target=\"q731529\">Solution<\/span><\/p>\n<div id=\"q731529\" class=\"hidden-answer\" style=\"display: none\">Solving for the principle is straightforward.This will answer the question\u00a0<em>how much will I need to deposit to have a certain balance given rate and time?\u00a0<\/em>We simply divide the account balance by the interest expression.<\/div>\n<\/div>\n<\/div>\n<div class=\"textbox exercises\">\n<h3>Example<\/h3>\n<p><strong>Solve the formula [latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]\u00a0for [latex]N[\/latex]\u00a0<\/strong><br \/>\n[latex]N=\\dfrac{\\log\\left[\\dfrac{P_{N}}{P_{0}}\\right]}{k\\log\\left[\\left(1+\\frac{r}{k}\\right)\\right]}[\/latex]<\/p>\n<div class=\"qa-wrapper\" style=\"display: block\"><span class=\"show-answer collapsed\" style=\"cursor: pointer\" data-target=\"q558693\">Solution<\/span><\/p>\n<div id=\"q558693\" class=\"hidden-answer\" style=\"display: none\">\n<p>Solving for time requires us to use the power rule for logarithms.<\/p>\n<p style=\"text-align: left\">\u00a0[latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]<\/p>\n<p>[latex]\\log\\left[\\dfrac{P_{N}}{P_{0}}\\right]=\\log \\left[\\left(1+\\frac{r}{k}\\right)^{Nk}\\right][\/latex]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Take the common logarithm on both sides.<\/p>\n<p>[latex]\\log\\left[\\dfrac{P_{N}}{P_{0}}\\right]=Nk\\log\\left[\\left(1+\\frac{r}{k}\\right)\\right][\/latex]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Apply the power rule of logarithms.<\/p>\n<p>[latex]\\dfrac{\\log\\left[\\dfrac{P_{N}}{P_{0}}\\right]}{k\\log\\left[\\left(1+\\frac{r}{k}\\right)\\right]}=N[\/latex]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Divide on both sides to isolate [latex]N[\/latex]<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"textbox exercises\">\n<h3>Example<\/h3>\n<p><strong>Solve the formula [latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]\u00a0for [latex]r[\/latex]<\/strong><\/p>\n<p>[latex]r=k\\left[\\left(\\dfrac{P_{N}}{P_{0}}\\right)^{\\left(\\frac{1}{Nk}\\right)}-1\\right][\/latex]<\/p>\n<div class=\"qa-wrapper\" style=\"display: block\"><span class=\"show-answer collapsed\" style=\"cursor: pointer\" data-target=\"q436120\">Solution<\/span><\/p>\n<div id=\"q436120\" class=\"hidden-answer\" style=\"display: none\">\n<p>Solving the formula for the rate requires us to raise both sides to a fractional power.<\/p>\n<p>[latex]P_{N}=P_{0}\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]<\/p>\n<p>[latex]\\dfrac{P_{N}}{P_{0}}=\\left(1+\\frac{r}{k}\\right)^{Nk}[\/latex]\u00a0 \u00a0 \u00a0Divide by [latex]P_{0}[\/latex] on both sides.<\/p>\n<p>[latex]\\left(\\dfrac{P_{N}}{P_{0}}\\right)^{\\left(\\frac{1}{Nk}\\right)}=\\left(\\left(1+\\frac{r}{k}\\right)^{\\cancel{\\left(Nk\\right)}}\\right)^ {\\left(\\cancel{\\frac{1}{Nk}}\\right)}[\/latex]\u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0 Raise both sides to [latex]\\left(\\dfrac{1}{Nk}\\right)[\/latex]<\/p>\n<p>[latex]\\left(\\dfrac{P_{N}}{P_{0}}\\right)^{\\left(\\frac{1}{Nk}\\right)}=1+\\frac{r}{k}[\/latex]<\/p>\n<p>[latex]\\left(\\dfrac{P_{N}}{P_{0}}\\right)^{\\left(\\frac{1}{Nk}\\right)}-1=\\frac{r}{k}[\/latex]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Subtract 1 to the left<\/p>\n<p>[latex]k\\left[\\left(\\dfrac{P_{N}}{P_{0}}\\right)^{\\left(\\frac{1}{Nk}\\right)}-1\\right]=r[\/latex]\u00a0 \u00a0 \u00a0 \u00a0 Multiply both sides by the denominator, [latex]k[\/latex].<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>Now we have the formulas to input for the second portion of the calculator.<\/p>\n<ol>\n<li>First, we&#8217;ll need to make a little room to include the Periods, since our formulas depend on the number of compounding periods. To add a row, right click on the shaded &#8220;16&#8221; in row 16 of the sheet. A menu should appear in which you can click &#8220;insert&#8221; to insert a new line below line 15. Label this line Periods.<\/li>\n<li>We&#8217;ll need to populate these cells with values that will help us test our formulas. Use the known information from our CD example (see the image below).<\/li>\n<li>Also note the new formulas adjacent to B18 &#8211; B20. Change yours to match these, which we solved for in the examples above. Delete the simple interest formulas from cell B18, B19, and B20.<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12011851\/Compound_Interest_05.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4321\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12011851\/Compound_Interest_05.jpg\" alt=\"\" width=\"553\" height=\"419\" \/><\/a><\/li>\n<li>Into cell B18, type =B15\/(1+(B13\/B16))^(B14*B16)<\/li>\n<li>Into cell B19, type =B16*((B15\/B12)^(1\/(B14*B16))-1)<\/li>\n<li>Into cell B20, type =LOG(B15\/B12)\/(B16*LOG(1+(B13\/B16)))<\/li>\n<li>The yellow cells should have populated automatically with $1000 for Principal, 0.0144 for Rate, and 5 for Years. If they didn&#8217;t, you may have made an error typing in the formula. Check carefully that you have all the parentheses! Getting the formulas into a spreadsheet once may be tedious work, but it is a time-saver in the long run if you use the sheet repeatedly.<\/li>\n<li>We won&#8217;t need the remaining cells for compound interest. You can delete those lines entirely by clicking on the first line number, dragging down to include them all, right-clicking, and choosing delete.The Compound Interest Calculator is complete!\u00a0<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12012443\/Compound_Interest_06.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4323\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/12012443\/Compound_Interest_06.jpg\" alt=\"\" width=\"547\" height=\"420\" \/><\/a><\/li>\n<li><\/li>\n<\/ol>\n<h3>Step 2: Use the calculator<\/h3>\n<p>Use your calculator to investigate the situations that follow.<\/p>\n<div class=\"textbox exercises\">\n<h3>example<\/h3>\n<p>Suppose you deposit $7,395 into a 3 year CD paying\u00a00.9% interest, compounded monthly.<\/p>\n<p>(a) How much money will you have in your account when the CD matures?<\/p>\n<p>(b) How much total interest will you have earned?<\/p>\n<p>(c) If, on the day of maturity, you reinvest the account balance into a 5 year CD paying 1.29% interest compounded daily, how much money will you have in the account when the second CD matures?<\/p>\n<p>(d) How much will your initial investment of of $7,395 have grown over the 8 years it was invested?<\/p>\n<div class=\"qa-wrapper\" style=\"display: block\"><span class=\"show-answer collapsed\" style=\"cursor: pointer\" data-target=\"q162289\">Solution<\/span><\/p>\n<div id=\"q162289\" class=\"hidden-answer\" style=\"display: none\">\n<p>(a) $8,103.20 (In your Compound Interest Calculator, enter 7395 for the Principal, 0.009 for the rate, 12 for the periods, and 3 for the years, then read the balance)<\/p>\n<p>(b)\u00a0 $215.78 (read this from the Interest box in line 10)<\/p>\n<p>(c) $8,643.07<\/p>\n<p>(d) $755.65 (215.78 + 539.87)<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"textbox exercises\">\n<h3>Example<\/h3>\n<p>You have $20,000 from an inheritance You would like to invest at least some of it in a CD.<\/p>\n<p>(a) You find a CD paying 1.39%, compounded daily for 3 years. What amount would you need to deposit if you want the account balance to be $10,000<\/p>\n<p>(b) What rate would you need to obtain to grow the entire $20,000 to $25,000 over 10 years? You can assume daily compounding.<\/p>\n<p>(c) If you&#8217;d like to spend $5,000 now but want the remaining $15,000 to grow back to $20,000 eventually, what maturity term would you need for a CD paying 1.89% compounded daily?<\/p>\n<div class=\"qa-wrapper\" style=\"display: block\"><span class=\"show-answer collapsed\" style=\"cursor: pointer\" data-target=\"q75310\">Solution<\/span><\/p>\n<div id=\"q75310\" class=\"hidden-answer\" style=\"display: none\">\n<p>(a) $9591.58 (Enter 0.0139 for Rate, 3 for Years, $10,000 for Balance, and 365 for Periods in the second part of the sheet to find Principal, given r, t, A, and k)<\/p>\n<p>(b) 2.23% (Enter $20,000 for Principal, 10 for Years, $25,000 for Balance, and 365 for Periods in the second part of the sheet to find Rate, given [latex]P_{0}[\/latex], t, A, and k.<\/p>\n<p>(c) 15 years would yield $19,916.39. You&#8217;d need to settle for being $83.16 shy of your goal or find a short-term CD to invest in to reach $20k.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"textbox key-takeaways\">\n<h3>try it<\/h3>\n<p><iframe loading=\"lazy\" id=\"ohm6680\" class=\"resizable\" src=\"https:\/\/ohm.lumenlearning.com\/multiembedq.php?id=6680&theme=oea&iframe_resize_id=ohm6680&show_question_numbers\" width=\"100%\" height=\"150\"><\/iframe><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-4303\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li><strong>Authored by<\/strong>: Deborah Devlin. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><li>Revision and Adaptation. <strong>Authored by<\/strong>: Deborah Devlin. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><li>Screenshot of Published CD Rates. <strong>Located at<\/strong>: <a target=\"_blank\" href=\"https:\/\/www.navyfederal.org\/products-services\/checking-savings\/certificates-rates.php\">https:\/\/www.navyfederal.org\/products-services\/checking-savings\/certificates-rates.php<\/a>. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/about\/cc0\">CC0: No Rights Reserved<\/a><\/em><\/li><\/ul><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Shared previously<\/div><ul class=\"citation-list\"><li>Math in Society. <strong>Authored by<\/strong>: David Lippman. <strong>Provided by<\/strong>: Open Textbook Store, Transition Math Project, and the Open Course Library. <strong>Located at<\/strong>: <a target=\"_blank\" href=\"http:\/\/www.opentextbookstore.com\/mathinsociety\/\">http:\/\/www.opentextbookstore.com\/mathinsociety\/<\/a>. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by-sa\/4.0\/\">CC BY-SA: Attribution-ShareAlike<\/a><\/em><\/li><li>Question ID 6680. <strong>Authored by<\/strong>: David Lippman. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em>. <strong>License Terms<\/strong>: IMathAS Community License CC-BY + GPL<\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":25777,"menu_order":10,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"\",\"author\":\"Deborah Devlin\",\"organization\":\"\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"},{\"type\":\"original\",\"description\":\"Revision and Adaptation\",\"author\":\"Deborah Devlin\",\"organization\":\"\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"},{\"type\":\"cc\",\"description\":\"Math in Society\",\"author\":\"David Lippman\",\"organization\":\"Open Textbook Store, Transition Math Project, and the Open Course Library\",\"url\":\"http:\/\/www.opentextbookstore.com\/mathinsociety\/\",\"project\":\"\",\"license\":\"cc-by-sa\",\"license_terms\":\"\"},{\"type\":\"original\",\"description\":\"Screenshot of Published CD Rates\",\"author\":\"\",\"organization\":\"\",\"url\":\"https:\/\/www.navyfederal.org\/products-services\/checking-savings\/certificates-rates.php\",\"project\":\"\",\"license\":\"cc0\",\"license_terms\":\"\"},{\"type\":\"cc\",\"description\":\"Question ID 6680\",\"author\":\"David Lippman\",\"organization\":\"\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"IMathAS Community License CC-BY + GPL\"}]","CANDELA_OUTCOMES_GUID":"","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-4303","chapter","type-chapter","status-web-only","hentry"],"part":4179,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/pressbooks\/v2\/chapters\/4303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/wp\/v2\/users\/25777"}],"version-history":[{"count":14,"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/pressbooks\/v2\/chapters\/4303\/revisions"}],"predecessor-version":[{"id":4305,"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/pressbooks\/v2\/chapters\/4303\/revisions\/4305"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/pressbooks\/v2\/parts\/4179"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/pressbooks\/v2\/chapters\/4303\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/wp\/v2\/media?parent=4303"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/pressbooks\/v2\/chapter-type?post=4303"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/wp\/v2\/contributor?post=4303"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/slcc-mathforliberalartscorequisite\/wp-json\/wp\/v2\/license?post=4303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}