What is the total of the finance charges

Assignment Help Other Subject

Reference no: EM132339938

Question :

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.

Reference no: EM132339938

Questions Cloud

Explain how HR activities impact organizations financially : HR company performance - Do HR activities positively impact organizations financially: explain how HR activities can impact organizations financially

Do ethics influence employee attitude and morale : Discussion - Ethics and Employee Attitude - How does the ethical code of conduct and behavior influence employee morale and business performance

Conduct an Investigative Interview with an employee : Future Work Skills Assignment - Labor Market. Conduct an Investigative Interview with an employee or manager working in a company or organisation

Explain the facts or statistics that you think would make : Explain the facts or statistics that you think would make this country a good place to build and staff your factory. Your company wants to put a ball-bearing.

What is the total of the finance 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.

Evaluate and design realistic computer network solutions : DN304 Capstone Project Assignment, Abacus Institute Of Studies, New Zealand. Evaluate and design realistic computer network solutions

Find the total interest paid by the end of the mortgage : How much will be owed on the mortgage after making payments for 10 years? Find the total interest paid by the end of the mortgage.

Discuss the implementation challenges you faced : SEN 2120-SOFTWARE ENGINEERING APPROACH TO HUMAN-COMPUTER INTERACTION-Emirates Aviation University-Dubai - United Arab Emirates.

Research different methods of selecting projects : PROJ6000 Principles of Project Management Assignment - Project Selection Methods and Initial Documents, Laureate International Universities, Australia

User Account

All Pages