Value-add investing in apartment properties is the oldest play in the book for how to create wealth in the real estate game. While it's easy to get lost in... read more →
When faced with modeling a commercial real estate refinancing (replacing an in-place loan by taking a new loan), you don't always have to rely upon building out a 360-row tall amortization... read more →
Unfortunately for us, Excel requires that literally every new tab we create be formatted from scratch. It's pretty awful and painstaking work with which we are all too familiar. In... read more →
We have written before about job interview Excel modeling tests here, and wanted to provide a tip sheet as a complement to what we have already said. Here are our... read more →
It’s easy to get caught up in the excitement of purchasing an investment property and lose track of the basic financial equations that are necessary to ensure long-term success. One... read more →
As a newer agent in commercial real estate, how can you stand out from the more established agents that seem to have all the business? The answer is: financial modeling.... 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 →
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 →
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 →
Learn how to set yourself up for success in CRE investment! In this free E-Book, learn the top 7 elements to positioning yourself to succeed in the CRE business: define... read more →