1 / 12

Credit Cards

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)

chakra
Télécharger la présentation

Credit Cards

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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)

More Related