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!

Anonymous A

on Oct 04, 2024

Global

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!

700+

Be the first to answer!

Nobody has responded to this question yet.

Top answer

Alessa

Coach

on Oct 04, 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 :)

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.