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 Bal

Hire us to tackle your online classes, quizzes, homework, research papers, essays, dissertations, thesis, cv's et cetera.

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 Bal

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 companys president and/or board. Upload your excel report into Canvas.