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
- 4 Macro Data with FRED in Excel
- 5 The Keynesian Model
- 5.1 Introduction
- 5.2 The Keynesian Cross: KCross.xls
- 5.3 The Money Market: MoneyMarket.xls
- 5.4 The ISLM Model: ISLM.xls
- 5.5 The ISLMADAS Model: ISLMADAS.xls
- References
5.3 - The Money Market: MoneyMarket.xls
from 5 - The Keynesian 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
- 4 Macro Data with FRED in Excel
- 5 The Keynesian Model
- 5.1 Introduction
- 5.2 The Keynesian Cross: KCross.xls
- 5.3 The Money Market: MoneyMarket.xls
- 5.4 The ISLM Model: ISLM.xls
- 5.5 The ISLMADAS Model: ISLMADAS.xls
- References
Summary
The bad news is that we have just been through a once-in-hundred-year credit tsunami that has had a devastating impact on the economy that will last for years to come. The good news is that macro/monetary economists and central bankers do not have to go back to the drawing board and throw out all that they have learned over the last forty years.
– Frederic S. MishkinQuick Summary
To access MoneyMarket.xls, visit
http://www.depauw.edu/learn/macroexcel/excelworkbooks/ISLMModel/MoneyMarket.xls
MoneyMarket.xls provides a quick explanation of the equilibrium interest rate (r) that is produced by money demand and supply. It also uses the Baumol–Tobin Model to explain why money demand is a function of the interest rate and income.
Screencasts
• http://vimeo.com/econexcel/mmintro: introduces the money market and uses Excel's Solver to find the equilibrium interest rate
• http://vimeo.com/econexcel/mmcs: does comparative statics in the money market by exploring the effect on the equilibrium interest rate when changing the money supply
• http://vimeo.com/econexcel/mmmoneydemand: uses a Baumol–Tobin Model to derive money demand from a comparative statics analysis (using the Scenario Comp Statics add-in)
Introduction
This workbook is a stepping-stone on the way to the ISLM Model. Instead of an exogenously given interest rate, money demand and money supply (real balances) determine the equilibrium interest rate, which is then fed into the investment demand function to determine the level of investment. To help students understand money demand, a Baumol–Tobin Model is implemented. The explicit display of a money management optimization problem is an excellent way to imprint the concept of money demand.
Common Problems for Students
Money is undoubtedly one of the most confusing variables in economics. In the Keynesian Model, it is easily tangled with government spending. After all, both are in units of currency and used as policy tools. For the same reasons, students mix up money with income and wealth. Distinctions between stocks and flows are too subtle to be noticed. It may be worthwhile to review or assign the Money.xls workbook to remind students of basic monetary concepts.
Beyond these fundamental definitional problems and the need to highlight getting the variables exactly right, there is the issue of the money market itself (by which is meant a chart with demand for and supply of money, not a real-world financial market for short-term securities).
- Type
- Chapter
- Information
- Teaching Macroeconomics with Microsoft Excel® , pp. 153 - 156Publisher: Cambridge University PressPrint publication year: 2016