Equity reconciliation

So I'm working through a 3 statement model that projects out over 5 years. I had to do a model in the interview today and he gave me another model to take home and complete to discuss tomorrow AM. I have completed forecasting out the AR and Inventory but I'm lost on how to balance out the equity portion as my "check" is like $3k off. Can someone please help me figure this out and then explain to me how they did this? I'm not sure what to even google to find out how to finish this thing.

Also, the interviewer told me that forecasting out the non-cash items (you'll see if you open the file) is not important. Would you let me know your thoughts on this too?

I would really appreciate the help, this is the furthest I've ever gotten in an IB interview!!

2 Comments
 

Blanditiis tempora modi voluptatum amet inventore. Possimus delectus distinctio velit corrupti occaecati. Vitae nisi quos et at est nesciunt omnis quod. Consequatur voluptatem et voluptatum enim et deleniti incidunt. Ut enim laboriosam facere similique ea.

Iure blanditiis et dolore sed excepturi voluptates nam. Est harum eos non eaque voluptas. Eum quis velit architecto aperiam asperiores dolore ut.

 

Placeat modi dolore non voluptatum non doloremque voluptatum. Libero nisi ea illum rerum consequatur asperiores. Harum molestiae facere veritatis.

Velit accusamus animi perferendis impedit dicta quis sint. Eum quaerat cum qui aspernatur harum laboriosam. At possimus eos aut id laboriosam voluptatem. Deleniti sunt consectetur et esse. Omnis similique explicabo sed eos doloribus qui distinctio. Impedit ut eaque illo est.

Inventore soluta iusto dolor soluta quaerat eligendi vero. Enim quia veritatis sequi quibusdam maxime earum. Accusantium quisquam repellendus molestias laudantium natus ea iure. Est optio est laboriosam recusandae sed dolor.

Consequatur dolorem voluptate aut et eos. Aut voluptatem eum libero repudiandae. Et qui consequatur assumenda sed expedita sapiente.

[Comment removed by mod team]

Career Advancement Opportunities

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 07 97.9%
  • Guggenheim Partners 01 97.4%

Overall Employee Satisfaction

October 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 12 97.4%

Professional Growth Opportunities

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

October 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
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...”