Understanding Accounting and Financial Analysis using Public Entities

Project Title:

Understanding Accounting and Financial Analysis using Public Entities

Due Date

Possible Points out of 100

Deliverable#4:

#4.       Using the same annual report/10-K you selected, find the  Consolidated Balance Sheet and A) calculate the following ratios for  fiscal year 2022:

1. Current Ratio,

2. Debt Ratio (Debt to Asset Ratio).

B)  Prepare a Horizontal (Trend) Analysis for your company.  Prepare the  Trend Analysis for the following accounts:  Cash, Accounts Receivable,  Retained Earnings.

C) Write in 3-10 sentences, based on data you  have calculated and read, whether your company is in good financial  health. Put your write-up in the same excel file.

NOTE:  THE  RATIOS and TREND ANAYSIS MUST be DONE in EXCEL.  Your excel report must  be done professionally with headings and titles as if presenting to your  company’s president and/or board.  Upload your excel report into  Canvas.