Please help with this project. Choose your own 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. Everything should be formula based and not just hard number cells. 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