, , , ,

Using ChatGPT to Create Excel Logic #2 – Annual to Monthly Growth

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: Born and raised in the Northwest United States, Spencer Burton has over 20 years of residential and commercial real estate experience. Over his career, he has underwritten $30+ billion of commercial real estate at some of the largest institutional real estate firms in the world. He is currently President and member of the founding team at Stablewood. Spencer holds a BS in International Affairs from Florida State University and a Masters in Real Estate Finance from Cornell University.