Hey everyone, I have to fully understand this financial model for real estate. My main experience are doing DCF's, Comps, and Project Finance. I understand the flow and "big picture" of this model. But I'd just like to have a more thorough understanding of the flow and how they relate to each other.
If you could explain how each sheet / section links to the other that'll be great. Like if you we're to rebuild this model from scratch, what is the sequence in which you'll build it?
(i.e. for DCF you get historical financials, scrub the financials, project income, then project balance sheet, then project cash flows, then plug in the supporting schedules (i.e. working capital, depreciation, amortization, etc).
I feel like this is your homework you want us to do.
But holy cow, is that one involved workbook. If you have specific questions I'll chime in. But in the mean time maybe another user would hold your hand on this. Personally the dashboard is very not user friendly.