How would I make an excel spreadsheet for this and solve the following problems?

11:114 Back Credit Card12.docx You get a new credit card and charge $300 each month to it. You only pay the minimum balance. The minimum is the greater of S30 or 1.5% of the balance. Your credit card charges 22.99% annual percentage rate (APR) interest. How much do you owe at the end of a year? Use an IF function to compare 1.5% of the balance to the minimum payment. After subtracting the minimum payment from the beginning balance, add the monthly interest to get an ending balance. The beginning balance for the next month is the ending balance from the previous month. Remember to use absolute/fixed references for any information that does not change (i.c., monthly interest, monthly credit card charges). When calculating monthly interest use the monthly interest rate (annual rate/12 months). Dashboard Calendar To Do Notifications Inbox