Microeconomics using Excel: Integrating Economic Theory, Policy Analysis and Spreadsheet Modelling

by Schwarz; Gerald

• ISBN13: 9780415417877
• ISBN10: 0415417872
• Edition: 1st
• Format: Nonspecific Binding
• Copyright: 2007-09-12
• Publisher: Routledge

Summary

Using Microsoft Excel, the market leading spreadsheet package, this book combines theory with modelling aspects and spreadsheet analysis. Microeconomics Using Excel provides students with the tools with which to better understand microeconomic analysis. A new textbook, it focuses on solving microeconomic problems by integrating economic theory, policy analysis and spreadsheet modelling. This unique approach facilitates a more comprehensive understanding of the link between theory and problem solving. It is divided into four core parts: analysis of price policies analysis of structural policies multi-market models budget policy and priority settings. The theory behind each problem is explained and each model is solved using excel. Each model is also available on the accompanying CD and can be used as a prototype for analysis and specific needs. Microeconomics using Excel will be of great interest to studentsstudying economics as well as to professionals in economic and policy analysis.

Table of Contents

Preface	p. vii
Free online content access instructions	p. ix
Symbols	p. x
Introduction	p. 1
Analysis of price policies	p. 3
Supply, demand and price policies	p. 5
Welfare and distribution	p. 15
Price policy instruments	p. 28
Iso-elastic supply and demand functions	p. 37
Policy formulation and trade-offs	p. 47
External effects	p. 59
Integrated markets	p. 73
World market and third country effects	p. 88
Analysis of structural policies	p. 99
Shifts of the supply curve	p. 101
Implications of structural policies over time	p. 111
Optimal structural policies	p. 121
Multi-market models	p. 131
Interdependencies of markets	p. 133
Microeconomic foundations	p. 146
Formulation of a four-market model	p. 163
Model framework for a 12-market model	p. 180
Budget policy and priority setting	p. 193
Optimisation approach	p. 195
Multiple objectives	p. 209
Parametric analysis	p. 221
Bibliography	p. 236
Index	p. 238
Table of Contents provided by Ingram. All Rights Reserved.