Question: this is a homework problem, I would really appreciate if you can help me how to get the results from excel step by step. Thank

this is a homework problem, I would really appreciate if you can help me how to get the results from excel step by step. Thank you

this is a homework problem, I would really appreciate if you can

5. Solving the Solow model with Excel. a) Using the following parameter values calculate the steady state value of capital per capita. Parameter Description Value (I Elasticity of output to capital 0.33 6 Depreciation rate 0.05 n Rate of population growth 0.02 5 Saving rate 0.20 b) Using a spreadsheet generate a simulation for 150 years for the following variables. In logs t N(t) Ki(t) Yi(t) Ii(t) Ci(t) w(t) r(t) g(Ki(t)) gown) Y(t) K(t) C(t) Where N(t) is employment and Ii(t) is investment per capita and the remaining variables use the notation introduced in the lecture. Use as initial conditions N(0)=K(0)=l. Plot the resulting time-paths. Does the economy achieve a steady state? c) Consider the effects of an increase in the saving rate, from 20% to 60%. Plot the resulting time- paths, assuming the economy remains in the steady state described in b) for the first 10 periods and then the change in saving occurs. Does the change in saving have any permanent effects in the growth rates of the economy? Does it have permanent effects on the levels of capital and production? (1) Repeat the same exercise changing the saving rate from 20% to 10%. What is the golden rule level of saving? Explain the evolution of consumption in this and the previous case (comparing then with the benchmark of a 20% saving rate)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!