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.

? asked in Science & MathematicsMathematics · 9 years ago

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

Relevance
  • Anonymous
    9 years ago
    Favorite Answer

    By setting the spreadsheet, you should obtain the appropriate principal values contained in the column table...

    Good luck!

    Source(s):
Still have questions? Get your answers by asking now.