Commercial Acquisition and Development Models

[Tanner Queen]

All - I am working on a rather large portfolio valuation at the moment and would like some assistance on my models. The model I have  been working on has become far too large and crashes every time it opens. I am under a deadline crunch for Tuesday morning. In the links at the end I included the snapshots of the models I have created but things aren't working properly. The format and layout should be good looking as it will be inserted into a presentation. Would be happy to pay or work on future deals. 

Scenarios: 

1) Acquisition of an existing 280,000 SF office building in a major city. a) keep and stabilize as creative office, b) convert to boutique hotel c) convert to residential.

2) Development of a 33,000 SF open lot into a 27 story residential tower. Programming already created by architect partner. 

3) Development of a full city block (almost 3 acres) into student housing or high-end office for adjacent user.

Parameters / Tabs to include: 

1) Summary or Snapshot page (format included in link below)

Major Metro Snapshots

2) Inputs page for assumptions 

3) Cash Flows that flow into summary page with development or conversion (downtime / carry costs) i.e. If property is purchased in year 0, conversion or development takes "x" amount of time, cash flows until stabilization (year 3) with a sale in year 5. 

4) Return Metrics: Project Value at Sale, Net Profit (after sales commissions), Profit Margin, IRR (unlevered for these purposes), Yield on Cost.

Please feel free to reach out.