course bg
EduPristine>Blog>Financial Modeling and Circular Referencing

Financial Modeling and Circular Referencing

January 3, 2014

To join Free Workshop Click here

Consider the data used in spreadsheet below.

Donation that you make is tax exempt. That is donation is actually an expense. So I take donations to be 10% of whatever you have after the tax.

Here the blue line indicates circular referencing. As a result, our cells which were supposed to show some values as per the formulas (depicted below), are valued zero. That is the problem that comes with circular referencing.

Formulas:

First of all, what actually is this menace that is termed as circular referencing by MS-Excel? It is any reference within a formula that depends upon the result of same formula i.e. a cell that refers to its own value or the cell which refers to another cell which depends on the original cell’s value, both contains circular referencing.

Now how do we set this situation right?

Microsoft has given excel and a feature within excel on how to remove circular referencing.

1. Go to Excel options in the start button of ‘Excel’

2. Go to ‘Formulas’ section within Excel Options

3. Tick on ‘Enable Iterative calculation

4. Press ‘OK’

And voila! Circular referencing is gone.

As a result, our data sheet will be modified as below.

And that is another Financial Modeling lesson concluded!

About Author

avatar EduPristine

EduPristine is a member of Adtalem Global Education (NYSE: ATGE), a global education provider headquartered in the United States. Adtalem is a 3 billion dollars (20,000 crores) company that has about 9 institutions and companies with more than 16,000 employees spread across 145 locations. Adtalem takes pride in training 142,000 degree-seeking students all over the world.The organization's purpose is to empower students to achieve their goals, find success and make inspiring contributions to our global community. EduPristine is one of India's leading training providers in Analytics, Accounting, Finance, Healthcare, and Marketing. Founded in 2008, EduPristine has a strong online platform and network of classrooms across India and caters to self-paced learning and online learning, in addition to classroom learning

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

Post ID = 43054