Answered You can hire a professional tutor to get the answer.

QUESTION

I don't understand, the following problems in an Excel file. All problems must be using the functions in Excel . Should be able to see your formulas...

$29

6)   What would the present value be of $3,000 to be received 12 years from now discounted back at 8%?

7)   You are offered $1,000 today, $10,000 in 12 years, or $25,000 in 25 years. Assuming that you can earn 11 percent on your money, which offer should you choose?

8)   Selma and Patty are saving for retirement in two different ways.  Who will save more money for retirement at the end? Show your work. They will both receive 8% annual return on their investment over the next 35 years.  Selma invests $2,000 at the end of each year only for first 10 years of the 35 year period - for a total of $20,000 saved.  Patty doesn't start saving for 7 years and then saves $2,000 per year at the end of each year for 28 years -for a total of $56,000 saved.

9)   You invested $100,000 5 years ago at 7.5% annual interest rate. If you invest an additional $1,500 a year, at the beginning of each year for 20 years at the same 7.5% annual rate, how much will you have 20 years from now?

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question