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?
Quia voluptas asperiores id doloremque occaecati eum. Repudiandae quia unde est est voluptate iste praesentium. Corrupti ab eos rerum quam. Ut vel tempora ipsa tempora non. Eligendi ex beatae facilis et. Dolores inventore asperiores occaecati repellat praesentium.
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...