Most important financial models to know?
Hey all,

I'm currently a marketing analyst looking to switch to the CRE industry as an analyst and my plan is to build a portfolio of sorts of example financial models to include with my resume when I start applying for positons. 


My question is which type of models should I focus on learning? Which ones will stand out and show I know my shit? Also as a less important question at the moment, what's a good way to find example information to plug into said models?


Thanks!
[{"id": "fa1ojzn", "text": "If you are wanting to do CRE and are concerned regarding formulas to sounds smart, do CCIM", "replies": [{"id": "fa1v0at", "text": "Not looking to sound smart, looking to build a skillset surrounding models that are relevant to the work I'll be doing.", "replies": [{"id": "fa1zut3", "text": "I recommend CCIM 100% then. I did the first level and change my view on CRE for the better", "replies": [{"id": "fa20nea", "text": "Ill definitely look into it. What did the total costs net out to for completing the first level?", "replies": [{"id": "fa2332u", "text": "You have to join CCIM website membership which is prorated if you decide to do it later in the year. I know for 2019 their prices went up but I think I paid like $1200 for the class. It was over a year ago so I don't remember the exact pricing but I'll tell you, completely worth it", "replies": [], "depth": 5}], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "fa1vqp2", "text": "Look into these courses, it has helped me a ton with underwriting and financial modeling. \n\nhttps://www.udemy.com/user/justinkivel/", "replies": [{"id": "fa5ms0j", "text": "Big fan of justin kivel! Just finished his CRE Investing 101 course. Any recommendations for other courses like his (for after I finish his)?", "replies": [], "depth": 2}], "depth": 1}, {"id": "fa25hzi", "text": "1. Rent Roll for Office &amp; Retail with lease terms and renewal assumptions. Example @ 7 mins https://youtu.be/vx7ChDkFFh4\n\n2. TILC model for tenants in Rent Roll.\n\nCost for a new tenant is:\n\n(Tenant Improvement Cost PSF \u00d7 New Tenant square Footage)\n\nLeasing Commissions would be something like\n(5% comission x rental rate PSF \u00d7 tenant SF \u00d7 # of years for tenant lease).\n\nIf you're using weighted averages for new/renewal rates then apply a weight of, example 70% renew, 30% new and you multiply these weights by TI\n (TI calculation with $10 PSF\u00d7 70%) + (TI calculation with $25 PSF x 30%).\n\nSame for Leasing Commissions but use 3% for renew and 5% or 6% for new.\n\n3. Underwriting model for Multifamily, Retail and Office. Feed in Revenue &amp; TILC numbers from #1&amp;2. Include debt service payments from #5. This is really nebulous and not very formalized in how you do this. Basically get 3 years of historical operating expenses and adjust the wild calculations out to arrive at an average or the previous year's amount plus 2% or so. Taxes and Insurance can be more accurately estimated but the others you have to use best judgement. For simplicity, group the various expense line items into a few groups (Repairs &amp; Maintenance, Payroll, Management, Taxes, Insurance).\n\n4. Discount rate/cap rate matrix for valuation ranges.\n\n5. Amortization table based on 70% of value from middle range value in #4. https://youtu.be/SE6VFlMjiwo\n\n6. Leveraged and Unleveraged IRR for said properties above given 30% equity.\n\n7. Preferred Equity Waterfall for duration of the hold period. https://youtu.be/OsEkz3Hahco\n\nOther good but albeit overly complex models (no one makes this complex of models unless you have a template and are required by a client or boss to do this detailed of a model)\n\nhttps://youtu.be/UtClU4WGrjQ\nhttps://youtu.be/KR2GhRmr00s", "replies": [{"id": "fa26myv", "text": "Oh and rule of thumb cap rates by property type, 9.5% for hotel, 8% for Retail and Office and 5% for multifamily. This is all very general and can vary here and there but this is a good start.\n\nAlso, just try to keep things simple. I often do a lot of side work and leave visible only the things that I absolutely have to. Neatness &amp; simplicity are best. Your job is to dig into the details so others do not have to. But, know said details if asked. After you have a good template, a model should take you anywhere from 3 to 8 hours.", "replies": [{"id": "fa5kcp7", "text": "This is an incredible amount of helpful information. I have a lot to unpack here but I really appreciate you taking the time to write it up and explain everything in such great detail.", "replies": [{"id": "fa66n2m", "text": "No problem man.", "replies": [], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "fa2hk1v", "text": "Just know Argus modeling, show an understanding of leases, and balancing valuation between cap rates, IRRs, return on costs, etc.", "replies": [], "depth": 1}]