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.