Two developers in Dallas, TX are developing a tract of land where they plan to build...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Two developers in Dallas, TX are developing a tract of land where they plan to build 30 new single-family homes, specifically 20 3-bedroom homes and 10 4-bedroom homes. The target market is the growth in new households living within the metro area with age groups 25-54. The construction takes approximately nine months and is expected to be completed at the end of 2020. From comparable pricing data, they want to begin sales this spring and price the three-bedroom homes at $450,000 each and the four-bedroom homes at $600,000 each and hope to sell all by the end of 2020. 1. If they can sell all the homes in 2020, what are the total projected revenues for 2020 achieved by selling all the homes? 2. They expect that qualifying households who buy the homes will take out a fixed rate 30-year loan (with an interest rate of 4.1%) and a 20 percent down payment. What down payment (equity amount) is required from the buyers for each type of home? How do the down payment amounts change if interest rates increase to 4.5% and is this true in general? 3. Use the PMT function in Excel to compute the minimum qualifying income for the homes priced at $450,000. Also, what is the minimum qualifying income for the homes priced at $600,000? (You may assume that property taxes and insurance will cost 2% of the sale price annually and the maximum qualifying ratio from the bank is 33% of income). What are the minimum qualifying incomes if interest rates rise to 4.5%? How do they change and is this true in general with a higher interest rate? What implications does this have for affordability in changing interest rate conditions? 4. There is some concern whether there is enough demand to sell all the units in 2020. To help estimate the demand, they purchased data from ESRI that provide the number of households in 2018 and the projected number of households in 2023 by age and income within the metropolitan area of Dallas. The data appear in the file Dallas Market xls. The developers want to focus on the 25-54 age groups in the area and estimate that approximately 45 percent of the households in the 25-34 age group prefer to own rather than rent. Similarly, 65 percent in the 35-44 age group, and 85 percent in the 45-54 age group prefer to own (rather than rent). Also, market focus groups indicate that out of those who qualify and want to own, 60 percent prefer the three-bedroom design and 75 percent prefer the four- bedroom design. 5. Estimate the number of new households in 2020 who qualify for the three-bedroom homes priced at $450,000, prefer to own, and prefer the three-bedroom design. Similarly, estimate the household demand in 2020 for the four-bedroom homes. Also, estimate the demand for each design if interest rates rise to 4.5% for a 30-year fixed rate loan and indicate how it changes. 6. If the developers build 20 three bedroom and 10 four-bedroom homes (30 total), what are the "capture rates of the household demand for each type if the developers sell all 30 homes in 2020 and if interest rates remain at 4.1 percent? What are the demand capture rates if interest rates rise to 4.5 percent? 7. Discuss the risk to the project if interest rates rise this year? Here, competing supply is missing and discuss why this information is important to know. Also, what other information is needed to determine the market feasibility of the new home project? Do you think that the developers should proceed with construction, why or why not? Two developers in Dallas, TX are developing a tract of land where they plan to build 30 new single-family homes, specifically 20 3-bedroom homes and 10 4-bedroom homes. The target market is the growth in new households living within the metro area with age groups 25-54. The construction takes approximately nine months and is expected to be completed at the end of 2020. From comparable pricing data, they want to begin sales this spring and price the three-bedroom homes at $450,000 each and the four-bedroom homes at $600,000 each and hope to sell all by the end of 2020. 1. If they can sell all the homes in 2020, what are the total projected revenues for 2020 achieved by selling all the homes? 2. They expect that qualifying households who buy the homes will take out a fixed rate 30-year loan (with an interest rate of 4.1%) and a 20 percent down payment. What down payment (equity amount) is required from the buyers for each type of home? How do the down payment amounts change if interest rates increase to 4.5% and is this true in general? 3. Use the PMT function in Excel to compute the minimum qualifying income for the homes priced at $450,000. Also, what is the minimum qualifying income for the homes priced at $600,000? (You may assume that property taxes and insurance will cost 2% of the sale price annually and the maximum qualifying ratio from the bank is 33% of income). What are the minimum qualifying incomes if interest rates rise to 4.5%? How do they change and is this true in general with a higher interest rate? What implications does this have for affordability in changing interest rate conditions? 4. There is some concern whether there is enough demand to sell all the units in 2020. To help estimate the demand, they purchased data from ESRI that provide the number of households in 2018 and the projected number of households in 2023 by age and income within the metropolitan area of Dallas. The data appear in the file Dallas Market xls. The developers want to focus on the 25-54 age groups in the area and estimate that approximately 45 percent of the households in the 25-34 age group prefer to own rather than rent. Similarly, 65 percent in the 35-44 age group, and 85 percent in the 45-54 age group prefer to own (rather than rent). Also, market focus groups indicate that out of those who qualify and want to own, 60 percent prefer the three-bedroom design and 75 percent prefer the four- bedroom design. 5. Estimate the number of new households in 2020 who qualify for the three-bedroom homes priced at $450,000, prefer to own, and prefer the three-bedroom design. Similarly, estimate the household demand in 2020 for the four-bedroom homes. Also, estimate the demand for each design if interest rates rise to 4.5% for a 30-year fixed rate loan and indicate how it changes. 6. If the developers build 20 three bedroom and 10 four-bedroom homes (30 total), what are the "capture rates of the household demand for each type if the developers sell all 30 homes in 2020 and if interest rates remain at 4.1 percent? What are the demand capture rates if interest rates rise to 4.5 percent? 7. Discuss the risk to the project if interest rates rise this year? Here, competing supply is missing and discuss why this information is important to know. Also, what other information is needed to determine the market feasibility of the new home project? Do you think that the developers should proceed with construction, why or why not?
Expert Answer:
Answer rating: 100% (QA)
1 To calculate the total projected revenues for 2020 achieved by selling all the homes we need to multiply the number of homes sold by their respective prices Number of 3bedroom homes sold 20 Price pe... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Private carriage is more important in the motor carrier segment of our transportation industry than any of the other four major modal segments. What factors have contributed to private carriage...
-
Suppose that Myers and Myers in P3-8 paid no dividends during 2012 and that the December 31, 2012, balance sheet looks like the one below. (This problem requires knowledge of present value...
-
Continue with the case of ITC Ltd. Analyse its results to examine the chronological performance of the company and assess the 200304 EPS. Attempt the following requirements towards this purpose....
-
When soup is stirred in a bowl, there is considerable turbulence in the resulting motion. From a very simplistic standpoint, this turbulence consists of numerous intertwined swirls, each involving a...
-
Lee, Brad, and Rick form the LBR Partnership on January 1 of the current year. In return for a 25% interest, Lee transfers property (basis of $15,000, fair market value of $17,500) subject to a...
-
Compare U.S. government and private sector financing models in the table and include a minimum of four sentences for each criterion: Cost - What the patient pays: premiums, copays, and deductibles....
-
Captain America Corporation is a small private corporation that sells desktop printers to local businesses and schools. On May 1, 2021, the following were the account balances of Captain America...
-
Statistical Process Control (SPC) Charts? display a measurement of every unit that has been produced. are exclusively used for data following a binary distribution. indicate to the process operator...
-
Which of the following types of drugs would you expect to inhibit heterochromatin formation? A. A drug that inhibits DNA methyltransferase B. A drug that inhibits histone methyltransferase C. A drug...
-
With regard to chromosomal locations, how do constitutive and facultative heterochromatin differ?
-
What are some key functions of heterochromatin?
-
List and briefly describe the three phases of heterochromatin formation at the chromosome level.
-
Briefly describe three higher-order structures that occur in heterochromatin.
-
Financial Instruments Scenario Classification of investment Balance Sheet Presentation Initial measurement Subsequent Measurement An entity acquires debt securities that it will hold until...
-
In the operation of an automated production line with storage buffers, what does it mean if a buffer is nearly always empty or nearly always full?
-
Key comparative figures ($ millions) for both Best Buy and RadioShack follow. Required 1. What is the total amount of assets invested in (a) Best Buy and (b) RadioShack? 2. What is the return on...
-
The following selected transactions are from Chantay Company. 2010 Dec. 16 Accepted a $14,400, 60-day, 8% note dated this day in granting Adam Bakko a time extension on his past-due account...
-
Refer to the information in QS 5-1 and assume the periodic inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on LIFO. (Round per unit costs to...
-
Company G has a hardware business. The balance sheet at the beginning of the financial year showed the position in Table 2.23. Show the adjustments, in the columns provided, for each of the following...
-
This information has been taken from the companys books as at 31 December 20X1, but the information below has not been allowed for. (a) Inventory at 31 December 20X1 is 20,000. (b) Plant and...
-
The information has been taken from the companys books as at 31 December 20X1, but the following has not been allowed for. (a) Inventory at the end of the year is 25,000. (b) Audit fees owing...
Study smarter with the SolutionInn App