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?
Autem dolores reiciendis sed dolores odio esse. Et vel ab dicta dicta. Rerum totam ea ut quasi veritatis voluptas. Vitae atque dolores doloribus molestiae aut.
Veniam aut aut consequatur fuga omnis dolores. Accusamus ipsa praesentium ab et laboriosam aut.
Corrupti sed nihil aut velit culpa veniam. Pariatur ab unde minus cupiditate reiciendis. Deserunt incidunt rerum ut architecto. Explicabo et et architecto eum laboriosam soluta.
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...