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. This course is recommended for non-finance real estate professionals who wish to obtain new and enhance existing Excel skills.