AI and Excel

How long do you expect until we strictly interact with excel through a LLM prompt (like the current Claude and ChatGPT excel plug ins). Sure, AI makes mistakes and hallucinates but its getting better and better? Obviously this is a real estate/finance forum and and not for tech experts but always fun to speculate.

7 Comments
 

I'm only a student so apologies if I'm way off the mark but I reckon expressing intent about what you want to do on Excel and AI doing it can't be too far off at all. Wouldn't be surprised if this becomes very common among smaller firms as they don't have as much bureaucracy as bigger ones. They will probably adopt this sort of stuff quite quickly if it saves them a couple hours  -- within 12-24 months probably. Wouldn't be out of the question to make a pretty reliable industry grade wrapper for Excel given what's already here. 

 
Most Helpful

I've spent the last two months in Claude building a new multifamily pro forma using bits and pieces of all the pro formas I've used in the past.

Is it an incredible tool that gets better with every new version? Yes

Is it still highly flawed and needs to be fully guided by a human? Yes

It still makes a ton of mistakes when pulling data, wiring cells and making assumptions. Unless you 100% know how the underwriting is supposed to work and what it is supposed to do at an institutional level, you'll have errors in the model that you will not be aware of that will throw the returns of a deal off. Sometimes by a little, sometimes by a lot.

I've spent probably $500 - $600 in extra tokens to fully build, audit, break, build, audit, break and I'm still going - even though I have Claude log and remember the work. I'm 95% of the way done, but every little tweak can make a difference.

But its a great tool for a "quick pass" on deals by simply uploading the broker OM and making your own quick adjustments to see if a deal is worth spending more time on.

 

My opinion is that AI is similar to a calculator - it needs someone competent to operate in order for it to produce the right output. AI will be disruptive tech, but I doubt it will be more impactful than the assembly line, the wheel, the airplane personal computer, calculators or even excel for that matter.

I bet a ton of errors (logic, calculations, data) already exist in the average model. My guess is Claude already makes less errors than a human, we just continue to make errors in prompting and Claude is getting better at recognizing our intent even when direction is poor. Claude is only as smart as the direction given and it’s leaning to manage up.

 

Agreed - it still gets things like circ refs, formatting, organization, inputs, and optionality incorrect without strong context and the user already having a clear vision of what and how they want to accomplish something.

It is great at building out/reworking complex formulas once you nail down the intent and features, it’s pretty terrible if you ask it to build from scratch even with relatively strong prompts/context.

It is great for multi tasking while Im working on other things however, big timesaver and faster and safer than my analyst once you explain vision and align on plan to have it execute in background.

 

My firm has started rolling out Claude and it's definitely a big productivity boost. It can create pretty nice-looking dashboards and cuts of data that would've otherwise taken me hours to do on my own. That said, my predictions for the AI world are the following:

  1. It'll be like Excel was back in the day. It'll eliminate a lot of low-level work, but will also create a demand for deeper analysis faster from the productivity gains. So instead of my work/value-add in RX CO being creating a dozen different cuts of data to tell a story (i.e. revenue by segment, region, customer, customer-segment, etc.), I can now do that quickly with Claude, which will demand deeper analysis or allow my firm and I to help more companies in the same time frame.
  2. Understanding stats/what data means will be critical. To further my analogy on the dozens of data cuts, the onus will now be on my team and I to figure out what the data is telling us and what the implications are. For example, on my current project, we spoke with management about historical win rates for projects and what the data showed is that one business segment was magnitudes above the other. So, the blended win rate Management quoted was skewed by this part of the business that was much smaller in revenue/scale and the legacy business was struggling. Now, we have to decide if we divest the legacy businesses that are underperforming, keep the smaller segment and only have management focus on bidding mid-sized work, where they're doing better, etc. AI can be a great thought partner for this, but the ultimate call will still come down to humans and often times qualitative factors
  3. Domain knowledge will be really important. I think what AI will morph from these tools like Claude, that are general purpose, to domain-specific tools. At a high-level, there will likely be LLMs that are specifically designed for financial-analysis in Excel. There might also be LLMs that are designed for certain industries, etc. I have a feeling the days of being a generalist and being able to tell simple stories and analysis from cranking out various cuts of data will fade away.
  4. Soft skills and presentation will matter even more. If everyone has AI, effectively nobody has AI, or it's at least not a point of differentiation. What will matter more is getting buy-in and presenting ideas and data in a clear, digestible manner to get deals/initiatives across the finish line. 
 

Reprehenderit omnis laboriosam ab aut quidem consequatur reprehenderit voluptas. Aliquam dolorem praesentium et et enim officia.

Qui sint voluptatem voluptatem ut laborum. Praesentium veritatis rerum modi magnam. Ea sequi ut ex pariatur labore odit. Quidem ab aut hic dolorem.

Nihil rerum laboriosam alias perferendis architecto ducimus ut. Dolor voluptatem quas quo dolor labore sed voluptate. Eius vel placeat temporibus ea ipsum. Qui voluptatem consequatur quaerat omnis.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.8%
  • Morgan Stanley 07 97.2%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.7%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.2%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (16) $429
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
DrApeman's picture
DrApeman
98.9
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”