Using ChatGPT to Create Excel Logic #2

Another post in a growing series on how to use ChatGPT in commercial real estate. In our real estate financial modeling Accelerator program we have a Q&A. Members of the Accelerator ask the A.CRE team questions, and we provide answers. Depending on the complexity/nature of the question, either Arturo, Emilio, Kyle, Michael, or I respond.

We recently received a question regarding how to write a formula such that rent growth would grow on a monthly basis, driven by some annual rent growth input. And while this is logic I’ve used in my models before, it was not a formula that I have memorized. I also couldn’t recall which models I’d included this logic in.

And so, I thought this would be a great use case for ChatGPT to help me develop that logic anew but in a much quicker way. In this video tutorial, I show you how I used ChatGPT to quickly build a formula and then share that formula as a response to the Accelerator question.

Not yet a member of our real estate financial modeling Accelerator program? Consider joining today.

The output created from ChatGPT during a back-and-forth exercise to create Excel logic to convert annual to monthly growth cash flows.

What is GPT, ChatGPT, and OpenAI?

Given that this is another blog post in the series, I assume you’re well aware of what ChatGPT and natural language models are. I also assume you’re familiar with its creator, OpenAI and the significant advances in artificial intelligence that is currently underway.

Therefore, I won’t rehash in this post what GPT, ChatGPT, or OpenAI are. However, if these concepts are new (or you’re looking to learn more) you might check out our Using AI in Real Estate guide.

Using GPT in Commercial Real Estate – Converting Annual to Monthly Growth

I continue to explore other use cases for natural language models like ChatGPT and Google Bard in commercial real estate. In this video, I show you one such use case wherein I find the logic to convert annual growth to monthly growth cash flows. Note that ChatGPT relies on a plugin called Wolfram – a math and computation tool – to provide an accurate response in this case.

Click here to read the entire ChatGPT conversation that this video is based on.

About the Author: Spencer Burton is Co-Founder and CEO of CRE Agents, an AI-powered platform training digital coworkers for commercial real estate. He has 20+ years of CRE experience and has underwritten over $30 billion in real estate across top institutional firms.

Spencer also co-founded Adventures in CRE, served as President at Stablewood, and holds a BS in International Affairs from Florida State University and a Masters in Real Estate Finance from Cornell University.

Contact Spencer