Accounting homework help

1
ACTG 495
Case 5 – Business Valuation
The following case will utilize your 5 year forecast of Ubisoft Entertainment SA’s (“Ubisoft” or “the
Group”) financial statements to value the business. This case involves a discounted cash flow
approach to value Ubisoft at a total company level as well as a value per share of common stock.
Companies will maintain valuation models to ensure proposed strategies improve value, evaluate
acquisitions and divestitures, sale or repurchase of financial securities, etc.
Requirements
Part I – Weighted Average Cost of Capital (WACC)
Under the Discounted Cash Flow method, the value of a business is the present value of all future
Free Cash Flow. The discount rate applied to the future Free Cash Flow is the WACC. This is the
weighted average return that equity and debt investors expect based on the risk of the business.
A. Calculate the weights (mix) of debt and equity the company is utilizing as of March 31, 2020
(“2020”). The weights can be estimated by using the current market values. For example,
the weight of equity would be the value of equity divided by the sum of value of equity plus
the value of debt. To calculate the value of equity use the total number of shares outstanding
multiplied by the current market price per share. To calculate the value of debt, add the value
of short term financial debt plus the value of long term financial debt from the 2020 balance
sheet.
B. Calculate the cost of equity based on the Capital Asset Pricing Model (CAPM). Estimates for
Risk Free Rate and Market Risk Premium (MRP) and provided in the assumptions section at
the end of the case. (You will need to calculate the ß (beta) for Ubisoft based on comparable
U.S. companies – see PowerPoint slides for formulas.)
C. Calculate the after tax cost of debt. To arrive at a cost of debt for the company use the rate
of return debt investors are currently expecting from the company and then multiply by (1 –
tax rate). Many companies which utilize debt as a source of financing have multiple debt
securities outstanding with each having a different interest rate based on varying maturities or
provisions in each debt agreement.
D. Calculate the WACC based on the estimated rates of return on debt and equity and weights
calculated above.
Part II – Free Cash Flow (FCF)
A. Based upon your 5 year forecast of Ubisoft’s financial statements, calculate FCF for each year
of the forecast period. Feel free to revise your forecast from the prior case as needed.
B. Ubisoft is a strong company and will likely continue to operate and generate FCF after the
forecast period. Analyst’s typically capture the value after the forecast period in a Terminal
Value calculation (also called horizon value or continuing value). Please calculate the terminal
value for Ubisoft.
Part III – Valuation
With estimates in place for WACC and future FCF, you are now able to calculate a discounted cash
flow based valuation for Ubisoft.
2
A. Based on your estimates, what is the total value of Ubisoft? The total value of the firm would
be the present value of all future FCF plus the current value (2020) of any non-operating
assets not included in the forecast. Non-operating assets are typically financial in nature,
such as cash & equivalents, marketable securities, and short and long term investments.
B. What is the estimated value of equity?
C. What is the estimated value per share of common stock?
Part IV – Sensitivity Analysis
The estimated value of Ubisoft is based on many assumptions related to the future performance
of the business and investor return expectations. Analysts spend a lot of time trying to put an
accurate forecasts in place, but the probability of every single input being accurate is virtually
zero. Sensitivity is a form of risk analysis to help identify which forecast assumptions are most
material and how changes to these assumptions impact the valuation.
Perform a sensitivity analysis on the following variables:
• Growth rate of sales
• Operating margin
• Operating cycle
• Choose 1 – 2 other variables
Part V – Recommendation: Market value vs. calculated value
Compare your estimate of per share value of common stock to Ubisoft’s current market price.
• Is your estimate higher or lower than the market price? What factors are likely
contributing to the difference?
• If you were an equity analyst, would you recommend a Buy, Hold or Sell on Ubisoft stock
and why?
Assumptions:
• Yield to Maturity (YTM) on 10 year French government bond (risk free rate): 0.67%
• Market risk premium for France: 5.65%
• Ubisoft’s stock price €70.04 per share