Question: How is each questions solved ? Suppose you have an outstanding balance in your credit card account of $588.76 at the beginning of the month.
How is each questions solved ?

Suppose you have an outstanding balance in your credit card account of $588.76 at the beginning of the month. During the month, you make the following transactions: Day Amount Type Amount Type $73.08 Purchase $32.02 Purchase $78.56 Purchase $5.14 Return $62.00 Purchase $65.97 Purchase $87.24 Purchase $51.58 Purchase $78.57 Purchase $47.47 Purchase $92.65 Purchase $85.74 Return $83.17 Purchase $67.14 Purchase $13.21 Purchase $78.05 Payment Assume the month has 30 days. Use an interest rate of 1.25% per month. Use a Microsoft Excel spreadsheet to a. find the total of your purchases on the ninth of the month. b. find the total of your purchases on the eleventh of the month. c. find the day during the month when your end-of-day balance was the least. 1. day 2. balance d. find the day during the month when your end-of-day balance was the greatest. 1. day 2. balance e. calculate the balance on your account at the end of the month before the bank adds interest. f. calculate the total dollar amount of all the purchases you placed on your account during the month g. calculate the total dollar amount of all the payments you placed on your account during the month. h. calculate the total dollar amount of all the returns you placed on your account during the month. i. calculate the total dollar amount of the thirty end-of-day balances on your account for the month. j. calculate the net change to your balance over the course of the month. k. calculate the average daily balance on your account for the month. 1. calculate the interest the bank will charge on your account for the month. m. calculate the new balance on your account at the end of the month
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
