Could you help me develop an Excel workbook, including data from Under Armor's (UR) most recent 10-k (Annual Report):

oThe 1^st tab (worksheet) in your Financial Statement Analysis Template must be labeled Company Information. The following information must be included:

-Company Name and ticker symbol

-Industry

-Products or services offered

-Major competitors

-An example of this tab is provided in Exhibit A.

oThe 2^nd tab in your Financial Statement Analysis Template must be labeled Historical Income Statements.

-Include the latest three years based on SEC filings.

-Ensure that the worksheet includes a header with:

Company Name

Financial Statement Name (Income Statements)

Financial Statement Dates

Denomination level ($s in millions or thousands, etc.)

oThe 3^rd tab in your Financial Statement Analysis Template must be labeled Historical Balance Sheets.

-Include the latest three years based on SEC (10-K) filings.(Note: Some 10-Ks only provided 2 years of balance sheet data.You may need to download the second most recent 10-K for your company in order to obtain 3 years of balance sheet data.)

-Ensure that the worksheet includes a header with:

Company Name

Financial Statement Name

Financial Statement Dates

Denomination level ($s in millions or thousands, etc.)

-A partial balance sheet example is provided in Exhibit B.

oThe 4^th tab in your Financial Statement Analysis Template must be labeled Historical Statement of Cash Flows.

-Include the latest three years based on SEC (10-K) filings.

-Make sure that the Income Statement, Balance Sheet, and Cash Flows Statement tie in as follows:

Net Income from Income Statement agrees with Net Income on the Statement of Cash Flows.

Ending Cash Balance from Statement of Cash Flows agrees with Cash in the Balance Sheet.

-Ensure that the worksheet includes a header with:

Company Name

Financial Statement Name

Financial Statement Dates

Denomination level ($s in millions or thousands, etc.)

Format: Annual Search for ticker or company name... View Annual Reports Annual Data I Millions of US $ except per share data 2019-12-31 2018-12-31 2017-12-31 2016-12-31 2015-12-31 2014-12-31 2013-12- Revenue $5,267.132 $5,193.185 $4,989.244 $4,833.338 $3,963.313 $3,084.37 $2,332 Cost Of Goods Sold $2,796.599 $2,852.714 $2,737.83 $2,584.724 $2,057.766 $1,572.164 $1,195 Gross Profit $2,470.533 $2,340.471 $2,251.414 $2,248.614 $1,905.547 $1,512.206 $1,13 Research And Development Expenses SG&A Expenses $2,233.763 $2,182.339 $2,099.522 $1,831.143 $1,497 $1,158.251 $871 Other Operating Income Or Expenses Operating Expenses $5,030.362 $5,218.202 $4,961.401 $4,415.867 $3,554.766 $2,730.415 $2,066 Operating Income $236.77 $-25.017 $27.843 $417.471 $408.547 $353.955 $265 Total Non-Operating Income/Expense $-26.928 $-42.771 $-38.152 $-29.189 $-21.862 $-11.745 $-4 Pre-Tax Income L.lal $209.842 $-67.788 $-10.309 $388.282 $386.685 $342.21 $260 Income Taxes $70.024 $-20.552 $37.951 $131.303 $154.112 $134.168 $98 Income After Taxes $139.818 $-47.236 $-48.26 $256.979 $232.573 $208.042 $16 Other Income Income From Continuous Operations $92.139 $-46.302 $-48.26 $256.979 $232.573 $208.042 $16 Income From Discontinued Operations Net Income $92.139 $-46.302 $-48.26 $197.979 $232.573 $208.042 $16 EBITDA $423.449 $157.005 $201.844 $562.241 $509.487 $426.048 $315 EBIT $236.77 $-25.017 $27.843 $417.471 $408.547 $353.955 $265 Basic Shares Outstanding 451 446 441 436 431 426 Shares Outstanding 454 446 441 445 442 439 Basic EPS $0.20 $-0.10 $-0.11 $0.45 $0.54 $0.49 EPS - Earnings Per Share $0.20 $-0.10 $-0.11 $0.45 $0.53 $0.47Annual Data I Millions of US $ except per share data 2019-12-31 2018-12-31 2017-12-31 2016-12-31 2015-12-31 2014-12-31 2013-12- Net Income/Loss $92.139 $-46.302 $-48.26 $256.979 $232.573 $208.042 $16 Total Depreciation And Amortization - Cash Flow $186.679 $182.022 $174.001 $144.77 $100.94 $72.093 $50 Other Non-Cash Items $103.221 $-203.587 $248.968 $132.323 $176.166 $76.578 $40 Total Non-Cash Items $289.9 $-21.565 $422.969 $277.093 $277.106 $148.671 $91 Change In Accounts Receivable $-45.45 $186.834 $-79.106 $-249.853 $-191.876 $-101.057 $-3 Change In Inventories Lolal $149.519 $109.919 $-222.391 $-148.055 $-278.524 $-84.658 $-1 Change In Accounts Payable $59.458 $26.413 $145.695 $202.446 $-22.583 $49.137 $14 Change In Assets/Liabilities $-36.41 $197.286 $-52.106 $-23.029 $-76.476 $-33.345 $-19 Total Change In Assets/Liabilities $126.992 $696.097 $-137.249 $-167.449 $-495.138 $-137.68 $-133 Cash Flow From Operating Activities Lalil $509.031 $628.23 $237.46 $366.623 $14.541 $219.033 $12 Net Change In Property, Plant, And Equipment $-145.802 $-159.1 $-281.339 $-386.746 $-298.928 $-140.528 $-8 Net Change In Intangible Assets L.lil Net Acquisitions/Divestitures $-539.46 $-10.924 $-148 Net Change In Short-term Investments $6.482 $-6.534 Net Change In Long-Term Investments Lalal $-39.207 Net Change In Investments - Total $-39.207 $6.482 $-6.534 Investing Activities - Other $-1.311 $-4.597 $-1.648 $-0.875 $-2.553 $-0.86 $-2 Cash Flow From Investing Activities $-147.113 $-202.904 $-282.987 $-381.139 $-847.475 $-152.312 $-238 Net Long-Term Debt $-137.817 $-190 $98 $156.851 $384.798 $131.278 $94 Net Current Debt Debt Issuance/Retirement Net - Total $-137.817 $-190 $98 $156.851 $384.798 $131.278 $94 Net Common Equity Issued/Repurchased $7.472 $2.58 $11.54 $15.485 $10.31 $15.776 $15 Net Total Equity Issued/Repurchased $7.472 $2.58 $11.54 $15.485 $10.31 $15.776 $15 Total Common And Preferred Stock Dividends Paid $-2.927 Financial Activities - Other $-6.725 $-2.448 $-2.781 $-23.295 $-13.675 $35.252 $17 Cash Flow From Financial Activities $-137.07 $-189.868 $106.759 $146.114 $381.433 $182.306 $126 Net Cash Flow $229.948 $247.925 $65.41 $122.873 $-463.323 $245.686 $5 Stock-Based Compensation $49.618 $41.783 $39.932 $46.149 $60.376 $50.812 $43 Common Stock Dividends Paid $-2.927 www.jqwidgets.com Waiting for digstelOnfua17.cloudfront.net.Format: Annual Search for ticker or company name... View Annual Reports Annual Data I Millions of US $ except per share data 2019-12-31 2018-12-31 2017-12-31 2016-12-31 2015-12-31 2014-12-31 2013-12- Cash On Hand $788.072 $557.403 $312.483 $250.47 $129.852 $593.175 $347 Receivables Lolol $708.714 $652.546 $609.67 $622.685 $433.638 $279.835 $209 Inventory $892.258 $1,019.496 $1,158.548 $917.491 $783.031 $536.714 $469 Pre-Paid Expenses $313.165 $364.183 $256.978 $174.507 $152.242 $87.177 $63 Other Current Assets Total Current Assets $2,702.209 $2,593.628 $2,337.679 $1,965.153 $1,498.763 $1,549.399 $1,128 Property, Plant, And Equipment $792.148 $826.868 $885.774 $804.211 $538.531 $305.564 $223 Long-Term Investments Goodwill And Intangible Assets $586.523 $588.287 $602.669 $627.901 $660.867 $149.486 $146 Other Long-Term Assets $88.341 $123.819 $97.444 $110.204 $75.652 $57.064 $47 Total Long-Term Assets $2,141.322 $1,651.394 $1,668.688 $1,679.178 $1,367.207 $545.684 $44 Total Assets $4,843.531 $4,245.022 $4,006.367 $3,644.331 $2,865.97 $2,095.083 $1,577 Total Current Liabilities $1,422.009 $1,315.977 $1,060.375 $685.816 $478.81 $421.627 $42 Long Term Debt $592.687 $703.834 $765.046 $790.388 $624.07 $255.25 $47 Other Non-Current Liabilities $98.113 $208.34 $162.304 $137.227 $94.868 $67.906 $49 Total Long Term Liabilities $1,271.435 $912.174 $927.35 $927.615 $718.938 $323.156 $97 Total Liabilities $2,693.444 $2,228.151 $1,987.725 $1,613.431 $1,197.748 $744.783 $524 Common Stock Net $0.149 $0.148 $0.146 $0.145 $0.144 $0.071 $ Retained Earnings (Accumulated Deficit) $1,226.986 $1,139.082 $1,184.441 $1,259.414 $1,076.533 $856.687 $653 Comprehensive Income $-50.765 $-38.987 $-38.211 $-52.143 $-45.013 $-14.808 $2 Other Share Holders Equity Share Holder Equity $2,150.087 $2,016.871 $2,018.642 $2,030.9 $1,668.222 $1,350.3 $1,053 Total Liabilities And Share Holders Equity $4,843.531 $4,245.022 $4,006.367 $3,644.331 $2,865.97 $2,095.083-jqwidg $1,577