use pmt function to solve it

Q2 use pv function

You want to retire in 27 years, and you've decided you will deposit an equal amount in your account at the beginning of each month until you retire. If you want to have $4,200,000 in your account at that time, and your account will earn a 3.7% annual interest rate, how large will your monthly deposits need to be? (5 points) Your car was just totaled, and the insurance company has sent you a check for \$26,200. You'd like to use this as an opportunity to upgrade your ride, and you have enough room in your budget to spend $605 per month on a car payment. If you took out a 3 year loan with a 6.0% annual rate, how much could you afford to spend on a car? (10 points) How much more could you afford to spend if you took out a 5 year loan instead? Assume that the interest rate would not change. (10 points)