In: Finance
Using your Excel TVM Calculators answer the following questions, be sure to submit your spreadsheet with your answers highlighted.
At what annual interest rate must $137,000 be invested so that it will grow to be $475,000 in 10 years?
If you wish to accumulate $175,000 in 13 years, how much must you deposit today in an account that pays an annual interest rate of 15%?
How many years will it take for $125,000 to grow to be $500,000 if it is invested in an account with an annual interest rate of 9%?
What will $137,000 grow to be in 12 years if it is invested today in an account with an annual interest rate of 10%?
If you wish to accumulate $200,000 in 7 years, how much must you deposit today in an account that pays a quoted annual interest rate of 12% with semi-annual compounding interest?
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference
Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.