Mathematics Homework Help
Grand Canyon University Personal Investment Values Worksheet
- Open the attached Excel file and save it to your computer with a different name.
- 2-3 Technology (p. 91 in your eBook)
A quick glance at the table you filled out in Question 3 at the beginning of this lesson should be enough to convince you that spreadsheets are particularly well-suited to interest calculations. First, recreate that table using a spreadsheet. Of course, the point is to use formulas to do the calculations, not just key in the results. Then use the “copy down” feature to calculate the future value of the account and the total interest earned for years 11 through 30. A template to help you get started is included in the online resources for this lesson.
Next, suppose that your goal was for the future value of the investment to be $1,000 after 10 years. Use trial and error, changing the amounts in cells A2 and B2, to find (1) how much more you’d need to invest upfront, and (2) what interest rate you’d need to earn to achieve that goal if you keep the original investment at $600.
Note, you will see the formula typed in the formula bar above the cell columns.
Note, the attached PDF will show you how to access the eBook where you can access the video for the DQ.
- Click Unit 2
- Choose media
- Scroll to the right until you find QR 2-3 Tech video.
Here is the video link for Tech Hint QR 2 – 3
