Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exhibit 1 0 Shamrock Capital: Pricing the Masters of Taylor Swift Financial Forecast for Swift Catalog ( in millions ) Assumptions 2 0 2 0
Exhibit
Shamrock Capital: Pricing the Masters of Taylor Swift
Financial Forecast for Swift Catalog in millions
Assumptions
E E E E E E E
Total streams
Master royalty rate per stream $ $ $ $ $ $ $
Growth rate for physicaldigital sales
COGS percentage for physical sales
Revenuesharing rate with artist
Revenuesharing rate with Braun
Other operating expenses percentage
Account receivable days
Inventory days
Accrued royalties days
Accounts payable days
Net fixed asset turnover
Income Statement
E E E E E E E
Royalty revenue from streaming
Revenue from physical and other digital
Total revenue
Cost of physical sales
Royalty sharing with artist
Royalty sharing with Braun
Other operating expenses
Operating profit
Balance Sheet Items
E E E E E E E
Accounts receivable
Inventory
Accrued royalties payable
Accounts payable
Net fixed assets
Note : COGS cost of goods sold.
Source: Author analysis.
Exhibit
Shamrock Capital: Pricing the Masters of Taylor Swift
Valuation Model for Swift Catalog. Base Case Scenario with No Rerecording in millions
Assumptions
Cost of capital
Steadystate growth rate
Tax rate
E E E E E E E
Operating profit
Net working capital NWC
Net fixed assets NFA
Annual Cash Flow and Terminal Value
Net operating profit after tax NOPAT
Cash flow to NWC
Cash flow to NFA
Free cash flow
Steadystate cash
flow
Terminal value
Discounted Cash Flow
Present value of forecast horizon
Present value of terminal value
Total value to Shamrock
Source: Author analysis.
Based on the payments specified in the basecase forecast, what is the discounted cash flow value of the deal to Swift? Note that the cash flow to Swift is equal to her after tax royalty income less increases in the amount retained for her accounts receivable. The amount of Swift's Accounts receivable from Shamrock is by definition, the same as the amount of Shamrocks accrued royalties to Swift.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started