Compound Interest Project
Compound Interest Project
Directions
You need to download a template in Excel to complete the project
1. Type your name, the date, and the title of the worksheet
2. Enter the beginning balance in Column C, Row 2 based on one of the problems below
3. 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)
4. 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"
5. 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
6. Next, click once on the cell in Column C row 3 (cell C3, just under your beginning balance)
7. 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:
8. 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.
9. Finally, repeat the last step with cell C3. Congratulations, you are done.
10. Answer the questions at the bottom of the page
11. Print your work
Problems to choose from:
|Find the number of years needed to double your |Find the number of years needed to double your |Find the number of years needed to double your |
|money if you deposit $100 in a savings account that|money if you deposit $1000 in a savings account |money if you deposit $40 in a savings account that |
|earns 5% annual interest compounded annually |that earns 5.5% annual interest compounded |earns 6% annual interest compounded semiannually. |
| |annually. | |
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- balance of payments wendy jeffus
- compound interest project
- determining forage production and stocking rates
- replacement reserve spreadsheet instructions
- calculating the actual price of the security in the wall
- instructions for using the reconciliation
- an effective method for teaching and understanding
- using excel for present value calculations
- lecture notes on time value of money
Related searches
- daily compound interest calculator
- daily compound interest table excel
- mortgage compound interest calculator monthly
- calculate monthly compound interest formula
- compound interest calculator car loan
- dave ramsey compound interest example
- how to compound interest monthly
- monthly compound interest calculator
- compound interest calculator with reinvesting
- compound interest formula excel spreadsheet
- compound interest calculator excel templates
- power of compound interest examples