Book contents
- Frontmatter
- Dedication
- Contents
- Preface
- Software Requirements and Opening a Macro-Enhanced Workbook
- Introduction:Why Simulation and Excel?
- 1 Charting in Excel
- 2 Economic Growth Literacy
- 3 The Solow Model
- 3.1 Introduction
- 3.2 Capital Accumulation: KAcc.xls
- 3.3 The Golden Rule: GoldenRule.xls
- 3.4 Population Growth: Population.xls
- 3.5 Technological Progress: TechProgress.xls
- 4 Macro Data with FRED in Excel
- 5 The Keynesian Model
- References
3.2 - Capital Accumulation: KAcc.xls
from 3 - The Solow Model
Published online by Cambridge University Press: 05 May 2016
- Frontmatter
- Dedication
- Contents
- Preface
- Software Requirements and Opening a Macro-Enhanced Workbook
- Introduction:Why Simulation and Excel?
- 1 Charting in Excel
- 2 Economic Growth Literacy
- 3 The Solow Model
- 3.1 Introduction
- 3.2 Capital Accumulation: KAcc.xls
- 3.3 The Golden Rule: GoldenRule.xls
- 3.4 Population Growth: Population.xls
- 3.5 Technological Progress: TechProgress.xls
- 4 Macro Data with FRED in Excel
- 5 The Keynesian Model
- References
Summary
Moreover, the production function has been a powerful instrument of miseducation. The student of economic theory is taught to write O = f(L, C) where L is a quantity of labour, C a quantity of capital and O a rate of output of commodities. He is instructed to assume all workers alike, and to measure L in man-hours of labour; he is told something about the index-number problem involved in choosing a unit of output; and then he is hurried on to the next question, in the hope that he will forget to ask in what units C is measured. Before ever he does ask, he has become a professor, and so sloppy habits of thought are handed on from one generation to the next.
– Joan RobinsonQuick Summary
To access KAcc.xls, visit
http://www.depauw.edu/learn/macroexcel/excelworkbooks/SolowModel/KAcc.xls
KAcc.xls includes several sheets that carefully explain capital accumulation in a basic version of the Solow Model (no population growth or technological progress) and an EqPath sheet that enables quick simulation of an economy, along with a series of charts to display results.
Screencasts
• http://vimeo.com/econexcel/kacc: introduces the Solow Model and shows how to use the EqPath sheet to run a simulation and find the steady-state solution
• http://vimeo.com/econexcel/kacccs: copies the EqPath sheet and does comparative statics analysis via direct comparison of two economies
Introduction
To teach the Solow Model effectively, the material must be chopped into bite-sized pieces. KAcc.xls introduces the model, focusing on the core, iterative mechanics at the heart of the model. It also shows how capital accumulates when starting below the steady-state, and then settles into a repetitive pattern that is the hallmark of the steady-state. This simple model can generate only catch-up growth (with no growth in the steady-state), so it is clearly a stepping-stone that must be extended to exhibit persistent, long-run growth.
Common Problems for Students
Not only are almost all students unfamiliar with dynamic models, most find the notation of the Solow Model to be a significant barrier. Solow (1956) cleverly transformed a two-variable, L and K, system into a single variable, k = K/L, model, but undergraduate students tend to overlook the levels versus per worker distinction in the variables. It is important to continually stress and write out the variables, for example, “output per worker,” instead of merely using y.
- Type
- Chapter
- Information
- Teaching Macroeconomics with Microsoft Excel® , pp. 61 - 71Publisher: Cambridge University PressPrint publication year: 2016