January 4, 1999, Revised August 1, 2007
"My financial planner said I could afford to spend $250,000 for a house,
my real estate broker said $280,000 and a calculator I found on the
internet said $295,000. How come these large differences?"
The affordability calculation is fairly complex when done correctly, and
some approaches oversimplify it. The calculation also involves a number
of assumptions that affect the answer.
The Three Affordability Rules
To do it properly, affordability must be calculated three times using
three different rules. I call these the "income rule", the "debt rule",
and the "cash rule." The final figure is the lowest of the three. When
affordability is measured on the back of an envelope, which real estate
brokers often do, usually it is based on the income rule alone, ignoring
the other two. This can result in error.
The income rule says that the borrower's monthly housing expense (MHE),
which is the sum of the mortgage payment, property taxes and home-owner
insurance premium, cannot exceed a percentage of the borrower's income
specified by the lender. If this maximum is 28%, for example, and John
Smith's income is $4000, MHE cannot exceed $1120. If taxes and insurance
are $200, the maximum mortgage payment is $920. At 7% and 30 years, this
payment will support a loan of $138,282. Assuming a 5% down payment,
this implies a sale price of $145,561. This is the maximum sale price
for Smith using the income rule.
The debt rule says that the borrower's total housing expense (THE),
which is the sum of the MHE plus monthly payments on existing debt,
cannot exceed a percentage of the borrower's income specified by the
lender. If this maximum is 36%, for example, the THE for Smith cannot
exceed $1440. If taxes and insurance are $200 while existing debt
service is $240, the maximum mortgage payment is $1000. At 7% and 30
years, this payment will support a loan of $150,308. Assuming a 5% down
payment, this implies a sale price of $158,218. This is the maximum sale
price for Smith using the debt rule.
The required cash rule says that the borrower must have cash sufficient
to meet the down payment requirement plus other settlement costs. If
Smith has $12,000 and the sum of the down payment requirement and other
settlement costs are 10% of sale price, then the maximum sale price
using the cash rule is $120,000. Since this is the lowest of the three
maximums, it is the affordability estimate for Smith.
Removing Constraints on Affordability
When the cash rule sets the limit on the maximum sale price, as in the
case above, the borrower is said to be cash constrained. Affordability
of a cash constrained borrower can be raised by a reduction in the down
payment requirement, a reduction in settlement costs, or access to an
additional source of down payment -- a parent, for example.
When the income rule sets the limit on the maximum sale price, the
borrower is said to be income constrained. Affordability of an income
constrained borrower can be raised by a reduction in the maximum MHE
ratio, or access to additional income -- sending a spouse out to work,
for example.
When the debt rule sets the limit on the maximum sale price, the
borrower is said to be debt constrained. The affordability of a debt
constrained borrower (but not that of a cash constrained or income
constrained borrower) can be increased by repaying debt.
Differences in Affordability Estimates
Affordability can be overestimated if one of the three rules is ignored
and it turns out to be the one generating the lowest maximum price. The
affordability estimate will also be affected by changes in the assumed
maximum MHE and THE ratios, which vary from loan program to program and
can also vary with other characteristics of the loan such as the down
payment. Affordability may also be affected by changes in the
assumptions made regarding settlement costs, taxes and insurance,
interest rate and term. In addition, affordability calculators have
idiosyncrasies that can affect results.
Using Affordability Calculators
It turns out that programming a calculator to find the lowest of the
affordability amounts under the income, debt and required cash rules is
difficult because of the relationships between them. In programming our
Housing Affordability Calculator 5a, Chuck Freedenberg and I took
the easy way and required the user to input a sale price. The calculator
then shows the income required, the maximum debt permitted, and the cash
required. An illustration is provided in
How Much House Can You
Afford.
More recently, Freedenberg on his own programmed an affordability
calculator for MSN that successfully derives a maximum price when the
user inputs income, debt and available cash. One of its features, about
which I have mixed feelings, is that it raises the maximum allowable
expense ratios for borrowers with better credit. In a rough way, this
mirrors what lenders do, but not necessarily what any particular
borrower would want to do. The user who understands this, however, can
raise or lower the allowable ratios by inputting better or worse credit.
The user who understands this has a powerful tool at his disposal. See
Freedenberg/MSN Affordability Calculator.