# Project #121327 - BAUD 3301

A home builder is planning a new subdivision. Write a paper addressing the cost of homes to be built in this subdivision using the information provided below. Your recommendation should be based on the results of analyzing the data provided below. You will describe your analysis and results as well as present the results of your analysis. The table below provides the distribution in household income for the city.   Number Percent Households 405,887 100.0  Less than \$10,000 46,058 11.3  \$10,000 to \$14,999 28,462 7.0  \$15,000 to \$24,999 61,545 15.2  \$25,000 to \$34,999 59,989 14.8  \$35,000 to \$49,999 69,799 17.2  \$50,000 to \$74,999 72,213 17.8  \$75,000 to \$99,999 32,724 8.1  \$100,000 to \$149,999 23,245 5.7  \$150,000 to \$199,999 5,942 1.5  \$200,000 or more 5,910 1.5
The distribution above provides the potential market for the new homes. Assume that a buyer can afford a home if the monthly payment (PITI) is no more than 28% of their monthly income. Assume the annual tax rate is 2.5% and monthly homeowner's insurance will be \$100. Mortgage rates over the last 20 years have ranged from approximately 4% to approximately 10% with an average of 6.75%. To analyze the data, determine the maximum monthly payment each distribution group can afford. Also create a data table of monthly payments based on interest rates over the range of the last 20 years and home prices from \$50,000 to \$400,000. Finally, calculate the maximum affordable home price for each group with more than 50,000 households using the average interest rate from the last 20 years. Use this information to come up with a recommendation. Note that the subdivision will not be completed for at least 10 years so the interest rates (and consequent affordability) may change considerably over time. Your recommendation should be of the form houses from \$50,000 to \$100,000 or \$350,000 to \$400,000.

 Subject Business Due By (Pacific Time) 04/14/2016 05:00 pm
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews