Purpose: Review the entire 10-K of your assigned company that was filed between January 2022 and August 2022 to complete the assignment. You will specifically need to reference the footnotes accompanying the financial statements to address certain questions.
Tools: Students should use Edgar on the SEC Website to access the 10-K of your assigned company and Microsoft Excel to create the Excel Dashboard. You may reference the LinkedIn Learning videos for instructions on using data in Excel to create visualizations. You may also review the video on how to access 10-K data through Edgar.
The Debt/Equity Dashboard should include:
1. Bar graph of liabilities vs. stockholders’ equity over the last 2 years
2. Line graph of total liabilities, total equity, and debt to equity ratio (using total liabilities) over the last 2 years with 2 difference y-axes (one for Lia and Equity, one for D/E ratio)
3. Pie chart of lease liabilities
4. Stacked area graph of lease liability maturities
5. Pie chart of lease assets (could be gross or net of accumulated amortization depending on
the company’s presentation of lease assets in the financial statements). If there is both gross
and net, use gross!
Final Submission Requirements: The project will be graded based on the submitted Excel Dashboard (including the underlying data used to create your visualizations) and your responses to short answer questions.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|