can someone help

AC 211 - FINANCIAL REPORTING \& ANALYSIS ASSIGNMENI INTRODUCTION: This Financial Reporting \& Analysis Assignment analyzes the company named The Walt Disney Company ("Disney, "DIS, ok 0001744489) to provide information and recommendations to a hypothetical client to determine whether they would invest in or loan money to the company. In this assignment, you will conduct careful research to analyze the financial performance of Disney in three (3) separate parts. In Part 1, you will create and complete a Microsoft Excel (Excel) spreadsheet (using the Excel template provided and using Excel formulas) to calculate selected finandal ratios. In Part 2, you will complete answers on a FORM (see page 5). In Part 3, you will then prepare a business MEMO that would be included in the file for your hypothetical client, Ms. Truly Russ, regarding the completed financial analysis of Disney and your recommendations. The business memo for Ms. Truly Russ' flle must include your recommendations and condlusions on whether she should invest in and/or lend money to Disney, supported by specific and comprehensive financial analysis and explanations based upon this assignment's instructions. See required Memo Format below. To form a basis for your memo's recommendations and conclusions, you will apply concepts from our class, using only our textbook, (Chapters 5 and 13 are most helpful) and Disney's 10K Annual Report. (As you recall, the 10-K Annual Report is a financial report that must be completed by public companies and filed with the Securities \& Exchange Commission (SEC). Finally, in the required Memo format, as a technical business memo, you will respond to Ms. Russ' (the dient) inquiry and provide conduding recommendations on investing in or lending to Disney supported by a comprehensive analysis of the company's financial performance. The memo must provide and cite specific ratios and reasons from your analysis to support your recommendations and conclusions. Your answers will be based on fact, analysis, and research of the 10- K. INSTRUCTIONS: On or before the specific due dates for each of the specific Parts, electronically submit On or before the specific due dates for each of the specific Parts, electronically submit (.doc and .xls files ONLY) the following in the Blackboard submission tab: 1. Part 1: An Excel Spreadsheet ( xls only file format) with calculations for specific financial ratios. These ratios are also referenced in the form. See illustration provided below as a template. 2. Part 2: A completed FORM (.doc only flle format). Provide answers in the Form after the question, not as stand alone replies. 3. Part 3: A Business Memo (,doc only file format) which should be 1.5 to 2 pages long, using a proper business memo format. (See provided directions.) 4. Part 4: Signed and dated Academic Honesty Statement (see last poge) submitted upon completion of all parts of this assignment. 5. Each Part must include your name, date, and class (date and time or OL for On-Line) in the upper right corner of the document. Use and read your textbook and the 10K report which contain all the information required for this assignment. Additional materials/ resources are not allowed. Remember to SAVE your files and back-up your work FREQUENTLY. To start, gain access to the company's 10-K report from the SEC website (www.sec.gov) (.gov indicates it is a government site.) - Go to www.sec.goy To start, gain access to the compary's 10-K report from the SEC website (wwwisecgow) (gov indicates it is a govemment site.) Go to www. sec.gon On the dark ribbon, click on Filings - From the drop-down list, click on EDGAR-Search \& Access On the left column, click on "Company Elings" Enter the company name "Disney" or the troding symbol "Dis") - Under Selected Files, click "10-K" Locate the most recent 10-K report. This is dated November 29, 2022. The 10K contains a variety of information. The cover page, page 1, contains essential information such as name of company, company addresses, state of incorporation, fiscal year, troding symbol, applicable stock exchange, number of shares outstanding. etc. "Item 8 " in the 10-K's "Table of Contents" provides most of the information required for this assignment. It contains the company's Financial Statements and Supplementary Data including a Report of Independent Registered Public Accounting Firm and Notes to Consolidated Anancial Statements. Excel Calculation Spreadsheet. Prepare an Exced Spreadubeet - seet towoute attacted beliun question it, thtio name, specfic formila, and celtuiation, be mue tu seport sosula b 2 decienal places. Exce Temelrte (and soe nu: Vion) het Draw Design tayout References Malings Review Viw Help Add enly amounts above needed focalcula to the required ration from the Aswment form 1. Net Profit Magin \begin{tabular}{l|l} 2.) Gras profit Peficentage & Net SalescoGs \\ Net Sales \end{tabular} 3.) Fied Awet Turnover katio Netkerenge: 1.14 **Complete the Excel spead heet by lisbiez and calculasigall the ratios in the same format as above that are needed per the directions in the Assignment form