Building on the earlier introductory pro forma modeling course, this four-part online live program will help further build the participants’ financial modeling and Excel skills. Attendees will learn more advanced Excel functions for valuation, amortization, rent roll, construction and permanent financing, construction draws, and cash flows….Continue Reading
Past Events
February 12, 2013
Introduction to Pro forma Modeling with Excel: ULI Online Live Workshop
Held over four sessions, this online workshop will guide students through the construction and manipulation of a basic multifamily investment pro forma. Starting with a blank spreadsheet, the program is geared toward individuals who have never completed a pro forma from scratch. Students will receive step-by-step direction in the construction of this investment pro forma. At the end of the last session, participants will have completed their own investment pro forma and will have gained a new appreciation for how valuation and investment decisions are made.
January 24, 2013
Rose Center Webinar: Parking Reform
Rose Center webinar for public officials….Continue Reading
September 18, 2012
Graphing Real Estate Finance and Analysis Data with Excel: ULI Live Online Workshop
Held over two sessions, this new online program will instruct attendees in the skills required to better display quantitative data using Microsoft Excel. It will focus on the tools provided in Excel, with specific emphasis placed on commonly used graphics for financial reporting and analysis and particular attention paid to real estate uses. …Continue Reading
August 27, 2012
Understanding and Calculating Residual Land Value Using Excel: ULI Live Online Workshop
Determining how much a developer can afford to pay for developable land can be a daunting task. Employing comparable sales data is one technique often used for deciding the value of a piece of land. However, this approach ignores critical project details and can be unreliable for determining project viability. Ultimately, it can cause the failure of what could have been a successful undertaking. A more reliable and comprehensive technique is residual land valuation. This technique—used by development professionals, corporations, and appraisers alike—determines project viability by taking into account specific operational components of a project such as rents, operating expenses, and prevailing capitalization rates. …Continue Reading
