Question

In: Finance

Assume that you have a balance of $3000 on your MasterCard and that you make no...

Assume that you have a balance of $3000 on your MasterCard and that you make no more charges. Assume that MasterCard charges 12% APR and that each month you make only the minimum payment of 5% of the balance.

Find how many months it will take to bring the remaining balance down to $400. (Round your answer to the nearest whole number.)

Please do NOT use Excel

Solutions

Expert Solution

ANSWER: 48 Months

Interest in each month = opening balance * (APR / 12)

We divide by 12 as we are calculating interest for 1 month

= 3000*12/100*1/12=30

Payment in each month = (opening balance + interest for the month) * 5%

closing balance of each month = opening balance + interest - payment

For 1st Month=3000*12/100*1/12=30

=3000+30-5/100

=2878.50

It goes till 48 months to reach the balance down to 400.

48th Month= 429.05*12/100*1/12

=429.05+4.29-21.67

=411.68

Months Opening Bal Interest Total Mini.Payment Closing Balance
1 3,000.00                             30.00           3,030.00                151.50                        2,878.50
2 2,878.50                             28.79           2,907.29                145.36                        2,761.92
3 2,761.92                             27.62           2,789.54                139.48                        2,650.06
4 2,650.06                             26.50           2,676.56                133.83                        2,542.74
5 2,542.74                             25.43           2,568.16                128.41                        2,439.75
6 2,439.75                             24.40           2,464.15                123.21                        2,340.94
7 2,340.94                             23.41           2,364.35                118.22                        2,246.14
8 2,246.14                             22.46           2,268.60                113.43                        2,155.17
9 2,155.17                             21.55           2,176.72                108.84                        2,067.88
10 2,067.88                             20.68           2,088.56                104.43                        1,984.13
11 1,984.13                             19.84           2,003.98                100.20                        1,903.78
12 1,903.78                             19.04           1,922.81                   96.14                        1,826.67
13 1,826.68                             18.27           1,844.94                   92.25                        1,752.70
14 1,752.70                             17.53           1,770.22                   88.51                        1,681.71
15 1,681.71                             16.82           1,698.53                   84.93                        1,613.60
16 1,613.60                             16.14           1,629.74                   81.49                        1,548.25
17 1,548.25                             15.48           1,563.73                   78.19                        1,485.55
18 1,485.55                             14.86           1,500.40                   75.02                        1,425.38
19 1,425.38                             14.25           1,439.64                   71.98                        1,367.65
20 1,367.66                             13.68           1,381.33                   69.07                        1,312.26
21 1,312.27                             13.12           1,325.39                   66.27                        1,259.12
22 1,259.12                             12.59           1,271.71                   63.59                        1,208.12
23 1,208.12                             12.08           1,220.21                   61.01                        1,159.19
24 1,159.20                             11.59           1,170.79                   58.54                        1,112.25
25 1,112.25                             11.12           1,123.37                   56.17                        1,067.20
26 1,067.20                             10.67           1,077.87                   53.89                        1,023.98
27 1,023.98                             10.24           1,034.22                   51.71                            982.51
28      982.51                                9.83               992.33                   49.62                            942.72
29      942.72                                9.43               952.14                   47.61                            904.54
30      904.54                                9.05               913.58                   45.68                            867.90
31      867.90                                8.68               876.58                   43.83                            832.75
32      832.75                                8.33               841.08                   42.05                            799.03
33      799.03                                7.99               807.02                   40.35                            766.67
34      766.67                                7.67               774.33                   38.72                            735.62
35      735.62                            

Related Solutions

Assume that you have a balance of $3200 on your MasterCard and that you make no...
Assume that you have a balance of $3200 on your MasterCard and that you make no more charges. Assume that MasterCard charges 12% APR and that each month you make only the minimum payment of 6% of the balance. What will the balance be after 24 months? (Round your answer to the nearest cent.)
Assume that you have a balance of $9000 on your MasterCard and that you make no...
Assume that you have a balance of $9000 on your MasterCard and that you make no more charges. Assume that MasterCard charges 12% APR and that each month you make only the minimum payment of 5% of the balance. Find how many months it will take to bring the remaining balance down to $400. (Round your answer to the nearest whole number.)
Assume that you have a $22,500 balance on your credit card. You plan to make monthly...
Assume that you have a $22,500 balance on your credit card. You plan to make monthly payments of $450 until the balance is paid off. The interest rate on your credit card is 17.5% p.a., compounded monthly. A letter in the mail informs you that you are approved for a new credit card and balance transfers are subject to a 9.5% p.a., compounded monthly. How many months sooner will you pay off your bill?
Assume that you have a balance of $5300 on your Discover credit card and that you...
Assume that you have a balance of $5300 on your Discover credit card and that you make no more charges. Assume that Discover charges 21% APR and that each month you make only the minimum payment of 2% of the balance. Find how many months it will take to bring the remaining balance down to $2500. (Round your answer to the nearest whole number.) Answer is NOT 301
. You have a $28,000 balance on your credit card. You plan to make monthly payments...
. You have a $28,000 balance on your credit card. You plan to make monthly payments of $550 until the balance is paid off. The interest rate on your credit card is 19.5% p.a., compounded monthly. A letter in the mail informs you that you are approved for a new credit card and balance transfers are subject to a 8.5% p.a., compounded monthly. How many months sooner will you pay off your bill?
Assume you have a saving account that pays 4% APR. If you have a beginning balance...
Assume you have a saving account that pays 4% APR. If you have a beginning balance of$6000, How much do you need to save on a monthly basis in a saving account (add to your saving account) to have a down payment of $20000 for a house in 5 years
i need someone to find the answer for this question A MasterCard statement shows a balance...
i need someone to find the answer for this question A MasterCard statement shows a balance of $510 at 13.5% compounded monthly. What monthly payment will pay off this debt in 1 year 10 months? (Round your answer to the nearest cent.)
In a certain city, 30% of the families have a MasterCard, 20% have an American Express...
In a certain city, 30% of the families have a MasterCard, 20% have an American Express card, and 25% have a Visa card. Eight percent of the families have both a MasterCard and an American Express card. Twelve percent have both a Visa card and a MasterCard. Six percent have both an American Express card and a Visa card. 31. Is possession of a Visa card independent of possession of a MasterCard? Why or why not? No, because P (M...
Make me a millionaire. Assume that you are a financial advisor. I have come to you...
Make me a millionaire. Assume that you are a financial advisor. I have come to you because I want to develop a plan for retiring early. I am currently 24 years old and I want to retire by age 55. That gives me 31 years to build wealth. I have just graduated from college and obtained my first job as an urban planner with a local city, earning $32,000 per year. People in this field usually top out at about...
You have a $2,100 balance on your 10% credit card. You have lost your job and...
You have a $2,100 balance on your 10% credit card. You have lost your job and been unemployed for 6 months. You have been unable to make any payments on your balance. However, you received a tax refund and want to pay off the credit card. a. How much will you owe on the credit card if you have not made a payment for 6 months? (Round your answers to the nearest cent.) Interest Principal 1 months 2 months 3...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT