Creating a BOV model with shortcut

We're gonna build a quick back of the napkin model for a Los Angeles real estate broker to quickly analyze deals.

Now, I'm gonna go over to my AI girlfriend Claude, where I had already created a prompt for this.

We're gonna plug it in and we're gonna watch Shortcut go to work.

Shortcut AI, which is an Excel super agent that can effectively do anything within Excel.

We could build pro formas for any asset class.

We could build comparison models, any type of models, or Excel work we could do utilizing shortcut.

We could extract P, Ls and OMs and rent rolls and essentially whatever we want.

Now I, I just have the free version of shortcut AI here.

So you get 250 daily credits.

But let's put it to the test here.

We want to create a professional dynamic back of the envelope BOV analysis Excel workbook for multifamily divestment investment opportunities in la.

we gave it a bunch of criteria as well.

And so we're going to watch Shortcut go to work.

I will hit send there and I'll just talk you through what is happening here.

Essentially it's, it's going to understand the task first and then what it'll do is create a to do list, for us here, which we could easily just keep track of.

Shortcut is 1 of 2 Excel super agents that I use.

Hang on, it's just asked us some qualifying questions here.

Which, which it's great.

for the unit mix input, how would you prefer to structure it?

simple table with unit type rows, detail table.

Either is fine.

That's nice that you could just select a button versus typing in for operating expenses.

Would you like to input both options single total line?

Yeah, the more the better.

Right?

What default hold period should the model use?

Let's use five years for the sensitivity analysis.

Which variables are most important?

Let's do all of the above.

And then what's nice, it's, it's asking any specific branding colors you'd like me to use.

So maybe you could put in your, your logo, your brand colors, all that good stuff.

Waiting for clarification here.

We just gave it.

It it's good.

The more of an understanding that it has this, the, the better the model will be.

obviously we want to build it specific to our needs.

so let's just watch it go to work.

I think it's only going to use 50 credits for all this, which is nice.

So that Means we could do five similar type tasks for free per day, which to me feels like quite a bit.

So that's great.

Shortcut AI also has a prompt library.

So I think what's so interesting about these tools is it levels the playing field.

What I mean by that is that the barriers to entry for underwriting for all this, are, are so much less.

Watch it go to work here.

I mean, it's already built these tabs.

Boom, boom, boom.

we're keeping it simple in this particular case, but it looks like it's going to start with the input, assumptions, and then it gave us 10 tasks that we're going to do here.

So once all that's done, we'll be done here.

but going back to what I was saying, if I could find my train of thought, yeah, so you could effectively delegate a lot of the underwriting tasks to folks that are maybe not as qualified as an analyst, but now have the tools and resources to be able to do a lot of this.

What I mean is that if you have a va, an executive assistant, anybody for that matter, maybe they don't even have a real estate background, you could have them underwrite deals or at least take a first pass at underwriting deals with this software, which is so great.

What I also like about the software is that you're not, you're not abandoning your existing workflows and processes.

Right?

You're not learning another interface.

This is all in Excel, which we have known to come, have come to know and love.

8 Contact context is the AI's memory of your conversation.

When it runs low, agents responses can degrade.

Start a new chat to continue with the fresh contact.

That's all fine.

review changes.

So it's working here, it's working hard.

How beautiful that is already, like right out the gate.

So awesome.

And you can see all the work that it's doing, all the different cells it's building.

Input sheet looks thorough and clear.

Moving to detailed pro forma.

So now it's going to start building right here.

And it moved on to task two.

As you can see, and here we go.

Now these take a little bit of time to build, but relatively speaking, no time.

In other words, if I'm taking a crack at building this model myself, or even an analyst who spends all day in Excel, I assure you they're not done building this input tab or making this type of progress.

It's not possible.

I mean, this is like PhD level capabilities in Excel.

In Excel, it's a plugin as well.

So I mean, we're on their website here, but this plugs into your actual Excel.

If we were to open that up separately.

so again, those that have been following along for some time now know that I'm a firm believer that the tools that integrate seamlessly with our existing workflows are the tools that are winners.

This is a winner.

And watch, we have some of these division errors.

All that's going to get cleaned up.

It'll do.

All that for us might just be a zero division error.

Yeah, so anytime you divide by zero, you'll get that.

But, it's working.

So next it's going to calculate investment returns and pro forma analysis.

Cash on cash returns.

Bang, there it is.

I'm gonna stop playing around with it.

We'll come back once it's ready.

But just watch how beautiful this is gonna look when it's all said.

All right, so we're pretty much done here.

What it's actually doing is final verification.

So it's going through every single formula in cell just to make sure that it works and there's no errors, which is great.

You have the option of skipping that verification, if you'd like.

I wouldn't recommend it.

unless you wanted to go and battle test this yourself.

it didn't take that much time.

I'd say about 10 or so minutes total, maybe a little bit longer.

I don't know what the math is on however many seconds that is.

12 minutes, maybe, tops.

But look what it's built.

All right, so here's our executive summary.

Okay, and how do I move this off?

Let's push that off to the side.

Yeah, look at this.

All right, so it's built us charts, move a little slow here.

color coded, formatted perfectly.

Here's our input assumptions tab as well.

So this is where everything goes in as inputs.

Wonderful.

Pretty robust page here.

It's straightforward, easy to use, obviously.

blue being, you know, where do you input is my guess.

Yep, so it seems.

Closing cost percentage, that's all fine.

So we fill all that out.

Here's the pro forma analysis here.

looks like it did 10 years.

We have a IRR calculation helper on the side here, whatever that is.

got our cash flow, all of our key metrics.

Look how easy this is to read and understand.

exit analysis, investment return summary, additional metrics.

And then we have our sensitivity analysis as well.

All Formatted beautifully, here, but really, really just easy to build professionally done.

I mean this is something if you're going to do yourself would, would take a very, very long time to do.

longer than, than we just saw here.

What's great too is, I mean you essentially do anything else while this is all happening too.

So again, AI I believe is here to multiply our capabilities, not replace anybody.

But instead of me spending the time building something like this, right.

I could have AI do it even better than I could and be jumping into something else.

Now if you're a broker and you know, you need to build something like this, like go make cold calls while this is happening, come back, check it out.

Right.

It appears this is done.

No, it's still verifying anyways, really thorough verification process which is great, but really, really great use case.

Now this was just multifamily.

Let's, let's assume, you know, there's other asset classes which maybe you don't have as much of an understanding for.

Industrial retail, whatever it might be, we could build these models so easily it levels the playing field, lower barrier to entry.

this is a game changer whether we like it or not.

So and, and for underwriting, you know, the existing deals, this makes it a lot easier.

Again you could delegate to an assistant effectively.

They could underwrite this stuff, add the OM into here, bang bang, have it fill out all of it out.

so the use cases are endless.

This is a really exciting tool to have in the arsenal.

Check it out, play around with it.

You need to be using it even if you just want to use it to extract rent, roll and P and L data.

This is a no brainer.

So really excited about this