NEED TO SHOW ALL WORK IN EXCEL
1. What is the annual interest rate, if $10,000 grows to $12,166
over 5 years? (3)
2. Payments of $500 each are received every six months ($1,000
per year) for 5 years. The nominal annual interest rate is 5%.
Using semi-annual compounding, what is the present value today?
What is the present value of the payments today? (3)
3. What monthly annuitiy investment (deposit per month) is
required to achieve $20,000 in 4...