5The Solow Model Unleashed.xlsx

The Solow Mo Model Unleashed: Understanding Eco Nicolas Vincent and Pierre Yared Yared Columbia CaseWorks ID: 130304

Abstract: Te !ollo"in# !ollo"in# s$reads s$readseets eets accom$an% accom$an% te &Te &Te 'olo" (odel (odel )nleased: )nleased: )nderst )nderstan an

omic Growth

in# *conomic +ro"t& case stud%,

Copyright Information © 2013 by The Trustees o !olumbia Uni"ersity in the !ity o #ew #either this s(readsheet nor the associated case can be used or r without e)(licit (ermission rom !olumbia !ase*or%s& To obtain (ermission+ (lease "isit: www&gsb&columbia&edu-!ase*or%s or e,mail: !olumbia!ase*or%s.gsb&columbia&edu

or%& 'll rights reser"ed& (roduced

The Solow Model Unleashed: Understanding Economic Gro Nicolas Vincent and Pierre Yared

The ollowing (arameters in the yellow bo)es can be changed tart ng o(u at on tart ng a( ta 0

o(0

Starting Total /actor roducti"ity '0 o(ulation Growth 7 o( Em(loyment to o(ulation atio #-o( 4n"estment ate 4-$ Total /actor roducti"ity Growth 7 ' 5e(reciation ate

US 1-0 10000

/rance-US 0,30 0,03

/rance 4.-0

10 ./ 0,40 0,30 0/ -/

1,00 1,00 1,.1,00 1,00 1,00

10 ./ 0,-0 0,30 0/ -/

Output per Capita - France and U 1000000000000.000

10000000000.000

100000000.000

1000000.000

10000.000

100.000

1.000 1950

1960

1970

1980

1990

2

th Columbia CaseWorks ID: 130304

FRANCE

000

2010

2020


)NIT*D 'TAT* $ears rom #ow t

o(ulation o(

8abor #

!a(ital 6

!a(ital,8abor Total /actor atio 6-# roducti"ity '

1-0

1-0

0

10000

12

10,00

1-1 1-. 1-3 1-4 1-1- 1-2 1- 1- 10 11 1. 13 14 11 12 1 1 120

1-3 1- 1- 1. 1 1 12. 12 12 13 12 10 14 1 .0. .0 .10 .14 .1 ..3

1 . 4    20 2. 23 22 2 2 1 . 4  2 

10331024 1101 1131 11211 1.04 1.4.1 1.2. 1314 13-12 13. 14.21 14-1-044 1-43 1-32 1.4. 1-3 12020 124.

1 121 123 12122 12 10 1. 13 11 1 1 10 11 1. 13 14 11

10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00

121 12. 123 124 1212 122 12 12 10

..2 .3. .32 .41 .4 .-1 .- .1 . .2.

1 3 2  100 10. 104 102 10

12.1 13- 12 1.42 120. .01.03.111. .1-2 ..00

12 1 1 1 .00 .01 .01 .0. .03 .03

10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00

wth Columbia CaseWorks ID: 130304

roduction $ 4n"estment 4

5e(reciation d6

roduction (er !a(ita $-o(

.24

3-

-00

1,-.

.-1 .1 . 30- 31. 3.01 3.24 334 34.4 3-01 3-2 3- 323 3.1 3030 402 414 4.-4 434-

-2  12 3 0 . 10010.2 10-0 1024 102 11.. 114 1121 112 1..3 1.4 1.2 1303

-12 -34 --1 - - 03 .1 3 -2 2 214 233 2-. 22. 2. 1. 33 -3 2-

1,31,201,221 1,33 1,3 1,4 1,00. 1,0-3 1,101 1,14 1,1 1,.30 1,. 1,30 1,34. 1,321,402 1,432 1,41,43

4432 4-3. 4. 42. 4. 4.2 -031 -13 -.43 -3-3

1331 130 13 141 144 142 1-0 1-41 1-23 10

 1 40 . 100 103. 10- 100 110-

1,-1 1,-43 1,- 1,- 1,10 1,30 1,4 1,2 1,4 1,200


5ANC* $ears rom #ow t


8abor #

!a(ital 6


1-0

4-

..,-

.-0

11

10,00

1-1 1-. 1-3 1-4 1-1- 1-2 1- 1- 10 11 1. 13 14 11 12 1 1 120

4 42 4 4 -0 -1 -. -3 -4 -- -2 - - 1 . 3 4  2

34 -1 2 114 121 .- 34 -22 1.2 14 .1 432 - -3 1422 ..1 33.-3 42 241

322 - -. 1.2 1.1 .4330 4 2-1 1431 .1-0 3.31 4401 2410 1111 12. .-01-1 32-.32 -. 44310

11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11

10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00

121 12. 123 124 1212 122 12 12 10

 20 21 2. 24 222 2 0 .

11...2 1341 .-.-1. 322 -1-1 -...2 1.2340 112-11 .2. 43143

1.42 1233 .41 4.24443 41112--1 144.3-. .13-- 3.4-3 404

11 11 11 11 11 11 11 11 11 11

10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00 10,00

wth Columbia CaseWorks ID:130304

roduction $ 4n"estment 4



43

13

13

10,.2

 1041- .3-3 3-31 -. 24 11. 120 .3 40.- 031 0-0 13- .033 30-2- 4-43 2 10310 1-4242

.0 313 420 20 10- 1-0 .33-2 -32 0-1 1.02 1112 .2122 402 11-1 12. 132-3 .031 30- 4434

1 . 43 4  144 .12 3.4 23. 10 142 .420 320--- 33 1.-0 12. .143 4..1

1-,10 ..,313.,32 4,314 21,02 104,--1 1-3,23 ..,133.,. 4,.-0 21,-. 160-,12 16--,1 .6.,- 363-,30 464,-.26.2,2 106204,14 1-6241,-32 .3614,41

.3.1.2 34. -..43- 23-4 112-433 123... .44402 32.. --0- .34-3

-2 104420 1-2302 .3-04 3-.4-0 -.2 234-.. 11012 12-.2 .2203

33.4 42 14.41 .132.. 3.0-4 402 2.131 1012 1.. .4344-4

346043,3 -0603,236.3,-04 106.20,000 1-6..0,24. .34614,31 344633-,4-0632,-1 244621,22 160-610-,42


)NIT*D 'TAT*' 7 Partial $ears rom #ow t


8abor #

!a(ital 6

1-0

1-0

0

10000

12

10,00

1-1 1-. 1-3 1-4 1-1- 1-2 1- 1- 10 11 1. 13 14 11 12 1 1 120 121 12. 123 124 1212 122 12 12 10 11 1. 13 14 11

1-3

1

1033-

1

10,00

..3



124.

1

10,00

12 1


1 10 11 1. 13 14 11 12 1 1 .000 .001 .00. .003 .004 .00.00 .002 .00 .00 .010

331

13.

.2-0-

.0

10,00

4.

12

412.1

.1.

10,00

wth Columbia CaseWorks ID: 130304

ans"ers roduction $ 4n"estment 4



.24

3-

-00

1,-.

.-1

--

-12

1,3-

434-

1303

2-

1,43

-2

120

132-

1,.

1

.4-

.0

1,4

5The Solow Model Unleashed.xlsx

Recommend Documents