This is a beautiful house that is currently on sale in Alpine, New Jersey. Alpine is
a town that is 40 minutes from my hometown. As kids, we would talk about all the
houses in Alpine. The house has 7 bedrooms and 7.5 bathrooms, with a 2-acre
lot. The house is currently on sale for $15,088,000. The 20% down payment is
calculated as $3,017,600. The estimated closing cost fee of 4% is calculated as
$603,520. The total due at the close is $3,621,120. According to FRED, a 30-year
fixed rate mortgage is calculated as 7.08%.
Using 30- a year fixed loan at a 7.08% rate, the following is calculated:
Principal & Interest
$80,954
Property Tax
$3,232
Home Insurance
$3,238
MONTHLY PAYMENT
$87,424
Down payment (20%)
$3,017,600
The overall amount overpaid time of loan
$31,472,640
When multiple variables are changed (such as interest rate, time of the loan, and
down payment), there is an impact that is seen below.
If using a 30-year fixed loan at a 5.05% interest rate and the down payment stays
the same as 20%, the following is calculated: (changed interest rate variable)
Principal & Interest
$65,166
Property Tax
$3,232
Home Insurance
$2,238
MONTHLY PAYMENT
$71,636
Down payment (20%)
$3,017,600
The overall amount overpaid time of loan
$25,788,960
If the loan time is changed to a 20-year fixed loan at the FRED according to
interest rate (7.08%) and the down payment stays the same as 20%, the following
is calculated: (the loan time amount variable changed)
Principal & Interest
$94,162
Property Tax
$3,232
Home Insurance
$3,238
MONTHLY PAYMENT
$100,632
Down payment (20%)
$3,017,600
The overall amount overpaid time of loan
$24,151,680
Using the FRED accordance rate of 7.08% and 30-year fixed loan, when the
down payment is changed to 35%, the following is calculated: (down payment
variable is changed)
Principal & Interest
$65,775
Property Tax
$3,232
Home Insurance
$3,238
MONTHLY PAYMENT
$72,245
Down payment (35%)
$5,280,800
The overall amount overpaid time of loan
$26,008,200
Assuming the closing cost is 4%, the calculated amount is $603,520. Thus, the
total due at the close is $5,884,320.
Reference
12 the Esplanade, Alpine, NJ . realtor.com®. (2022). Retrieved November 17,
2022, from https://www.realtor.com/realestateandhomes-detail/12-The-
Esplanade_Alpine_NJ_07620_M54229-69246
30-year fixed rate mortgage average in the United States. FRED. (2022,
November 17). Retrieved November 17, 2022, from
https://fred.stlouisfed.org/series/MORTGAGE30US
Mortgage rates: Compare today's rates. Bankrate. (2022, November 17).
Retrieved November 17, 2022, from
https://www.bankrate.com/mortgages/mortgage-rates/
• image_7929814721668738961571.png
(2.35 MB)
