Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house. Lender guidelines suggest that the

image text in transcribed

Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house. Lender guidelines suggest that the allowable monthly housing expenditure should be no more than 28% of monthly gross income. From this, you must subtract total nonmortgage housing expenses, which would include insurance and property taxes and any other additional expenses. This defines the affordable monthly mortgage payment. In addition, guidelines also suggest that total affordable monthly debt payments, including housing expenses, should not exceed 36% of gross monthly income. This is calculated by subtracting total nonmortgage housing expenses and any other installment debt, such as car loans, student loans, credit card debt, and so on, from 36% of total monthly gross income. The smaller of the affordable monthly mortgage payment and the total affordable monthly debt payments is the affordable monthly mortgage. To calculate the maximum that can be borrowed, find the monthly payment per $1,000 mortgage based on the current interest rate and duration of the loan. Divide the affordable monthly mortgage amount by this monthly payment to find the affordable mortgage. Assuming a 10% down payment, the maximum price of a house would be the affordable mortgage divided by 0.9. Use the following data to test your model: Total monthly gross income = $7,000 Nonmortgage housing expenses = $320 Monthly installment debt = $500 Monthly payment per $1,000 mortgage = $6.75 Enter the formulas for the spreadsheet that implements this model. B D $7,000.00 Max Percentage 0.28 A 1 Total Monthly Gross Income 2 Allowable Monthly Housing Expenditure 3 Total Non-Mortgage Housing Expenses 4 Affordable Monthly Mortgage Payment 5 Monthly Installment Debt 6 Total Affordable Monthly Debt Payments $320.00 $500.00 Max Percentage 0.36 7 Affordable Monthly Mortgage $6.75 8 Monthly Payment per $1000 mortgage 9 Maximum that can be borrowed 10 Down Payment 10% 11 What one can afford to spend on a house Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house. Lender guidelines suggest that the allowable monthly housing expenditure should be no more than 28% of monthly gross income. From this, you must subtract total nonmortgage housing expenses, which would include insurance and property taxes and any other additional expenses. This defines the affordable monthly mortgage payment. In addition, guidelines also suggest that total affordable monthly debt payments, including housing expenses, should not exceed 36% of gross monthly income. This is calculated by subtracting total nonmortgage housing expenses and any other installment debt, such as car loans, student loans, credit card debt, and so on, from 36% of total monthly gross income. The smaller of the affordable monthly mortgage payment and the total affordable monthly debt payments is the affordable monthly mortgage. To calculate the maximum that can be borrowed, find the monthly payment per $1,000 mortgage based on the current interest rate and duration of the loan. Divide the affordable monthly mortgage amount by this monthly payment to find the affordable mortgage. Assuming a 10% down payment, the maximum price of a house would be the affordable mortgage divided by 0.9. Use the following data to test your model: Total monthly gross income = $7,000 Nonmortgage housing expenses = $320 Monthly installment debt = $500 Monthly payment per $1,000 mortgage = $6.75 Enter the formulas for the spreadsheet that implements this model. B D $7,000.00 Max Percentage 0.28 A 1 Total Monthly Gross Income 2 Allowable Monthly Housing Expenditure 3 Total Non-Mortgage Housing Expenses 4 Affordable Monthly Mortgage Payment 5 Monthly Installment Debt 6 Total Affordable Monthly Debt Payments $320.00 $500.00 Max Percentage 0.36 7 Affordable Monthly Mortgage $6.75 8 Monthly Payment per $1000 mortgage 9 Maximum that can be borrowed 10 Down Payment 10% 11 What one can afford to spend on a house

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments

Authors: Zvi Bodie, Alex Kane, Alan J. Marcus

8th Edition

0077261453, 978-0077261450

More Books

Students also viewed these Finance questions

Question

What must a person do to apply?

Answered: 1 week ago