Hey everyone,
I have a REPE Asset Management Analyst modeling test/case study coming up. Does anyone know what to be prepared for? I've prepared more for an acquisition type modeling test given assumptions and hold periods. What would an asset management test involve?
Any help is appreciated.
Thanks in advance,
| +51 | Leave brokerage to be GP | 12 | 11h | |
| +46 | New Comp Database - Google Form (Now with Data Validation) | 24 | 13h | |
| +24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 1d | |
| +23 | Going out on your own | 4 | 15h | |
| +22 | REPE/Development GPA | 15 | 3d | |
| +21 | Real Estate = complicated + underpaid | 15 | 14h | |
| +17 | Fisher Brothers | 6 | 16h | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 4d | |
| +15 | Spreads over SOFR/UST | 1 | 15h | |
| +13 | How to recommend a RE investment? (Interview help) | 3 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Hey there!
For a REPE (Real Estate Private Equity) Asset Management Analyst modeling test or case study, it's great that you've prepared for acquisition type modeling tests, as that foundation will certainly be beneficial. However, asset management in real estate can have its unique nuances, focusing more on the operational side of managing an asset post-acquisition. Based on the most helpful WSO content, here are some key areas you might want to prepare for:
Cash Flow Projections: Unlike acquisition modeling, which might focus more on the purchase and financing of the property, asset management modeling will likely require you to project cash flows over the holding period of the asset. This includes forecasting revenues (like rental income), operating expenses, and capital expenditures.
Lease Analysis: Understanding the lease terms, such as lease length, rent escalations, and tenant improvement allowances, is crucial. You might be asked to model the impact of different leasing scenarios on the asset's cash flow and value.
Refinancing and Disposition: Asset management often involves making strategic decisions about refinancing or selling the asset. You might need to model the impact of refinancing terms on the asset's cash flow or determine the optimal time to sell the asset based on projected future values.
Value-Add and Repositioning Strategies: If the asset management strategy involves improving the property to increase its value, you might need to model the costs and benefits of various value-add initiatives, such as renovations, rebranding, or re-leasing to higher-quality tenants.
Sensitivity Analysis: Being able to model how changes in key assumptions (like occupancy rates, rental rates, or interest rates) impact the asset's financial performance is crucial. This helps in understanding the risks associated with the asset.
Performance Metrics: Be prepared to calculate and analyze key real estate investment performance metrics, such as Net Operating Income (NOI), Internal Rate of Return (IRR), Cash on Cash Return, and Equity Multiple.
Remember, the goal of an asset management case study is to assess your ability to make informed decisions that will maximize the value of the real estate asset over time. It's not just about the numbers; it's also about demonstrating strategic thinking and understanding the operational aspects of real estate asset management.
Good luck with your modeling test/case study! Keep a cool head, and let your preparation guide you through.
Sources: Why Work in Asset Management?, Asset Management as a long-term career?, Asset Management vs Investment Banking 101, Is Real Estate "Asset Management" Considered Back Office?, https://www.wallstreetoasis.com/forum/asset-management/could-use-some-insight-on-careers-in-asset-management?customgpt=1
Hey there!
Preparing for a REPE (Real Estate Private Equity) Asset Management Analyst modeling test or case study is an exciting step forward in your career! Based on the most helpful WSO content, here are some insights and tips to help you gear up for the challenge:
Understand the Role of Asset Management in REPE: Unlike acquisitions, which focus on the buying process, asset management is about maximizing a property's value post-acquisition. This involves strategic decisions on property improvements, leasing strategies, and operational efficiencies.
Financial Modeling Skills: You should be comfortable with Excel and financial modeling. However, the focus might shift towards operational models rather than just acquisition models. This includes forecasting revenues (e.g., rent rolls), operating expenses, and capital expenditure projects to improve the asset.
Operational Analysis: Be prepared to analyze and make recommendations on property operations. This could involve scenarios to reduce costs, increase occupancy rates, or enhance tenant satisfaction. Understanding how these operational changes impact the financial performance of the asset is key.
Lease Analysis: You might be asked to analyze leasing agreements and their impact on the asset's financial performance. This could include evaluating lease terms, tenant mix, and lease expiration profiles to identify risks and opportunities.
Market and Location Analysis: Asset management often requires a deep understanding of the market and location of the property. Be ready to analyze market trends, competitive properties, and demographic data to inform your asset management strategies.
Disposition Strategies: Although the focus is on managing the asset, you might also need to think about the exit strategy. This could involve analyzing the optimal hold period and preparing the asset for sale to maximize returns.
Case Study Approach: Typically, a case study might provide you with a property's financial data, market information, and operational challenges. You'll be expected to analyze this information and present a strategic plan to improve the asset's performance.
Remember, the key to success in an asset management modeling test is not just about crunching numbers but demonstrating your ability to think strategically about real estate operations and market dynamics. Practice with real-life scenarios, review past case studies if available, and stay updated on market trends.
Good luck with your modeling test/case study! You've got this!
Sources: Why Work in Asset Management?, Asset Management as a long-term career?, Asset Management vs Investment Banking 101, Is Real Estate "Asset Management" Considered Back Office?, https://www.wallstreetoasis.com/forum/asset-management/could-use-some-insight-on-careers-in-asset-management?customgpt=1
In my experience in applying for junior AM roles, the tests are often the same as acq. They just want to see you understand concepts of real estate so I’m gonna guess it will be a simple acq model. However one test i saw for an AM role was a lease comparison - lease A is for xK sf and 5 years at $x.00/sf with $25 in TI but lease B is for yK sf and 4 years but at $x.75 and $30/sf in TI, which is more accretive?
Is there a reason you might choose one or the other besides the lease terms? (Answers: maybe one is a strong credit tenant like Google and the other is a mom and pop shop, maybe the lease-up timing of one fits the business plan better, maybe one is already a known vacate the but the other has a high likelihood of renewing, yadda yadda)
Thanks for the feedback. I figured it would be similar to an acquisition model, but maybe also incorporating a refinance, or sensitizing hold period to get the best target returns.
Good point on the lease comparison. This is for a multifamily firm, but same example can apply to a residential tenant minus the TI. Thanks again!
I recently took an AM role Excel Test. It was a massive sheet of 50 detailed T12s and I had to rollup all 50 of these properties into one excel table to find highest opex, lowest noi, etc... Gave up after 30 mins lol since I haven't done data summarization like that since college.
Yikes.... lol. I would've been in the same boat as you. Unfortunately, they have 50-60 assets so this could be possible. Gonna try to prep for this best I can. Thank you for the feedback.
Thats the spirit!
For context, was given 45 mins for this excel case study lol. Forgot to include that
That's doable if you have strong working knowledge of Excel. Granted, 45 mins is tight.
Roll up the line-item expenses into the relevant categories for each property using SUMIFS. This should also serve to standardize the categories and line up the data across the properties.
If the properties are each on separate tabs, that might even make it easier. In that case, I would use INDIRECT to dynamically pull from each tab and INDEX/MATCH or XLOOKUP to pull the relevant category expenses all into one tab/table. Then use MIN/MAX function to find highest and lowest. Or if I need to find from highest to lowest on a particular category, I would CTRL V+T to transpose the table so that I can sort highest to lowest/lowest to highest on any of the categories.
Nemo at assumenda asperiores eius. Illum nostrum laborum quaerat assumenda molestiae. Debitis eos mollitia qui suscipit id exercitationem quia. Omnis temporibus cupiditate voluptates.
Autem ea cupiditate sed eos non dignissimos. Voluptates hic reiciendis maiores qui dolores similique. Soluta quo vero voluptatem debitis accusamus hic.
Maxime voluptatem unde ipsam quia nobis officiis in. Assumenda dolorem consequatur repudiandae eaque quia ut quaerat. Doloribus quae repudiandae quasi est et exercitationem aperiam. Voluptatem sint quaerat ut.
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...