The Maxwell School

Syracuse University

Syracuse University

Download the Excel template in teams and use it as follows. Please note that you'll need to use the full Excel app, not the web version.

- Name the Pd, Tax and Ps cells.
- Fill in the green parameter cells with the data from the pencil-and-paper exercise where `Q^d=200-P^d` and `Q^s=-40+2P^s`. Leave Pd set at 5.
- Add appropriate equations to the Ps, Qd, Qs and Qd-Qs cells.
- Use Goal Seek to solve for the BAU equilibrium when the tax is 0 and verify that it's the same as the pencil-and-paper result.
- Use Goal Seek again to solve for the policy case equilibrium when the tax is $30 and verify that it's also correct.
- Now that you've tested the spreadsheet, revise it so you can analyze a market with `Q^d = 2000-4P^d` and `Q^s =-400+2P^s`.
- Suppose that there's currently a tax equal to 150 in the market. This will be the BAU case. Solve for the equilibrium and enter the results in the BAU column in the Results section.
- Finally, suppose the government is considering setting the tax to zero. Solve for that equilibrium and enter it into the Policy column in the Results section.
- Save and submit your spreadsheet.

Site Index |
Zoom |
Admin

URL: https://wilcoxen.maxwell.insightworks.com/pages/9439.html

Peter J Wilcoxen, The Maxwell School, Syracuse University

Revised 02/13/2024

URL: https://wilcoxen.maxwell.insightworks.com/pages/9439.html

Peter J Wilcoxen, The Maxwell School, Syracuse University

Revised 02/13/2024