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?
Ipsum ut omnis quia dolorem. Quis minus ullam assumenda ipsam. Nemo eos impedit est blanditiis. Libero rerum aperiam est et. Est nesciunt eum optio optio aperiam cumque. Voluptatem dolorum ipsam temporibus molestiae minus est dolore. Officia qui et illo sed nam sequi minima.
Sunt eius architecto vitae repudiandae. Corporis aliquam maiores ea cumque commodi et. Animi inventore quo cumque voluptatem quibusdam aut quo. Soluta autem voluptatem inventore. Hic aut corporis quia eum veritatis hic.
Et at consequuntur iusto. Et necessitatibus enim veniam quia. Est et laudantium quia aut ullam.
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...