@hazardpolicy RE Model practice.

A few days ago, @hazardpolicy" posted an office acquisition model term sheet and I decided to build a model as well for practice sake.

As I was building the model, the term sheet seemed very vague and in some area very unrealistic( e.g rent.. I think they meant annual rent.. but forgot to mention it?). Regardless I built the model strictly following the term sheet provided.

I would love any feedback from anyone.

P.S I used AdventureCRE author's model template.

Thanks.

Attachment Size
model_pract.xls 1.89 MB 1.89 MB
 
Best Response

Only thing I can't find is where you took into account the exit point? I also think this is usually represented as a % (i.e. 1%) - just an fyi for formatting purposes

Also, I think it may have been better to keep all monthly cashflows on the rent roll tabl and then rolled up (using a sumif function or whatever) all monthly into a yearly pro-forma rather than have monthly c/f's on your "Inputs & CF" tab.

The question was also pretty vague on the leasing assumptions (we don't know how to escalate the other 2 leases) and the TI/Leasing Comm so I would have also just taken Y1 figures and multiplied through. PM me if you're keen to share models.

FInally, for CAPEX - if I sum all your c/f's you get to a value over $1m which seems rather high - I would have taken off the $200k at the beg of the year 0 (i.e. added to the upfront equity req.) and then divided the 50k by 12 for the remaining 3 years - not sure how other monkeys interpreted the CAPEX line?

"Average people have great ideas. Legends have great execution"
 

Recusandae qui non molestias sit. Quia facilis veritatis et quidem. Nulla neque dolores alias.

In architecto aspernatur dignissimos hic reprehenderit voluptates et. Exercitationem et beatae aut non possimus non. Qui maxime vitae rerum est.

Omnis labore voluptatem commodi optio quam voluptate. Enim officiis qui quas sed eius atque. Minus ipsa tempore explicabo velit optio. Quas officiis est ea temporibus quo nesciunt tempore. Eos facere autem ut fugit ea blanditiis libero repudiandae. Assumenda sed expedita sunt aut nihil reiciendis molestias.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 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

March 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

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $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
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
DrApeman's picture
DrApeman
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
kanon's picture
kanon
98.9
10
Jamoldo's picture
Jamoldo
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...”