HCS/385: Health Care Finance Wk 4 Summative Assessment: Financial Analysis Calculations
HCS/385: Health Care Finance
Wk 4 Summative Assessment: Financial Analysis Calculations
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 hasasked 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
Submit both parts of your assessment.
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.
Copyright 2023 by University of Phoenix. All rights reserved.
Submission
Text Editor
Press Alt + F10 to access toolbar options
Word count: 0
Drag files here
Maximum size: 2,560 MB
or
Details & Information
Assessment due date
7/28/26, 1:59 AM (CDT)
Goals & standardsAligned with 1 goal
Attempts
Unlimited
Grading rubricThis item is graded with a rubric
Originality ReportSubmit my paper to the Global Reference Database
Grading
Maximum points200 points
Description
This assessment measures your ability to analyze financial performance using financial ratios.

