Suppose you open a credit card account and charge $125 to the account on the first of each month to pay for your cable and Internet subscription. You plan to pay just the minimum payment each month for the first 6 months (until your summer job starts). The APR is 21.99% and the minimum payment is 6.5% of the balance. Use Excel to fill in the values in the table below and answer the questions that follow. Month Starting Balance New Purchases Balance + Purchases Finance Charge New Balance Minimum Payment $0 $125 $125 $125 3. $125 4. $125 $125 $125 XXX XXX XXX XXX XXX

Suppose you open a credit card account and charge $125 to the account on the first of each month to pay for your cable and Internet subscription. You plan to pay just the minimum payment each month for the first 6 months (until your summer job starts). The APR is 21.99% and the minimum payment is 6.5% of the balance. Use Excel to fill in the values in the table below and answer the questions that follow. Month Starting Balance New Purchases Balance + Purchases Finance Charge New Balance Minimum Payment $0 $125 $125 $125 3. $125 4. $125 $125 $125 XXX XXX XXX XXX XXX

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Assume you have a balance of $1000 on a credit card with an APR of 24%, or 2% per month. You start making monthly payments of $200, but at the same time you charge an addicional $90 per month to the credit card. Assume that interest for a given month is based on the balance for the previous month. The following table shows how you can calculate your monthly balance. Complete and extend the table to show the balance at the end of each month until the debt is paid off. How long does it take to pay off the credit card debt? Fill out the table row by row, and continue until the last full payment (Round to the nearest cent as needed) Month Payment 0 1 $2 $200 $200 $200 $200 Continue until the last full payment 3 4 $200 Expenses $90 $90 $90 590 Interest 0.02 $1000-$20.00 $90 Therefore, ain)th partial payment will pay off the loan, which means the loan will paid off in months New Balance $1000 $1000-$200-500-$20.00-$910.00
Suppose you open a credit card account and charge $150 to the account on the first of each month to pay for your cable and Internet subscription. You plan to pay just the minimum payment each month for the first 6 months (until your summer job starts). The APR is 18.99% and the minimum payment is 6.5% of the balance. Use Excel to fill in the values in the table below and answer the questions that follow. Month — 23 5 6 1 4 7 Starting Balance $0 New Purchases $150 $150 $150 $150 $150 $150 XXX Balance + Purchases $150 XXX Finance New Charge Balance XXX Express your answers rounded to the nearest cent. (a) What is the starting balance at the beginning of the 7th month? $ (b) What is the starting balance at the beginning of the 4th month? $ (c) Your total finance charge is what percent of your total payments? XXX Minimum Payment XXX
How much would you need to deposit in an account each month in order to have $20,000 in the account in 9 years? Assume the account earns 6% interest. Submit Question .com/course/showcalendar.php?cid=179278 Q Search
Give typing answer with explanation and conclusion You have a balance of $9700 for your tuition on your American Express credit card. Assume that you take no more charges on the card. Also assume that American Express charges 13% APR and that each month you make only the minimum payment of 4% of the balance. What will the balance be after 32 months? At what balance do you begin making payments of $60.00 or less? How long will it take to get the balance below $50?
The balance (debt) on your credit card is $4000. Your credit card APR is 18%. You are spending $150 each month. You are paying $450 to your credit card each month. How many months it takes to pay off all your debt (balance)? NOTE: you need to use Excel to find the answer to this problem please share as a pdf
Assume that you start with a balance of $3900 on your credit card.During the first month you charge $400. During the second month you charge $650 and make a payment of $280. Assume that your credit card charges a 29% APR and each month you make the minimum payment of 2.5% of the balance. Complete the following table. Round your answer to the nearest cent. Month 1 Previous balance- $3900 Finance charge- $94.25 Purchase- 400 Payment ?97.50 New balance? Month 2 Previous balance- finance charge- purchase- payments- New balance
Problem #1. You have a Visa credit card account with a 22.75% annual percentage rate calculated on the average daily balance. The billing date is the first day of each month, and the billing cycle is the number of days in that month. Your credit card balance on June 1 was $307. On June 9th you made a $139 purchase. You made another purchase, a $150 gift card, on June 25th. You made a $250 payment on July 27th. Show your work for all parts of the problem. (a) What is the average daily balance for June? (b) What is your finance charge on the account as of July 1st? (c) What is your new credit card balance?
Suppose you have a credit card with a balance of $3295.89 that charges 19.85% APR on unpaid balances. The minimum payment each month is $35. If you make just the minimum payment, how much interest will be added to your account balance?
You have $3,500 on a credit card that charges a 21% interest rate. If you want to pay off the credit card in 3 years, how much will you need to pay each month (assuming you don't charge anything new to the card)? $ MyOpenMath Question Help: Video Submit Question each month Search hp
Suppose you want to have $300,000 for retirement in 20 years. Your account earns 10% interest. How much would you need to deposit in the account each month? Submit Question ath.com/course/showcalendar.php?cid=179278 Q Search
Suppose you want to have $600,000 for retirement in 25 years. Your account earns 4% interest. How muc would you need to deposit in the account each month? Submit Question /course/showcalendar.php?cid=179278 Search
Create an amortization table for a $60,000 loan. We will assume payments are made monthly over 6 years at an interest rate of 4%. a.) First use a formula cell in your spreadsheet to calculate the monthly payment amount. b.) Create an amortization table for the 72 months. Your columns of your amortization table should include payment number, payment amount, interest paid each month, principle paid that month, amount paid on principal total, and the amount of principal remaining.