Advanced Pro Forma Modeling Using Excel

« Back to Events
Start:
November 13, 2012 @ 8:00 am
End:
November 14, 2012 @ 5:00 pm
Category:
Venue:
Ivey ING Direct Leadership Centre
Address:
130 King Street West, Toronto, Ontario M5X 1A9 Canada
Organizer:
David Mulvihill, Vice President, Professional Development
Phone:
202-624-7122
Email:

Other

Netforum Event ID. You can find it here: http://netforum.uli.org/eweb//DynamicPage.aspx?site=ULIMC&webcode=ULIEventsSearch&ord=evt_start_date
a7908c1d-c18b-4262-aa78-c7bf69215d02
Display group registration button?
No
Display individual registration button?
Yes
Non-netforum Registration URL
http://netforum.uli.org/eweb/DynamicPage.aspx?webcode=EventInfoNoAtt&Reg_evt_key=a7908c1d-c18b-4262-aa78-c7bf69215d02&RegPath=EventRegFees&site=ULIMC
Display registration button above event description?
Yes
Display registration button below event description?
No
Display attendees list link?
No

This popular ULI workshop is designed for real estate finance professionals who want to build complex financial models using Excel. Students will develop their own spreadsheets for different property types that will allow them to model multiple real estate investment scenarios quickly and effectively.

Students will learn advanced tools in Excel and apply them immediately to their own Excel models. Important skills such as building construction loan and development models, using statistical skills to better understand real estate investments, developing reusable models, and auditing existing models will be addressed in detail.

Participants are expected to bring a laptop with Microsoft Excel to the course

Instructor

Joshua Kahr
Principal
Kahr Real Estate Services
New York, New York

Joshua Kahr is the Principal of Kahr Real Estate Services, a consulting firm that specializes in financial modeling, market analysis, and financial software training. He has trained hundreds of people in how to use Excel to model real estate investments for numerous clients including Wall Street investment banks, top business schools, and investment firms. Kahr is currently an adjunct associate professor at Columbia University where he teaches a year -long real estate finance course in their MS in Real Estate Development program.

Prior to launching his consulting business in 2002, he worked in investment sales at GVA Williams and at a Credit Suisse backed investment firm that redeveloped environmentally contaminated real estate. Kahr recently authored his first book, Real Estate Market Valuation and Analysis (John Wiley and Sons: 2005).

Kahr has an MS in Real Estate from New York University and a BA in Economics from Reed College.

Registration Fee

ULI Member: $642 CDN ($650 US)
Nonmember: $740 CDN ($750 US)
Government and non-profit: $587 CDN ($595 US)

Download Registration Form

Registration fee includes tuition, course materials, luncheons, and refreshments. There is an additional $100 charge for on-site registrations.

Cancellations, which must be made in writing or email to ULI’s Customer Service Department, will be subject to a $100 administrative fee. Cancellations must be received at least seven days prior to the start of the workshop to be eligible for a refund. No refunds will be granted thereafter. You may, however, transfer your registration, without penalty, to another member of your organization.

Program Highlights

  • The opportunistic redevelopment of an office building
  • The construction and financing of a single-family housing subdivision
  • Using a partnership to raise money to purchase a stabilized shopping center
  • Using a partnership to raise an investment fund to finance multiple transactions