How long should It take to build a mf model from scratch?

Just asking because I’m practicing building models during school.

And just for further information I mean a basic multifamily development model with assumptions, construction draw, proforma, returns, and waterfall.

i just want to get an idea of how long it takes for someone who is proficient at this to do this(30 min, an hour, etc.). Again, this would just be for the most basic of multifamily development Proformas with a waterfall.

any insight would be much appreciated.



 

Totally depends on if you are building monthly or annually. And how much detail. For example, are you going to want to build loan covenant testing in, interest rate adjustments if the loan is IO for 3 years at 4.5% but amortization beginning year 4 is at 5.5%, fixed vs floating, choice for 30/360 vs Act/360 interest rates, etc. If you’re doing annually, and literally from scratch, probably 2-4 hours chances are if you have a development model as an interview round, you will have that amount of time. And they won’t expect you to build it monthly. 

 

I built about 10 Tabs from scratch on a timed take home in about 3/4 hours, having done it before and knowing almost to a T exactly what it should look like. Here are the tabs I used for a Multi-Family renovation plan without a Waterfall. Keep in mind I had to read an OM and be able to defend my assumptions. I basically backed into Broker assumptions changed some and then spent the last hour writing a 2 pages on what I thought. This was experienced position, so it was less about modeling and more about thinking about your inputs with just an OM given.

1. Inputs 2. Expenses 3. Rent Roll / units to be upgraded 4. Upgrades per month and Expected Revenue 5. Taxes (Knew the market) 6. Debt 7. Cash Flows 8.Summary Cash Flows (Comparing T-12/T-6/T-3 to PF 1 and then PF 2345) 9. Summary Page 10. Deliverables (Answering Case Questions) then moved this to the first tab.

But to be fair my first job in the industry, I didn't know shit. I had to build a Multi-Family revenue model with Yr 1 Revenue given Expenses given and be able to model growth with an exit cap rate. I managed to get it right, but I looked back on it and it was complete shit. 

I had a really good mentor and ever since that job I have only been told I smoked everyone in the modeling portion. I wouldn't worry about modeling skills in your first job, your boss is going to want it all to look his way anyway. Font, Font Colors, Highlight Colors what is bold what isnt, ect. He is going to seem like an asshole, but eventually after having all those excel tips burned into your brain you will be able to produce IC ready content from scratch in a few hours.

These models you are making for interviews are just to make sure you understand the concepts. I am doubtful anyone would use them on the job, the interview isn't going to care that you have something that looks different, but more that you understand the concept and you are someone they can teach.

 

Built out a basic waterfall model, probably put in 5 hours total. As someone else above mentioned, I have not seen a monthly model, I feel like that could be a bit excessive.

Array
 
Most Helpful

Dignissimos asperiores tenetur tenetur blanditiis. Consequatur deserunt at inventore enim quaerat cupiditate qui.

Nisi in magni sunt harum eius et. Debitis voluptas perspiciatis voluptas. Officiis asperiores alias rerum illum eius ex fugiat. Vitae nam aut saepe officia officia voluptatem unde. Sunt ipsam aperiam aut inventore. Sapiente maiores eos laboriosam enim qui ut quo.

In rerum cupiditate saepe distinctio. Perspiciatis harum architecto sed. Est officia praesentium delectus.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (20) $385
  • Associates (88) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (67) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
kanon's picture
kanon
98.9
9
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
98.8
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”