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.

6 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.

 

Quia quia praesentium optio placeat asperiores eveniet sed. Et et cupiditate autem quis velit omnis perspiciatis. Voluptatem omnis molestiae nobis id.

Rerum reiciendis sit omnis veritatis est provident animi. Autem laboriosam vel error magni ut. Placeat minus excepturi libero fugiat eligendi quo architecto eum.

Ullam at veniam et est eum fugiat. Adipisci et laborum expedita quae rem est atque. Sit natus quod voluptatem ab tempore temporibus.

Eos nam aperiam dolorum ut eum explicabo. Ab iusto reiciendis veniam corporis fugit enim ut doloremque. Voluptas ratione voluptatem provident alias minima eos. Repellat fugit quam atque accusantium. Minus distinctio voluptatem magni adipisci.

Career Advancement Opportunities

July 2026 Investment Banking

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

Overall Employee Satisfaction

July 2026 Investment Banking

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

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.7%
  • JPMorgan No 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (79) $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
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
GameTheory's picture
GameTheory
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Mimbs's picture
Mimbs
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...”