Consulting Consulting
Finance General
Finance General
Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Interview Partners to connect and practice with!
Meeting Board
Consulting Q&A
Interview Partner
Premium Membership
Back to overview
Anonymous A
on Oct 04, 2024
Global
I want to receive updates regarding this question via email.

Circular reference switch: when to turn on/ off?

Hi all, when a 3 statement model is completed, we need to enable the circular reference function, and then set the "Circular Reference Switch" to 1 in the model. 

When saving the completed model, should I keep the Switch to 1, or should I set to 0? If the Switch is set at 1, will the model result be different when someone opens the model in the future, as the circular reference might be re-calculating?

I've seen mixed answers on the internet, so I would like to learn from your perspective. Thank you!

2
1.2k
29
Write an answer
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Alessa
Coach
on Oct 04, 2024
xMcKinsey & Company | xBCG | xRB | >400 coachings | feel free to schedule an intro call for free

Hey! When dealing with the circular reference switch in a 3-statement model, I’ve set it to 1 while working on the model to ensure accurate calculations. However, when saving the completed model, I always set it back to 0 to prevent any recalculation issues when others open it later. This method helped me maintain consistency and stability in my previous projects at MBB.

For more detailed guidance on managing circular references, I always checked out resources from financial modeling courses or platforms like Wall Street Prep - maybe that helps you too? 

Alessa :)

19
Contact coach
Benjamin
Coach
on Feb 12, 2025
Ex-BCG Principal | 8+ years consulting experience in SEA | BCG top interviewer & top performer

I would keep it at 0 for efficiencies. 

11
Contact coach
Similar Questions
Consulting
Hi, I got an offer from McKinsey Paris!
on Sep 05, 2024
Global
6
1.7k
66
6 Answers
1.7k Views
Consulting
Onboarding prep: 1 week left, how to use time wisely?
on Sep 23, 2024
Global
7
1.4k
81
7 Answers
1.4k Views
Consulting
Incoming McKinsey BA - What are courses to get up to speed in Excel AND PPT, specifically designed for consultants?
on Sep 29, 2024
USA
5
1.8k
62
5 Answers
1.8k Views
Consulting
Oliver Wyman Interview (Excel Model Case?)
on Oct 10, 2024
Asia
3
2.4k
47
3 Answers
2.4k Views
Consulting
Urgent: Preparation for an MBB Internship
on Oct 22, 2024
Global
4
1.0k
44
4 Answers
1.0k Views
Show more
Top Answer by
Alessa
Coach
xMcKinsey & Company | xBCG | xRB | >400 coachings | feel free to schedule an intro call for free
Related Articles
Excel for Consultants – Key Skills for Your Life as a Consultant
In this article you will learn which Excel skills are really important for consultants.
View article
How to Master Financial Modeling for Your Finance Career
Discover the basics of financial modeling and how it supports high-stakes decisions.
View article
Related Case
Expert case by
Agrim
BCG Final Round: Stadium Naming Rights
4.4
2.6k times solved
Intermediate
Candidate-led
Open case
Similar Questions
Consulting
Hi, I got an offer from McKinsey Paris!
on Sep 05, 2024
66
6
1.7k
Consulting
Onboarding prep: 1 week left, how to use time wisely?
on Sep 23, 2024
81
7
1.4k
Consulting
Incoming McKinsey BA - What are courses to get up to speed in Excel AND PPT, specifically designed for consultants?
on Sep 29, 2024
62
5
1.8k
Consulting
Oliver Wyman Interview (Excel Model Case?)
on Oct 10, 2024
47
3
2.4k
Consulting
Urgent: Preparation for an MBB Internship
on Oct 22, 2024
44
4
1.0k
Show more
Questions by Categories
Questions about MBB
CV Questions
Personal Fit Questions
Questions or Feedback?
Select category
  • Select category
  • Case Interview Preparation
  • Coaching
  • Technical Problems
  • Other
Your name
Your email address
Cancel