Develop spreadsheet for spending on a house

Assignment Help Engineering Mathematics

Reference no: EM131439323

Question: Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house.7 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; nonmortgage housing expenses = $350; monthly installment debt = $500; monthly payment per $1,000 mortgage = $7.25.

Reference no: EM131439323

Questions Cloud

Describe the concrete aspects of the music : describe the concrete aspects of the music as best as you can- who is playing, what instruments are playing, what songs are they playing, what style of jazz, etc... I also would like to know your opinion- how the music makes you feel, what does it..

Sales order form of carbon river furniture : The following figure shows a screen shot of a sales order form of Carbon River Furniture, a fictitious company. When a customer places an order to buy one or multiple furniture items, one of sales persons enters data on the form to complete an ord..

Identify key characteristics outlined as classic themes : Informatics has a very important role in organisations and an understanding of how informatics can help an organisation achieve goals is vital. In this report you are asked to identify key characteristics outlined as classic themes in informatics ..

Write a letter of application to job advertised at newspaper : Write (1) a letter of application (cover letter), (2) a chronological resume, and (3) a thank you email in response to the following job advertised at the university's newspaper.

Develop spreadsheet for spending on a house : Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house.7 Lender guidelines suggest that the allowable monthly housing expenditure should be no more than 28% of monthly gross income.

Functional dependencies and candidate keys : Based on given functional dependencies and candidate keys that you have found, find a 3NF decomposition of R. (follow regular normalization steps and successively normalize to 3NF)

Bluetooth and zigbee based wireless personal area networks : Write a 4-5 page paper (double-spaced) on Bluetooth and ZigBee based Wireless Personal Area Networks. Your paper should address various aspects of these technologies including, but not limited to standards, security features, frequency bands, powe..

Explain if any of other staffing frameworks would any better : Explain if any of the other staffing frameworks would be any better? What can you recommend to the company's headquarters in this sense? Why does Paul want this job? Is Paul a good candidate for this expatriate position?

What is the responsibility of the organizations board : ORG-812: Discussion Question- What is the responsibility of the organization's board when a leader is acting in an unethical manner but the company is profitable?

User Account

All Pages