Exam Content The key to understanding an organization’s financial health is anal

Exam Content
The key to understanding an organization’s financial health is anal

Exam Content
The key to understanding an organization’s financial health is analyzing its financial performance using financial ratios.
Scenario
In your new role as comptroller of the hospital, your CFO has asked you to prepare a financial analysis by evaluating a medical supply company, Hillside, Inc., that the hospital is considering purchasing. You will use its balance sheet and income statement to calculate several financial ratios. You’ll demonstrate your financial analysis skills and make final recommendations as to whether the hospital should purchase Hillside, Inc. to improve the availability of medical supplies to the hospital.
Assessment Deliverable
Access and complete Financial Analysis Calculations Worksheet (contains Parts 1 and 3) and Financial Ratio Calculations (contains Part 2) in the following order using the prompts provided in the documents:
Financial Analysis Calculations Worksheet, Part 1: Matching Questions
Financial Ratio Calculations, Part 2: Financial Ratio Calculations
Financial Analysis Calculations Worksheet, Part 3: Financial Performance Summary
Assessment Support
Review the rubric for guidance on deliverable expectations.
Review “Financial Ratios” from the Week 4 University Library to understand the different types of financial ratios.
Review “6 Basic Financial Ratios and What They Reveal” by Glenn Wilkins from Investopedia to understand the different types of financial ratios.
Review the Financial Functions (Reference) page on the Microsoft 365 website to understand the financial functions used in Microsoft Excel.