How to Convince My Boss to Include Excel Modeling Into the Job?
What's up everyone, first time post here.
So to summarize, I currently work at a large real estate firm and work as an analyst in their multifamily department. My job mainly entails managing a large portfolio of mortgage loans and monitoring/reporting their operating statistics, as well as analyzing their cash flows, balance sheets, etc. Some site inspections and I may be getting the life co. loans in my portfolio pretty soon. But overall, pretty basic work once you get the hang of it.
This is my first job out of UG and I took it because of the company's size and resources. I want to continue in capital markets but I see all over here and job postings that financial modeling is almost a must-have once you are in the working environment. Now don't get me wrong, I know how to model in Excel from internships and my real estate finance class taught us Argus Enterprise as well, but at my current job we just DO NOT do any modeling!
I reached out to my boss last week and asked how we could incorporate modeling into our job function and he said to do some research and see if it would be compatible. If so, then we bring it to the actual boss who could approve or deny. Now from my research, I know that multifamily modeling can be done, but I have read that there is no need for it, not worth it etc. Does anyone know how this would be possible? We have an underwriting team in our office and I know that they do model, so I don't want to suggest to the boss we incorporate underwriting, cause then he'll just tell me to go there.
Can we forecast their actual cash flow statements? Interest rates for variable rate deals? Perhaps, group the properties by borrower and project a "mini-portfolio" within my own portfolio? Personally, I have a good amount of deals in my portfolio where Blackstone is the principal, so could we maybe project borrower cash flows if that borrower notable or has many deals/high UPB or some sort of benchmark? I'm really just looking for any type of financial data to forecast that proves to be beneficial.
If anyone has any advice on how I can go back to my boss with a plan on how to incorporate some sort of financial modeling (Excel) into the job function, that would be awesome. I want to gain more exposure to it because I know it is a skill required basically everywhere and I also know that other loan portfolio analyst positions do financial modeling and I would love to know how we can try to get that at my firm.