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 7 Affordable Monthly Mortgage 8 Monthly Payment per $1000 mortgage 9 Maximum that can be borrowed 10 Down Payment 11 What one can afford to spend on a house B $6,000.00 $300.00 $400.00 $7.25 10% D Max Percentage 0.28 Max Percentage 0.36
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 7 Affordable Monthly Mortgage 8 Monthly Payment per $1000 mortgage 9 Maximum that can be borrowed 10 Down Payment 11 What one can afford to spend on a house B $6,000.00 $300.00 $400.00 $7.25 10% D Max Percentage 0.28 Max Percentage 0.36
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
Sub : Economics
Pls answer very fast.I ll upvote correct answer. Thank You
![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 = $6,000
Nonmortgage housing expenses $300
Monthly installment debt = $400
Monthly payment per $1,000 mortgage = $7.25
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
7 Affordable Monthly Mortgage
8 Monthly Payment per $1000 mortgage
9 Maximum that can be borrowed
10 Down Payment
11 What one can afford to spend on a house
B
$6,000.00
▼
$300.00
▼
$400.00
▼
▼
$7.25
10%
C
Max Percentage
Max Percentage
D
0.28
0.36](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd7b3a5a8-62f8-422a-9e49-23846b36685e%2F0ff6e444-4517-4106-9ef1-15639aa188f3%2F3zj9145_processed.png&w=3840&q=75)
Transcribed Image Text: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 = $6,000
Nonmortgage housing expenses $300
Monthly installment debt = $400
Monthly payment per $1,000 mortgage = $7.25
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
7 Affordable Monthly Mortgage
8 Monthly Payment per $1000 mortgage
9 Maximum that can be borrowed
10 Down Payment
11 What one can afford to spend on a house
B
$6,000.00
▼
$300.00
▼
$400.00
▼
▼
$7.25
10%
C
Max Percentage
Max Percentage
D
0.28
0.36
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.Recommended textbooks for you
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
![Principles of Economics (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305585126/9781305585126_smallCoverImage.gif)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
![Managerial Economics: A Problem Solving Approach](https://www.bartleby.com/isbn_cover_images/9781337106665/9781337106665_smallCoverImage.gif)
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
![Managerial Economics & Business Strategy (Mcgraw-…](https://www.bartleby.com/isbn_cover_images/9781259290619/9781259290619_smallCoverImage.gif)
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education