Question

1) Your credit card has a current balance of $4,965.20. This balance is accruing interest at a nominal rate of 24.0% compounded monthly. A) Assuming you didnt spend any more on this card, what uniform end-of-month payments over the next 36 months would be required to reduce the loan balance to zero at the end of three years from today? B) Suppose you plan on spending an additional $1,000 at the end of next year (end of month 12) and S1,000 at the end of the following year (end of month 24) on this same card. What uniform end-of month payments over the next 36 months would be required to pay off the existing debt along with the additional new purchases? Hint: I am looking for one A value in months 1-36
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum 11.A. A.--- 9- ー E ゴText ずWrap Text General Fill Formatz すFormat Painter B l U. ーータ.Δ. -=- 還便困Merge & Center. $,%,,Ma conditional Format Cell Insert Delete Format Clipboard 88Conditional Formattng as Table styies 2 ClearFe Select Editing Alignment Number Cells AB FORMULA CALCULATION OF A PMT BALANCE RATE MONTHS PMT PVAA//m) (1-1/(1+r/m)Anm) 4965.2- A/(0.24/12) (1-1/1+(0.24/12)A3*12)) 4965.2-A/0.02*(1-1/(1.02436)) 4965.2 A/0.02*(1 -1/2.03989) 4965.2A/0.02*0.50978 A4965.2 0.02/0.50978 4965.2 24% COMPOUNDED MONTHLY 4 36 $194.80 EXCEL PMT(R3/12,R4,-R2) 6 194.80 9 PV-FV/(1+/m)nm CURRENT BALANCE $ 4,965.20 PV OF 1000 PV OF 1000 PRESENT VALUE 6,375.41 10 $788.49 EXCEL PV(R3/12,12,,-1000) END OF 12 MONTHS PV OF 1000 1000/(1+0.24/12)41*12 S621.72 EXCEL PV(R3/12,24,,-1000) END OF 24 MONTHS PV OF 1000 1000/(1+0.24/12)A2*12 1.2 133 14 15 16 17 18 19 PVA-A/(r/m)*(1-1/((1+r/m)nm) 6375.41 A/0.02*0.50978 A-6375.41 0.02/0.50978 $250.13 EXCEL PMT(R3/12,36,-R10) 250.12 Sheet2 Z scORE nsu pv fv cash opti LINE OF CREDIT eog miler CARD BANKER ACCEPTANC FACTOR SI DISC FOCAL 80 ае 08:56 15-01-2019

Add a comment
Know the answer?
Add Answer to:
1) Your credit card has a current balance of $4,965.20. This balance is accruing interest at...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Your credit card has a current balance of $4,965.20. This balance is accruing interest at a...

    Your credit card has a current balance of $4,965.20. This balance is accruing interest at a nominal rate of 24.0% compounded monthly. A) Assuming you didn’t spend any more on this card, what uniform end-of-month payments over the next 36 months would be required to reduce the loan balance to zero at the end of three years from today? B) Suppose you plan on spending an additional $1,000 at the end of next year (end of month 12) and $1,000...

  • Your credit card has a current balance of $4,965.20. This balance is accruing interest at a...

    Your credit card has a current balance of $4,965.20. This balance is accruing interest at a nominal rate of 24.0% compounded monthly. Suppose you plan on spending an additional $1,000 at the end of next year (end of month 12) and $1,000 at the end of the following year (end of month 24) on this same card. What uniform end-of-month payments over the next 36 months would be required to pay off the existing debt along with the additional new...

  • 31. Calculating Interest Expense You receive a credit card application from Shady Banks Savings and Loan...

    31. Calculating Interest Expense You receive a credit card application from Shady Banks Savings and Loan offering an introductory rate of .9 percent per year, compounded monthly for the first six months, increasing thereafter to 18.5 percent compounded monthly. Assuming you transfer the $10,000 balance from your existing credit card and make no subsequent payments, how much interest will you owe at the end of the first year?

  • 1. Simon recently received a credit card with an 17% nominal interest rate. With the card,...

    1. Simon recently received a credit card with an 17% nominal interest rate. With the card, he purchased an Apple iPhone 5 for $440. The minimum payment on the card is only $20 per month. If Simon makes the minimum monthly payment and makes no other charges, how many months will it be before he pays off the card? Do not round intermediate calculations. Round your answer to the nearest month. ____ month(s) If Simon makes monthly payments of $60,...

  • You owe ​$3629 on your credit card which has a 17.2​% APR. ​(a) How much interest...

    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...

  • You receive a credit card application from Shady Banks Savings and Loan offering an introductory rate...

    You receive a credit card application from Shady Banks Savings and Loan offering an introductory rate of 3.7 percent per year, compounded monthly for the first six months, increasing thereafter to 18.6 percent compounded monthly. Assuming you transfer the $18,000 balance from your existing credit card and make no subsequent payments, how much interest will you owe at the end of the first year?

  • 3.2 If your credit card calculates interest based on 19.25% APR, compounded monthly: (a) What are...

    3.2 If your credit card calculates interest based on 19.25% APR, compounded monthly: (a) What are your monthly interest rate and annual effective interest rate? (b) If your current outstanding balance is $3,400 and you skip payments for four months, what would be the total balance four months from now?

  • You receive a credit card application from Shady Banks Savings and Loan offering an introductory rate...

    You receive a credit card application from Shady Banks Savings and Loan offering an introductory rate of 2.2 percent per year, compounded monthly for the first six months, increasing thereafter to 17.1 percent compounded monthly. Assuming you transfer the $10,500 balance from your existing credit card and make no subsequent payments, how much interest will you owe at the end of the first year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Interest...

  • You receive a credit card application from Shady Banks Savings and Loan offering an introductory rate...

    You receive a credit card application from Shady Banks Savings and Loan offering an introductory rate of 1.4 percent per year, compounded monthly for the first six months, increasing thereafter to 16 percent compounded monthly.    Assuming you transfer the $6,500 balance from your existing credit card and make no subsequent payments, how much interest will you owe at the end of the first year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)...

  • 21. Stacey has a $8,000 balance on her credit card that has an interest rate of...

    21. Stacey has a $8,000 balance on her credit card that has an interest rate of 21%, compounded monthly. (a) If she decides to pay it off over 5 years with equal monthly payments, how much should each payment be? (b) How much interest will Stacey pay to the credit card company? (c) If instead she wants to completely pay off her debt after 3 years (1.6. 2 years early), what lump sum payment must she make?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT