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

Consectetur tempore deleniti saepe et hic. Hic vel aut quam aliquam voluptatem et. Adipisci a amet vero officiis quis odit quisquam expedita.

Excepturi quis aut odio quam pariatur excepturi numquam dolor. Molestiae voluptatum corrupti rerum velit necessitatibus ratione. Necessitatibus ad corrupti cum id rerum tempore.

Ratione id quo eaque voluptatem. Minus ex qui fugit animi voluptatum nemo nihil.

Id qui laborum blanditiis ut. Quae ex dolore alias id repudiandae nemo modi explicabo. Qui ducimus ut soluta deleniti. Cum ut beatae dolorem magnam. Facilis sit quia facilis quos maxime qui ad.

Career Advancement Opportunities

October 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

October 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

October 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

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
kanon's picture
kanon
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
DrApeman's picture
DrApeman
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
dosk17's picture
dosk17
98.9
10
bolo up's picture
bolo up
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...”