Advice on modeling knowledge for an Asset Management role?
I have an interview next week as an Asset  Manger. I’m unsure what the interview will consist of, but I’m trying to sharpen my excel/modeling knowledge prior to the interview. 

To those who have worked as an AM at an owner operator, what type of modeling do you use frequently in excel? What are some calculations or models I should be familiar with? Anything related to rent roll analysis, budgeting, or property operations related.

Thanks
[{"id": "i6hdci2", "text": "I worked as a Pm (called asset manager in diff companies ) and a good basic knowledge of excel was sufficient. Nothing super fancy\n\nMost of your reports will be generated by a pm software with Yardi being one of the most popular at least in my market. My opinion is they will care about you knowing how to operate the pm software that generates reports to excel. \n\nI would say overall have a good understanding of the operations of commercial real estate from property management, accounting ( not cpa stuff but rent roll, rent bump, reconcialtion of accounts, collections, etc) and maintenance. It\u2019s also proper to understand the relationship to the owner(s) and their expectations of how they expect their asset to be run.", "replies": [{"id": "i6hr2tz", "text": "Thanks for sharing! I\u2019m certain they\u2019ll have a software they utilize specifically. The job description outlined needing \u201cexcel modeling\u201d skills. I can get around excel easily enough, and know how to make a dynamic proforma, amortization schedule, project simple cash flows, and calculate IRR. \u201cExcel modeling\u201d is just such an open ended term and I\u2019d hate to get blind sided by something and it cost me after making it through the first initial phone screening with HR", "replies": [{"id": "i6ht6xd", "text": "I\u2019ve honestly never heard of that term in regards to asset managing. (I\u2019ve worked with large brokerages and the small boutique brokerage)Is this an asset manger analyst type role?", "replies": [{"id": "i6hth2a", "text": "Yes it is! Im assuming they are wanting the individual to build out a model in excel to evaluate leases, cash flows, etc", "replies": [{"id": "i6hucov", "text": "Ah ok! Another different field all together. I mean listen I\u2019d do this with a role to get some direction. I have my real LinkedIn account and then a faux account where I can glance at people for these type of reasons (as LinkedIn notifies ppl looking at your profile) look up the company and even someone in the role you are doing or a manager of said dept. if you have their info. Someone will have a good description of what they do as an analyst (you may have to dig). It\u2019ll give you better direction for the companies needs. Google YouTube and do research from that. Good luck on the interview. You got this!", "replies": [], "depth": 5}], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "i6he964", "text": "I\u2019m self-taught and manage my own properties. The main things I look at are what-if scenarios for rent increases vs occupancy changes. The other day I was looking at gross revenue per resident over time and projecting how that would look 2-3 years out.", "replies": [{"id": "i6hh6ia", "text": "How different is it for debt AM?", "replies": [{"id": "i6hj8k5", "text": "I\u2019ve never done that but my guess is you primarily look at is reserves and DSCR, maybe potential changes in insurance and property tax if there have been any disasters and/or assessments.", "replies": [], "depth": 3}, {"id": "i6hj956", "text": "I\u2019ve never done that but my guess is you primarily look at is reserves and DSCR, maybe potential changes in insurance and property tax if there have been any disasters and/or assessments.", "replies": [{"id": "i6hri4d", "text": "I\u2019d say that is correct. DSCR is what banks will underwrite to, likely wanting the property to be covering at a 1.20x. NOI/Loan Payment = DSCR. Gotta pat the bank before counting out what you\u2019ve made", "replies": [], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "i6hfsvt", "text": "I work in asset management at the analyst/associate level. I feel like the day is always a little different, but I think the most typical analyses I do are a lease analysis to compare potential lease terms to budget/underwriting  and hold-sell analyses to project returns and determine the asset strategy going forward. Definitely important to be able to prove out whether a lease is a good deal and the impact it has the property.", "replies": [{"id": "i6hqrgm", "text": "Correct me if I\u2019m wrong, but it sounds like you\u2019re in retail or mixed use asset class?", "replies": [{"id": "i6itcnd", "text": "I actually work mostly on office assets, but I also work on a handful of retail, MF, and hospitality assets.", "replies": [{"id": "i6j72ex", "text": "Very nice! Sounds like a great role with a lot of exposure to different assets", "replies": [], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "i6hrbw8", "text": "Be able to create or work through a discounted cash flow model in excel. Know how to calc cash on cash, equity multiple, yield on cost, value of a property with a cap rate. Helpful if you understand how to calc and comp property tax wherever they are operating.", "replies": [{"id": "i6hrtsa", "text": "Discounted cf model I can get thought, and I\u2019m familiar with cash on cash calcs, as well as determining property value with cap rates (including projecting cash flows and using cap rate to project future value with appropriate assumptions). Unfamiliar with equity multiple and yield on cost so I\u2019ll have to dive into that.", "replies": [], "depth": 2}], "depth": 1}, {"id": "i6jjcr2", "text": "Assuming AM role oversees/interfaces with PMs/Acct/Leasing/ConstMgr...\n\nIf it's on the equity side, at a minimum:\n\n\\- Lease analysis (proposed vs budget or uw)  i.e. net effective rent and property value\n\n\\- TT analysis (i.e. credit)\n\n\\- Hold/sell analysis using Argus and Excel (i.e. partnership waterfall, before/after tax IRR) \n\n\\- Budgeting/forecasting cash flow\n\n\\- Refinance analysis\n\n&amp;#x200B;\n\nIf it's on the debt side, at a minimum:\n\n\\- Borrower credit analysis\n\n\\- DSC/yield/LTV analysis\n\n\\- Understanding and being able to speak intelligently of risk ratings (PD and LGD)\n\n\\- Refinance analysis\n\n\\- Collateral analysis\n\n\\- Amortization/prepayment/interest rate swap analysis\n\n\\- Analyzing budgets/quarterly/annual statements", "replies": [{"id": "i6juhiu", "text": "This was really insightful. Thanks so much for sharing!", "replies": [], "depth": 2}], "depth": 1}]