please solve without excel

2. Suppose you are in the market for a new car worth $35,000. You are offered a deal to make a 15% down payment now and to pay the balance in equal end-of-month payments over 60 months with an APR of 12%. a. What should be the required monthly payment? b. Complete the following table: End of Month Interest Payment Principle Payment Remaining Balance 31 $114 42 49