SlideServe
Menu
Préférences
© SlideServe · v2026

Credit Cards

chakra avatar
12 diapositives · 377 Views · Aug 10, 2014

Credit Cards. Amortization Tables. Fill-in headings across in the first row. (Type "Month in cell A1, Beginning Balance in cell B1, etc…). Month. Fill-in the number of months going down ( type in 0 in A2 and 1 in A3 then select both numbers and fill down)

Credit Cards - slide 1
01 / 12Credit Cards
1 / 17

Télécharger la présentation

Credit Cards
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation
  1. Credit Cards

  2. Amortization Tables Fill-in headings across in the first row. (Type "Month in cell A1, Beginning Balance in cell B1, etc…)

  3. Month Fill-in the number of months going down (type in 0 in A2 and 1 in A3 then select both numbers and fill down) We can now see how many months it will take us to pay off the loan

  4. Loan Amount Type in loan amount ($2,500.00) in cell F2 under the heading Ending Balance.  This means that the ending balance in month 0 before making any payments is the amount you paid on the bull statue. This is the only cell (besides the headings and the months) that doesn't have a formula.

  5. Beginning Balance Each month you will pay off a bit of your balance. The beginning balance each month is your balance that month before you make your payment. It is also equivalent to the previous month’s ending balance so… In cell B3 type "= F2“

  6. Payment How much you pay each month

  7. Payment option 1 You have to decide Type in a number for payment P & I

  8. Monthly interest • Money that the bank makes • The Annual Percentage Rate divided by 12 times the Beginning Balance • We’ll say for this credit card … 15% APR • Interest =(.15/12)*B3

  9. Principal Amount that goes toward paying off your balance!! • Principal = Payment – interest amount • Principal = C3 – D3

  10. Ending Balance • Ending Balance = Beginning balance minus the principal you paid • Ending balance = B3-E3

  11. Payment option 2 Minimum payment(set by bank): • Percent of Balance OR • Some minimum dollar amount Payment = MAX(Balance*some percent, 25) Payment = MAX(B3*.02, 25)

  12. Payment option 3 Payment option 3 Whatever it takes to pay it off in a certain time • =PMT(interest/12, # of payments, - Beginning balance) • So if you bought the bull statue for $2500, wanted to pay it off in 5 years of making monthly payments and your credit card’s annual percentage rate is 15%.... • =PMT(.15/12, 60, -2500)