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

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Comments

Interested in this topic?

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

* Mandatory Field

`````````````````````````````````````````````````` Post ID = 43054