Home  ::  Log In  ::  Search :: 
Classroom-Based Programs
Conferences and Workshops
Instructor-Guided Online Courses
Live Webinars

Designations and Certificates
Magazine and Newsletter Subscriptions
Market and Research Data
Publications and Guides
Self-Study Web-Based Courses
Webinar Recordings and Packages

Excel for Commercial Real Estate Finance Professionals
Member Price: $99.00
Nonmember Price: $299.00
Product Code: E2191716AB/REGIS
Date Held:
September 26, 2019

 Before 8/26/2019StandardAfter 8/26/2019

Description of Product
Date Held:
September 26 

Excel for Commercial Real Estate Finance Professionals is an interactive webinar that will explore the ways in which to create a useful and powerful spreadsheet when analyzing commercial real estate. Using an office building case study, the webinar will demonstrate the steps taken to create a spreadsheet, project income and expenses over a holding period, integrate various commercial real estate formulas including but not limited to debt service, discounted cash flow analysis, NPV, IRR and demonstrate how to link two or more workbooks together. The webinar will utilize Adobe and the "Share My Screen" feature allowing the instructor to walk the participants through the steps to building the spreadsheet.


Thursday, September 26, 2019


2-3:30 p.m. ET


Attendees should expect to understand:
  • Learn how to set up a spreadsheet using income and expense categories and project cash flow for a set holding period
  • Learn how to integrate the spreadsheet with pertinent commercial real estate formulas
  • Learn how to link the two or more spread sheets together


  • Build a spreadsheet for an office building
  • Project income and expenses for a 7 year holding period
  • Value the property using yield capitalization
  • Calculate annual debt service and provide an amortization schedule
  • Calculate Performance ratios (LTV, DSC, Debt Yield, IRR)
  • Provide rollover analysis
  • Calculate principal balance at maturity
  • Calculate tenant’s net effective rent
  • Link two or more workbooks together


  • Terry Wellman, Senior Vice President, FHA Chief Underwriter, Agency Finance, PNC Real Estate

Who Should Attend?

This webinar is designed for individuals with little to no experience with Excel, but some familiarity with commercial real estate terminology is required. The course is open to college students, recent graduates and individuals working in the commercial real estate field including originators, analysts, loan processors, closers and servicers.  
Product Category:
Live Webinars 
Contact Info:

For registration information, call (800)-793-6222 or email education@mba.org

Contact E-mail:
Excel for Commercial Real Estate Finance Professionals 

   Terms of Use & Privacy Statement

Copyright © 2019 Mortgage Bankers Association.  All rights reserved.