Watch Me Model a Real Estate Private Equity Technical Interview Exercise in Excel

Thanks! Share it with your friends!

You disliked this video. Thanks for the feedback!

Added 4 years ago by andem

4 Views

Warning: This video is long and boring! But, if you're preparing for a real estate technical interview, you'll likely find value in it. Watch me complete what is an actual real estate private equity modeling test. Download the Excel file and follow along (see notes below for edits).

To download the Excel file that goes along with this video (both the finished version as well as a blank tab to follow along), visit: https://www.adventuresincre.com/watch-me-model-real-estate-technical-interview/

Join our comprehensive real estate financial modeling training program - the A.CRE Accelerator: https://www.adventuresincre.com/accelerator/

A Couple of Notes/Corrections:

At 21:20, the formula for the Loan Cash Flow should be Total Project Costs (row 22) minus Equity (row 26), not row 20 minus row 26. This error was fixed around the 26:00 mark, but was not made clear.

The formula in C21 that sums all Construction Interest for the entire development period [=SUM(G21:CR21)] got zeroed out somehow. I didn't realize this had happened until the 1:00:00 minute mark, when I saw my Levered Cash Flow line had equity contributions beyond when I'd expect. Adding the formula in C21 back, corrected the issue.