Trying to study for a test for financial modeling course and im not understanding exactly where to start an excel sheet with formulas is recommended.
1. If you wish to accumulate $140,000 in 13 years, how much must you deposit today in an account that pays an annual interest rate of 14%?
2. What will $247,000 grow to be in 9 years if it is invested today in an account with an annual interest rate of 11%?
3. How many years will it take for $136,000 to grow to be $468,000 if it is invested in an account with an annual interest rate of 8%?
4. At what annual interest rate must $137,000 be invested so that it will grow to be $475,000 in 14 years?
5. If you wish to accumulate $197,000 in 5 years, how much must you deposit today in an account that pays a quoted annual interest rate of 13% with semi-annual compounding of interest?