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. 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.
    2. 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.
    3. 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.
    4. Olivier Blanchard, 2016. "Do DSGE Models Have a Future?," Policy Briefs PB16-11, Peterson Institute for International Economics.
    5. 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.
    6. 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.
    7. Miles Cahill & George Kosicki, 2001. "A Framework for Developing Spreadsheet Applications in Economics," Working Papers 0102, College of the Holy Cross, Department of Economics.
    8. Miles Cahill & George Kosicki, 2000. "Exploring Economic Models Using Excel," Southern Economic Journal, John Wiley & Sons, vol. 66(3), pages 770-792, January.
    9. Holger Strulik, 2004. "Solving Rational Expectations Models Using Excel," The Journal of Economic Education, Taylor & Francis Journals, vol. 35(3), pages 269-283, July.
    10. 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.
    11. 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.
    12. Barreto,Humberto, 2016. "Teaching Macroeconomics with Microsoft Excel®," Cambridge Books, Cambridge University Press, number 9781107584983, September.
    13. Marimon, Ramon & Scott, Andrew (ed.), 1999. "Computational Methods for the Study of Dynamic Economies," OUP Catalogue, Oxford University Press, number 9780198294979.
    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. Holger Strulik, 2004. "Solving Rational Expectations Models Using Excel," The Journal of Economic Education, Taylor & Francis Journals, vol. 35(3), pages 269-283, July.
    3. 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.
    4. 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.
    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. 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.
    10. 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.
    11. Carlo A. Favero, 2007. "Model Evaluation in Macroeconometrics: from early empirical macroeconomic models to DSGE models," Working Papers 327, IGIER (Innocenzo Gasparini Institute for Economic Research), Bocconi University.
    12. Maliar, Lilia & Maliar, Serguei, 2004. "Endogenous Growth And Endogenous Business Cycles," Macroeconomic Dynamics, Cambridge University Press, vol. 8(5), pages 559-581, November.
    13. Jaime Alonso-Carrera & Maria Jesus Freire-Seren & Baltasar Manzano, 2008. "Macroeconomic Effects From The Regional Allocation Of Public Capital Formation," CAMA Working Papers 2008-09, Centre for Applied Macroeconomic Analysis, Crawford School of Public Policy, The Australian National University.
    14. Andrew Foerster & Juan F. Rubio‐Ramírez & Daniel F. Waggoner & Tao Zha, 2016. "Perturbation methods for Markov‐switching dynamic stochastic general equilibrium models," Quantitative Economics, Econometric Society, vol. 7(2), pages 637-669, July.
    15. Hanson Michael S. & Kapinos Pavel S., 2008. "Endogenous Persistence and the Performance of Inertial Targeting Rules," The B.E. Journal of Macroeconomics, De Gruyter, vol. 8(1), pages 1-31, March.
    16. Peter J. Boettke & Alexander W. Salter & Daniel J. Smith, 2018. "Money as meta-rule: Buchanan’s constitutional economics as a foundation for monetary stability," Public Choice, Springer, vol. 176(3), pages 529-555, September.
    17. Stephen J. Terry, 2017. "Alternative Methods for Solving Heterogeneous Firm Models," Journal of Money, Credit and Banking, Blackwell Publishing, vol. 49(6), pages 1081-1111, September.
    18. Claudio Campanale, 2007. "Increasing Returns to Savings and Wealth Inequality," Review of Economic Dynamics, Elsevier for the Society for Economic Dynamics, vol. 10(4), pages 646-675, October.
    19. Lindquist, Matthew J., 2005. "The welfare costs of union wage compression," European Economic Review, Elsevier, vol. 49(3), pages 639-658, April.
    20. repec:hal:spmain:info:hdl:2441/7l23tbn4rd9539sljmp8of2hcb is not listed on IDEAS
    21. Ajevskis Viktors, 2017. "Semi-global solutions to DSGE models: perturbation around a deterministic path," Studies in Nonlinear Dynamics & Econometrics, De Gruyter, vol. 21(2), pages 1-28, April.

    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.