Question

Develop a spreadsheet model to determine how much a person or a couple can afford to...

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 20% down payment, the maximum price of a house would be the affordable mortgage divided by 0.8. Use the following data to test your model: total monthly gross income =$6,500;=$6,500; nonmortgage housing expenses =$350;=$350; monthly installment debt =$500;=$500; monthly payment per $1,000 mortgage =$7.25.

What one can afford to spend on a house?

Need to create formulas for each empty cells to solve the problem of House Affordability.

Homework Answers

Answer #1
Housing Affordability
Total Monthly Gross Income $ 6,500.00
Allowable Monthly Housing Expenditure $ 1,820.00 Max Percentage 28%
Total Non-Mortgage Housing Expenses $ 350.00
Affordable Monthly Mortgage Payment $ 1,470.00
Monthly Installment Debt $ 500.00
Total Affordable Monthly Debt Payments $ 1,490.00 Max Percentage 36%
Affordable Monthly Mortgage $ 1,470.00
Monthly Payment per $1000 mortgage $ 7.25
Maximum that can be borrowed $202,758.62
Down Payment 20%
What one can afford to spend on a house $253,448.28
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1)You want to buy a house and wonder what you can afford. Banks look at collateral,...
1)You want to buy a house and wonder what you can afford. Banks look at collateral, creditworthiness and capacity (ability to pay) when making loans. Assume you have sufficient down payment and credit score. Your bank has a requirement of 28% housing expense ratio and your gross annual income is $69,000. Based on those assumptions, how much can you afford to pay in total housing costs each month? 2) You are looking to purchase a new home that is listed...
PITI is typically quoted on a monthly basis and compared to a borrower's monthly gross income...
PITI is typically quoted on a monthly basis and compared to a borrower's monthly gross income by means of computing the individual's front-end and back-end ratios, which are used to approve mortgage loans. Generally, mortgage lenders prefer PITI to be equal to, or less than 28%, of a borrower's gross monthly income. Example: If the lender requires a debt-to-income ratio of 28/36, then to qualify a borrower for a mortgage, the lender would go through the following process to determine...
Estimate the maximum house value you can afford to buy. Assume the mortgage is fixed rate,...
Estimate the maximum house value you can afford to buy. Assume the mortgage is fixed rate, 30-year maturity, 80% LTV, with no points. The interest rate is quoted is 3.5% with monthly payments. The property tax rate in the city is 0.7% per year based on property value; the hazard insurance premium is 0.5% per year based on property value, and that on average you should consider $50 per month for maintenance. Determine the required monthly payment for the mortgage...
Mortgage Affordability Seth and Alexandra Moore of Elk Grove Village, Illinois have an annual income of...
Mortgage Affordability Seth and Alexandra Moore of Elk Grove Village, Illinois have an annual income of $104,000 and want to buy a home. Currently, mortgage rates are 4.0 percent. The Moores want to take out a mortgage for 30 years. Real estate taxes are estimated to be $5,040 per year for homes similar to what they would like to buy, and homeowner's insurance would be about $1,620 per year. Using a 28 percent front-end ratio, what are the total annual...
A buyer can afford no more than $500 per month for mortgage payments (principal and interest)....
A buyer can afford no more than $500 per month for mortgage payments (principal and interest). The most favorable loan availabe to him requires monthly payments for 30 years at 10%. If the lender allows a maximum loan to value ration of 90%, what is the most expensive house the borrower can purchase assuming he has the necessary down payment?
Duane Miller wants to know what price home he can afford. His annual gross income is...
Duane Miller wants to know what price home he can afford. His annual gross income is $49,200. He has no other debt expenses and expects property taxes and insurance to cost $320 per month. He knows he can get a 8.50%, 15 year mortgage so his mortgage payment factor is 9.85. He expects to make a 15% down payment. What is Duane's affordable home purchase price?
1. A homeowner planning a kitchen remodeling can afford a $800 monthly payment. How much can...
1. A homeowner planning a kitchen remodeling can afford a $800 monthly payment. How much can the homeowner borrow for 3 years at 6%, compounded monthly, and still stay within the budget? (Round your answer to the nearest cent.) 2. The problem describes a debt to be amortized. (Round your answers to the nearest cent.) A man buys a house for $380,000. He makes a $150,000 down payment and amortizes the rest of the purchase price with semiannual payments over...
You are shopping for a house and wonder what you can afford. Banks look at collateral,...
You are shopping for a house and wonder what you can afford. Banks look at collateral, creditworthiness and capacity (ability to pay) when making loans. Assume you have sufficient downpayment and credit score. Your bank has a requirement of 28% housing expense ratio and your gross monthly income is $5,450. How much can you afford to pay in principal, interest, taxes an insurance (PITI) each month? Show how you calculated how much you can afford to spend on a home...
3. Laurie has been renting an apartment for a few years and is considering buying a...
3. Laurie has been renting an apartment for a few years and is considering buying a house. Her gross annual income is $48 000. Laurie finds a house she likes, with a cost of $145 000. She has saved up enough money to cover the closing costs plus an additional $25 000 for a down-payment. b) The mortgage is amortized over 25 years, with an interest rate of 7.25% /a, compounded semi-annually. Use the TVM Solver to determine Laurie’s monthly...
As housing prices in his area have recently dropped, Tarek is insistent that he should buy...
As housing prices in his area have recently dropped, Tarek is insistent that he should buy a home. Given his projected monthly income of $5,200 and other monthly debt repayment expenses of $200 for a car and estimated student loan payments of $520 per month (use this number rather than the number calculated for part (c)), what’s the maximum monthly principal and interest payment he can afford if insurance is $85 per month and property taxes on the home are...