solow_dynamics.xlsx

	A	B	C	D	E	F	G	H	I
1	Solow
2	Technologie Cobb-Douglas: Y=K^(alpha)*L^(1-alpha)
3
4	Dynamique:	k_t+1 = sk_t^alpha + (1-delta)k_t
5
6	Paramètres du modèle:
7	alpha	0.5
8	delta	0.10
9	s	0.3
10	k_1	4
11
12	St/st:
13	Note st/st: k*=(s/delta)^(1/(1-alpha))
14	k*	9
15
16	Année t	k_t	y_t	c_t	i_t	delta*k_t	k_t+1 - k_t	g_k %	g_y %
17	1	4.000	2.000	1.400	0.600	0.400	0.200	5.000	2.470
18	2	4.200	2.049	1.435	0.615	0.420	0.195	4.639	2.293
19	3	4.395	2.096	1.467	0.629	0.439	0.189	4.310	2.132
20	4	4.584	2.141	1.499	0.642	0.458	0.184	4.012	1.986
21	5	4.768	2.184	1.529	0.655	0.477	0.178	3.739	1.852
22	6	4.946	2.224	1.557	0.667	0.495	0.173	3.489	1.729
23	7	5.119	2.263	1.584	0.679	0.512	0.167	3.260	1.617
24	8	5.286	2.299	1.609	0.690	0.529	0.161	3.049	1.513
25	9	5.447	2.334	1.634	0.700	0.545	0.155	2.854	1.417
26	10	5.602	2.367	1.657	0.710	0.560	0.150	2.675	1.328
27	11	5.752	2.398	1.679	0.720	0.575	0.144	2.508	1.246
28	12	5.897	2.428	1.700	0.728	0.590	0.139	2.354	1.170
29	13	6.035	2.457	1.720	0.737	0.604	0.133	2.211	1.100
30	14	6.169	2.484	1.739	0.745	0.617	0.128	2.079	1.034
31	15	6.297	2.509	1.757	0.753	0.630	0.123	1.955	0.973
32	16	6.420	2.534	1.774	0.760	0.642	0.118	1.840	0.916
33	17	6.538	2.557	1.790	0.767	0.654	0.113	1.732	0.862
34	18	6.652	2.579	1.805	0.774	0.665	0.109	1.632	0.813
35	19	6.760	2.600	1.820	0.780	0.676	0.104	1.538	0.766
36	20	6.864	2.620	1.834	0.786	0.686	0.100	1.451	0.723
37	21	6.964	2.639	1.847	0.792	0.696	0.095	1.368	0.682
38	22	7.059	2.657	1.860	0.797	0.706	0.091	1.291	0.644
39	23	7.150	2.674	1.872	0.802	0.715	0.087	1.219	0.608
40	24	7.237	2.690	1.883	0.807	0.724	0.083	1.151	0.574
41	25	7.321	2.706	1.894	0.812	0.732	0.080	1.088	0.542
42	26	7.400	2.720	1.904	0.816	0.740	0.076	1.028	0.513
43	27	7.476	2.734	1.914	0.820	0.748	0.073	0.972	0.485
44	28	7.549	2.748	1.923	0.824	0.755	0.069	0.919	0.458
45	29	7.618	2.760	1.932	0.828	0.762	0.066	0.869	0.434
46	30	7.685	2.772	1.940	0.832	0.768	0.063	0.822	0.410
47	31	7.748	2.783	1.948	0.835	0.775	0.060	0.778	0.388
48	32	7.808	2.794	1.956	0.838	0.781	0.057	0.736	0.367
49	33	7.866	2.805	1.963	0.841	0.787	0.055	0.697	0.348
50	34	7.920	2.814	1.970	0.844	0.792	0.052	0.660	0.329
51	35	7.973	2.824	1.977	0.847	0.797	0.050	0.625	0.312
52	36	8.022	2.832	1.983	0.850	0.802	0.047	0.592	0.295
53	37	8.070	2.841	1.989	0.852	0.807	0.045	0.561	0.280
54	38	8.115	2.849	1.994	0.855	0.812	0.043	0.531	0.265
55	39	8.158	2.856	1.999	0.857	0.816	0.041	0.503	0.251
56	40	8.199	2.863	2.004	0.859	0.820	0.039	0.477	0.238
57	41	8.238	2.870	2.009	0.861	0.824	0.037	0.452	0.226
58	42	8.276	2.877	2.014	0.863	0.828	0.035	0.428	0.214
59	43	8.311	2.883	2.018	0.865	0.831	0.034	0.406	0.203
60	44	8.345	2.889	2.022	0.867	0.834	0.032	0.385	0.192
61	45	8.377	2.894	2.026	0.868	0.838	0.031	0.365	0.182
62	46	8.408	2.900	2.030	0.870	0.841	0.029	0.346	0.173
63	47	8.437	2.905	2.033	0.871	0.844	0.028	0.328	0.164
64	48	8.464	2.909	2.037	0.873	0.846	0.026	0.312	0.156
65	49	8.491	2.914	2.040	0.874	0.849	0.025	0.296	0.148
66	50	8.516	2.918	2.043	0.875	0.852	0.024	0.280	0.140
67	51	8.540	2.922	2.046	0.877	0.854	0.023	0.266	0.133
68	52	8.562	2.926	2.048	0.878	0.856	0.022	0.252	0.126
69	53	8.584	2.930	2.051	0.879	0.858	0.021	0.239	0.120
70	54	8.605	2.933	2.053	0.880	0.860	0.020	0.227	0.114
71	55	8.624	2.937	2.056	0.881	0.862	0.019	0.216	0.108
72	56	8.643	2.940	2.058	0.882	0.864	0.018	0.205	0.102
73	57	8.660	2.943	2.060	0.883	0.866	0.017	0.194	0.097
74	58	8.677	2.946	2.062	0.884	0.868	0.016	0.184	0.092
75	59	8.693	2.948	2.064	0.885	0.869	0.015	0.175	0.087
76	60	8.708	2.951	2.066	0.885	0.871	0.014	0.166	0.083
77	61	8.723	2.953	2.067	0.886	0.872	0.014	0.158	0.079
78	62	8.737	2.956	2.069	0.887	0.874	0.013	0.150	0.075
79	63	8.750	2.958	2.071	0.887	0.875	0.012	0.142	0.071
80	64	8.762	2.960	2.072	0.888	0.876	0.012	0.135	0.067
81	65	8.774	2.962	2.073	0.889	0.877	0.011	0.128	0.064
82	66	8.785	2.964	2.075	0.889	0.879	0.011	0.122	0.061
83	67	8.796	2.966	2.076	0.890	0.880	0.010	0.115	0.058
84	68	8.806	2.967	2.077	0.890	0.881	0.010	0.110	0.055
85	69	8.816	2.969	2.078	0.891	0.882	0.009	0.104	0.052
86	70	8.825	2.971	2.079	0.891	0.882	0.009	0.099	0.049
87	71	8.834	2.972	2.080	0.892	0.883	0.008	0.094	0.047
88	72	8.842	2.974	2.081	0.892	0.884	0.008	0.089	0.045
89	73	8.850	2.975	2.082	0.892	0.885	0.007	0.085	0.042
90	74	8.857	2.976	2.083	0.893	0.886	0.007	0.080	0.040
91	75	8.864	2.977	2.084	0.893	0.886	0.007	0.076	0.038
92	76	8.871	2.978	2.085	0.894	0.887	0.006	0.072	0.036
93	77	8.877	2.980	2.086	0.894	0.888	0.006	0.069	0.034
94	78	8.884	2.981	2.086	0.894	0.888	0.006	0.065	0.033
95	79	8.889	2.982	2.087	0.894	0.889	0.006	0.062	0.031
96	80	8.895	2.982	2.088	0.895	0.889	0.005	0.059	0.029
97	81	8.900	2.983	2.088	0.895	0.890	0.005	0.056	0.028
98	82	8.905	2.984	2.089	0.895	0.891	0.005	0.053	0.027
99	83	8.910	2.985	2.089	0.895	0.891	0.004	0.050	0.025
100	84	8.914	2.986	2.090	0.896	0.891	0.004	0.048	0.024