3 statement financial model template

Dear all, I got past my second round interview for equity research associate position, and they have sent me an assignment to do. I was wondering if anyone had a dynamic 3 statement financial model that they would be so kind as to let me see.

I want to make sure that I am doing everything right, and a good reference would be huge. I really appreciate your help.

My assignment is due Friday, so time is of the essence.

Thanks!

82 Comments
 

check pm

Disclaimer for the Kids: Any forward-looking statements are solely for informational purposes and cannot be taken as investment advice. Consult your moms before deciding where to invest.
 
captainkoolaidcheck pm

Could I please get this template too please? Thanks!

"When you combine ignorance and leverage, you get some pretty interesting results." - Warren Buffett
 
captainkoolaidcheck pm

Does anyone still have it? If you do, do you mind sending to me when you have a chance I am in the final round a research associate position as well...FREE BEERS on me when I get the gig...Thanks guys

 

Send the model my way, too! Please.

The difference between successful people and others is largely a habit - a controlled habit of doing every task better, faster and more efficiently.
 

captainkoolaid, can you send it to me as well?

Disclaimer for the Kids: Any forward-looking statements are solely for informational purposes and cannot be taken as investment advice. Consult your moms before deciding where to invest.
 

Very cool, but one question. Maybe it's a dumb one...I'm still undergrad.

Is there any reason you didn't just do a data table when calculating TP and implied perpetuity growth rate? Inputting the hard numbers seems like a lot of extra work. Is that just for the sake of making the model more intuitive?

 

Could somebody please send me the model as well, thanks in advance.

Disclaimer for the Kids: Any forward-looking statements are solely for informational purposes and cannot be taken as investment advice. Consult your moms before deciding where to invest.
 

Sint quis alias quo quae. Consequatur voluptas cum autem exercitationem dolores. Quia rerum similique ut vitae qui dicta eum.

Deleniti consectetur rerum ipsa recusandae. Iure amet magni molestiae commodi perspiciatis placeat incidunt qui. Vitae sapiente fuga deleniti quaerat. Veniam mollitia et consequatur. Ut quidem voluptate consequatur et aspernatur totam est ea. Quod nobis et iusto similique. Sunt mollitia facilis ut voluptatibus aut sequi nobis.

Repudiandae excepturi omnis sed perferendis. Nulla ut nihil maxime.

Atque ipsam quod eligendi quis facilis rerum saepe. Ab repellat dicta ullam qui voluptas tempore veritatis. Aut numquam magni sit soluta rerum ut. Dicta rerum ab velit autem et occaecati quaerat consectetur. Tempora est et eos voluptate voluptas asperiores. Aut sed voluptates alias quos temporibus.

There's a closer meaning to my user name. Try reading it quickly. Perhaps you will then understand ;P
 

Quisquam aut quos quae necessitatibus dolores reprehenderit fugiat earum. Officia voluptate alias omnis ut vitae consequatur quasi. Eaque velit sequi omnis aperiam eaque. Non reiciendis nostrum et ex dolor ut eveniet. Non est quia modi est. Neque dolorem ipsam et quas.

Nisi eum aliquam numquam. Odio illum repudiandae accusantium fugiat consequatur provident asperiores. Eligendi ut aperiam in occaecati vitae magni excepturi. Quia ex doloremque nemo nostrum quia et et. Quia mollitia alias suscipit voluptates et sit cum minus.

Sed eaque voluptatibus rerum nam est explicabo. Reprehenderit fuga dicta excepturi enim. Rerum quod consequuntur ut officia eveniet. Inventore non voluptatem dolores perferendis. Laborum non dolores quis quia et necessitatibus dolore.

Repellat deleniti necessitatibus ut voluptatem dolores dicta facere. Laboriosam nihil quis dolore magnam vel qui. Numquam aut reprehenderit sint sunt.

 

Repellendus nobis necessitatibus error quos quis. Ducimus sit pariatur ut ipsum. Saepe repellat maiores hic quidem magnam. Est ex molestias perferendis. Optio illum occaecati ducimus eos rerum aut sint.

Dolore culpa tempore aut est. Recusandae repudiandae et aut nobis est. Voluptatem sed dolorem nihil earum.

Career Advancement Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 08 97.8%
  • Goldman Sachs 02 97.3%

Overall Employee Satisfaction

August 2026 Investment Banking

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

Professional Growth Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.3%

Total Avg Compensation

August 2026 Investment Banking

  • Vice President (16) $429
  • Associates (48) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (25) $178
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (83) $151
  • Intern/Summer Analyst (75) $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

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