3:36 MM A method for calculating the interest owed on a credit card is the daily balance method. The daily balance is calculated at the end of each day. To get a daily balance, we take the balance at the end of the previous day and add the interest on the previous day's balance (the interest is compounded daily). We then add or subtract any purchases, credits, or payments that were made that day. The balance subject to interest Rate at the end of the billing cycle is the average of the daily balances. Use 365 days to represent a year. Use the daily balance method to answer the following questions: A credit card has an annual interest rate of 16.99%. In a 30-day billing cycle, purchases of $345.86 and $246.71 were made on days 9 and 16 respectively, and a payment of $500.00 was credited to the account on day 15. If the unpaid balance at the start of the billing cycle was $1,792.19, how much interest will be charged at the end of the billing cycle? What will the unpaid balance be at the start of the next billing cycle? Use excel to answer the questions above. Your excel sheet should show the balance for each day in the billing cycle. It should also contain a cell showing the formula used to calculate the interest charged at the end of the billing cycle. Hint: The interest at the end of the month should equal $26.76 after you round to the nearest cent