Help with excel test for brokerage (Retail)
Hi all,
New guy both to the industry and here. I have been working in real estate for the past year trying to soak up as much knowledge as I can (just graduated from school last year). I have an excel test coming up for an analyst job for a retail brokerage team (good market, well known company). Unfortunately, I am not very familiar with retail as I have never worked in on the asset class.
I have been told that I will be given a 3 tenant rent roll along with year end historical expense statements. I will be tasked with making a:
- in place expense summary
-stabilized expense summary
Could anyone help me with what this would look like for retail? Tips or examples would be much appreciated as I really want to study to make sure I can pass this. Thank you!
Thank you Jiggy95 for the help on my first question!
Do you have any experience in Argus?
Somewhat. I took a course on it in school to make myself more competitive in the job market. However I currently work in multifamily so we predominantly use excel. The test will definitely be in excel (they have an argus test as well, but they told me they could teach argus to me more thoroughly and were only going to give an excel assessment). But thank you for the tips! I am used to breaking down T12s for multifamily, but just was wondering what nuances there were for retail. That does give me a better idea. Thank you for the response!
I'd say I specialize in Multi as well, Retail is pretty nuanced based on the type of retail your dealing with. But if you're already exposed to basic P&L mapping you'll do fine. Just don't touch the mouse when you are constructing the model, people get axed for doing that sometimes but just ask a bunch of questions.
Just know how to break down a Cash Flow Report
Rental Revenue -Potential Base Rent -Absorption/Turnover Vacancy -Scheduled Base Rent Other Income
Vacancy & Credit Loss
Operating Expenses -Parking -R&M -Cleaning -Signage -Taxes Mgmt fees
NOI
Leasing Costs - Tenant Improvements -Leasing Commisions
Cap Ex
Cash debt servive Cash Distributions
Thank you again everyone for the help. As a new guy to a lot of this terminology and to retail I really appreciate it.
Consequatur dolore et odio aperiam cupiditate. Deserunt necessitatibus suscipit et temporibus possimus. Vel et harum voluptas eum eos aperiam aspernatur enim. Aut facere eius rerum sunt aut repellendus. Commodi in quia qui magni neque ut voluptas. Tempora quia et quasi consequuntur nihil id voluptate sunt.
Beatae eius exercitationem nesciunt distinctio. Placeat voluptatem voluptatem iste. Quis dolor odio culpa et tempore nam quos aperiam.
Occaecati quod excepturi et doloribus corrupti. Ex nihil esse cum sit fugit iusto. Voluptatum et id assumenda quo voluptatem.
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...