Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Math 123 Quantitative Reasoning Section 10 Excel Credit Cards Assignment 1. Create an Excel spreadsheet that can do the calculations for the credit card below.

image text in transcribed

Math 123 Quantitative Reasoning Section 10 Excel Credit Cards Assignment 1. Create an Excel spreadsheet that can do the calculations for the credit card below. Using formulas and the drag function of Excel (see the notes), find the values for 1 year of charges. With a beginning balance of $2500 and no additional charges, there is no grace-period, you will just pay the minimum payment each month for the next year. The APR is 24.99% and the minimum payment each month is 8% of the balance. Determine the finance charge, new balance, and minimum payment required for each of the next year, and the starting balance for month 13: a. What is the total of the minimum payments? b. What is the total of the finance charges? C. How much does the starting balance decrease after one year of payments? d. The total of your finance charges is what percent of your total payments? e. Explain why making the minimum payment all the time is great for the credit card company, but not so great for the user. Math 123 Quantitative Reasoning Section 10 Excel Credit Cards Assignment 1. Create an Excel spreadsheet that can do the calculations for the credit card below. Using formulas and the drag function of Excel (see the notes), find the values for 1 year of charges. With a beginning balance of $2500 and no additional charges, there is no grace-period, you will just pay the minimum payment each month for the next year. The APR is 24.99% and the minimum payment each month is 8% of the balance. Determine the finance charge, new balance, and minimum payment required for each of the next year, and the starting balance for month 13: a. What is the total of the minimum payments? b. What is the total of the finance charges? C. How much does the starting balance decrease after one year of payments? d. The total of your finance charges is what percent of your total payments? e. Explain why making the minimum payment all the time is great for the credit card company, but not so great for the user

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

Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert J. Hughes, Arshad Ahmad, Jordan Fortino

7th Canadian Edition

1259650650, 978-1259650659

More Books

Students also viewed these Finance questions