Sign up  |  Log in

Chart for Solow Model

Hi Everybody,

I need to graph Solow model, though it’s not as easy task as I hoped for. I looked for excel charts in internet and there is a problem with every single one of them. I’ll try to explain my point.

per capita output function: y=ka

k at time t = k at time t-1 + investment - d * k at time t, where d is depreciation rate: k(t) = k(t-1) + i - d*(k(t-1)

i is the function of y: i = y*s where s is the savings rate and is held constant

Now about the problem - everything is intertwined and function of each other - thus I have “circular reference problem” in excel. I don’t have truly independent variable as input. In sources I found in internet, they ignore the capital equation k(t) = k(t-1) + i - d*(k(t-1), which is independently is graphed and actual capital growth given for y calculation is different.

I hope I made the point as clear as possible.

I would appreciate your help!

Don’t waste your valuable time with unreliable and bogus strategies for passing the CFA® exam. Schweser prepares you for success with adaptive tools, expert instruction, and proven study techniques personalized to your unique learning style.

Can you please super smart people solve this problem?