How would you calculatw this with an excel formula on excel
1. You want to have $100,000 in your savings account 12 years from now. If you are prepared to make equal annual deposits at the end of each year, how much must you deposit each year if you can earn 8.5%
2. Wells fargo is offering you a $60,000 5-year loan at an annual interest rate of 9%. What if your annual payment?
3. You want to purchase a BMW for $69,500. Wells fargo is offering 60-month auto loans at 5% APR (compounded monthly). What is your monthly payment?