3 questions use excel formulas

8. Beginning three months from now, you want to be able to withdraw 52,50 each quarter from your bank account to cover college expenses over the next four years if the account pays 5 percent interest per quarter. How much do you need to have in your bank account today to meet your expense needs over the next four years? Prepare an amortization schedule for a five-year loan of $20.000. The interest rate is 8.2 percent per year and the loan calls for equat annual payments How much interest is paid in the third year? How much would need to be deposited into savings account today earning 3.5% compounded annually in order to offer a $100 yearly scholarship forever? hate 0.035 PMT 100 PV