Using the spreadsheet for Investing Regularly given above, determine what the closing balance of this inves...?
Use the following information to answer next 4 questions:
----Consider an investment of $2000 at 8% per annum, compounded monthly, for 5 years. A fixed sum of $100 is to be added to the investment at the end of each compounding period.
http://tinypic.com/r/29e1xj8/6
1.) Using the spreadsheet for Investing Regularly given above, determine
what values must be entered into cells C3, C4, C5, and C6.
~ $2000, 8%, 100, 12
~ $2000, 8%, 12, $100
~ $2000, 8, 12, $100
~ $2000, 8%, $12, $100
2.) Using the spreadsheet for Investing Regularly given above, determine to which row you must fill down in order to calculate the closing balance.
3.) Using the spreadsheet for Investing Regularly given above, determine what values will be found in cells A10, B10, C10, D10, and E10.
~ 0.169, 2213.33, 15.09, 100, 2329
~ 0.167, 2113.33, 14.09, 100, 2227
~ 0.167, 2413.78, 14.09, 100, 2227
~ 167, 21130.33, 14.09, 100, 22270
4.) Using the spreadsheet for Investing Regularly given above, determine what the closing balance of this investment is.
~ $10327.38
~ 147562.53
~ 10006.29
~ $15940.86