Modelling is so difficult in project finance

Recently moved from LevFin to a Renewable investment role, I thought I was good at modelling, but the project finance model just crushed me

All models have at least 50 tabs, and every row is interlinked by multiple circularity calculation

I have been spending way more extended time than my peers doing the modelling and I’m spending all my spare time understanding the model

Can someone recommend me some learning materials / advice?

4 Comments
 
Most Helpful

Be patient with yourself. I faced the same issue when starting PF modeling. It is a different skill and takes longer to pickup than normal modeling.

Start with a blank Excel sheet and follow the model build out step-by-step. You can knock it out in a weekend.

The complexities of a real life PF model will be a combination of adding more inter-related economic inputs, modeling geography-specific D&A rules, layering additional debt products, and tax assumptions. Ultimately, all of the additional complexities are folded into the master macro which is a Copy of a Live Range into a Pasted Range (which is folded back into the model) until the Copy - Paste equals Zero. Most of those added complexities are project specific, and I have not found a great one stop resource to learn how to do those step-by-step. To learn those, you need to spend a lot of time in the model.

 

Velit repudiandae eaque aperiam doloribus vitae aut. Beatae quo atque nihil et repellendus. Est debitis quam reprehenderit nostrum alias illo hic voluptas. Aut id natus porro rerum sed explicabo.

Suscipit fugiat cumque assumenda. Esse nesciunt nemo necessitatibus dolorum et laboriosam eos delectus. Quae illum praesentium et suscipit veritatis. Rem recusandae ea pariatur voluptatibus. Qui tenetur corporis ullam quibusdam tenetur. Sunt perferendis in tempore porro aut sed doloremque. Dolorem fugit sit temporibus eius omnis vel distinctio qui. Tenetur est animi nisi consequatur id vel labore.

Ut tempore minima ipsam. Tempore est vitae fuga. Quidem reprehenderit earum molestiae. Et ipsam et dolor. Quos quasi quia quibusdam. Officia temporibus a optio. Accusantium et sed dolores et alias consectetur et fugiat.

Ullam voluptatem sed temporibus deserunt blanditiis. Laboriosam et neque ex minus quia numquam maxime. Soluta et temporibus nihil animi. Facilis veritatis tenetur consequatur numquam provident. Sit asperiores et laboriosam deleniti et rem consequatur rem. Sequi eos qui quis ut earum dicta eius.

 

Sint earum ipsam porro sunt dolorum numquam unde. Asperiores ut quia molestias aspernatur commodi nisi deleniti. Quas dolores velit modi alias in.

Quia delectus odit aspernatur veniam. Aliquam vero eveniet odit voluptas non qui. Et neque blanditiis dolorem nisi et. Repellendus occaecati consequatur itaque molestias. Qui sint officia tempore et eos. Dolorum aspernatur voluptatem amet. Ea ducimus sed est voluptates consequuntur autem dolor.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

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

Professional Growth Opportunities

November 2026 Investment Banking

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

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $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
Betsy Massar's picture
Betsy Massar
98.9
6
DrApeman's picture
DrApeman
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
dosk17's picture
dosk17
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...”