Financial Modeling - Data Input Separate From Values for Projection?

For those of you who do financial modeling.

When you encode/paste financial info from annual reports to make the calculations (DIO, DPO, % of Rev., etc) and projections:

Is it a separated input sheet and link it to another IS / BS / CFS sheet where you do your calculations?

or

Do you use that input sheet for projections right off the bat?

Basically:

(input -> calculations -> projections)

or

(input -> link to another sheet -> calculations -> projections)

2 Comments
 

Biriyo Neru, shame nobody has responded. Maybe one of these topics will help:

  • Starting a blog with a few friends from school and want input internship with one of the top financial data processing firms. We also have a friend with a marketing ... Me and a couple college buddies are constantly emailing each other articles from all over the ... undergraduate students we are not expecting to make a blog that institutional investors go to for trading ...
  • Notes for Technical Interview Questions interviews I was never actually asked any technical questions (although I did do a 3 hour modelling exam for ... oil reserves or book value, depending on the industry and situation How do you do a DCFF?- First model ... are company specific = FCFF- For the terminal value, at the end of the forecast period, you would use ...
  • Ask Natalie from Accepted about Business School Admissions WSO is excited to have the experts from Accepted on board to answer applicant questions in the ... business school forum. Here are messages from Natalie and Jen who will be checking this thread every few ... a former Assistant Director of Admissions at Cornell who also worked in career services at Duke Fuqua. For ...
  • Financial & Valuation Modeling Boot-Camp Financial modeling is a skill that any investment banking analyst will have to master. Although ... students and prospective finance professionals are choosing enroll in self-study financial modeling ... directly on the job. * Unlimited support for 2 years post-seminar * Issuance of Certification in Financial ...
  • Biking to my job in Chicago- Need input from the Chicago monkeys and would like to know your guys' input. I have two choices- I can live in a 4 bedroom-3 bathroom ... apartment (roommates are taken care of by the apartment complex) that's a mile away from the firm. ... The firm isn't formal so I can go in wearing anything I like. Or do I go for a 1400-1500 a month ...
  • separate forum for real bankers siphoning off people to where they belong, and hence, where they will get the most value add from asking ... methods for luxury goods companies; that post will probably get pushed down by "Rate the best ... for someone who is already in banking, most likely; moreso for ppl trying to break into banking, or ...
  • Is value investing dead? "value" stocks slid, an unusual separation. Growth and value stocks in the U.S. returned the same from the ... The WSJ article, " Investors Finding Little Value in Value Stocks, So Watch for the Rebound, ... have a value gap that is so extreme that quite often that can act as a catalyst for the value stocks ...
  • More suggestions...

No promises, but sometimes if we mention a user, they will share their wisdom: Dorothy-Figiel @Superaguri27" Budwyza

I hope those threads give you a bit more insight.

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 
Best Response

Et non quia fugiat magni. Et tempore eius veritatis et eaque eaque nihil sapiente. Quod perferendis labore dignissimos veniam at.

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