Goal: Using Excel to build time series under discrete-time Solow Model.

Please click on the linkages, you'll find the corresponding xls files showing each steps except after step 8.

Step0: In this step, we just build the frame of the table that's we are gonna work on.

Step1: In this step, we build the time series from 0 to 40.

Step2: In this step, we build the technology series from time 0 to time 40.

Step3: In this step, we build k(0) and y(0).

Step4: In this step, we build k(1).

Step5: In this step, we bid to build the whole k(t).

Step6: In this step, we build the output series, and at the same time, we found k(t) would also be done.

Step7: In this step, we build the series for % change in k(t) and % change in y(t).

Step8: Please build the time series but up to time period 150 and observe the  % change in k(t) and % change in y(t) in the end of the series.

                                                                                                                                                                        Go Back