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

by Jechlitschkaj, Kurt; Kirschke, Dieter; Schwarz, Gerald

• ISBN13: 9780203931103
• ISBN10: 0203931106
• Copyright: 2007-07-31
• Publisher: Taylor & Francis

Summary

Using Microsoft Excel, the market leading spreadsheet package, this book combines theory with modelling aspects and spreadsheet analysis. Microeconomics Using Excelprovides students with the tools with which to better understand microeconomic analysis. 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 online and can be used as a prototype for analysis and specific needs. Microeconomics using Excelwill be of great interest to students studying economics as well as to professionals in economic and policy analysis.

Table of Contents

Introduction

Analysis of Price Policies

Supply, Demand and Price Policies

Welfare and Distributional Effects

Price Policy Instruments

Iso-Elastic Supply and Demand Functions

Policy Formulation and Trade-Offs

External Effects

Integrated Markets

World Market and Third Country Effects

Analysis of Structural Policies

Shifts of the Supply Curve

Implications of Structural Policies over Time

Optimal Structural Policies

Multi-Market Models

Interdependencies of Markets

Microeconomic Foundations

Formulation of a 4-Market Model

Model Framework for a 12-Market Model

Budget Policy and Priority Setting

Optimization Approach

Multiple Objectives

Parametric Analysis

Table of Contents provided by Publisher. All Rights Reserved.