Example: Comparing Mortgage Options for Savings

Green boxes are figures you must enter. Blue boxes remain empty. Formulas are in parenthesis.

   

First Mortgage Loan

First & Second Mortgage During Access Period
(interest only)

First & Second Mortgage During Repayment Period
(principle+interest)

1

Enter Purchase Price

$200,000

 $200,000
(1A)

$200,000
(1A)

2

Enter Down Payment

$20,000

 $20,000
(2A)

 $20,000
(2A)

3

Enter Second Mortgage Amount

 

$20,000

$20,000
(3B)

4

Principle Loan Amount

 $180,000
(1A-2A)

 $160,000
(1B-2B-3B)

 $160,000
(1C-2C-3C)

5

LTV

 90%
(4A/1A)

   

6

CLTV

 

 90%
(4A/1A)

 90%
(4A/1A)

7

Enter First Mortgage Term (in months)

360 months

360 months
(7A)

360 months
(7A)

8

Second Mortgage Term (in months)

 

120 months

240 months

9

Enter First Mortgage Interest Rate (as a decimal)

8%

 8%
(9A)

 8%
(9A)

10

Enter Second Mortgage Interest Rate (as a decimal)

 

4%

6%

11

Enter First Mortgage Payment (use financial calculator)

$1320.78

$1174.03

$1174.03
(11C)

12

Enter PMI (use financial calculator)

$120.00

   

13

Enter Second Mortgage Payment (use financial calculator)

 

$65.75
((3Bx10B)/365)x30
(interest only)

$143.92

(principle and interest)

14

TOTAL

$1440.78
(11A+12A)

$1239.78
(11C + 13B)

$1317.32
(11C + 13C)

15

Monthly Savings

 

$201.00
(14A-14B)

 $123.46
(14A - 14C)

16

Yearly Savings

 

$2412.00
(15B x 12)

 $1481.52
(15C x 12)

Note: Access period for Connecticut is 9 years and 10 months. Tennessee has a 10-year repayment period.