For over 40 years, Dr. Peter Linneman's unique blend of scholarly rigor and practical business insight has won him accolades from around the world, including PREA's prestigious Graaskamp Award for... read more →
We all want to work faster in Excel. That's why we take the time to learn keyboard shortcuts (get for PC | get for Mac). Beyond that and our formula-writing... read more →
This is the third in our series of mini-quiz posts (see here for the RE Finance 101 quiz) (see here for the Equity Joint Venture Waterfall quiz) Submit the form to receive the... read more →
This is the second in our series of mini-quiz posts (see here for the RE Finance 101 quiz). Submit the form to receive the solutions by email. Remember, your gut reaction is... read more →
This is the first in a series of mini-quiz posts. Submit the form to receive the solutions by email. Remember, your gut reaction is typically correct, so don't doubt your... read more →
Conditional, or "if-then" statements, are an incredibly powerful way to get Excel to do work for you. Writing them does require up-front investment, but the return on that time and... read more →
When you have a two-player equity joint venture partnership in a commercial real estate deal and there is a promote structure in place, you will likely end up with three... read more →
What a wicked web we weave. Ah yes, through all of our toil, we sometimes end up with a model that is just way too cumbersome to navigate and make inputs,... read more →
Some real estate transactions entail a "value add" strategy, wherein the property will receive at a minimum some cosmetic upgrades, and perhaps much more. Using an apartment building as an... read more →
The VLOOKUP function is used to return a value from one place in your spreadsheet into the cell where the VLOOKUP function sits. If you live your life in spreadsheets,... read more →