Question: Please someone help ASAP with this project. Choose your own whatever company for the project in https://www.sec.gov. The steps are given below and also the

Please someone help ASAP with this project. Choose your own whatever company for the project in https://www.sec.gov. The steps are given below and also the excel file is attached below which is accessible and editable. Also post your screen capture from your data analysis as well. I will UPVOTE!!

https://docs.google.com/spreadsheets/d/1QxunnZDGQMHyNV9Hi2OxNhkOTWM2lQkK/edit?usp=sharing&ouid=105755127997211834780&rtpof=true&sd=true

Step 1: Open the excel "Computer Project File".

Step 2: Search for the 10-K report data for the fiscal year 2019, 2020, and 2021

Step 3: Fill in the B85:D116 cells with the corresponding data and put company name and Ticker assigned in the cell B82 and D82, respectively.

Step 4: Check cell D59 if there is any error (Checking A=L+SE)

Step 5: If there is any error, correct the corresponding amount in the data area to make total assets, total liabilities and Shareholders' Equity are balanced.

Step 6: Finish the Ratio Analysis Tab and Credit Analysis Tab.

Warning! Do not touch the other area of the excel spread sheet except for the data input area in the Financial Statement tab and Ratio analysis, Credit Analysis Tab

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!