Financial Calculators: Deferred Mortgages: Solving for Payment and Price
Finance Now, Pay Later!
When a customer financing a loan or mortgage, and the customer can enjoy the benefits for a period of months prior to being required to make the first payment, we are dealing with a deferred mortgage. Interest is accrued from the beginning of the mortgage.
The procedures outlined on this blog entry can be applied to any financial calculator* with time value of money keys, such as the HP 12C and the HP 10bII+ (see source below).
* The procedure should be fine for most financial calculators. Check your manual for details.
Deferred Mortgage: Finding The Monthly Payment
Part 1:
Set the calculator to END mode.
N: Enter the number of deferred payments minus 1
I: Enter the interest rate of the loan
PV: Enter the borrowed amount as a negative number
PMT: Set to 0
Solve for FV
Part 2:
PV = FV from part 1 ( RCL FV, STO PV )
N: Enter the number of payments of the term
I = interest rate of the loan
FV: Enter the balloon payment as a negative number. If there is no balloon payment, enter 0.
Solve for PMT, this is your payment of the deferred mortgage.
Example 1:
A homeowner finances a house for $455,000.00. The mortgage lasts for 30 years at 2.86%. No payment is due for the first six months of the mortgage.
Part 1:
N: 6 -1 = 5
I: 2.86% annual rate, about 0.24% per month
PV: -455000.00
PMT: 0.00
FV = 460447.99
Part 2:
PV: 460447.99
N: 30* 12 = 360
I: 2.86% annual rate, about 0.24% per month
FV: 0.00
PMT = -1906.67
The monthly payment is $1,906.67.
Example 2:
A homeowner purchases a fixer-up property for $149,000.00. The buyer secures a 15-year mortgage at 4%. The end of the loan requires a $1,000.00 balloon payment but allows the buyer to defer the first payment for five months.
Part 1:
N: 5 - 1 = 4
I: 4% annual rate, about 0.33% per month
PV: -149000.00
PMT: 0.00
FV = 150996.62
Part 2:
PV: 150996.62
N: 15 * 12 = 180
I: 4% annual rate, about 0.33% per month
FV: -1000.00
PMT = -1112.84
Deferred Payment: Calculating the Price of the Mortgage
Part 1:
Set the calculator to END mode.
N: Enter the number of payments of the term
I: Enter the interest rate of the loan
PMT: Enter the payment as a positive number
FV: Enter the balloon payment as a positive number. If there is no balloon payment, enter 0.
Solve for FV
Part 2:
FV = PV from part 1 ( RCL PV, STO FV )
N: Enter the number of deferred payments minus 1
I = interest rate of the loan
Set PMT to 0
Solve for PV, this is your price of the deferred mortgage.
Example 3:
An owner enters a lease which requires at monthly payment of $495.00. The lease lasts for 8 years at 6.69%. There is no balloon payment at the end of the lease. The lease allowed the owner to defer the first required payments for three months. What is the value of the lease?
Part 1:
N: 8 * 12 = 96
I: 6.69% annual rate, about 0.56% per month
PMT: 495.00
FV: 0.00
PV = -36721.17
Part 2:
FV: -36721.17
N: 3 - 1 = 2
I: 6.69% annual rate, about 0.56% per month
Set PMT to 0
PV = 36315.13
The value of the lease is $36,315.13.
Example 4:
An owner executes a 30-year, 3% mortgage with the required payment of $1,005.85. The mortgage allows for the first payment to be deferred for six months. A $1,000.00 balloon payment is required. What is the price of the mortgage?
Part 1:
N: 30 * 12 = 360
I: 3% annual rate, 0.25% per month
PMT: 1005.85
FV: 1000.00
PV = -238983.97
Part 2:
FV: -238983.97
N: 6 - 1 = 5
I: 3% annual rate, 0.25% per month
Set PMT to 0
PV = 236018.94
The value of the lease is $236,018.94.
And that is how we work with deferred mortgages.
Source:
Greynolds Jr., Elbert B. and Aronofsky, Julius S. Practical Real Estate Financial Analysis: Using The HP 12C Calculator: A Step-by-Step Approach Real Estate Education Company: Dearborn Financial Publishing, Inc. 1983. ISBN 0-88462-378-5
Eddie
All original content copyright, © 2011-2020. Edward Shore. Unauthorized use and/or unauthorized distribution for commercial purposes without express and written permission from the author is strictly prohibited. This blog entry may be distributed for noncommercial purposes, provided that full credit is given to the author.