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

PRODUCTS
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: $199.00
Nonmember Price: $279.00
Product Code: E2181716X/REGIS
Date Held:
January 17, 2018





 Before 1/17/2018StandardAfter 1/17/2018
Member$199.00$199.00$199.00
Non-Member$279.00$279.00$279.00


Description of Product
Date Held:
January 17 
 
Description:

Excel for Commercial Real Estate Finance Professionals

Date: Wednesday, January 17, 2018

Time: 2-3:30 p.m.

Summary:

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, MEY 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.

Objectives:

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

Lessons:

  • 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, MEY)
  • Provide roll over analysis
  • Calculate principal balance at maturity
  • Calculate tenant’s net effective rent
  • Link two or more workbooks together

Speaker:

William Anderson, Associate, MetLife 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:
education@mba.org 
 
Product:
E2181716X/REGIS 
 
Title:
Excel for Commercial Real Estate Finance Professionals 
 


   Terms of Use & Privacy Statement

Copyright © 2017 Mortgage Bankers Association.  All rights reserved.