|
|
|
 |
|
|
Excel for Real Estate Analysis |
|
|
"I had no idea how tight my models could be until I took Kahr's class." - Associate underwriter at large commercial bank
Our Excel for Real Estate Analysis class draws students from across the country. It provides what many attendees say they never learned in business school - they learn how to model complex real estate transactions and use Excel to its fullest. The class is informative, challenging and practical in nature. All attendees will develop an understanding of how to use the power of Excel to analyze cash flow, leverage, partnerships and joint ventures, and construction projects.
Financial topics include: |
| |
 |
Building effective cash flow assumptions |
| |
|
Cash flow statements |
| |
|
Valuation of an asset using discounted cash flow analysis |
| |
|
Amortization schedules for mortgages |
| |
|
Impact of leverage |
| |
|
Depreciation schedules |
| |
|
Impact of taxation (income, capital gains, and accumulated depreciation) |
| |
|
Partitioning the IRR |
| |
|
Partnerships (preferred returns, waterfalls, and IRR look backs) |
| |
|
Sensitivity tables and graphs for presentation and analysis |
| |
|
How to use Excel and Argus together for effective analysis |
|
|
In addition to covering a wide range of real estate finance topics, the course specifically covers the following Excel tools and functions. Additional tools and functions will be covered based on questions and as time permits.
Functions
- SUM
- ROUND
- IF, AND, OR
- PV, FV, RATE, NPER
- PMT, IPMT, PPMT
- IRR, NPV
- XIRR, XNPV
- EDATE, EOMONTH, DATEDIF
- OFFSET
- TRANSPOSE
- ISERROR
- VLOOKUP, HLOOKUP
- INDEX, MATCH
- SUMIF
|
Tools and Concepts
- Absolute and Relative References
- Keyboard Shortcuts
- Data Validation
- Conditional Formatting
- Goal Seek
- Data Tables
- Solver
- Scenario Manager
|
|
| |
| Please click here to download a complete agenda. |
| |
| All open enrollment courses are restricted to no more than 20 attendees in order to maximize teacher to student interaction. Students will also receive a complete set of spreadsheets for all examples and case studies that are discussed in class. |
| |
| The class was designed by Joshua Kahr, founder and principal of Kahr. Mr. Kahr is internationally recognized as an expert in real estate financial modeling using both Argus and Excel. Over the last seven years, he has taught his Excel for Real Estate Analysis training class for leading institutions including commercial banks, investment banks, private real estate investment firms, REITs (Real Estate Investment Trusts), business schools, developers, and government agencies. Classes are taught by Mr. Kahr and members of his senior staff.
|
| |
| The class is $850 per attendee. Attendees are invited to bring their own laptop. Excel 2003 or Excel 2007 is preferred. Laptops with Excel 2003 may be rented for an additional fee. For more information on the class, please read our FAQ.
|
| |
|
|
|
|
Real Estate Analysis with Excel, July 24 and 25, New York
99 Hudson Street, 3rd Floor, New York, NY
|
|
|
Real Estate Analysis with Excel, August 28 and 29, New York
99 Hudson Street, 3rd Floor, New York, NY
|
|
|
|
| |
| For corporations and government agencies, attendees may pay by check. To register and pay with a check or government purchase order, contact info@kahrrealestate.com or call us at (212) 566-4085 to reserve a spot. |
| |
| You will receive an electronic confirmation of your payment shortly after registering. Sign up to the KREG newsletter, "Kahr Notes", to receive updates for upcoming classes in other locations. |
| |
|
|
|
| |
|
|
|
