Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Management Concepts And Skills

Authors: Samuel Certo, S Certo

15th global Edition

978-1292265193, 1292265191

More Books

Students also viewed these Accounting questions