dule, you will be reviewing and using market share data to calculate and asked to make calculations for industry concentration. A hypothetical merger is proposed, and the post$-$merger concentration must be calculated and compared to anti$-$trust guidelines.

Action Items

Read the case study, Spectrum $$ The Spawn of Time Warner Cable and Charter Communications $$ Navigates Challenges from Cord Cutting and Mobile Competition on pages $473-491$ in Baye and Prince $(2022).$

Review the Business Brief Guidelines.

On page $497$ of Baye and Prince $(2022),$ read Memo $12$

Write a $1-$ to $2-$page business brief that includes:

Opening: Provide an overview of the memo itself to inform the reader what the outline will encompass.

Calculate the industry concentration using the file named Marketshare.xls $($Note: Page $209$ begins the Measures of Industry Concentration$)$

Then calculate the post$-$merger concentration.

Marketshare.xlsxDownload Marketshare.xlsx

Compare and contrast the pre$-$merger and post$-$merger concentrations providing differences.

Conclude with a comparison of anti$-$trust guidelines.