Question: effect on your profitability analysis. In addition, discuss your reasoning for considering each item as an earnings quality issue. B. Using the spreadsheet posted online

effect on your profitability analysis. In addition, discuss your reasoning for considering each item as an earnings quality issue. B. Using the spreadsheet posted online containing the raw data associated with the financial statement information for Ubisoft (file entitled "Case 2 - FSA (Data)"), prepare the following calculations in good form (attach the Excel spreadsheets to your response as an Exhibit following your discussion) : 1) Prepare a common-size consolidated income statement (i.e. vertical analysis) for each of the five years ended March 31, 2020. 2) Using the consolidated income statement, prepare a schedule showing the percentage change from year to year for each revenue, expense, gain or loss line item (i.e. trend or horizontal analysis) for each of the five years ended March 31, 2020. 3) Using the Commonly Used Ratios (file entitled "Case 2 - FSA (Ratios)"), calculate the Profitability ratios - after any adjustments for earnings quality (see Item A above) - for each of the five years ended March 31, 2020. Use Ubisoft's effective tax rate as reflected on the income statement. C. Discuss the Group's profitability over the five year period, including detailed references to Group information from Ubisoft's financial statements. (As you reference Group information, note the page number and year of annual report for easy reference in class.) D. Overall, how effectively has the Group implemented its business strategy in returning profits to its shareholders
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
