ExcelCRE's profile picture. 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

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?

مثبتة

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

ExcelCRE's tweet image. 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

👨‍💻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'🧠


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?📉📈


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.


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.


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

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



Ever heard of the 1% Rule in real estate investing? This quick check helps determine if a rental property's monthly rent will cover its mortgage. Use #Excel or #GoogleSheets to calculate it easily! #RealEstateInvesting

ExcelCRE's tweet image. Ever heard of the 1% Rule in real estate investing? This quick check helps determine if a rental property's monthly rent will cover its mortgage. Use #Excel or #GoogleSheets to calculate it easily! #RealEstateInvesting

Rent roll management in #Excel can streamline your cash flow tracking as a #RealEstateInvestor. Automate due dates, late fees, and more with simple formulas!


Ever thought about visualizing your #RealEstateInvesting data? Use Excel's charting tools to spot trends in rental yields, appreciation rates, and more. A picture is worth a thousand words! #ExcelTips


Investors, are you making the most of depreciation? With #Excel or #GoogleSheets, you can easily track depreciation schedules for your rental properties. An essential for optimizing tax benefits! #RealEstate


What if we fell in love with Excel? That must be a saving grace right?

Hot take: Don’t fall in love from 22-29, there’s to much to lose. Your career will thank you.



New to #CRE? Consider bridge loans, a short-term financing tool designed to 'bridge' gaps between your immediate cash needs and long-term loans. It's like a stepping stone to help you secure that dream property while you arrange for traditional financing. #BridgeLoans #retwit

ExcelCRE's tweet image. New to #CRE? Consider bridge loans, a short-term financing tool designed to 'bridge' gaps between your immediate cash needs and long-term loans. It's like a stepping stone to help you secure that dream property while you arrange for traditional financing. #BridgeLoans #retwit

Still using IRR for evaluating real estate investments?🤔 Time to level up!📷 IRR assumes equal time intervals & same cash flows - not realistic at all. Enter #XIRR: it accurately calculates returns, accommodating varying cash flows and dates! #RealEstate

ExcelCRE's tweet image. Still using IRR for evaluating real estate investments?🤔 Time to level up!📷 IRR assumes equal time intervals & same cash flows - not realistic at all. Enter #XIRR: it accurately calculates returns, accommodating varying cash flows and dates! #RealEstate

Some believe #AI will automate #CRE valuation and underwriting, eliminating the need for complex Excel models. Do you agree, or do you think the human touch will always be needed? #Retwit


When deciding on a commercial real estate investment, which metric should carry more weight - DSCR or Yield? Make your choice and let us know why! #CRE

DSCR 💰 %0
Yield 📈 %100

صوت 1 · النتائج النهائية


Forecast with finesse📈, not just guesswork! Have you used the FORECAST.ETS function in Excel to predict rental revenue in your #CRE models. Comment "me" if would you find a step-by-step guide helpful!👇

ExcelCRE's tweet image. Forecast with finesse📈, not just guesswork! Have you used the FORECAST.ETS function in Excel to predict rental revenue in your #CRE models. Comment "me" if would you find a step-by-step guide helpful!👇

Loading...

Something went wrong.


Something went wrong.