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
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