Reference no: EM133591114
Assignment
You are considering developing a new apartment building with 300 units of 1,000 rentable square feet each. The expected rent is $2.00 per rented sf. per month with a vacancy of 5% and 0.5% bad debt allowance. (Hint: Build a spreadsheet to answer these questions.)
Question I. What is the expected potential gross income (or gross potential revenue)?
Question II. What is the expected effective gross income?
Question III. The operating expenses are projected to be 30% of the effective gross income. In apartment buildings, the landlords are responsible for operating expenses. What is the expected NOI?
Question IV. The going-out cap rate is 4%. For how much you expected to sell this building?
Question V. The design of your apartment building implies an efficiency of 80%. What is the estimated gross square footage (gsf) of your building?
Question VI. The construction hard cost is $175/gsf (including a garage). What is the estimated hard construction cost?
Question VII. You estimate that soft cost is 10% of hard construction cost and that development contingency is 3% of hard construction cost. What are the estimated soft cost and development contingency?
Question VIII. Assume that the land cost $10,000,000. What is the total project cost (land+hard cost+ soft cost + development contingency)?
Question IX. You obtain a construction loan. You borrow 60% of the total project cost at 6% annual interest rate. Assume that your construction loan will have a two-year term and average draw during these two years equal to 65%. What is the estimated construction loan interest?
Question X. Using your previous answers, what is the overall cap rate (or yield on cost) of your project?
Question XI. Assuming that your feasibility criteria is that the spread between the yield on cost and the going-out cap rate is greater than 150 basis points. Is this project economically feasible?
Question XII. What is the cost of land that makes the yield on cost equal to 5.5%?
Question XIII. Assuming that you pay 10,000,000 for the land, what is the rent per square foot per month that makes the yield on cost equal to 5.5%?