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 ?

How is each questions solved ? Suppose you have an outstanding balance

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!