The CircEquil.xlsx Model

Find equilibrium values for X0 and Y0 that satisfy an otherwise circular reference.

View the model
Download the model

Given Y as a function of X, and X as a function of Y, find values for X and Y that satisfy both.				
One could try iteration, as in Excel, when you have circular references, but it may not converge.				
One can solve it directly as a set of simultaneous equations with What'sBest!.				

Keywords:

Equilibrium | Simultaneous Equations | Excel | WhatsBest | What'sBest | What'sBest! | What's Best | Circular reference |