Technical Question Help - 3 Statement model

Hi All,

Incoming IB analyst. I’m in my final year of studies and for my class final I have been asked to make a full 3 forma financial projection and then do a DCF valuation. I’ve gone through “simple” examples in class and on YouTube videos so I have a good understanding, but now I have to project one for a real company.

There are a bunch of line items on the balance sheet (highlighted in yellow), that I have no idea how to project. Do I just keep the accounts the same or project them with revenue or Cogs? Or do I need to download the detailed excel financial statements and spend hours digging through each account to see how it is projected

Thanks for the assistance. Really wanting to make a complex and detailed model that gives me exposure before I go into banking. Highlighted items are ones I have no idea how to project:

3 Comments
 
Most Helpful

% of revenue: prepaid expenses, accrued expenses, other non-current liabilities

structured payables: take historical DOH and use DOH across projected years which will allow you to calculate payables based on COGS. 

investments in unconsolidated affiliates: not sure here, could leave flat but maybe others can add detail. 

other intangibles: you can decrease the projected years if you are given detail on amortization, otherwise you can assume an assumption. 

Deferred tax liabilities: can assume a % of income taxes for simplicity, but the google the topic if you want a granular projection.  

 

Sint facere ex odio assumenda voluptatem. Accusamus consequatur sequi possimus quaerat perspiciatis occaecati.

Qui ut quos aut hic rerum id. Commodi eius qui sint animi qui repellendus enim. Autem eius qui non placeat. Omnis et natus est.

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 04 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 (17) $409
  • Associates (58) $261
  • 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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
GameTheory's picture
GameTheory
98.9
6
DrApeman's picture
DrApeman
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
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...”