Question
this worksheet should use formulas to calculate the common sized percentages, Revenue or Total Revenue (depending on your company) should be used as the base
this worksheet should use formulas to calculate the common sized percentages, "Revenue" or "Total Revenue" (depending on your company) should be used as the base for all common sized calculations on the Income Statements. Common sized percentages should be calculated for all three historical years presented.
AUTODESK, INC., Common Sized Income Statements as of Jan. 31, 2021, Jan. 31, 2020, Jan. 31, 2019 12 Months Ended Jan. 31, 2021 Jan. 31, 2020 Jan. 31, 2019 Net revenue: Net revenue $ 3,790.4 $ 3,274.3 $ 2,569.8 Cost of revenue: Amortization of developed technologies 30.9 34.5 15.5 Total cost of revenue 337.1 324.9 285.9 Gross profit 3,453.3 2,949.4 2,283.9 Operating expenses: Marketing and sales 1,440.3 1,310.3 1,183.9 Research and development 932.5 851.1 725 General and administrative 413.9 405.6 340.1 Amortization of purchased intangibles 37.5 38.9 18 Restructuring and other exit costs, net 0 0.5 41.9 Total operating expenses 2,824.2 2,606.4 2,308.9 Income (loss) from operations 629.1 343 (25) Interest and other expense, net (82.4) (48.2) (17.7) Income (loss) before income taxes 546.7 294.8 (42.7) Benefit (provision) for income taxes 661.5 (80.3) (38.1) Net income (loss) 1,208.20 214.50 -80.80 Basic net income (loss) per share (in dollars per share) 5.51 0.98 -0.37 Diluted net income (loss) per share (in dollars per share) 5.44 0.96 -0.37 Weighted average shares used in computing basic net income (loss) per share (in shares) 219.4 219.7 218.9 Weighted average shares used in computing diluted net income (loss) per share (in shares) 222.1 222.5 218.9 Subscription and Maintenance Net revenue: Net revenue 3,662.2 3,138.5 2,437.4 Cost of revenue: Cost of revenue 242.1 223.9 216 Subscription Net revenue: Net revenue 3,478.9 2,751.9 1,802.3 Maintenance Net revenue: Net revenue 183.3 386.6 635.1 Other Net revenue: Net revenue 128.2 135.8 132.4 Cost of revenue: Cost of revenue $ 64.1 $ 66.5 $ 54.4
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