Development projects can take years or decades to complete.  With the number of uncertainties that can occur during the course of the development, the changing variables, real estate development must be flexible and adaptive.  By its very nature, the process of real estate development is random since each site, physical orientation, location, project size, jurisdictional influences vary.  There is a large body of knowledge on market analysis, valuation, and capitalization of projects however there is little research on the entire analysis of real estate necessary to explore and expose the key components prior to executing agreements for purchase.  The best analysis of the market, project valuation and financials can be erased if a key component of title, physical characteristic, or legal issue is overlooked.

Preparing a project schedule in Excel can be used to plan cash flows and create a dynamic cash flow analysis driven by the project schedule.  This article provides a step-by-step process to building a schedule in Microsoft Excel as well as more advanced formula writing and formatting tricks.

How to prepare a Project Schedule in Microsoft Excel

Preparing the Project Schedule in Microsoft Excel – Case Study

Project schedule case study – blank worksheet + solution + formula sheets