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 →
Here's what's new with Valuate this month: 1 - a lightning-fast single-screen apartment property acquisition Back of the Envelope analysis mode, with sensitivity tables (see it here) 2 -... read more →
Learn more about REFM Certification In Excel For Real Estate here; it's a great way to learn/sharpen your skills and add to your resume and LinkedIn profile. More than 1,500... 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 →
Here's what's new with Valuate this month: 1 - a streamlined "Flip" mode that allows you to model out investments with a timeline of 2 to 12 months 2 - the... read more →
It's long overdue, but better late than never. Get your free Excel for Mac most commonly used keyboard shortcuts PDF one-pager here. You can get the Excel for PC version... read more →