PGain provides quarterly market updates on the state of commercial real estate within the United States by asset class. Membership provides access to current forecasts as well as access to best practices in financial modelling in commercial real estate.
to access pre-recorded lectures
Single-page example introducing users to Optimization. This page introduces readers to Decision Variables utilized in real estate architecture. Optimization allows analysts and owners to determine the optimal unit mix during the planning state or renovation state of a real estate project.
Crystal Ball Construction – A single page example of Crystal Ball used for an analysis. This is meant as a “practice” model and for demonstration.
Crystal Ball Sheet – This stand-alone sheet which can be “Bolted-On” to existing spreadsheet models to enable stochastic modelling of inputs.
Crystal Ball Add-on 5-Unit – The 5-unit real estate pro forma has been enhanced with Monte Carlo and Latin hypercube simulation of Crystal Ball. The basic Crystal Ball “Bolt-On” page has been added and the capability of stochastic risk quantification included within an existing spreadsheet model.
Another stand-alone “bolt on” sheet. The Waterfall bifurcates project returns by risk tranche. This sheet is added to existing models and provides increased capabilities. Two files are included, the single stand-alone sheet and the model with the waterfall included.
