Jane has a credit card balance of $21,000. The annual interest rate is 20%. She is required to pay a minimum of 4% of the outstanding balance, but never less than $40. How many months will it take to pay off the credit card balance if she pays $25 in addition to the required minimum payments? You must show your work on an Excel spreadsheet and place in the designated dropbox. 119 163 102

Jane has a credit card balance of $21,000. The annual interest rate is 20%. She is required to pay a minimum of 4% of the outstanding balance, but never less than $40. How many months will it take to pay off the credit card balance if she pays $25 in addition to the required minimum payments? You must show your work on an Excel spreadsheet and place in the designated dropbox. 119 163 102

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 27M

See similar textbooks

Similar questions

Alice has a balance of $19.000 on her credit card. The card carries a 22.00% annual rate of interest. The bank requires a minimum payment of 4.00% of the outstanding balance, but no less than $50.00 each month. If Alice wants to pay off the balance in 9 years, how much EXTRA must she pay every month in addition to the required minimum payment? Round your answer to the NEAREST dollar. Do NOT use a dollar sign.
Brandon has reached his credit card limit of $5000.00. Using an online calculator, Brandon determined that if he pays $180.00 per month, it will take him 39 months to pay off the credit card. Which of the following represents the total interest Brandon will pay when his debt is paid off? A $1,700.40 B $2,020.00 C $1,100.00 D $858.10 Need ASAP please
Tamika Harms needs $18,000 to prepare her web-page design business for opening. Her bank will loan her the money at a banker's discount rate of 9.2% for 195 days. Find the face value of the note so that Ms. Harms will have the required $18.000. Use banker's interest of 360 days
Peyton has a Home Depot credit card. The card has a balance of $4456.39 with an APR of 28.79%. The Home Depot expects the minimum payment to be 3.8% of the balance. What is Peyton’s minimum payment? How long will it take Peyton to pay off his Home Depot credit card? How much interest will Peyton pay if he only pays the minimum payment?Minimum payment Months to payoff Interest
Lizzie Gunderson is trying to establish a credit history and applied for a Visa credit card. She paid the previous month's statement balance in full. The card carries a finance charge rate of 16%. What is the amount of finance charge if Lizzie pays off the current $168.20 monthly statement balance in full?
If you are trying to build credit by using a credit card, each time you make a purchase with the credit card, deduct that amount from your checking account. That way, when your credit card bill is due, you will have enough to pay the credit card off in full. Kathy Lehner is going to start doing this. She plans on paying her credit card bill in full this month. How much does she owe with a 9% APR and the following transactions? (Round your answer to the nearest cent.) 31-day billing cycle 10/1 Previous balance 10/3 Credit 10/12 Charge: King Soopers 10/15 Payment 10/25 Charge: Delta 10/30 Charge: Holiday Fun Amount owed $84 cr. $143 $260 cr. $316 $56 Check my $ 1,159
If you are trying to build credit by using a credit card, each time you make a purchase with the credit card, deduct that amount from your checking account. That way, when your credit card bill is due, you will have enough to pay the credit card off in full. Kathy Lehner is going to start doing this. She plans on paying her credit card bill in full this month. How much does she owe with a 9% APR and the following transactions? (Round your answer to the nearest cent.) 31-day billing cycle 10/1 Previous balance $1,156 10/3 Credit 10/12 Charge: King Soopers 10/15 Payment 10/25 Charge: Deltal 10/30 Charge: Holiday Fun $ 87 cr. 140 230 cr. 313 53 Amount owed
If you are trying to build credit by using a credit card, each time you make a purchase with the credit card, deduct that amount from your checking account. That way, when your credit card bill is due, you will have enough to pay the credit card off in full. Kathy Lehner is going to start doing this. She plans on paying her credit card bill in full this month. How much does she owe with a 9% APR and the following transactions? (Round your answer to the nearest cent.) 31 day billing cycle 10/1 Previous balance $1,169 10/3 credit 10/12 Charge: King Soopers 10/15 Payment 10/25 charge: Delta 10/30 Charge: Holiday Fun $74 cr. 153 360 cr. 326 66 Amount owed
Camila Martinez has several credit cards, on which she is carrying a total current balance of $6,500. She is considering transferring this balance to a new card issued by a local bank. The bank advertises that, for a 4 percent fee, she can transfer her balance to a card that charges a 0 percent interest rate on transferred balances for the first 6 months. Calculate the fee that Camila would pay to transfer the balance. $ Describe the benefits and drawbacks of balance transfer cards.
If you are trying to build credit by using a credit card, each time you make a purchase with the credit card, deduct that amount from your checking account. That way, when your credit card bill is due, you will have enough to pay the credit card off in full. Kathy Lehner is going to start doing this. She plans on paying her credit card bill in full this month. How much does she owe with a 12% APR and the following transactions? (Round your answer to the nearest cent.) 31-day billing cycle 10/1 Previous balance 10/3 Credit 10/12 Charge: King Soopers 10/15 Payment 10/25 Charge: Delta 10/30 Charge: Holiday Fun Amount owed $ 75 cr. $152 $350 cr. $325 $ 65 $ 1,168
If you are trying to build credit by using a credit card, each time you make a purchase with the credit card, deduct that amount from your checking account. That way, when your credit card bill is due, you will have enough to pay the credit card off in full. Kathy Lehner is going to start doing this. She plans on paying her credit card bill in full this month. How much does she owe with a 12% APR and the following transactions? (Round your answer to the nearest cent.) 31-day billing cycle 10/1 Previous balance 10/3 Credit 10/12 Charge: King Soopers 10/15 Payment 10/25 Charge: Delta 10/30 Charge: Holiday Fun $1,177 $ 66 cr. 161 440 cr. 334 74 Amount owed 1 of 15 E Next > Mc Graw Hill Prev ... DO bo 1O 244 16 17 20 14 17 F3 F2 & 23 %24 7 8. 6. 2 Y Q W K G H F N. V C comma MOSISO V S4
If you are trying to build credit by using a credit card, each time you make a purchase with the credit card, deduct that amount from your checking account. That way, when your credit card bill is due, you will have enough to pay the credit card off in full. Kathy Lehner is going to start doing this. She plans on paying her credit card bill in full this month. How much does she owe with a 12% APR and the following transactions? 28-day billing cycle 1-October Previous balance $ 1,168 3-October Credit $ 75.00 12-October Charge: King Soopers $ 152.00 15-October Payment $ 350.00 25-October Charge: Delta $ 325.00 30-October Charge: Holiday Fun $ 65.00 APR 12% Required: Using the information above, complete the following table and questions Number of days of current balance Current balance Extension 2 $ 1,168.00 9 3 10 5 2 What is the total extension amount? What is the average daily balance? What is the total number of days of…