, , ,

Real Estate Financial Modeling Accelerator (Updated Dec 2020)

Since starting A.CRE, Michael and I have fielded email after email requesting a more structured real estate financial modeling training program on the site. Over the years, we've covered hundreds of real estate modeling topics in our blog,…
Sources and Uses
, , , ,

Construction Draw and Interest Calculation Model (Updated Nov 2020)

I originally uploaded this equity/construction loan draw and interest calculation tool to our library of real estate financial analysis models in 2016. Over the years, I've continued to update it as suggestions, comments, and requests…
, , ,

Commercial Mortgage Loan Analysis Model (Updated Nov 2020)

Over the years, I've received various requests to augment our library of real estate Excel models to include a model for underwriting and analyzing commercial mortgage loans. Specifically, people have asked for a tool to calculate the loan amount…
, , ,

Getting the First Job with Julio Villalobos-Torres – AiA

We get a lot of questions here at Adventures in CRE about how to "get the first job." Many young professionals breaking into the market struggle to do just that. Jobs available often require experience and or connections - things that new professionals…
, , , , ,

Using an IRR Matrix to Determine Hold Period

When building a real estate financial pro forma, it's important to model for and include a summary of various return and risk metrics. Among the different return metrics, the internal rate of return (IRR) - both on an unlevered and levered…
,

DateDif: The “Secret” Excel Formula (Updated 11.14.2020)

For one reason or another, there is a perfectly functioning and pretty valuable formula that can be utilized in Excel that Microsoft has chosen to exclude from Excel's list of functions: the DateDif function. This function is a valuable…
bite-sized real estate tutorials
, , ,

Bite-Sized CRE Lessons – A.CRE 30 Second Video Tutorials

As we continue to build out our A.CRE 101 series and our Glossary of Commercial Real Estate terms, we've started to supplement these initiatives with short (<30 second) video clips on how to do various CRE calculations and modeling tasks…
, ,

Glossary of Commercial Real Estate Terms (Updated Nov 2020)

Glossary of Commercial Real Estate Terms Welcome to the new Glossary of Commercial Real Estate Terms on A.CRE. This will be an ever growing list of commercial real estate terms and definitions and we hope it will become a valuable resource…
,

Texas Christian University – Undergraduate Real Estate Profile

I entered TCU with curiosity about Real Estate and solidified that interest by becoming involved with the TCU Real Estate Club and attending all the events they put on. Being in the business school, after I completed all the core classes…
, , , ,

A.CRE Apartment Development Model (Updated Nov 2020)

For several years now, our library of real estate models has been lacking a robust ground-up apartment development model. Sure, our All-in-One (Ai1) model has the capability to model multifamily development deals, but it's more a generalist…
, ,

A.CRE Mock Interview Workshop – Guide for Interviewers and Interviewees

The following is a guide for interviewers and interviewees scheduled to participate in an A.CRE co-sponsored Mock Interview Workshop. If you're a volunteer interviewer, thank you for taking the time to give back to students pursuing a career…
,

Texas Tech University – Undergraduate Real Estate Profile

Growing up in Corpus Christi, Texas I had little exposure to real estate until I became interested through books and the internet during high school. My first exposure to real estate was the writings of Robert Kiyosaki and John L. Bowman.…
, ,

Graduate Real Estate Series: Harvard University’s Master’s in Real Estate Program

When I was applying to graduate schools, I was focused on the real estate programs at Harvard, Columbia, and the University of Cambridge and a few misc. MBA programs (Yale SOM and Tuck). The MIT RE program is for much more experienced people,…
, , , , , , , , , , , ,

All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated Nov 2020)

As many of you recall, in 2015 I set out to build an Excel alternative to the widely-used (and now discontinued) ARGUS DCF. With career moves and a lot of other A.CRE-related side projects, this undertaking has been slow going. Alas, in 2016…
, , ,

Evolving your Career as a Young Professional with Greg Astor – AiA

Being young and just out of college is a shared experience of many of our listeners. Breaking into the industry and continually evolving your career as a young professional is an important thing to know. This episode talks about exactly that. In…