The aim of this exercise is for you to simulate the equilibrium of the Solow growth model on the computer. By programming it on a simple spreadsheet you will obtain a better understanding of the model.
Follow the prompt below. You will need to create a spreadsheet. To do so, you may use any spreadsheet software, for example, Excel (available to UCI students here (Links to an external site.)). You may also use Python, Matlab, R, or Julia. If you prefer to use another programming language please email Bryan for approval first.
To receive full credit, you will need to:
- Provide your answers
- Upload your spreadsheet (click “file upload”)
If you have difficulties completing this assignment, make sure to ask questions during office hours, we will be happy to help.
Suppose that you have a standard Solow model with a Cobb-Douglas production function,
(a) Derive the closed-form solution for steady-state capital stock,
(b) Suppose that A = 1, s = 0.2, d=0.1, and
= 1/3. Create a new spreadsheet. In the top-left cell, using your answer from (a), numerically solve for
(c) Create a column in your spreadsheet corresponding to periods. Let these periods run from period 0 to period 100. Create additional columns for capital stock, output, consumption, investment, depreciation, and change in capital stock. (2 points)
(d) Suppose that in period 0, the capital stock per worker equals its steady state (i.e.
(e) Using the central equation of the Solow model, compute capital stock per worker in period 1. Then repeat the process and fill in for output per worker, consumption per worker, investment per worker, depreciation, and change in the per worker capital stock in period 1. (2 points)
(f) Iterate this process until you have filled all of the columns up to period 9. What is true about the per worker capital stock in periods 0 through 9 when the per worker capital stock starts in the steady-state in period 0? (3 points)
(g) Suppose that in period 10, the saving rate increases to 0.25 and is expected to forever remain there. What will happen to the capital stock in period 10? (2 points)
(h) Compute the capital stock in period 11, given the capital stock in period 10 and the new, higher saving rate. Compute and fill in for output, consumption, investment, depreciation, and change in capital stock in period 11. (1 point)
(i) Iterate and fill in all of the columns all the way to period 100. (2 points)
(j) Approximately how many periods does it take the capital stock to get halfway to its new, higher steady-state value when s increases from 0.2 to 0.25? (5 points)
"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."