Us Bank Mortgage Rates

							 Squirrel Mortgage Rate Forecast Tool (Version 3.0)
 To get started on your mortgage call us on 0800 21 22 30 or visit www.squirrel.co.nz

This model is illustrative only. It compares the total interest cost of using a rolling 1 year fixed rate against using longer-term fixed
rates. Please consult your Mortgage Adviser for a full analysis of your situation and needs.

                                                                                              Put your mortgage balance and your
                                                                                              budgeted monthly repayments here.
 INPUTS

 1. How big is your Mortgage?                                    $300,000                  This is the long term fixed rate you want to
 2. How much can you pay per Month?                                $2,500                      compare the 1 year fixed rate with.                                   Enter the latest bank
 3. Forecast Comparison (1 Year vs ? Year)                              5                                                                                            mortgage rates here.
                                                                               1 Year         2 Year         3 Year         4 Year          5 Year
 Current Mortgage Rates (Enter them to Right)                                  5.50%          6.55%          7.40%          7.95%           8.30%


                                                                              Nov-11         Nov-12         Nov-13         Nov-14           Nov-15
 Calculated Implied Mortgage Rates                                               5.50%          7.60%          9.10%          9.60%            9.70%


                                                                                                                                                        Total Int.
 INTEREST COST - 5 Year Fixed                                                 Nov-11         Nov-12         Nov-13         Nov-14           Nov-15
                                                                                                                                                          Paid
 This is the interest cost of using a 5 Year Fixed Rate at current rates

 5 Year Fixed Mortgage Rate                                                       8.30%          8.30%           8.30%          8.30%           8.30%
 Spot Mortgage Balance                                          -$300,000     -$294,701      -$288,946       -$282,694      -$275,903       -$268,527
 Average Mortgage Balance                                                     -$297,351      -$291,824       -$285,820      -$279,299       -$272,215
 Interest you Pay                                                              -$24,680       -$24,221        -$23,723       -$23,182        -$22,594   -$118,400




                                                                                                                                                        Total Int.                     Interest Saved (versus JB
 SCENARIO 1 - JB Forecast                                                     Aug-10         Aug-11         Aug-12          Aug-13          Aug-14
                                                                                                                                                          Paid                                 Forecast)

 This is the cost of a rolling 1 Year Fixed Rate based on JB's View of Future Rates (as at 4/8/2009)                                                                                              $22,102
 Future 1 Year Rates (JB Forecast)                                                5.40%          6.00%           7.00%          7.50%           8.00%
 Spot Mortgage Balance                                          -$300,000     -$294,701      -$288,946       -$282,694      -$275,903       -$268,527
 Average Mortgage Balance                                                     -$297,351      -$291,824       -$285,820      -$279,299       -$272,215
 Interest you Pay                                                              -$16,057       -$17,509        -$20,007       -$20,947        -$21,777     -$96,298


                                                                                                                                                        Total Int.                    Interest Saved (versus your
 SCENARIO 2 - Your Forecast                                                   Nov-11         Nov-12         Nov-13         Nov-14           Nov-15
                                                                                                                                                          Paid                                  Forecast)

 This is the cost of a rolling 1 Year Fixed Rate based on your Forecast of Future Rates (as at 4/8/2009)                                                                                          $10,810
 Your Forecast of Future 1 Year Fixed Rates                                       5.40%          7.00%           8.00%          8.50%           9.00%
 Spot Mortgage Balance                                          -$300,000     -$294,701      -$288,946       -$282,694      -$275,903       -$268,527
 Average Mortgage Balance                                                     -$297,351      -$291,824       -$285,820      -$279,299       -$272,215
 Interest you Pay                                                              -$16,057       -$20,428        -$22,866       -$23,740        -$24,499   -$107,590
Changes in Version 3.0 (Launched 12/09/2009)

Tidied up usability