Shamrock capital pricing the master of taylor swift is a case study i want a solution.The question i need solution is mentioned below: Based on the information provided in the case study, your group has been tasked to prepare a

valuation analysis for all parties. Assuming no rerecording and the year $2020$ is year $0,$ calculate the

value of the acquisition proposal to Braun, Swift, and Shamrock. In your analysis, you may also

assume the following for all parties $($if needed$)$:

$$ An income tax rate of $21\%$ per annum.

$$ A discount rate of $7\%$ per annum.

$$ Beyond the year $2026,$ the cash flows continue into perpetuity at a steady growth rate of $2\%$ per

annum.

$$ Yearly Net Working Capital $(!"$#$!)$ is calculated as Cash $+$ Accounts Receivable $+$ Inventory

$$ Accounts Payable where t refers to time

$$ Yearly Free Cash Flow $($$#$$!)$ is calculated as EBIT$(1-\%)+$ Depreciation $$ Increase in Net

Working Capital $$ Capital Expenditures where EBIT refers to earnings before interest and

taxes and $\%$ refers to tax rate

$$ Alternatively, $#$$!$ can be presented as EBIT$(1-\%)$ Increase in Net Working Capital $$

Increase in Net Fixed Assets

$$ Increase in Net Fixed Assets is calculated as Capital Expenditures $$ Depreciation

Present your calculations in separate tabs for each party using Excel Spreadsheet. The Excel cells

should contain your workings. You may refer to the table provided in Appendix A as a guide.

Leave all calculations rounded to one decimal place and in millions.

b$)$ Fast forward to today, Taylor Swift intends to renegotiate for a better royalty rate that is reflective

of her status in American culture. As she has a hectic work schedule and does not come from a

background in finance, she is not keen on reading a lengthy report. Instead, she has asked for a

pitch on the issues to consider when determining a suitable royalty rate. She shared that it is

important to her that the issues are relevant and reflective of the current backdrop.