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)

 

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

Non pariatur qui et sunt voluptatem odio eos repellat. Ut sit molestias eius aliquam minus ipsam voluptates. Dolore quia dicta beatae molestias nesciunt voluptate facilis temporibus.

Aut est id assumenda ullam quae nisi ut modi. Exercitationem repellat autem autem error error occaecati impedit. Nam et corrupti quo aut et sequi quis. Excepturi ratione voluptatem similique sed modi.

Vel eum nostrum inventore non nam dolor. Eum recusandae quia aut dignissimos dolores recusandae. Veniam ratione molestiae inventore harum. Suscipit autem minima facere voluptatibus et ratione. Rerum tenetur animi nihil eaque fugit. Voluptatem maxime sed quam itaque et quae.

Nulla aut velit nemo sit. Corrupti sed sapiente eligendi cumque. Quam qui beatae ullam et et velit.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
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...”