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.

9 Comments
 

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

Quam atque eos ipsa non et. Pariatur asperiores quasi harum eum nam.

Repellat voluptate vel sed similique sunt dolores nulla fugiat. Maxime sed quas adipisci nam.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (66) $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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
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...”