I'm struggling with this can someone help me with the excel formulas? It's not the math I need to figure out It's how to plug that into excel. Thank you

If you are trying to build credit by using a credit card, each time you make a purchase with the credit card, deduct that amount from your checking account. That way, when your credit card bill is due, you will have enough to pay the credit card off in full. Kathy Lehner is going to start doing this. She plans on paying her credit card bill in full this month. How much does she owe with a 12% APR and the following transactions? \begin{tabular}{|c|c|r|} \hline \multicolumn{3}{|c|}{ 31-day billing cycle } \\ \hline 10/1/2023 & Previous balance & $1,168.00 \\ \hline 10/3/2023 & Credit & $75.00 \\ \hline 10/12/2023 & Charge: King Soopers & $152.00 \\ \hline 10/15/2023 & Payment & $350.00 \\ \hline 10/25/2023 & Charge: Delta & $325.00 \\ \hline 10/30/2023 & Charge: Holiday Fun & $65.00 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline APR (Annual percentage rate) & 12% \\ \hline Months per year & 12 \\ \hline Days in billing cycle: & 31 \\ \hline \end{tabular} Required: Using the information above, complete the following table and questions Note: Use cells A4 to C14 and A21 to B21 from the given information to complete this question. \begin{tabular}{|l|l|l|l|} \hline \multicolumn{1}{|c|}{ No. of days of current balance } & Current balance \\ \hline \end{tabular}