Open recovered workbooks? Your recent changes C59 x fel 2 2 4 S 5 7 9 11 12 . 14 15 16 7 8 . . D 1 2 Problem DCF and Waterfall Analyes (50 points) A new office development consisting of 22,000 square feet (soft) of lensable space is expected to cost $3.5 million, Including land acquisition costs. The current market rent and vacancy rate are $16/sqft/year and 7%, respectively. Operating expenses are projected at $85,000 per year. The developer expects to use a 5-year permanent loan with an annual Interest rate of 6.5% and an LTV of 703. The loan calls for monthly repayments and is amortired over 30 years. You are asked to develop a 5-year cash flow proforma and analyze the profitability of the development under the following assumptions using the DCF method: Rent, vacancy, and operating expenses are expected to remain constant at $16/sqft/Year, 7%, and $85,000, respectively. To compute the loan amount assume that the value of the completed project is equal to total development costs. The ext cap rate at the end of year 5 15.5% with no selling commissions pald. No capex reserves are taken over the 5-year period. Equity partnership structure: 10% of the equity is provided by the developer as a general partner with the remaining 90% provided by an outside investor. The developer and Investor rank parl-passu over all cash flow distributions paid as follows: 1": Annual cumulative preferred return of 10% 20. Equity payback 34: Remaining cash flows split 50/50 between the developer and the outside Investor a. Compute the before-tax (BT) levered equlty return from this project assuming that the entire cost of the development is spent at the beginning of year 1 (time O) and that the development is Instantaneously completed. (25 points) b. Recompute the BT levered equity return assuming now that the entire investment was made a year earlier (at time - 1) with the construction taking a full year to complete at time with no Income generated during that period. Explain your answer. (5 points) c. Allocate BT equity cash flows to the developer and the investor according to the equity partnership structure and compute the developer's and Investor's BT returns. (10. 10 points) a 5 5 7 Rent (Shaftyear Squarefootage soft Vacancy Operating Expense Total Cost LTV Interest rate Amortization years Et cap rate $16 22.000 7.DOS $85.000 $3.500.000 70% 6.50% 30 550X Problem Open recovered workbooks? Your recent changes C59 x fel 2 2 4 S 5 7 9 11 12 . 14 15 16 7 8 . . D 1 2 Problem DCF and Waterfall Analyes (50 points) A new office development consisting of 22,000 square feet (soft) of lensable space is expected to cost $3.5 million, Including land acquisition costs. The current market rent and vacancy rate are $16/sqft/year and 7%, respectively. Operating expenses are projected at $85,000 per year. The developer expects to use a 5-year permanent loan with an annual Interest rate of 6.5% and an LTV of 703. The loan calls for monthly repayments and is amortired over 30 years. You are asked to develop a 5-year cash flow proforma and analyze the profitability of the development under the following assumptions using the DCF method: Rent, vacancy, and operating expenses are expected to remain constant at $16/sqft/Year, 7%, and $85,000, respectively. To compute the loan amount assume that the value of the completed project is equal to total development costs. The ext cap rate at the end of year 5 15.5% with no selling commissions pald. No capex reserves are taken over the 5-year period. Equity partnership structure: 10% of the equity is provided by the developer as a general partner with the remaining 90% provided by an outside investor. The developer and Investor rank parl-passu over all cash flow distributions paid as follows: 1": Annual cumulative preferred return of 10% 20. Equity payback 34: Remaining cash flows split 50/50 between the developer and the outside Investor a. Compute the before-tax (BT) levered equlty return from this project assuming that the entire cost of the development is spent at the beginning of year 1 (time O) and that the development is Instantaneously completed. (25 points) b. Recompute the BT levered equity return assuming now that the entire investment was made a year earlier (at time - 1) with the construction taking a full year to complete at time with no Income generated during that period. Explain your answer. (5 points) c. Allocate BT equity cash flows to the developer and the investor according to the equity partnership structure and compute the developer's and Investor's BT returns. (10. 10 points) a 5 5 7 Rent (Shaftyear Squarefootage soft Vacancy Operating Expense Total Cost LTV Interest rate Amortization years Et cap rate $16 22.000 7.DOS $85.000 $3.500.000 70% 6.50% 30 550X
