Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Using the spreadsheet for Investing Regularly given above, determine what values will be found in cel.....?
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
1 Answer
- Anonymous9 years agoFavorite Answer
By setting the spreadsheet, you should obtain the appropriate principal values contained in the column table...
Good luck!
Source(s): ☻