It's not really possible to string together a more painfully boring term than "spreadsheet auditing". Auditing is a painstaking activity that requires intense concentration, an obsessive attention to detail, and its only... read more →
We have blogged before on data tables. Their power and efficiency for sensitivity analysis is impressive. But setting them up 100% correctly is critical, because if you do not, they... read more →
On this week's Invest Florida podcast I discuss the top three categories of mistakes we make when running financial models on transactions. Check out the 40-minute audio interview here, and... read more →
Below is the Excel so you can practice (you will need to download it by clicking on the download icon in the bottom border). Don't forget to see our other... read more →
Some of the many nuances across these various development analyses. See here for a similar chart on condominiums vs. housing subdivisions.
Thou shalt carry a contingency line item Thou shalt not be arrogant Thou shalt not be careless Thou shalt not hard code numbers into a formula Thou shalt not promise... read more →
Read my thoughts on it here on the Fundrise Blog.
To save a partially-constructed formula, or to inspect a formula outside of the cell in which it resides, simply put a single quote mark ( ' ) in front of... read more →
Why careful due diligence is so incredibly critical to being a responsible, smart investor, explained by Wharton Emeritus Professor Peter Linneman.
We have old saws like this because they are timeless in their validity. Here are REFM's recommendations for writing and testing formulas in Excel before deploying them in your models:... read more →
