I need the excel formulas i know the answers but it requires to use formulas pmt

Compute the amount of the semiannual payment on a 30year,$225,000 loan with an annual interest rate of 9%. Formula must include the PMT function and return a positive value. Compute the amount of the monthly payment on a 30 -year, $370,000 mortgate with an annual interest rate of 9%. Compute the amount of the monthly payment on a 4 -year, $37,500 car loan with an annual interest rate of 9%. Required: a. Compute the amount of each of the monthly car payments assuming the annual interest rate is 9%, and the term of the loan is 4 years. b. Compute the amount of each of the monthly car payments assuming the annual interest rate is 9%, and the term of the loan is 5 years. c. How much total interest is paid over the life of the car loan assuming the loan term is 4 years? d. How much total interest is paid over the life of the car lffin assuming the loan term is 5 years? e. How much additional interest is paid as a result of increasing the term of the loan by one year