GETTING OUT OF DEBT - BLANK MODEL SET: THE BOOK'S OWN INPUTS

Getting_Out_of_Debt_Blank.xlsx has 34 inputs on three sheets. Type these values back in and the
book's results come back. Rates and shares are decimals: 22.9 per cent is 0.229.

   1. Your Debts!B5              Store card, balance                             680
   1. Your Debts!C5              Store card, interest rate                       0.299
   1. Your Debts!D5              Store card, minimum, share of the balance       0.025
   1. Your Debts!E5              Store card, minimum floor                       20
   1. Your Debts!F5              Store card, fixed payment                       0
   1. Your Debts!B6              Credit card A, balance                          3200
   1. Your Debts!C6              Credit card A, interest rate                    0.229
   1. Your Debts!D6              Credit card A, minimum, share of the balance    0.025
   1. Your Debts!E6              Credit card A, minimum floor                    25
   1. Your Debts!F6              Credit card A, fixed payment                    0
   1. Your Debts!B7              Credit card B, balance                          1450
   1. Your Debts!C7              Credit card B, interest rate                    0.189
   1. Your Debts!D7              Credit card B, minimum, share of the balance    0.025
   1. Your Debts!E7              Credit card B, minimum floor                    25
   1. Your Debts!F7              Credit card B, fixed payment                    0
   1. Your Debts!B8              Personal loan, balance                          2100
   1. Your Debts!C8              Personal loan, interest rate                    0.125
   1. Your Debts!D8              Personal loan, minimum, share of the balance    0
   1. Your Debts!E8              Personal loan, minimum floor                    0
   1. Your Debts!F8              Personal loan, fixed payment                    95
   1. Your Debts!B9              Car loan, balance                               6500
   1. Your Debts!C9              Car loan, interest rate                         0.079
   1. Your Debts!D9              Car loan, minimum, share of the balance         0
   1. Your Debts!E9              Car loan, minimum floor                         0
   1. Your Debts!F9              Car loan, fixed payment                         180
   1. Your Debts!B12             Extra surplus, each month                       250
   4. The Emergency Fund!B5      An emergency of this size arrives               800
   4. The Emergency Fund!B6      in this month                                   9
   4. The Emergency Fund!B7      Starter fund target                             1000
   4. The Emergency Fund!B8      Held back each month to build it                125
   5. Your Own Debt!B5           What you owe on it                              2500
   5. Your Own Debt!B6           The interest rate                               0.229
   5. Your Own Debt!B7           What you pay each month                         100
   5. Your Own Debt!B16          Add this much to the payment                    50

Results, once all 34 are in:
   Sheet 2    card A: 61.07 of interest in a minimum of 81.53; 20.46 reaches the balance
   Sheet 2    minimums only: 258 months, 10,886.32 of interest, 1.78 times what was borrowed
   Sheet 3    highest rate first: 30 months, 2,032.93; smallest first: 31 months, 2,256.81; the snowball costs 223.87
   Sheet 4    the starter fund costs 347.51 when the emergency arrives, 338.49 when it does not
   Sheet 5    34.30 months and 929.69 of interest at 100 a month; adding 50 saves 14.05 months and 392.11
   Checks     ALL OK
