Invalid quantity. Please enter a quantity of 1 or more.
The quantity you chose exceeds the quantity available.
Please enter your name.
Please enter an email address.
Please enter a valid email address.
Please enter your message or comments.
Please enter the code as shown on the image.
Please select the date you would like to attend.
Please enter an email address.
Please enter a valid email address in the To: field.
Please enter a subject for your message.
Please enter a message.
You can only send this invitations to 10 email addresses at a time.
$$$$ is not a properly formatted color. Please use the format #RRGGBB for all colors.
Please limit your message to $$$$ characters. There are currently ££££.
$$$$ is not a valid email address.
Please enter a promotional code.
N/A
Sold Out
You have exceeded the time limit and your reservation has been released.
The purpose of this time limit is to ensure that registration is available to as many people as possible. We apologize for the inconvenience.
This is option is not available anymore. Please choose a different option.
Please read and accept the waiver.
All fields marked with * are required.
Please double check your email address. The email address format does not appear valid.
$$$$ requires a number between ££££ and §§§§
US Zipcodes need to be 5 digits.
Please double check your website URL.
All fields marked with * are required.
Your credit card expiration date is in the past.
Your credit card CSC needs to be 4 digits.
Please confirm your order:
$$$$
You have selected to Pay by Check.
Click OK to confirm your order.
Please confirm your order:
$$$$
You have selected to Pay at the Door.
Click OK to confirm your order.
Please confirm your order:
$$$$
You have selected to Pay upon Receiving an Invoice.
Click OK to confirm your order.
Your credit card CSC needs to be 3 digits.
Your billing zip code needs to be 5 digits.
There was a problem saving your address.
There was a problem saving your credit card info.
There was a problem saving your personal information.
Please select the date you would like to attend.
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams.
Copying Prohibited by Law - McAfee Secure is a Trademark of McAfee, Inc.
Unknown card type.
No card number provided.
Credit card number is in invalid format.
Wrong card type or credit card number is invalid.
Credit card number has an inappropriate number of digits.
Please enter numbers here.
Please enter an integer value.
Numbers must be less or equal to $$$$
All the required fields have not been filled out. Click OK to proceed without all the required information, or click Cancel to finish entering the missing data.
Sorry, invalid event registration form.
Sorry, invalid event or database error.
Sorry, quantity must be a positive integer.
Sorry, you did not select a valid ticket.
Sorry, invalid event organizer email address.
Your order was canceled.
Thank You. Your order has been successfully completed. Your name and email address have been added to the list of event attendees.
Sorry, that option is sold out.
Sorry, that option is no longer available.
Sorry, there are only tickets of that type still available.
Sorry, you entered an invalid quantity. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, you did not select any tickets to purchase. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, there are no tickets left for this event.
The tickets, ticket quantity or date and time you've requested are no longer available, due to previous sales. Please choose a different date, time or number of tickets and place your order again.
Sorry, one or more of the tickets you requested are no longer available for purchase.
Sorry, you need to select the date you want to attend.
Sorry, the promotional code you entered is not valid yet.
Sorry, the promotional code you entered has expired.
Sorry, the promotional code you entered is not valid.
Your session has expired. Try ordering again.
Sorry, your requested ticket quantity exceeds the number provided by your promotional code.
Sorry, the tickets you are trying to order are not currently available.
Sorry, the payment type chosen is invalid for this event.
Sorry, there is only 1 ticket left for this event.
Sorry, there are only tickets left for this event.
We're sorry, this invitation is invalid.
We're sorry, this invitation has already been used.
We're sorry, you already have an order being processed for this event. Please wait a few minutes and try again.
We're sorry, there is a problem with your invitation. Please try again.
Invalid quantity of tickets selected.
Sorry, the payment type chosen is invalid for this event.
Sorry, your billing address was not saved properly, please try again.
Sorry, we experienced an internal error, please try again.
The captcha you entered is invalid. Please try again.
Invalid credit card selected. You have been logged out.
Sorry, your team selection was not valid.
Sorry, the payment type chosen is invalid for this event.
Sorry, your billing address was not saved properly, please try again.
Sorry, we experienced an internal error, please try again.
State
Zip Code
Province
Postal Code
County
State/Territory
State/Province
Event Details
Advanced Financial Modeling
Using Excel
2-Day Workshop
September 20-21, 2008
9:00am - 5:00pm
YREP is excited to have partnered with
Kahr Real Estate for an Advanced Excel Modeling workshop at a discount from the regular workshop fee!
CLICK HERE for the workshop agenda
This 2-day workshop is the same workshop Josh Kahr taught through the Urban Land Institute. It is designed especially for real estate 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 any real estate investment scenario quickly and effectively.
What you will learn.
- Integrate statistical tools into your real estate investment models.
- Build sensitivity tables that quantify changes in variables.
- Learn how to use hidden functions in Excel to handle uneven cash flows.
- Control model using custom-built forms, checkboxes, and menus.
- Integrate Excel with other modeling software.
- Develop reusable models and audit existing models.
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.
Students taking this workshop are expected to have a basic knowledge of Excel and a firm grasp of basic real estate finance concepts such as time value of money, internal rate of return (IRR), and net present value (NPV).
A laptop with a CD drive and Excel 2000 or later is required.
Enrollment is limited and fills to capacity each time it is held, so register early to ensure your attendance.
CANCELLATION POLICY: For a refund, registration must be cancelled on or before Monday, September 15, 2008.
PLEASE NOTE:
If you would like to become an Annual YREP Member and receive the $50 YREP Member discount for this workshop (along with other Annual YREP Member benefits), just join YREP prior to purchasing your seat.
Registration Ends
Tuesday, September 18 at 8:00pm
(or when all seats are reserved, whichever comes first)
If you have any questions or are experiencing any technical difficulties registering for this event, please e-mail 
or call Steve Janowiak at (312) 231-8851.
Attendee List
Sort by: Date | First Name | Last Name
When & Where
Marriott Downtown
540 Michigan Avenue
Chicago,
IL 60611
Saturday, September 20, 2008 at 9:00 AM - Sunday, September 21, 2008 at 5:00 PM (CT)
Add to my calendar
Hosted By
YREP of Chicago (www.yrep.org)
www.yrep.org
