Understanding Accounting and Financial Analysis using Public Entities
Possible Points out of 100
#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.