ࡱ> 8:7` Tjbjb $|c|cT| | | | ;  ,RC       2 ~ [/| J ~ 4 0;R , ~ xxCompound Interest Project Directions You need to download a template in Excel to complete the project Type your name, the date, and the title of the worksheet Enter the beginning balance in Column C, Row 2 based on one of the problems below Use the Calculator in the formula bar and the "Fill Down" feature of Excel to fill in the rest of the table: Click once in the cell in Column B, row 3 (cell B3) Click on the picture of the calculator in the Formula Bar. If you do not see the formula bar, go to the "View" menu and select "Formula Bar" Now you'll enter the formula to calculate the yearly interest. To do this, click on the cell with the beginning balance (cell C2), then use the calculator to multiply this value by the interest rate in a decimal form, click OK on the calculator when you are done. The interest for year one should appear in cell B3 Next, click once on the cell in Column C row 3 (cell C3, just under your beginning balance) Click on the calculator again, and enter the formula for the new balance. To do this, click on cell C2, then on the plus sign in the calculator, finally click on cell B3, and click ok on the calculator when you are done. Now all that's left to do is to fill the remaining cells with the same formulas: Click once on cell B3, then use your mouse or track pad to grab the lower right hand corner of the blue rectangle that appears around the cell. Drag it to the bottom of the table, staying in the same column. Some cells will have no numbers yet, don't worry. Finally, repeat the last step with cell C3. Congratulations, you are done. Answer the questions at the bottom of the page Print your work Problems to choose from: Find the number of years needed to double your money if you deposit $100 in a savings account that earns 5% annual interest compounded annuallyFind the number of years needed to double your money if you deposit $1000 in a savings account that earns 5.5% annual interest compounded annually. Find the number of years needed to double your money if you deposit $40 in a savings account that earns 6% annual interest compounded semiannually.  %fThLDhLDhLD6hLDhLD56CJhLDhLD5CJ%fg#$_ ` : ; j k { |  & FgdLDgdLD $dha$gdLDT| } ' PQ$IfgdLDl$IfgdLDl:gdLDQRSTtoogdLDkd$$IflF, \(   t06    4 l4a":pLD/ =!"#$%R$$If!vh5 5 5 #v :Vl t65 <@< NormalCJaJmH sH tH DA@D Default Paragraph FontRi@R  Table Normal4 l4a (k@(No Listn@n LD Table Grid7:V0_HT!zT%fg#$_`:;jk{|}'PQRSV00000000 0000 0000 0000 0000 0000 0000 0000 0000 00ʀ 0 0 0 0ʀ0ʀ0ʀ0@0ʠ0@0@0@0@0ʠ0ʀ0ʀ%fg#$_`:;jk{|}PSV0000 00 00 00 00 00 00 00 00 0w0w0w0w0w0w0w0Gw0w00@T | QT T qi.^h ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.qi         'QRV@ \(T@ @UnknownGTimes New Roman5Symbol3 Arial 1h%t*t1#4dS @mCompound Interest Project Beth Billett Beth Billett  Oh+'0L   < H T`hpx'Compound Interest Project. Beth BillettttNormal Beth Billetttt2Microsoft Word 11.1@^в@V@X_WGPICTb HHb bHH/'̀bb       3kZso{g9wwcwwwAR=5JR595{11{Ns1RJRNsJRNsVJRJRBZJRNsVkZo{ cswwwJRVVNsJRNs)J!JR Mo{wwwwwwo{wwwwwu3g9ZZ^ZZVg9F1Zcw^kZZF1Zg9ZVVkZZF1^Vg9^ZkZg9Z^ZVVkZZg9NsZZ^g9Zo{Z^g9    AwkZwwwwwswwwi-kZkZg9Z^g9ZRVBkZ^wJR^ZVg9^RVZg9R^^Z^ZkZg9R^VVkZVF1^^g9  eo{o{wwwwo{wwo{kZo{wwswwwwwDg9VVg9^kZJR^R^ZVVNscRVNsVc^o{VcZkZ^NsNscVZVwg9RVZ^ZZVZV^ZkZJR^ZRRkZF1kZZR^RVw   o{wwwo{wwwwswwwwso{wo{ssg9wswwswM^cR^JR^cVV^Nsg9ZkZNsJR^RkZNsRkZVRVkZVVZg9R^g9o{kZcRVwVRVg9^kZ^ZNskZcRg9ZkZo{kZo{Vg9R^kZ^NsZkZg9R^Owwo{wwwwwo{wwo{o{wwkZo{we+g9VRRckZZVF1c^NsJR^c^kZkZNscZRNskZVVwkZZVZkZc^kZNsZkZ  mwo{wwwswwwwo{wo{wswwswwLVckZo{cVZVg9R^Zo{R^kZ^ZkZJR^cNsc^Nsg9ZkZNsJR^g9ZkZNsRkZVVRkZkZkZg9Z^ZZVZg9Z^^g9R^kZZF1kZ^NsRNswcZg9ZAwswwswwso{wo{sO g9R^^o{^VwNskZJR^VVZZ^Rcg9g9ZF1kZ^NsVRkZ   yswwwwswwwwwkZwwwwwwwww2c^kZZVcZ^wkZRVRkZg9R^kZZF1kZ^NsNscNsc^Nsg9^JR^g9^VZNsg9^kZ^NskZZg9RRwckZZVZVJR^c^kZNswo{JRJR^awwwwwkZkZwwwwwwwwwwwIR^cNsVo{VcRVkZVc^kZcRVg9g9g9R^V^Z^g9F1cNsc^Nsg9ZkZg9ZNsRkZ^ZZJRo{ZkZVR^Rg9JR^Nsg9^kZ^NskZJR^o{VV_wwswwo{swwwwwkZwswwwGZ^co{NsNskZRkZNsg9ckZZVcVwZVg9R^cVV^Nsg9ZkZVNs^VNs^VkZ^ZZV^kZR^Nsg9^kZ^NsRkZg9^VkZZV^ZRZ^kZZwkZo{% VZZ^VkZNscRNsZֹ   qwwwwwwwwo{wwo{wo{wwwo{kZwwwwwIV^RkZg9wckZZVZVc^ZVJR^c^kZkZNscZRNskZVcRVw^kZNskZkZc^wVZRVZ^kZg9Z^JR^ZVVNscRVNsVc^kZ  {so{wwwwwwwswswwwkZwwwwww;kZckZo{cVZVg9R^cVV^kZJRZNscVNswVVZ^Vg9^kZJR^kZZkZNsRNsRkZJR^V^VwRVNsVc^kZZJRo{VckZZVZVc^kZkZwo{kZwwwwwwswwwwwkZo{wwwwwwwcg9wg9R^VZVJR^ZkZ^Z8VNsJR^cVkZcRVg9Zg9kZNsVkZkZRkZZVZVc^kZNsZwVVZckZZVZVZVg9R^cVV^kZVg9ZkZ ^wwwwwwwwswswwwwwswVwRJRg9Z^VkZ^ZZV^^RVwVkZg9RJRVRkZg9g9Z RNs^kZZR^kZ^Nso{Vcc^kZRVwZRg9R^ZBkZ^kZZkZNsRNsZ  ao{o{wwwkZo{wwwwwwwwwswMVckZo{cVZVcJRVc^kZNsw^wJR^V^Z^g9Z^kZNskZZ^Z^ZkZZVcVZVZg9ZckZVRg9R^kZF1ZkZkZo{cRg9RVVZcZNs^kZZkZg9R^Owwwwwwwwo{wwswwwwIRkZ^^kZ^RVVcRg9RVNsZZ^VkZZVkZJRVZg9R^cRkZc^VcZg9Zg9R^RZg9g9BkZZkZJR^g9VRRwZg9JRo{Vco{Vg9R^ZVNsR 7wkZwwwwwwwg,cZkZF1kZVRZNsRcRRVkZkZJRVkZ^VZJRNskZR^kZZg9RwZZVcVVkZkZg9  Ko{o{wwwwwwkZkZo{www8^g9o{VVkZkZckZ^Z^JRJR^NsZNsg9^ZVwZRc^kZV^cZVckZJRRV^ZVZcZ^VRZZJR  /wo{wwwwswW kZVZRZVZZR^Z^ZVZVg9JR^RZg9g9BkZZkZJR^ZVc^   wwo{w-kZkZckZNsg9g9Z^kZVwZkZV    !o{wwws1 cRRkZF1kZZg9ZcRZRRNskZ   wo{wwws wwo{wwws wwo{wwwswwOg9NsZg9R^V^NskZRRZkZg9^VkZF1^^Z^Zg9o{VZg9R^V^NsJR^kZZkZg9^VkZZV^^Z^Zg9NsZg9R^V^NskZR^kZZkZg9^VkZF1^^Z^ZEwwwswwwswwwsg9ZZ^RkZ^g9Z^kZNskZZJRg9^g9Z^g9Z^RRg9Z^kZNsRV^g9o{kZg9Z^g9ZZF1kZ^g9Z^kZNskZZVR^g9Z^<wo{wo{o{wo{wo{wo{wo{Z^ZVkZVVo{VVZVkZNscZVccZ^Vg9Z^ZZRg9VkZV o{VVZNso{VcZZ^ZZo{g9VVNsVVZVkZNscZVccZ^Vg9 Owsswwwssswwwwsww JRVRVkZVZc^kZV^VkZNsg9^kZ^NsVccZJRg9g9RVRVkZVZcc^NsVV^NsJRVg9^VNsZV^kZVV^VkZo{VRkZ^Ns?wwwwwwwwwwww NsNskZZZ^VZ^ZV^NskZg9o{VRkZ^NscZNsRZ^VZ^ZV^VkZkZg9cBkZZZ^VZ^ZZ^Ns^VV^VkZkZg9                    HH ՜.+,0 `hpx  ' Compound Interest Project Title !"#$%&'()*+,-.01234569Root Entry FgL;Data 1TableWordDocument$SummaryInformation( |DocumentSummaryInformation8/CompObjX FMicrosoft Word DocumentNB6WWord.Document.8