Calculation of average daily balance
Date | Amount Due | No of Days (weight) | Weighted amount due |
June 1 | 5000 | 4 | 20000 |
June 5 | 5200 | 8 | 41600 |
June 13 | 4700 | 4 | 18800 |
June 17 | 5000 | 8 | 40000 |
June 25 | 5500 | 6 | 33000 |
Total | 30 | 153400 |
Average Daily balance = Weighted amount due / Total number of days
= 153400 / 30 = 5113.33
Calculation of Interest Payable
Interest = Principal * interest rate * time
Interest Amount = 5113.33 * 20% * 1/12 = 85.22
Calculation of money Owed and Outstanding balance
Money owed at the end of the month = 5500
Outstanding balance = Money owed + Interest payable
= 5500 + 85.22 = 5585.22
Calculation of Minimum Payment
Minimum Payment = outstanding balance * 1%
= 5585.22 * 1% = 55.85
Summary
At the end of the money owed (excluding interest) = 5500
Interest payable = 85.22
At the end of the month total outstanding amount = 5585.22
Minimum Payment = 55.85
1. Assume you owe $5,000 on a credit card on June 1st. Assume the company uses the average daily balance to compute...
use
excel
The typical American household owes approximately $15,000 in credit card debt. Assume you owe this amount today and will not to put another charge on your credit card until this debt is paid off. Your credit card has an APR of 18% and minimum payments are calculated as 2% of outstanding balance or $15, whichever is greater. Using two (2) decimal places for dollar amounts, determine: a) How many years will it take to pay the entire amount...
The credit card with the transactions described in the popup below uses the average daily balance method to calculate interest. The monthly interost rate is 1.6 % of the average daily balance. Calculate parts a d using the statement in the popup Cick the icon to view the credit card statement a. Find the average daily balance for the billing period Round to the nearest cont The average daly balance for the biling period is $ (Round to the nearest...
The credit card with the transactions described in the popup below uses the average daily balance method to calculate interest. The monthly interest rate is 1.3% of the average daily balance. Calculate parts a-d using the statement in the popup. Click the icon to view the credit card statement a. Find the average daly balance for the billing period. Round to the nearest cont. The average daily balance for the billing period is (Round to the nearest cent as needed.)...
Find the average daily balance for the credit card with the following transactions. Assume one month between billing dates using the proper number of days in the month. Then find the finance charge if interest is 1.5% per month on the average daily balance. Finally, find the new balance Previous Balance $459.21 Billing Date May 17 Date Transaction Amount May 19 Return $ 62.45 May 25 Purchase $134.76 May 28 Purchase $ 45.65 June 3 Payment $175 The average daily...
3. You have a credit card on which you currenty owe $10,000 The card has a 19 99% annual interest rate and requires a minimum monthly payment of $50 Assume that you do not incur any other purchases on the card. (12 points) a) If you only make the minimum payment, how long will it take you to pay off the card? b) If you only make the minimum payment, how much total interest will you pay? c) If you...
It
is for Mechanical engineering. Not Accounting
3. Assume that you have a credit card whose statement on April 1 showed that owe $1,890.00. You made a payment to the credit card company of $800.00 the same day using on-line payment. Throughout the month of April you cha $485.00 on this card which is posted on the May 1 statement. On May 1 you an on-line payment of $940.00 to the company. Throughout the month of M you charged $260.00...
3. Assume that you have a credit card whose statement on April 1 showed that you owe $1,890.00. You made a payment to the credit card company of $800.00 on the same day using on-line payment. Throughout the month of April you charged $485.00 on this card which is posted on the May 1 statement. On May 1 you made an on-line payment of $940.00 to the company. Throughout the month of May you charged $260.00 on this card which...
Bw . 3. Assume that you have a credit card whose statement on April 1 showed that you owe $1.890.00. You made a payment to the credit card company of $800.00 on the same day using on-line payment. Throughout the month of April you charged $485.00 on this card which is posted on the May 1 statement. On May 1 you made an on-line payment of $940.00 to the company. Throughout the month of May you charged $260.00 on this...
Assume the following: Melita carried an average daily balance of $937 on her credit card this month. Her previous balance last month was $1,717, compared to a balance of $227 this month. There are 30 days in this billing cycle and Melita always makes a payment on the fifteenth of the month. Based on this information, calculate the monthly interest charges for credit card accounts charging 14 percent, 16 percent, and 18 percent interest. Complete the following chart. Since the...
You owe $3629 on your credit card which has a 17.2% APR. (a) How much interest do you get charged this month on your balance of $3629? (b) You make a payment of $850. What is your new balance for the next month? (c) How many total months will it take you to pay off the debt if you continue to make $850 payments each month (the last month you would pay just what you owe)? (a) The interest is...