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).
mar711 Hey man check this out!
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.
You're gonna have to be more specific with your questions if you want any actual help man...
At a quick glance, looks like this is a size up model. Cash flow and Rent Roll tab are the backbone of this model and all the other modules are for related analyses. Underwriter is using current collections to get base rent (from rent roll), but otherwise using the borrower's proforma on all other income/expense assumptions.
Total proceeds are on Fixed RA Sizing, RA Sizing, and Floater Pricing tabs, depending on which loan type the borrower wants to go with.
Solid SB for you brother. Thank you!
what the actual f
???? what?
Natus magnam vero libero voluptas reprehenderit ullam neque. Recusandae voluptatem iure quod. Tenetur mollitia et veritatis minima. Facere voluptatem ipsa et dolores. Et magni reprehenderit harum.
Vitae eum reiciendis itaque labore magni quaerat. Nihil expedita molestiae sequi itaque molestias. Voluptatum cupiditate saepe reiciendis et vitae natus et non.
Earum nihil esse atque maxime omnis quia aut. Est quasi veniam quos.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...