Purchase Solution

Estimating An Affordable Mortgage and Monthly Payment

Not what you're looking for?

Ask Custom Question

Estimate the affordable monthly mortgage payment, the affordable mortgage amount, and the affordable home purchase price for the following situation:
Monthly gross income $2,950
Down payment to be made- 15% of purchase price
Other debt(monthly payment) $160
Monthly estimate for property taxes and insurance $210
30 year loan at 8%

Purchase this Solution

Solution Summary

Citing sources and using an Excel 97-2003 spreadsheet, this solution describes the Federal guidelines for an "affordable" mortgage and illustrates the steps to computing the amount of that mortgage and the related monthly payment amount.

Solution Preview

** Please see the attached file for the complete solution response **

Because you did not define "affordable," I used the guidelines at the American Banker's Association website (http://www.aba.com/aba/cgi-bin/howbignt.pl). The guidelines listed are:

1. House payments of principal, interest, taxes, and homeowner's insurance (PITI) should not exceed 28% of your gross monthly pay.

2. This monthly housing payment (PITI) plus your current monthly debt payments should not exceed 36% of your gross monthly pay.

Note that each guideline is restrictive; if a monthly mortgage payment ...

Purchase this Solution


Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.