Jake HellerApr 10, 2026
Create Offering Memos with NotebookLM 📝
Create Offering Memos with NotebookLM 📝
Jake Heller
Learn how to use Google's NotebookLM to create an offering memorandum for a broker. This tutorial demonstrates uploading due diligence files, including financial statements and property photos, and leveraging NotebookLM's AI capabilities to generate comprehensive documents.
Create Offering Memos with NotebookLM 📝
Jake Heller
Learn how to use Google's NotebookLM to create an offering memorandum for a broker. This tutorial demonstrates uploading due diligence files, including financial statements and property photos, and leveraging NotebookLM's AI capabilities to generate comprehensive documents.
Chapters
00:00
Intro to NotebookLM
Introduction to NotebookLM and its capabilities for creating offering memorandums.
00:43
Create New Notebook
01:14
Link Website Source
02:02
NotebookLM Features
03:39
Chat with Sources
05:49
Upload More Files
06:52
Files Uploaded
Transcript
00:00
All right guys, today we're looking at Notebook LM, which is a Google product.
00:05
It's actually unbelievable and it continues to get a lot better.
00:09
What we're going to do today is create an offering memorandum, for a broker.
00:14
The use cases are endless though.
00:16
You can create investor decks, you could put together lender decks.
00:21
Any type of deck, all can be done within NotebookLM and their, deck creating capabilities have just gotten so much better with time.
00:30
So today we're gonna showcase how if you're a broker, a client sends you a due diligence folder, how you can create an offering memorandum utilizing NotebookLM.
00:40
So the first thing you're gonna do, okay, is we're gonna create a new notebook.
00:44
All right?
00:44
And it's very— user-friendly.
00:47
It's very easy to use.
00:48
We're gonna upload a bunch of files.
00:50
And so here is our due diligence folder.
00:54
Okay.
00:55
Pretty straightforward stuff.
00:56
We got the whole works.
00:56
All right.
00:57
So this is an asset here in Los Angeles.
00:59
I believe it's a 14-unit building.
01:01
shout out to our boy Taylor at Vacan from the group CRE.
01:04
I'm gonna try something which I haven't done with NotebookLM.
01:07
Okay.
01:07
And you'll notice we have the groups.
01:09
Website open here.
01:11
Okay, so I'm actually going to link that website.
01:16
Okay, and my hope is that NotebookLM could pull some of the branding and information from that website when they're creating our deck.
01:26
So here you could upload any type of website link, YouTube URL.
01:30
You'll hit insert and, it'll get populated over here.
01:34
So now let's start uploading some of the other information that we have.
01:38
Let's upload our P&Ls.
01:40
Very easy to do.
01:41
Let's upload our rent roll.
01:44
Whoops.
01:44
Very easy to do.
01:45
And, I guess while those are loading, before we start loading up some other information, you'll notice on the right side here, there's a bunch of different things, okay, in the studio that you could do with NotebookLM.
01:58
Okay, you can create audio overviews.
02:00
And what's so cool is that you could customize all this stuff.
02:03
So what should the AI host focus on in this particular episode?
02:07
You could say whatever you want.
02:09
Okay, I want, you know, to focus on Los Angeles multifamily real estate, and all of your viewers are aliens in outer space.
02:19
It doesn't matter.
02:19
Okay, brief, critique, debate, all that information we can add there.
02:24
Okay.
02:25
You could also create a video overview, which is pretty remarkable.
02:29
I'm gonna focus today on just the deck generating capabilities.
02:33
You can also create a mind map, which is gonna effectively map out like all the different files you have.
02:38
It's incredibly useful when you have a bunch of different files.
02:41
Okay.
02:41
You can create these reports and you can create your own.
02:44
You can create a briefing doc, a study guide, a blog post.
02:47
It's gonna load some AI suggestions for us as well.
02:50
But here you could, I mean, describe any type of report you, wanna make and it's gonna reference all of those different sources and files for you.
02:58
And, it'll create that report.
03:01
Flashcards, all customizable as well.
03:04
You could do quizzes, infographics, the slide deck, which I'm gonna show you guys momentarily.
03:10
And then, also a data table, which is pretty cool.
03:13
So, you could also chat with all of your sources.
03:16
The same way you would with ChatGPT or with Claude.
03:19
this— we'll call it— I'm not going to say LLM, although it kind of is-ish.
03:24
but this is built on like your full data repository of all of your files here.
03:29
Okay, and so you could add sources and you could also search for sources on the web, which is pretty cool.
03:35
So if I wanted to say like, you know, multifamily market research, as of February 2026.
03:44
I could check the web.
03:45
I could do fast research.
03:46
I'll hit send and you'll see that it's gonna find some source files for us to add to our source database.
03:54
Voilà.
03:55
So we have a bunch of sources here.
03:58
Okay.
03:58
Stabilization signals emerge across the multifamily portfolio.
04:02
All this stuff.
04:02
Okay.
04:03
But I guess what I think would be more impressive— let's get out of here.
04:08
I think what would be more impressive— let's delete those— is if we did Los Angeles multifamily market.
04:19
Report February 2026, right?
04:22
Because we have a Los Angeles asset here.
04:24
So let's go ahead and hit search and see what comes of it.
04:27
Bunch of sources here.
04:29
Let's import them.
04:30
Why not?
04:31
Let's import a bunch of these source files.
04:32
Okay.
04:33
More information, the better.
04:34
And let's let that load and we'll come back and check on it momentarily.
04:38
All right.
04:38
So, checking back in here, that only took a minute.
04:41
Now we got all of these files uploaded.
04:43
Let's continue to add other files.
04:46
We have a bunch of photos.
04:48
Okay, let's add all these photos of the asset.
04:51
Drag and drop.
04:52
Boom.
04:52
And that should populate.
04:53
There we go.
04:54
Very, very good.
04:55
So we're gonna add all those photos and then let's see what else from our DD folder we got.
05:04
rent increases.
05:05
Preliminary title report, no files in there.
05:07
Property tax bill, all that's fine.
05:09
Service contract.
05:10
So I think that's it for the most part.
05:12
I have a couple underwriting scenarios.
05:15
I don't know if you could do Excel files.
05:17
No.
05:17
Okay.
05:17
So you cannot drag and drop Excel files into here, but that is okay.
05:21
So let's wait for these photos to get uploaded.
05:25
and we will come back in just a moment.
05:30
All right, so we got everything uploaded now as a source file.
05:35
And just to showcase the capabilities right here, you might say something like, what is this property we're looking at?
05:44
Okay, so you can communicate with it.
05:46
But again, we are focused on the deck.
05:49
So we're gonna go to slide deck and we're gonna hit this little pencil.
05:52
Okay.
05:53
And we could choose between two different formats, a detailed deck.
05:58
Okay.
05:59
Or a clean, with presenter slides.
06:02
Interesting.
06:03
key talking points to support you while you speak.
06:06
Maybe we could try both.
06:08
So let's do both.
06:09
Okay.
06:10
let's just say I am Taylor of Akin from the group CRE.
06:19
My website is, from the source file.
06:24
I need your help to create a new offering memorandum for our 559 Sunset property.
06:34
I sent you a bunch of photos, T-12 rent roll, and other information, including information on the Venice, California market.
06:52
Let's prepare a very professional Offering memorandum using the colors, branding, logo, and style from my website for our new deal here.
07:12
I'm just gonna copy that.
07:13
I wanna see the difference.
07:15
We're gonna hit generate.
07:19
Okay., and then let's try this other one here and just see what the difference is because I'm not totally sure.
07:26
But anyways, so yeah, we asked that question here so you can communicate what is the property we're looking at.
07:30
The property you're looking at is 559 Sunset Avenue Apartments, 14 units.
07:35
Good information.
07:36
You can click any of the source files here.
07:38
So that deck is working now.
07:41
We could also create this mind map.
07:42
I'm just going to show you guys some of the other features while the deck is being created, the mind map shouldn't take, too long here.
07:51
And it's just a helpful, easy way to understand and visualize your files.
07:58
So that's already done.
08:00
So this is what I mean.
08:03
Market fundamentals, vacancy rates.
08:06
Look at that.
08:08
Supply and pipeline.
08:12
Boom.
08:12
All that good information there.
08:21
Anyways, we'll delete that.
08:25
So there's really just so much that you could do.
08:29
And if— again, if you wanted to go find other sources, more sources on the Venice market, on the multifamily market, on interest rates, whatever it is.
08:37
You could search the web through here.
08:39
You could do fast research or deep research, okay, whichever you prefer.
08:44
Deep research takes a little bit of time, and then if you wanted to, you could integrate with your Drive.
08:48
So instead of looking on the web, you could look within your Drive at different files as well.
08:53
So pretty remarkable stuff there.
08:55
so let's come back when our deck is ready.
08:58
All right, so both of our decks are now done.
09:02
Let's take a look.
09:04
the first one right here, Consuela Venice.
09:06
Okay, so let's expand the viewer.
09:08
So this is deck number 1.
09:09
Pretty nice cover slide.
09:10
Look at that.
09:11
Wow.
09:11
The heavy lifting has been done.
09:13
Ownership has deployed over $562,000 in unit renovations and capital improvements.
09:17
Look at that chart.
09:19
Absolutely beautiful.
09:20
Macro timing, immediate lease-up.
09:22
Okay, wonderful.
09:23
The Consuelo Vision.
09:24
Interesting.
09:24
A completed high-end product in a market defined by scarcity.
09:28
Beautiful slides.
09:28
Look at that.
09:29
Look at this little— look at this.
09:31
Wow.
09:32
Located in a tech revolution hub, home to over 500 companies, a market where $200 ponchos and $80 lunches are the norm.
09:40
Interesting.
09:40
Venice submarket fundamentals, the macro forecast, why buy now.
09:44
Look at this beautiful chart.
09:46
Buying today captures the upside of the impending 2026 recovery before competition returns.
09:52
There's a quote from Kidder Matthews, navigating the regulatory landscape.
09:56
Okay, cool.
09:58
Vacancy is the value add.
09:59
Nice little chart here showcasing the vacancies Legacy rent, market potential, very good.
10:06
35% of the building can be leased at market rates immediately, bypassing legacy rent control drag.
10:11
Fair point.
10:12
Capital deployed versus operating expense, cool little chart here as well.
10:17
From renovation to stabilization, look at this graph, the visuals are like insane.
10:23
Cool.
10:23
The lease-up strategy: execute leases, fill units, 10 to 13 at market rates, $3,900+ target, capture demand, optimize operations.
10:31
And then there's some market comparables here.
10:34
Very good stuff.
10:34
And then last slide.
10:36
the group CRE Market Translators, talking about Taylor's team here.
10:42
$488+ million sold.
10:44
Rockstar team.
10:45
A flight to quality.
10:47
With some of the images there.
10:49
Wow.
10:49
Last slide right here.
10:50
And so then there's this revise look at that.
10:53
Wow.
10:53
This is interesting.
10:54
So you could literally query, right?
10:56
So for change slide 15, let's do, let's just say, can you improve this slide and make it more professional.
11:10
So you literally communicate— okay, so it's got to create a whole new slide deck by doing the revisions.
11:15
That's okay.
11:15
So while that's happening, let's go into this other deck.
11:17
So this is the second deck.
11:19
Wow.
11:20
Better cover slide in my opinion.
11:22
Very nice.
11:22
And it has the, new renderings of the asset as well.
11:27
Like, that's a legit picture that I gave it.
11:29
Slide 2, look at that.
11:31
Wow, very interesting.
11:32
Rare coastal inventory with significant upside.
11:36
Okay, I already like this deck better.
11:38
We're gonna need to figure out if it was the presenter slide or the other one that we chose.
11:43
modern design meets coastal living.
11:45
The investment thesis.
11:46
I'm going to assume this is the presenter slide.
11:49
If I was betting, look at this value-add potential versus high-demand market, walkability and tech, curated amenities.
11:55
Look at these photos and the way that it did it is just so nice.
11:58
The intersection of tech and culture.
12:00
Silicon Beach remains a top destination for startups and tech giants.
12:03
Venice is the 7th most expensive neighborhood in LA.
12:06
Creating a forever renter class of high-income earners.
12:10
True that.
12:11
Los Angeles market fundamentals, good statistics on the LA market.
12:15
Navigating the regulatory headwinds.
12:16
Okay, probably not a slide we want to add in there.
12:19
It doesn't really sell the asset.
12:23
rent roll analysis, full breakdown on current rents, what's the loss to lease opportunity.
12:29
Showcasing with visuals, a 40% upside.
12:32
Beautifully done.
12:33
T12 financial performance.
12:35
Okay, beautiful.
12:36
Pro forma path to stabilization.
12:38
These visuals are crazy.
12:40
Can you imagine trying to create those in PowerPoint?
12:45
Nuts.
12:45
Venice market benchmarks.
12:47
Median home price $2.99 million.
12:50
Wow.
12:51
Price per square foot's huge.
12:52
Median market rent— geez.
12:53
Here's the group CRE, not your typical brokers.
12:58
Deal process and type line— or timeline, excuse me.
13:01
Property tours, offer submission, review period.
13:03
We handle the headaches so you focus on what's next.
13:05
And then the last slide there, pretty insane.
13:08
And then again, like, you can make revisions, so it seems.
13:12
Revise.
13:13
So if I wanted to say instead of negative, put the actual number from the P&L.
13:23
So we're just going to make an edit to slide number 10.
13:27
Cool.
13:27
And you can go to other slides and make other revisions, and it'll showcase on the bottom here, and then you'll just hit Generate New Deck.
13:34
here, let's go back to this other one where we made a revision that didn't take too long.
13:38
So let's just see, it's loading up here.
13:39
So we, we made a revision to the last slide, I believe.
13:42
Yeah.
13:43
Okay.
13:43
So wow, that looks way better.
13:44
So we basically just said make it more professional.
13:46
That looks way better than what it was the first go around.
13:49
Cool.
13:50
So interesting.
13:51
The revision piece is interesting.
13:53
I, I think they'll need to figure out how instead of querying it and then generating a new deck, how we could just make edits in there the same way you would with a PowerPoint.
14:02
but really, really good stuff there.
14:03
You can, let's see, you could download as a PDF.
14:07
Beautiful.
14:08
And you could download as a PowerPoint.
14:10
Beautiful.
14:11
So you could do both.
14:11
That's really awesome, honestly.
14:13
Really, really awesome.
14:14
And it looks like that second revision is now done.
14:16
So let's just peep.
14:17
So we asked it very specifically to change instead of negative.
14:22
Got it.
14:22
Got it.
14:22
So instead of negative, we just asked it to put the number there, which it did.
14:27
I'm going to assume that math is right.
14:29
Okay, so really good stuff.
14:31
the deck quality is fantastic, and I think what you want to do is give it some pretty specific instructions.
14:42
I, I think the better one was the presenter it doesn't show us though, that's a bummer.
14:46
Let's see, Yeah, it doesn't show us the difference, if it's— if we did presenter or the detailed one, but I think if you give it very, very, explicit, very specific instructions, you can make it even better.
15:00
Wow.
15:01
So I'm, I'm really fired up.
15:02
NotebookLM crushing it.
15:04
Really good job by NotebookLM.
15:06
my God.
15:07
it'll continue to get better too.
15:08
So wow.
15:09
Deck creation.
15:12
NotebookLM definitely at the top of the list.
15:14
NotebookLM, Gamma, Manus, they're all creating the best decks.
15:18
Claude came out with Claude and PowerPoint.
15:20
It's just not there yet.
15:22
the fact that Microsoft let Claude create Claude and PowerPoint before Microsoft like figured that shit out is crazy to me.
15:28
but I'm really, really impressed