ABC Bank Business Loan Calculations Monthly Payment Annual Payment Loan Amount (PV) Annual Interest Rate Payments per Year nterest Rate per Period (RATE) Number of Years Total Payments (NPER) Part 6 You are planning to buy a new car. You would like to have an idea of the amount of the monthly payments. The price of the car is $45,000. The annual interest rate is 4.5%, and you would like to pay the car in 5 years. 10% On Cell E4, using a Function, calculate the amount of your monthly payments. Make sure the value is displayed as a positive value. On Cell E5, using a Formula, calculate the amount of your Annual Payment.