On-Demand Event
Course Summary:
This course is designed to introduce participants to financial modeling and to provide participants with the skills necessary to create professional spreadsheets. The course will begin with an overview of how to use formulas and overview common built-in math, statistical, date, conditional and financial functions used in financial modeling. The course will acquaint students with multiple Excel shortcuts to allow students to learn or enhance Excel skills necessary to save time in building financial models. The course will next guide students through a construction of a basic pro-forma, focusing on the use of formulas, functions, shortcuts, and formatting. The purpose of the last session is to acquaint students with advanced Excel functions needed to build more complex Excel models. The course is taught using multiple real estate finance and investment examples, such as time value of money, loans, amortization table, and pro-forma.

Course Summary:This course is designed to introduce participants to financial modeling and to provide participants with the skills necessary to create professional spreadsheets. The course will begin with an overview of how to use formulas and overview common built-in math, statistical, date, conditional and financial functions used in financial modeling. The course will acquaint students with multiple Excel shortcuts to allow students to learn or enhance Excel skills necessary to save time in building financial models. The course will next guide students through a construction of a basic pro-forma, focusing on the use of formulas, functions, shortcuts, and formatting. The purpose of the last session is to acquaint students with advanced Excel functions needed to build more complex Excel models. The course is taught using multiple real estate finance and investment examples, such as time value of money, loans, amortization table, and pro-forma.

Details
Format

The course is eight hours long, delivered in four two-hour modules. It is available in a convenient on-demand format.

Type

On-Demand Course

Experience Level

Foundational

Career Stage

Beginning Professional

RELATED
Report

Emerging Trends in Real Estate®: Asia Pacific 2021

Throughout 2020, the success of government efforts across the Asia Pacific to contain the spread of COVID-19 has helped limit its impact on local real estate markets. At the same time, however, there is a sense that asset values have been propped up ...
Reading List

Better Than Before: How Communities Regroup and Rebuild After Disaster

While the cost to rebuild has never been higher, whether it be from wildfires or earthquakes, heat waves, or flash floods, the opportunity has never been more evident as communities look to both private capital and government stakeholders to help the...
Webinar

Airport Development Council in Formation: Supporting the Recovery

This second ULI Airport Development Council Concept Webinar focuses on Dallas-Fort Worth DFW International Airport and other Airport examples, exploring “Airports’ Key Roles as Multi-Modal Logistic Hubs in Supporting the Recovery”.
Topics
Finance & Investment

Introduction to Excel for Real Estate Professionals

Register

Featured Content Pillars

  • Housing and Communites
  • Real Estate Finance and Investment
  • Sustainability and Economic Performance
  • Innovation in Development Practice
  • Shaping Successful Cities and Regions