|
|
|
 |
|
|
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.
|
| |
|
Kahr Real Estate Services is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. |
| |
| 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.
|
| |
|
We offer classes on the weekends and weekdays in the following cities: New York City, Boston, Chicago, Charlotte, Washington, DC, and Los Angeles. We are always adding new classes and locations. We will be updating our class dates once a month.
|
|
| City |
Address |
Date And Time |
Sign Up |
|
|
|
Chicago |
Chicago Marriott Downtown
540 Michigan Avenue
Chicago, IL 60611
|
September 20 & 21
(Saturday & Sunday)
9:00 AM to 5:00 PM |
|
|
| New York City |
Kahr Real Estate
55 Broad Street, 7th Floor
New York, NY 10004 |
October 4 & 5
(Saturday & Sunday)
9:00AM to 5:00PM |
|
|
|
| Washington, DC |
Washington Marriott
1221 22nd Street NW
Washington, DC 20037
|
October 18 & 19
(Saturday & Sunday)
9:00 AM to 5:00 PM |
|
|
|
| Boston |
Boston Marriott Copley Place
110 Huntington Ave
Boston, Massachusetts 02116
|
October 25 & 26
(Saturday & Sunday)
9:00 AM to 5:00 PM |
|
|
| Los Angeles |
Manhattan Beach Marriott
1400 Parkview Ave
Manhattan Beach, CA 90266
|
October 25 & 26
(Saturday & Sunday)
9:00 AM to 5:00 PM |
|
|
| New York City |
Kahr Real Estate
55 Broad Street, 7th Floor
New York, NY 10004 |
November 15 & 16
(Saturday & Sunday)
9:00AM to 5:00PM |
|
|
Chicago |
Chicago Marriott Downtown
540 Michigan Avenue
Chicago, IL 60611
|
November 15 & 16
(Saturday & Sunday)
9:00 AM to 5:00 PM |
|
|
Washington, DC |
Washington Marriott
1221 22nd Street NW
Washington, DC 20037
|
December 5 & 6
(Saturday & Sunday)
9:00 AM to 5:00 PM |
| |
Chicago |
Chicago Marriott Downtown
540 Michigan Avenue
Chicago, IL 60611
|
December 13 & 14
(Saturday & Sunday)
9:00 AM to 5:00 PM |
| |
|
Real Estate Financial Modeling & Analysis with Joshua Kahr. |
Calgary CFA Society (CCFAS), Calgary, Canada |
Ramada Hotel
708 8 Ave SW
Calgary, AB T2P 1H2, Canada
|
October 20 & 21
(Monday & Tuesday)
8:00 AM to 4:00 PM |
|
|
|
|
|
| |
| To register and pay with a check or government purchase order, please click here |
| |
|
| |
| 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. |
| |
|
|
|
| |
|
|
|
