Excel

Please complete part 1 and part 2 of the assignment; attached notes and the Excel worksheet.

Finalize your Healthcare Budget Request by completing the following:

Part 1: Financial Statement Calculations and Analysis:

Open your Excel Assignment Workbook and navigate to the “W10/11A6 Financials” worksheet.

You have 2 Options for completing this Assignment as noted in the Excel Assignment Workbook.

Using the Healthcare Budget Request Guide for guidance, conduct analyses as directed on either your organization’s financial statements or those provided in the HealthWays Financial Statements worksheet. Your analysis will include spreadsheet calculation of financial statement ratios.
Part 2: Summary of Analyses and Interpretation of Results:

Create a brief (1- to 2-page) description of your analyses. Be sure to address the following in your summary:

Describe the results of each statement analysis. What do the results of each analysis mean?
What does your complete financial statement analysis suggest about the financial health of the organization?
If using your current organization’s data, does your analysis help describe any observed organizational behaviors or actions? Explain.
What assumptions have you made in your analyses?
What implications do these analyses have for your proposed healthcare product or service?

Last Completed Projects