American express card week 7

.xlsx
Owed $9,000 Interest 22% 0.018333 monthly rate Payment per month $456 (Remaining bal - payment) Months Payments Interest Balance After payment 0 1 $456 0.018333 $8,544.00 + 2 $456 #NAME? $8,253.00 + 3 $456 #NAME? #NAME? + 4 $456 #NAME? #NAME? + 5 $456 #NAME? #NAME? + 6 $456 #NAME? #NAME? + 7 $456 #NAME? #NAME? + 8 $456 #NAME? #NAME? + 9 $456 #NAME? #NAME? + 10 $456 #NAME? #NAME? + 11 $456 #NAME? #NAME? + 12 $456 #NAME? #NAME? + 13 $456 #NAME? #NAME? + 14 $456 #NAME? #NAME? + 15 $456 #NAME? #NAME? + 16 $456 #NAME? #NAME? + 17 $456 #NAME? #NAME? + 18 $456 #NAME? #NAME? + 19 $456 #NAME? #NAME? + 20 $456 #NAME? #NAME? + 21 $456 #NAME? #NAME? + 22 $456 #NAME? #NAME? + 23 $456 #NAME? #NAME? + 24 $456 #NAME? #NAME? + 25 $456 #NAME? #NAME? +
(remaining bal * interest ) Column F+G =H interest Remaining balance 9000 $165.00 = $8,709.00 #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME? #NAME? = #NAME?
First 3 months of interest $478.90 Owe after 3 payments $8,110.90 165
Uploaded by CountBisonPerson602 on coursehero.com