Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A credit card holder has 58,000 on a credit card that charges nominal rate of interest [compounded 12 times a year. If the card holder

image text in transcribedimage text in transcribed
image text in transcribedimage text in transcribed
A credit card holder has 58,000 on a credit card that charges nominal rate of interest [compounded 12 times a year. If the card holder wants to pay off the credit card in 5 years, how much will the card holder need to pay {assumingthat the card holder does not charge anything new to the card}? a] If the card holder is a lowrisk customer, and the credit card company will charge 14% annual rate of interest (compounded 12 times a year). Compute: i. Monthly payment: ii. Total amount of money the card holder will pay: iii. Total interest amount the credit card company will earn bl If the card holder is a higherrisk customer, and the credit card company will charge 24.5% annual nominal rate of interest (compounded 12 times a year}. Compute: i. Monthly payment ii. Total amount of money the card holder will pay: iii. Total interest amount the credit card company will earn: c) Use Microsoft Excel to display graphs and table of interest amount paid yearly for both cases. i. Display graphs and table here {Bellow you can see the Microsoft Excel graphs' example for case: loan amount is $10,000, lowrisk interest rate r = 13% and higher risk interest rate is r = 22.4%, time to payout loan is 6 years}. Example: Interest Amount Paid for $10, 000 Loan in 0 Years (r=13% versus r=22.4%) 8000.00 2000.00 6000.00 4000.00 fatal-eat Amum Plld, S '3 mm am am T 2 3 4 5 +r=13o 161.39 595 40 1255.915 2153.01 3222 02 +r=22 4% 339 2? 1215 32 2525.53 4119.58 6110 20 \"ms. Yum ii. Using graphs calculate the difference in the interest amount of money earned in 6 years by credit company charging 24.5 % yersus 14% interest rate. 2. Conclusion [45 sentences}: 6 1453.55 8252.45 me)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Algebra (Subscription)

Authors: Elayn Martin Gay

7th Edition

0134305116, 9780134305110

More Books

Students also viewed these Mathematics questions