Credit Card Finance Charges and Payments

The video tutorial demonstrates how to use Excel to model credit card payments and balances. It covers calculating new balances, minimum payments, and finance charges using formulas and autofill. The tutorial also explores the impact of different payment percentages on the overall balance, illustrating how increased payments can reduce finance charges and overall debt. The use of Excel functions like autosum is highlighted to sum up payments and charges, providing a comprehensive view of financial management using spreadsheets.

What is the initial APR set in the credit card example?

• 22.99%

• 25.99%

• 19.99%

• 20.99%

What is the monthly purchase amount in the example?

• $25

• $20

• $15

• $10

What is the initial starting balance in the credit card example?

• $20

• $0

• $30

• $10

How is the new balance calculated in Excel?

• Starting balance minus finance charge

• Starting balance plus finance charge plus new purchases

• Finance charge plus new purchases

• Starting balance plus new purchases

What percentage of the new balance is used to calculate the minimum payment?

• 8%

• 5%

• 6%

• 7%

How is the carryover balance for the next month determined?

• New balance plus minimum payment

• New balance minus minimum payment

• Starting balance minus finance charge

• Finance charge minus new purchases

How is the finance charge calculated?

• APR multiplied by new purchases

• Finance charge divided by 12

• New balance multiplied by APR

• Starting balance multiplied by APR divided by 12

What is the purpose of converting the APR to a monthly rate?

• To calculate annual finance charges

• To calculate weekly interest

• To calculate daily interest

• To calculate monthly finance charges

What feature in Excel allows you to apply formulas across multiple cells?

• Formula Wizard

• Drag-Drop

• Copy-Paste

• Autofill

What is the effect of using Excel's autofill feature?

• It formats cells

• It deletes data

• It copies data

• It applies formulas across cells