Junior analyst here: how do you handle endless OMs?

[u/AgencyWarm2572]

Hey everyone,

Just started as a junior analyst on an acquisitions team in CRE. Honestly, it takes forever to go through all the OMs I get in my inbox and then plug everything into our Excel underwriting model.

Is there any kind of AI tool out there that can actually help speed this up?

[u/mranomalous300]

This is a solid question cause I’ve thought about this as well, and in understand that automations can make this easier but it’s the how to get it there is the roadblock that I’ve come across. Like what specific prompts do I ask to get the most concise and accurate OM

[u/AgencyWarm2572 → u/mranomalous300]

This is why i post it, hoping to have better kickstart based on others experience

[u/dfwstars]

My company, Top Shelf Models, has this exact product. Upload an OM and it models it automatically into our template models. It takes roughly 3 minutes and you also get a dashboard with all of the OMs you have uploaded, maps, etc.

[u/AgencyWarm2572 → u/dfwstars]

my manager asks if we can use your own excel model or it is fix to yours?

[u/ocean_dream17]

The short term solution to your problem is to upload the OM to an AI assistant, ask to extract specific data points you need for your underwriting model and request the output to be in desirable format that matches your excel template. The medium to long term solution would involve the same ideas but automating the process using other tools like make.com, a LLM API and proper integration with Excel.

[u/AgencyWarm2572 → u/ocean_dream17]

I start explore n8b, look promising but there is still work to be done

[u/PrizeBlueberry4053]

OM overload is real!

[u/AgencyWarm2572 → u/PrizeBlueberry4053]

The crazy part is that there are so many startup-to building automation for deals to OM’s pipelines, so I believe we’re going to see an increase in OM’s over time.
i am truly afraid from that day

[u/PrizeBlueberry4053 → u/AgencyWarm2572]

OM AI extractors combatting OM AI generators...

[u/big_dataFitness]

Are you interested in just automation or you are looking for more ?

[u/AgencyWarm2572 → u/big_dataFitness]

for first automation would be goo. one step at a time

[u/No-Dare-7624]

If you use a LLM you will need to verify manually every result. Is better if you design a format of what data to store in a database, and later search. Can be done via a webapp. Can be done with google sheets, but depends on the amount of data.

[u/AgencyWarm2572 → u/No-Dare-7624]

the problem is how to extract the data from OM's
Each one is so unique

[u/DecoBase-Skyler]

Using a general model like chatGPT or claude will work fine, but you'll need to iterate a bit on the prompt to get it to work. Including an example of what you want your output to look like can be very helpful. If you are more technical, you can also try "structured outputs" that are available via their APIs.

You could also try https://www.decobase.app/, which works for this exact problem. You can upload OMs and get structured data back - optimized for CRE and automatically oganized onto a map. I'm the founder - feel free to dm me with any questions.

[u/AgencyWarm2572 → u/DecoBase-Skyler]

can it fill my excel underwriting model?

[u/DecoBase-Skyler → u/AgencyWarm2572]

Yes - you can export straight to excel and use the structured outputs in your own models.

[u/Outrageous_fellow]

Nothing that I would ever rely on

[u/apieceofcrab]

I use an AI app that does acquisition underwriting with PDFs, URLs or simple text in under 1 minute. How many OMs do you have to plug in your Excel on a daily basis?

[u/TurbulentCucumber709]

I would like to know what these OMs look like, because software exists to solve repetitive problems like these.

I just started a software company building tools for realtors.

I hope I'll be able to help build a software to solve this problem. You only pay once you feel the software is any good. I could also offer you free coaching if you like.

All that matters to me at this point is knowing what problems realtors face and how software could solve them.

DM me if you're interested.

[u/WaterSuccessful75]

Hey @AgencyWarm2572, I get you so much. This is why my business partner and I build a product to do this dirty work exactly. currently, it works best for acquisitions OMs and it works on high volume.

[u/Such_Necessary_5969]

Let me know if you need help. We build custom solutions combining n8n workflows with a react/typescript app to handle any kind of a need you might have. Parsing the right information is quite nuanced as is writing the right prompt and providing the right context.

[u/ChampionshipOk3382]

Dealground.com

[u/AgencyWarm2572 → u/ChampionshipOk3382]

wow! looking good i will try it
are you develop/ owner or user?

[u/FaldotheGolfer42 → u/AgencyWarm2572]

I can give you the run down of DealGround if you would like

[u/AgencyWarm2572 → u/FaldotheGolfer42]

u/FaldotheGolfer42 please do

[u/FaldotheGolfer42 → u/AgencyWarm2572]

Make an account on app.dealground.com and upload any OMs which will go straight into your own private database. The key data is extracted via AI and put into a database and you can search and filter via a map -based interface. You can also create a saved list of those very same properties (grouped and edited down to what you want) and export them to excel or share it via a link (with the pins on a map based interface) with a client. We've added title data as well (last transaction, owner, debt) to augment the OM data. This title data is available on all commercial address, not just on the OMs you have. We are making the exports better to - i.e. the entire rent rolls on multi-tenant retail is coming.

[u/ChampionshipOk3382 → u/AgencyWarm2572]

User.

Pretty rad