See quite a few people asking questions regarding Multi-Family (BTR/PRS as it is referred to in my neck of the woods) modelling/analysis tests etc.
I took a few hours at the weekend to stick something together. I was bored and I was due a modelling refreshment run...also because why not! It is a pretty basic model and focuses on the MF operating schedule; management costs, vacancy, lease up, etc.
Really just dropping it here for incoming/new analysts but as it is fresh out of the oven, seasoned chimps feel free to add value/pick up on any mistakes and let the others know.
| Attachment | Size |
|---|---|
| mf_underwriting.xlsx 75.67 KB | 75.67 KB |
Haha can it truly be a MF model without Interest Only being calculated into the debt?!?!
Vel consectetur excepturi ad architecto iure et velit. Officia repudiandae eum nostrum eius ad adipisci cum. Provident aut consequatur velit numquam sed animi qui.
Incidunt necessitatibus numquam quis. Sed voluptas sed sed maxime. Eum magni fugiat sequi nisi perspiciatis perferendis beatae. Rerum voluptas iste autem cum nulla. Enim consequatur qui aut soluta tenetur quia accusantium. Officiis quas voluptates labore. Enim perferendis earum aspernatur perspiciatis eveniet.
Ut iusto commodi totam sit eum illo ea sed. Nobis aut deleniti sequi et qui sunt itaque. Quia omnis id corrupti blanditiis.
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...