Hey all,
For everyone that wanted a case study, I thought I would help out and post a list of Case Studies that Kahr just put on LlinkedIn.
May 11, 2020May 11, 2020
Real Estate Modeling Course
- Real-life RE Modeling Tests from actual Interviews
- Various asset classes including multi-family, commercial and more
- Huge discount - until more tests and cases added
Related Content
See morePopular Content See all
Total Avg Compensation
June 2021 Investment Banking
- Director/MD (9) $911
- Vice President (35) $364
- Associates (202) $234
- 2nd Year Analyst (115) $151
- Intern/Summer Associate (97) $145
- 3rd+ Year Analyst (27) $145
- 1st Year Analyst (420) $131
- Intern/Summer Analyst (338) $82
Related Events See all
Comments (38)
Awesome resource!
For anyone who is wondering - he said in the post that he is working on compiling the answer keys for these so keep an eye out.
Hey. It's me (Josh Kahr). That's the plan... will do in June or so... I'm busy with other stuff right now. If you have any you want added, email me.
This is great! Thank you!
Out of curiosity, can you do these in Excel or do you need Argus? I flipped through the first couple and those seemed doable without a license.
most if not all should be excel
-
- Learn more
- | Suggested Resource
Learn More300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.
Learn moreFrom a quick skim through, all Excel. The most complex stuff I saw are waterfalls, base year stop recoveries (super easy to model in Excel), and % chance of renewal.
Argus modelling tests are actually quite rare from what I know.
All Excel.
Its funny, the most simple one except if a one hour time constraint is the final one.
anyone get a hand of the solutions?
Could someone comment here solutions they're getting that he says are correct?
Super cool stuff! anyone know if similar resource available for PE?
Haven't ever modeled acquisitions with TI/LC. Looking at the 2nd case study balsa construction. Would you have the TI/LC money come out day one even though its not actually getting paid until months 8 and 15?
no, mechanically it would be either a negative cash flow in month 1 and 15 or year 1 and 2 respectively. But if the NCF for those periods is negative you would need a cash flow reserve that would be capitalized in the sources and uses to either meet a hurle requirement or the dscr requirement. Happy to explain further.
Thanks, that makes sense conceptually but I'm struggling with thinking through how to model it. If those charges hit still during a development or cf negative period I'd know how to set up a draw but not sure how it works when the property is already cf positive.
Awesome, thank you kindly
Any update on the answer keys? Thanks again for everything!
Any update on when the answer key will be public?
Array
Hey guys, I've pretty much worked through all of them, almost done with Black Capital. PM if anyone needs an unofficial 'answer key'
Hello, I would be really interested for your unofficial "answers keys" for the "challenges cases" since I cannot find all of them on Kahr's website. It would be really helpful for me as I am trying to prepare for CRE Interviews. Thanks!
Any update on the official answer key?
Any update on the official answer key?
he's posting the answer keys one by one, rather than all at once. he just uploaded the first case, Abascus, last week.
Where is it posted?
Array
Hi All ~ if anyone has the unofficial answer keys from personal attempts, would love to connect to cross check my attempts / understanding (I'm a newbie to RE modeling). Please PM!
Check PM :)
Approx how long did abacus and balsa take for you guys? I'm a newbie so just wanted to see how my skills compare
Bump. Also he just added answers for two more case studies
Bump
Anyone have any of the answers to some of these? These look great, coming from corporate banking background so a little lost lol
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 Want to Unlock by signing in with your social account?