# Us Bank Mortgage Rates

Document Sample

```					 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

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

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 597 posted: 11/23/2010 language: English pages: 2
Description: Us Bank Mortgage Rates document sample