Excel for CRE

A duo of a CRE & Excel wizard. Both ex-Big4, now innovating CRE with spreadsheets. Startup survivors and opportunity seekers. Did we mention that we love Excel?

[Excel for CRE @ExcelCRE]

1/n

Sam Zell, the high-stakes risk-taker who revolutionized real estate. His rise from humble beginnings to self-made billionaire is a journey full of twists and turns. Get ready as we unpack the fascinating life of this intriguing figure.
#SamZell #retwit

[Excel for CRE @ExcelCRE]

Compounding

[Excel for CRE @ExcelCRE]

Collary:
1. Unconscious incompetence
2. Conscious incompetence
3. Conscious competence
4. Unconscious competence

[Excel for CRE @ExcelCRE]

Level 1: excel with a mouse
Level 2: excel without a mouse
Level 3: analysis on a cocktail napkin
Level 4: intuition

[Excel for CRE @ExcelCRE]

Your reputation depends on it.

[Excel for CRE @ExcelCRE]

One deal is all it takes to change your life. It takes a great deal of responsibility to be able to properly execute. Make sure that you are willing to take that risk and put yourself in the hot seat of putting your own, and your investors capital on the line.

[Excel for CRE @ExcelCRE]

@ExcelHumor IndexMatch for the win baby

[Excel for CRE @ExcelCRE]

@GCiams Unless you can't due to tenancy laws 😂

[Excel for CRE @ExcelCRE]

@landisreal @realEstateTrent @FLRetailPro Welcome!

[Excel for CRE @ExcelCRE]

👨‍💻Quick and easy Excel combo to auto-format your data:
CTRL+A
ALT+H+O+I
ALT+H+O+A

OR

Code in:
"Sub Autofit()
Worksheets("Sheet1").Cells.EntireColumn.Autofit
Worksheets("Sheet1").Cells.EntireRow.Autofit
End Sub" into VBA and run it as a macro'🧠

[Excel for CRE @ExcelCRE]

@MarkMcGrathCFP If only you could add actual real estate in a tfsa lol, REITs aren't it

[Excel for CRE @ExcelCRE]

Mezzanine loans carry higher risk, being repaid after primary lenders but before equity investors. Hence, the rewards are greater too, often yielding a combination of interest and equity upside. So, how do you manage and understand these risks and rewards?📉📈

[Excel for CRE @ExcelCRE]

Diving into the middle layer of #CRE financing, we find mezzanine loans - a vital tool for bridging the gap in your capital stack. Imagine you're buying a $10M property. You have $2M in equity and a $6M bank loan, leaving you short of $2M. This is where a mezzanine loan comes in.

[Excel for CRE @ExcelCRE]

Trust your instincts when it comes to #RealEstateInvesting. After all, your intuition is the culmination of all your experiences and knowledge. But remember, intuition isn't a replacement for due diligence. It's a tool to supplement it.

So please use excel for the love of god.

[Excel for CRE @ExcelCRE]

@Rudolph_Cos 100% agree, would love to add a few to that list as well:
- DSCR Analysis Spreadsheets
- Acquisition (Valuation) Models
- Rent Rolls

[Excel for CRE @ExcelCRE]

@DangremondSam @nwsoco @CHFA Wow, those are better than our traditional loan rates. Congrats! 👏

[Excel for CRE @ExcelCRE]

@GRDecter The real question is if rent is understated or if housing prices are overstated. We personally think rental prices are simply unstated based on the past 3 year's inflation rates

[Excel for CRE @ExcelCRE]

@dtmorgan18 You could say they have a vested interested

[Excel for CRE @ExcelCRE]

Always important to have well organized excel models that provide you the most important metrics immediately. Toss away the napkins. Please.

[The Real Estate God @TheRealEstateG6]

How to quickly check a model

- Stabilized yield 200bps+ above market cap rate
- Stabilized price per key below market price per key
- NOI margin at/below market
- DSCR above 1.25x

If all 4 check out, you probably have a very good deal

[Excel for CRE @ExcelCRE]

@drippedIRR I choose txt

[Excel for CRE @ExcelCRE]

@EstateRanger Just because financial metrics such as IRR was not used in the past does not mean they are not effective tools today! Highly recommend you facilitate deals on excel 😉