The Maxwell School
Syracuse University
Syracuse University
Suppose that the market price of a good with no tax is initially $10 and 1000 units are being traded. The government would like to know the impact of imposing a $14 tax. An earlier analysis has found that under the tax, the buyer price would rise to `P^d` = $20 and the seller price would fall to `P^s` = $6. Demand for the good has an elasticity of -0.2 and the elasticity of supply is 0.5.
Use the spreadsheet in Teams to analyze the impact of the tax.
The data cells are already named so use the full Excel app rather than the web version.
Note that there's already a formula in the DWL/$ cell but it shows #DIV/0!. When the spreadsheet is complete and the numbers are all correct, it should show -13%.
Save and submit the results.