please do on excel ( no hand written )

A man has P60,00 debt which is to be paid in equal semi-annual payments of P6,000 each at 15%, and a smaller final payment to be made six months after the last regular payment of P6,000 is made. a. How many regular payments of P6,000 are needed? b. Find the outstanding balance after the 12th payment. c. What is the smaller final payment if it is made one period after the last regular payment of P6,000