Question

Deciding to Buy. Dave and Diane Starr of New Orleans, Louisiana, both of whom are in their late 20s, currently are renting an unfurnished two-bedroom apartment for $1,200 per month, plus $230 for utilities and $34 for insurance. They have found a condominium they can buy for $170,000 with a 20 percent down payment and a 30-year, 6.5 percent mortgage. Principal and interest payments are estimated at $860 per month, with property taxes amounting to $150 per month and a homeowner’s insurance premium of $900 per year. Closing costs are estimated at $4,200. The monthly homeowners association fee is $275, and utility costs are estimated at $240 per month. The Starrs have a combined income of $90,000 per year, with take-home pay of $5,800 per month. They are in the 25 percent tax bracket, pay $225 per month on an installment loan (ten payments left), and have $39,000 in savings and investments outside of their retirement accounts.

1. Can the Starrs afford to buy the condo? Use the results from the Garman/Forgue companion website or the information to support your answer. Also, consider the effect of the purchase on their savings and monthly budget.

2. Dave and Diane think that their monthly housing costs would be lower the first year if they bought the condo. Do you agree? Support your answer. Assume that they currently have $10,000 in tax deductible expenses.

3. If they buy, how much will Dave and Diane have left in savings to pay for moving expenses?

4. Available financial information suggests that mortgage rates might increase over the next several months. If the Starrs wait until the rates increase 1/2 of 1 percent, how much more will they spend on their monthly mortgage payment? Use the information in Table 9-4 or the Garman/Forgue companion website to calculate the payment.

Answer 1

Total cost of house is $170,000

Total loan to be taken = 170,000 x (1 - 0.20) = $136,000

Current annual Interest rates = 6.5%, current monthly interest rate = 6.5% / 12= 0.5417%

number of monthly periods = 30 * 12 = 360

Monthly installment (payment) on loan = $860 (859.6)

If interest rate increases by 0.5% to 7%, Monthly interest rate = 7%/12 = 0.583%

Using excel formula,

Monthly installment for new monthly interest rate of 0.583% =PMT(0.583%,360,-136000,0)

New Monthly payment = $904.8

Increase in monthly mortgage payment = 904.8 - 859.6

Increase in monthly mortgage payment = $45.2

They will have around $45 additionally on monthly mortgage payment if interest increase by 0.5% to 7%