Verabrede dich zum Casen über das Meeting-Board, nimm an Diskussionen in unserem Consulting Q&A teil und finde gleichgesinnte Interview-Partner:innen, um dich auszutauschen und gemeinsam zu üben!
Zurück zur Übersicht

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
700+
25
Schreibe die erste Antwort!
Bisher hat niemand auf diese Frage reagiert.
Beste Antwort
Alessa
Coach
am 4. Okt. 2024
xMcKinsey & Company | xBCG | +200 individual & group coachings | feel free to schedule a 15 min 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 :)

am 12. Feb. 2025
Ex-BCG Principal | 8+ years consulting experience in SEA | BCG top interviewer & top performer

I would keep it at 0 for efficiencies. 

Ähnliche Fragen
Consulting
Case Study Based on CIM
am 12. Juni 2024
Global
4
1,6k
Beste Antwort von
Sanjeev
Coach
PwC/Strategy&/GT/Chicago Booth - 2nd Session Complementary till June 1st
46
4 Antworten
1,6k Aufrufe
+1
Consulting
Finance Intern - Hiring Process
vor 8 Std
Global
3
< 100
Beste Antwort von
Daniel
Coach
Ex-McKinsey, Bain & Kearney | 5+ yrs consulting, coaching & interviewing | 95%+ candidate success
1
3 Antworten
< 100 Aufrufe
Consulting
Hi, I got an offer from McKinsey Paris!
am 28. Feb. 2025
Global
6
1,2k
Beste Antwort von
Florian
Coach
1400 5-star reviews across platforms | 600+ offers | Highest-rated case book on Amazon | Uni lecturer in US, Asia, EU
66
6 Antworten
1,2k Aufrufe
+3
Wie wahrscheinlich ist es, dass du uns einem Freund oder Kommilitonen empfiehlst?
0 = Nicht wahrscheinlich
10 = Sehr wahrscheinlich
Vielen Dank für dein Feedback! Deine Meinung hilft uns, PrepLounge noch besser zu machen.