Variable Rate Mortgage Spreadsheet
| Product Features |
# 1 |
# 2 |
# 3 |
# 4 |
# 5 |
# 6 |
# 7 |
# 8 |
# 9 |
# 10 |
# 11 |
# 12 |
# 13 |
# 14 |
# 15 |
# 16 |
# 17 |
| What Is The Term? |
5 YR. |
3 YR. |
3 YR. |
5 YR. |
5 YR. |
5 YR. |
5 YR. |
5 YR. |
5 YR. |
5 YR. |
3 YR. |
5 YR. |
5 YR. |
6 YR. |
5 YR. |
5 YR. |
3 YR. |
| Is CASH BACK Available? |
YES |
N |
YES |
N |
N |
N |
N |
N |
N |
N |
N |
N |
N |
YES |
N |
N |
N |
| What Is The Initial "Teaser" Rate? |
PRIME
-40 +CB |
PRIME
-50 |
PRIME |
PRIME
+25 |
PRIME
-50 |
PRIME
+50 |
PRIME
-50 |
PRIME
-1.01% |
PRIME
-60 |
2.24% |
PRIME
-50 |
PRIME
-1.01% |
2.24% |
PRIME
-2.25% |
PRIME
-10 |
PRIME
-1% |
PRIME
-50 |
| How long is the Teaser rate for? |
3-MOS. |
N/A |
N/A |
N/A |
5 YRS. |
N/A |
5 YRS. |
6 MOS. |
N/A |
3 MOS. |
3 YRS. |
3 MOS. |
3 MOS. |
3 MOS. |
5 YRS. |
9 MOS. |
N/A |
| How Is The Initial Payment Calculated? |
TEASER
RATE |
3 YR
POSTED |
3 YR
POSTED |
PRIME
+ .25 |
PRIME
- .50 |
3 YR
POSTED |
PRIME
- .50 |
TEASER
RATE |
N/A |
PRIME
- .40 |
INTEREST
ONLY |
PRIME
- .50 |
TEASER
RATE |
PRIME
- .375 |
5 YR
POSTED |
3 YR
POSTED |
PRIME
- .50 |
| What Is The Ongoing Rate after the "Teaser" period is over? |
PRIME
- .60 |
PRIME
- .50 |
PRIME |
PRIME
+ .25 |
PRIME
+ .50 |
PRIME
+ .50 |
PRIME
- .50 |
PRIME
- .40 |
PRIME
- .60 |
PRIME
- .40 |
PRIME
- .50 |
PRIME
- .50 |
PRIME
- .40 |
PRIME
- .375 |
PRIME
- .10 |
PRIME
- .25 |
PRIME
- .50 |
| Is The Rate Capped? |
N |
YES- 3 YR.
POSTED |
YES- 3 YR.
POSTED |
N |
N |
N |
N |
N |
N |
N |
PRIME
+ 3% |
N |
N |
N |
5 YR.
POSTED |
N |
N |
| When Is The Rate Renewed? |
MTHLY |
MTHLY |
MTHLY |
MTHLY |
MTHLY |
WITH
PRIME |
MTHLY |
WITH
PRIME |
MTHLY |
MTHLY |
MTHLY |
MTHLY |
3
MOS. |
MTHLY |
WITH
PRIME |
WITH
PRIME |
WITH
PRIME |
| What Is The On-Going Payment Based On |
Eff.
RATE |
3 YR
POSTED |
3 YR
POSTED |
PRIME
+ .25 |
PRIME
- .50 |
3 YR
POSTED |
PRIME
- .50 |
PRIME
- .40 |
PRIME
- .60 |
PRIME
- .40 |
INTEREST
ONLY |
PRIME
- .50 |
PRIME
- .40 |
PRIME
- .375 |
5 YR
POSTED |
3 YR
POSTED |
PRIME
- .50 |
| Maximum Loan To Value |
UP TO
95% |
UP TO
95% |
UP TO
95% |
UP TO
75% |
UP TO
90% |
UP TO
75% |
UP TO
90% |
UP TO
75% |
UP TO
75% |
UP TO
75% |
UP TO
75% |
UP TO
75% |
UP TO
75% |
UP TO
90% |
UP TO
75% |
UP TO
90% |
UP TO
75% |
| Is There A High Ratio Surcharge on the insurance premium? |
N |
N |
N |
0.25% |
0.25% |
N |
N |
N |
N |
N |
N |
N |
N |
0.25% |
N |
0.25% |
N |
| How often is the rate compounded? |
SEMI
ANNUAL |
MTHLY |
MTHLY |
MTHLY |
MTHLY |
SEMI
ANNUAL |
SEMI
ANNUAL |
SEMI
ANNUAL |
SEMI
ANNUAL |
SEMI
ANNUAL |
MTHLY |
SEMI
ANNUAL |
SEMI
ANNUAL |
MTHLY |
SEMI
ANNUAL |
SEMI
ANNUAL |
MTHLY |
| Can I get into negative amortization? |
- |
- |
- |
YES |
YES |
- |
- |
- |
- |
- |
- |
- |
- |
UP TO
105% |
- |
- |
YES |
| Payment Frequency Options |
W,BW,M |
MTHLY |
MTHLY |
MTHLY |
MTHLY |
W,BW,M |
MTHLY |
W,BW,M |
MTHLY |
W,BW,M |
MTHLY |
W,BW,M |
W,BW,M |
W,BW,
SM,M |
W,BW,
SM,M |
W,BW,M |
W,BW,M |
| Early Termination Interest Penalty |
3 MOS. |
3 MOS
INT. OF
CAP RATE |
3 MOS
INT. OF
CAP RATE |
YES |
3 MOS. |
3 MOS. |
3 MOS. |
3 MOS. |
2 MOS. |
- |
OPEN |
2 MOS. |
2 MOS. |
2 MOS. |
3 MOS. |
3 MOS. |
3 MOS. |
| No Pre-payment Penalty After: |
- |
- |
- |
2 YRS. |
- |
- |
- |
- |
3 YRS. |
3 YRS. |
OPEN |
3 YRS. |
3 YRS. |
3 YRS. |
- |
- |
- |
| Convertible To A Fixed Term? |
Y |
Y |
Y |
REM OF
5 YRS. |
REM OF
5 YRS. |
REM OF
5 YRS. |
YES |
YES |
YES |
YES |
YES |
YES |
YES |
YES |
NO |
REM OF
5 YRS. |
REM OF
3 YRS. |
| Conversion Rate |
DISC. |
DISC. |
DISC. |
DISC. |
DISC. |
POSTED |
DISC. |
DISC. |
DISC. |
DISC. |
DISC. |
- .85 |
DISC. |
DISC. |
- |
DISC. |
DISC. |
| Is It Available For Rental Properties? |
- |
YES |
YES |
YES
+ .25% |
YES
+ .25% |
NO |
NO |
YES |
NO |
- |
YES |
- |
YES |
YES |
YES |
YES |
YES |
| Is It Available For Switching or Refinancing? |
YES |
YES |
YES |
YES |
YES |
NO SWITCH |
YES |
YES |
YES |
NO |
YES |
NO |
YES |
YES |
YES |
YES |
NO |
|
