IDEAS home Printed from https://ideas.repec.org/a/eee/ireced/v35y2020ics1477388020300244.html
   My bibliography  Save this article

Teaching dynamic General equilibrium macroeconomics to undergraduates using a spreadsheet

Author

Listed:
  • Bongers, Anelí
  • Gómez, Trinidad
  • Torres, José L.

Abstract

Dynamic Stochastic General Equilibrium (DSGE) models have become the fundamental theoretical framework in current macroeconomic analysis. However, with very few exceptions, they are not taught to undergraduate students, in spite of the fact that they form the core of standard economics graduate programmes. One of the main barriers for teaching DSGE models at an undergraduate level is not theoretical complexity, but rather, computer skills, as these models have to be solved numerically using specific software. In this paper, we propose a method for solving DSGE models using a spreadsheet, with computer software widely known by students: Microsoft Excel. We consider two different alternative approaches to solving DSGE models in Excel. First, the model can be solved using Excel’s Solver tool. Second, the model can be linearized and numerically simulated directly in a spreadsheet. We think that these approaches can pave the way for teaching DSGE modelling to students in an undergraduate advanced macroeconomics course by removing the limitations imposed by the requisite computer skills.

Suggested Citation

  • Bongers, Anelí & Gómez, Trinidad & Torres, José L., 2020. "Teaching dynamic General equilibrium macroeconomics to undergraduates using a spreadsheet," International Review of Economics Education, Elsevier, vol. 35(C).
    • Handle: RePEc:eee:ireced:v:35:y:2020:i:c:s1477388020300244
    DOI: 10.1016/j.iree.2020.100197
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S1477388020300244
    Download Restriction: Full text for ScienceDirect subscribers only
    File URL: https://libkey.io/10.1016/j.iree.2020.100197?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. David Colander, 2018. "The Macro Pedagogy Debate: Teaching DSGE to Undergraduates Symposium," The Journal of Economic Education, Taylor & Francis Journals, vol. 49(3), pages 224-225, July.
    2. Olivier Blanchard, 2016. "Do DSGE Models Have a Future?," Policy Briefs PB16-11, Peterson Institute for International Economics.
    3. Findley, T. Scott, 2014. "Using MS Excel to solve and simulate the Life-Cycle/Permanent-Income Model of Consumption and Saving," International Review of Economics Education, Elsevier, vol. 16(PB), pages 129-146.
    4. Miles Cahill & George Kosicki, 2001. "A Framework for Developing Spreadsheet Applications in Economics," Working Papers 0102, College of the Holy Cross, Department of Economics.
    5. Miles Cahill & George Kosicki, 2000. "Exploring Economic Models Using Excel," Southern Economic Journal, John Wiley & Sons, vol. 66(3), pages 770-792, January.
    6. Mark Setterfield, 2018. "The Macro Pedagogy Debate: Teaching DSGE to Undergraduates Symposium," The Journal of Economic Education, Taylor & Francis Journals, vol. 49(3), pages 237-241, July.
    7. Marimon, Ramon & Scott, Andrew (ed.), 1999. "Computational Methods for the Study of Dynamic Economies," OUP Catalogue, Oxford University Press, number 9780198294979, Decembrie.
    8. Chu, Angus C., 2018. "From Solow to Romer: Teaching endogenous technological change in undergraduate economics," International Review of Economics Education, Elsevier, vol. 27(C), pages 10-15.
    9. Tsigaris, Panagiotis & Wood, Joel, 2016. "A simple climate-Solow model for introducing the economics of climate change to undergraduate students," International Review of Economics Education, Elsevier, vol. 23(C), pages 65-81.
    10. Seth Neumuller & Casey Rothschild & Akila Weerapana, 2018. "The Macro Pedagogy Debate: Teaching DSGE to Undergraduates Symposium," The Journal of Economic Education, Taylor & Francis Journals, vol. 49(3), pages 242-251, July.
    11. Holger Strulik, 2004. "Solving Rational Expectations Models Using Excel," The Journal of Economic Education, Taylor & Francis Journals, vol. 35(3), pages 269-283, July.
    12. Mario Solis-Garcia, 2018. "The Macro Pedagogy Debate: Teaching DSGE to Undergraduates Symposium," The Journal of Economic Education, Taylor & Francis Journals, vol. 49(3), pages 226-236, July.
    13. Barreto,Humberto, 2016. "Teaching Macroeconomics with Microsoft Excel®," Cambridge Books, Cambridge University Press, number 9781107584983.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Bongers, Anelí & Molinari, Benedetto & Torres, José L., 2022. "Computers, Programming and Dynamic General Equilibrium Macroeconomic Modeling," MPRA Paper 112505, University Library of Munich, Germany.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Bongers, Anelí & Molinari, Benedetto & Torres, José L., 2022. "Computers, Programming and Dynamic General Equilibrium Macroeconomic Modeling," MPRA Paper 112505, University Library of Munich, Germany.
    2. John Gilbert & Onur A. Koska & Reza Oladi, 2022. "Building and Using Nonlinear Excel Simulations: An Application to the Specific Factors Model," Working Papers in Economics 22/08, University of Canterbury, Department of Economics and Finance.
    3. John Gilbert & Onur A. Koska & Reza Oladi, 2023. "Building and using nonlinear simulations in Excel with an application to the specific factors model," Southern Economic Journal, John Wiley & Sons, vol. 89(4), pages 1242-1265, April.
    4. Holger Strulik, 2004. "Solving Rational Expectations Models Using Excel," The Journal of Economic Education, Taylor & Francis Journals, vol. 35(3), pages 269-283, July.
    5. Miles B. Cahill, 2003. "Teaching Chain-Weight Real GDP Measures," The Journal of Economic Education, Taylor & Francis Journals, vol. 34(3), pages 224-234, January.
    6. Adnan Haider Bukhari & Safdar Ullah Khan, 2008. "A Small Open Economy DSGE Model for Pakistan," The Pakistan Development Review, Pakistan Institute of Development Economics, vol. 47(4), pages 963-1008.
    7. Matteo Iacoviello, 2008. "Household Debt and Income Inequality, 1963–2003," Journal of Money, Credit and Banking, Blackwell Publishing, vol. 40(5), pages 929-965, August.
    8. Esther Eiling & Raymond Kan & Ali Sharifkhani, 2018. "Sectoral Labor Reallocation and Return Predictability," Working Papers 2018-006, Human Capital and Economic Opportunity Working Group.
    9. Linnemann, Ludger & Schabert, Andreas, 2003. "Fiscal Policy in the New Neoclassical Synthesis," Journal of Money, Credit and Banking, Blackwell Publishing, vol. 35(6), pages 911-929, December.
    10. Gomme, Paul & Klein, Paul, 2011. "Second-order approximation of dynamic models without the use of tensors," Journal of Economic Dynamics and Control, Elsevier, vol. 35(4), pages 604-615, April.
    11. Régis Barnichon & Geert Mesters, 2020. "Optimal policy perturbations," Economics Working Papers 1716, Department of Economics and Business, Universitat Pompeu Fabra.
    12. Michael Creel, 2008. "Using Parallelization to Solve a Macroeconomic Model: A Parallel Parameterized Expectations Algorithm," Computational Economics, Springer;Society for Computational Economics, vol. 32(4), pages 343-352, November.
    13. S. Sirakaya & Stephen Turnovsky & M. Alemdar, 2006. "Feedback Approximation of the Stochastic Growth Model by Genetic Neural Networks," Computational Economics, Springer;Society for Computational Economics, vol. 27(2), pages 185-206, May.
    14. Andrew Bauer & Nicholas Haltom & Juan F. Rubio-Ramirez, 2003. "Using the Kalman filter to smooth the shocks of a dynamic stochastic general equilibrium model," FRB Atlanta Working Paper 2003-32, Federal Reserve Bank of Atlanta.
    15. Yongsung Chang & Sun-Bin Kim & Bo Hyun Chang, 2015. "Pareto Weights in Practice: Income Inequality and Tax Reform," 2015 Meeting Papers 224, Society for Economic Dynamics.
    16. Dennis, Richard & Kirsanova, Tatiana, 2016. "Computing Markov-Perfect Optimal Policies In Business-Cycle Models," Macroeconomic Dynamics, Cambridge University Press, vol. 20(7), pages 1850-1872, October.
    17. Kobayashi Keiichiro & Nutahara Kengo, 2010. "Nominal Rigidities, News-Driven Business Cycles, and Monetary Policy," The B.E. Journal of Macroeconomics, De Gruyter, vol. 10(1), pages 1-26, September.
    18. Heer Burkhard & Maußner Alfred, 2011. "Value Function Iteration as a Solution Method for the Ramsey Model," Journal of Economics and Statistics (Jahrbuecher fuer Nationaloekonomie und Statistik), De Gruyter, vol. 231(4), pages 494-515, August.
    19. Jonathan Heathcote, 2003. "On the Distributional Effects of Reducing Capital Taxes (previously: Factor Taxation with Heterogeneous Agents)," Working Papers gueconwpa~03-03-22, Georgetown University, Department of Economics.
    20. Berriel, Tiago Couto & Zilberman, Eduardo, 2011. "Targeting the poor: a macroeconomic analysis of cash transfer programs," FGV EPGE Economics Working Papers (Ensaios Economicos da EPGE) 726, EPGE Brazilian School of Economics and Finance - FGV EPGE (Brazil).

    More about this item

    Keywords

    Advanced macroeconomics; Dynamic General equilibrium models; Undergraduate education; Spreadsheet;
    All these keywords.

    JEL classification:

    • A22 - General Economics and Teaching - - Economic Education and Teaching of Economics - - - Undergraduate
    • C63 - Mathematical and Quantitative Methods - - Mathematical Methods; Programming Models; Mathematical and Simulation Modeling - - - Computational Techniques
    • E27 - Macroeconomics and Monetary Economics - - Consumption, Saving, Production, Employment, and Investment - - - Forecasting and Simulation: Models and Applications
    • E37 - Macroeconomics and Monetary Economics - - Prices, Business Fluctuations, and Cycles - - - Forecasting and Simulation: Models and Applications

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:ireced:v:35:y:2020:i:c:s1477388020300244. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: http://www.journals.elsevier.com/international-review-of-economics-education .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.