As the financial advisor for Georgetown Development Co. (GDC), you are responsible for analyzing the newly proposed Woodland Street Office Project. Your boss has given you the construction and marketing studies for the project. The plan calls for a construction phase of one year and an operational phase of five years, after which the property will be sold. Your boss has informed you that the required return on the project is 15% (after tax).

Part 1: Construction Phase The marketing staff has found a 2.2 acre site that can be acquired for $412,500. They have concluded that the 2.2 acre site will provide enough space for the proposed building, as the site will support an office building with a gross building area (GBA) of 62,000 square feet. The gross leasable area (GLA) will be 55,800 square feet, giving it a leasable ratio of 90%. The construction division of GDC had told you that they can keep construction hard costs to $48/square foot (GLA). On soft costs, you are told that $5/square foot (GLA) is expected to cover all typical soft cost items EXCEPT (construction loan) interest carry and all loan fees. These uncovered soft cost items need to be estimated by you in this homework given their straightforward definitions. The construction division has also informed you that they will have to spend $100,000 for site improvements before construction of the office building begins. Goliath National Bank has agreed to provide the construction loan for the project. The bank will authorize you to draw funds enough to cover cost on site improvements, all the hard cost plus eligible soft cost as defined above, i.e., 5$/sf. The construction loan interest carry will be at an annual rate of 11.5%, plus a loan origination fee of 2 points. The construction division estimates that 40% of the total draw will be taken down evenly during the first four months, with the remaining 60% of total draw being taken down during the final eight months of the construction phase. Permanent financing for the project will come at the end of the first year at the amount equal to the ending balance of the construction loan. GDC plans to obtain permanent financing from Trust Insurance Co. at an interest rate of 11% with a 3% prepaid loan fee. The loan has a 10 year term and is to be paid back monthly over a 25-year amortization schedule.

a) Calculate the construction draw schedule. What will the yield to the lender of the construction loan be? (20 points)

b) Calculate the total sum of the following items1: total draw plus two loan fees and construction loan interest carry). (20 points)

c) Create a statement of cash flows for the construction phase. Use this to determine how much equity is needed to fund the project. The statement of cash flows should include outflows relate to purchase and improvement of the site, as well as loan fees and interest. Inflows should include the construction loan. (20 points)