Best valuation modeling advice? Or your pet peeves

likehelpful
Posting as :
works at
You are currently posting as works at

Never ever ever ever ever put a hard coded number inside a formula... you are basically dead to me if I see that

likefunny

Colour code your cells. And hard coding is the worst possible sin

like

Have a tab for all assumptions, hard coded numbers, etc, and color code cells based on assumptions/inputs, offsheet reference, on sheet reference, macro, etc.

like

No hidden columns or rows, use grouping

like

Simple formulas > complex formulas

like

Cite your data sources (footnote, or elsewhere) and update them to reflect the valuation date always!!!!

like

Trying to account for risk in CoC rather than expected value (or even better, scenarios) for cash flows

Related Posts

If anyone is looking to work for Stryker DM me. Can give more info and potential referrals.

like

The biggest thing that messes me up is my memory. I keep forgetting that I am a Titan of Wall St.

likefunny

What are current directors in Student Life making ? I love my current job but currently doing more than my job description and it keeps piling on with little to no compensation .

like

How much package should a data engineer get for 3 year exp?

like

𝐋𝐨𝐨𝐤𝐮𝐩() - Life saver!

Rule Functions in SAP SuccessFactors

#SAP #SuccessFactors #Functions

Post Photo

What's it like working with BCG in Dubai? Which service lines have the best people and which should be avoided?

like

Made a mistake: I bought a watch instead of an iPad for grad school use.

like

Breakfast food is so much better and energizing at lunch (11:30 - 12:30) than it is early in the morning.

like

How much do you actually work per day. For me it is an avg of 3-4 hours

like

Hi Dolphins,
Please give me 11 likes on this post so I can get DM access. Thanks in advance! 😊

like

Is at-will contracts the standard in the US? California. Are there any opportunities to have a non at-will contract? We just moved countries and I got a few great offers, but was wondering if there’s negotiation room for non-at-will contracts? Thank you!

like

Feelings about project managers? Good, bad, otherwise?

like

In weekend checked out VTP Peagusus project in Kharadi possession 2025. Project looks promising but when visited the site accept for the towers rest all be it roads or daily basis shops nothing is there yet but they say that till the time of possession roads and everything will be functional. The rate for 750 sqft carpet 2bhk they are giving for 74lacs and possession is 2023 May. Another 2025 possession 850 sqft carpet 2bhk for 79lacs.Hardly any difference in rate per sqft. Please suggest

like

Hi Fishes,

I received an offer (28 Lakhs + 3.9 Lakhs incentive) from Novartis for Sr Project Manager yesterday. This was just 13.6% more than my current earnings as Project Manager. I've given the reasons why I deserve at least 30% to HR. In response to that, HR has sent 2nd offer i.e. 29 Lakhs + 4 Lakhs incentive + 50k sign-on bonus. The 2nd offer is just 18.2% higher than my current earnings. Need your suggestion, if I could still negotiate with HR to finalize deal by asking for 25% hike?

like

What are benefits of working with a content strategist on a project?

What are strong must-have traits of a good content strategist?

Trying to build a case for my agency to hire our first CS!

like

Anyone in the suburbs find it harder to make friends compared to the city? I don’t want to move back but I don’t know what else to do..

like

I’ve been weightlifting at my boyfriend’s home gym, but when I’m home I’m a bit scared about using sizable weight without a spot. What have you guys been doing regarding solo workouts? I go to a local gym, but I don’t know anyone there

like

What’s your opinion on Cue Health?

likefunny

What platforms do folks use for vault / element management these days? I need to build a new library. Is it still klugey FileMaker databases?

Additional Posts in Consulting

I do believe EY is d kindest when it comes to putting people first.Thank U Kelly.Resume travel based on CDC & facts, no layoffs in foreseeable future, extending trust when wfh& personal accountability

like

Are we able to mirror our motions/voices/moves to a different location? Who wants to work on this initiative? Would be a perfect tool for WFH situation.

like

Sheraton Atlanta Perimeter North - worth it for a confirmed suite as opposed to the nearby Westin? Usually a westin loyalist.

like

No matter how many times Harry Potter is on TV, I always watch it over and over. Even though I have watched the movies millions of times, haha. 😅

likeuplifting

3 Day PTO starts now...my buddy's bachelor party. Forget you, utilization.

like

To those starting the year on the beach: office or home office ...or actual beach?

like

Hey 🐠, what are your recommendations of books, articles, or practice tips to improve communication, both verbal and written? Want to be stronger at running meetings, pitching ideas, writing (cont’d)

like

Shit Consultants Say.....

like

Any idea why EY is not on the list of Vault 50 top consulting firms but it is on the prestigious list?

like

Where should I go for dinner?

likefunny

Whats the difference between a Partner and Leader at EY?

likefunny

How do you save taxes & etc . If you are making more than 175K(bonus included, no stocks).
Max out 401 K,
Can I put money in IRA?
Is there any other options to save taxes?

like

Looking for book recommendations; any favorites? Interested in both fiction and educational/self-improvement (for example, investment / finance books, time management, etc). I feel my vocab is...

like

To the moon…Oh I mean back to earth. Sigh 😞

funny

The moment when I left client site at 9 pm, grabbed takeout, then found myself driving back to client site instead of hotel #losingmymind

like

You know it's a slow week when the highlight is when your comment to a fishbowl post gets more upvotes than the initial post

like

Had this question pop up a lot recently - discussed here many times before, but want to see if we can quantify the discussion a bit. Let’s assume the vaccine is at 70% shots in arms by 4th of July (‘21), and 80-85% by Labor Day. In 2022, are we back to 3/4/5, or do you think parts of the remote culture will stick going forward?

likehelpful

One of my lead partners is super nice to in front of others but then really mean to me when we meet 1x1. How to deal with this?

like

Has anyone heard of IVY: The Social University? What is this?

How is every fucker priority? And the non priority people...please stand in your own peasant line, do we ever crowd your way?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal