IDEAS home Printed from https://ideas.repec.org/a/taf/jeduce/v35y2004i3p269-283.html
   My bibliography  Save this article

Solving Rational Expectations Models Using Excel

Author

Listed:
  • Holger Strulik

Abstract

Simple problems of discrete-time optimal control can be solved using a standard spreadsheet software. The employed-solution method of backward iteration is intuitively understandable, does not require any programming skills, and is easy to implement so that it is suitable for classroom exercises with rational-expectations models. The author explains the method in general and shows how the basic models of neoclassical growth and real business cycles are solved using Microsoft Excel.

Suggested Citation

  • Holger Strulik, 2004. "Solving Rational Expectations Models Using Excel," The Journal of Economic Education, Taylor & Francis Journals, vol. 35(3), pages 269-283, July.
    • Handle: RePEc:taf:jeduce:v:35:y:2004:i:3:p:269-283
    DOI: 10.3200/JECE.35.3.269-283
    as

    Download full text from publisher

    File URL: http://hdl.handle.net/10.3200/JECE.35.3.269-283
    Download Restriction: Access to full text is restricted to subscribers.
    File URL: https://libkey.io/10.3200/JECE.35.3.269-283?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. Hansen, Gary D., 1985. "Indivisible labor and the business cycle," Journal of Monetary Economics, Elsevier, vol. 16(3), pages 309-327, November.
    2. Kenneth L. Judd, 1998. "Numerical Methods in Economics," MIT Press Books, The MIT Press, edition 1, volume 1, number 0262100711, April.
    3. Maurice Obstfeld & Kenneth S. Rogoff, 1996. "Foundations of International Macroeconomics," MIT Press Books, The MIT Press, edition 1, volume 1, number 0262150476, April.
    4. King, Robert G. & Plosser, Charles I. & Rebelo, Sergio T., 1988. "Production, growth and business cycles : II. New directions," Journal of Monetary Economics, Elsevier, vol. 21(2-3), pages 309-341.
    5. Daniel Fylstra & Leon Lasdon & John Watson & Allan Waren, 1998. "Design and Use of the Microsoft Excel Solver," Interfaces, INFORMS, vol. 28(5), pages 29-55, October.
    6. Cooley, Thomas F. & Hansen, Gary D., 1992. "Tax distortions in a neoclassical monetary economy," Journal of Economic Theory, Elsevier, vol. 58(2), pages 290-316, December.
    7. Heijdra, Ben J., 2017. "Foundations of Modern Macroeconomics," OUP Catalogue, Oxford University Press, edition 3, number 9780198784135.
    8. King, Robert G. & Plosser, Charles I. & Rebelo, Sergio T., 1988. "Production, growth and business cycles : I. The basic neoclassical model," Journal of Monetary Economics, Elsevier, vol. 21(2-3), pages 195-232.
    9. Taylor, John B & Uhlig, Harald, 1990. "Solving Nonlinear Stochastic Growth Models: A Comparison of Alternative Solution Methods," Journal of Business & Economic Statistics, American Statistical Association, vol. 8(1), pages 1-17, January.
    10. Miles Cahill & George Kosicki, 2000. "Exploring Economic Models Using Excel," Southern Economic Journal, John Wiley & Sons, vol. 66(3), pages 770-792, January.
    11. Casey B. Mulligan & Xavier Sala-i-Martin, 1991. "A Note on the Time-Elimination Method For Solving Recursive Dynamic Economic Models," NBER Technical Working Papers 0116, National Bureau of Economic Research, Inc.
    12. Holger Strulik & Martin Brunner, 2001. "A Simple and Intuitive Method to Solve Small Rational Expectations Models," Quantitative Macroeconomics Working Papers 20106, Hamburg University, Department of Economics.
    13. Olivier Jean Blanchard & Stanley Fischer, 1989. "Lectures on Macroeconomics," MIT Press Books, The MIT Press, edition 1, volume 1, number 0262022834, April.
    14. 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í & 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).
    2. Toru Hokari & Masaki Iimura & Seiji Murakoshi & Yoshiko Onuma, 2007. "Simulating a Simple Real Business Cycle Model Using Excel," Computers in Higher Education Economics Review, Economics Network, University of Bristol, vol. 19(1), pages 16-20.
    3. Calvin Blackwell, 2010. "Rational Expectations in the Classroom: A Learning Activity," Journal for Economic Educators, Middle Tennessee State University, Business and Economic Research Center, vol. 10(2), pages 1-6, Fall.

    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. Lilia Maliar & Serguei Maliar & John B. Taylor & Inna Tsener, 2020. "A tractable framework for analyzing a class of nonstationary Markov models," Quantitative Economics, Econometric Society, vol. 11(4), pages 1289-1323, November.
    2. Campbell, John Y., 1994. "Inspecting the mechanism: An analytical approach to the stochastic growth model," Journal of Monetary Economics, Elsevier, vol. 33(3), pages 463-506, June.
    3. Serguei Maliar & John Taylor & Lilia Maliar, 2016. "The Impact of Alternative Transitions to Normalized Monetary Policy," 2016 Meeting Papers 794, Society for Economic Dynamics.
    4. Özer Karagedikli & Troy Matheson & Christie Smith & Shaun P. Vahey, 2010. "RBCs AND DSGEs: THE COMPUTATIONAL APPROACH TO BUSINESS CYCLE THEORY AND EVIDENCE," Journal of Economic Surveys, Wiley Blackwell, vol. 24(1), pages 113-136, February.
    5. Etro, Federico, 2017. "Research in economics and macroeconomics," Research in Economics, Elsevier, vol. 71(3), pages 373-383.
    6. Uhlig, H.F.H.V.S., 1995. "A toolkit for analyzing nonlinear dynamic stochastic models easily," Other publications TiSEM cc1b2469-9d2f-445a-a2b3-1, Tilburg University, School of Economics and Management.
    7. Posch, Olaf & Trimborn, Timo, 2013. "Numerical solution of dynamic equilibrium models under Poisson uncertainty," Journal of Economic Dynamics and Control, Elsevier, vol. 37(12), pages 2602-2622.
    8. José Cao-Alvira, 2010. "Finite Elements in the Presence of Occasionally Binding Constraints," Computational Economics, Springer;Society for Computational Economics, vol. 35(4), pages 355-370, April.
    9. Kollman, R., 1996. "The Exchange Rate in a Dynamic-Optimizing Current Account Model with Nominal Rigidities: a Quantitative Investigation," Cahiers de recherche 9614, Universite de Montreal, Departement de sciences economiques.
    10. Fujiwara, Ippei & Hara, Naoko & Hirose, Yasuo & Teranishi, Yuki, 2005. "The Japanese Economic Model (JEM)," Monetary and Economic Studies, Institute for Monetary and Economic Studies, Bank of Japan, vol. 23(2), pages 61-142, May.
    11. Lars J. Olson & Santanu Roy, 2006. "Theory of Stochastic Optimal Economic Growth," Springer Books, in: Rose-Anne Dana & Cuong Le Van & Tapan Mitra & Kazuo Nishimura (ed.), Handbook on Optimal Growth 1, chapter 11, pages 297-335, Springer.
    12. Alfonso Novales & Javier J. PÈrez, 2004. "Is It Worth Refining Linear Approximations to Non-Linear Rational Expectations Models?," Computational Economics, Springer;Society for Computational Economics, vol. 23(4), pages 343-377, June.
    13. Lan, Hong & Meyer-Gohde, Alexander, 2014. "Solvability of perturbation solutions in DSGE models," Journal of Economic Dynamics and Control, Elsevier, vol. 45(C), pages 366-388.
    14. Schmidt, Sebastian & Wieland, Volker, 2013. "The New Keynesian Approach to Dynamic General Equilibrium Modeling: Models, Methods and Macroeconomic Policy Evaluation," Handbook of Computable General Equilibrium Modeling, in: Peter B. Dixon & Dale Jorgenson (ed.), Handbook of Computable General Equilibrium Modeling, edition 1, volume 1, chapter 0, pages 1439-1512, Elsevier.
    15. Mitra, Kaushik & Evans, George W. & Honkapohja, Seppo, 2013. "Policy change and learning in the RBC model," Journal of Economic Dynamics and Control, Elsevier, vol. 37(10), pages 1947-1971.
    16. Harald Uhlig, 1995. "A toolkit for analyzing nonlinear dynamic stochastic models easily," Discussion Paper / Institute for Empirical Macroeconomics 101, Federal Reserve Bank of Minneapolis.
    17. Ilaski Barañano, 2001. "Endogenous growth and economic fluctuations," Investigaciones Economicas, Fundación SEPI, vol. 25(3), pages 515-541, September.
    18. Lahiri, Radhika, 2002. "The Inflation Tax, Variable Time Preference, And The Business Cycle," Macroeconomic Dynamics, Cambridge University Press, vol. 6(4), pages 496-522, September.
    19. Miroljub Labus & Milica Labus, 2019. "Monetary Transmission Channels in DSGE Models: Decomposition of Impulse Response Functions Approach," Computational Economics, Springer;Society for Computational Economics, vol. 53(1), pages 27-50, January.
    20. Finn, Mary G., 1995. "Variance properties of Solow's productivity residual and their cyclical implications," Journal of Economic Dynamics and Control, Elsevier, vol. 19(5-7), pages 1249-1281.

    More about this item

    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:taf:jeduce:v:35:y:2004:i:3:p:269-283. 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: Chris Longhurst (email available below). General contact details of provider: http://www.tandfonline.com/VECE20 .

    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.