You are a health care manager at a nursing home. You are looking to expand your business arrangements and your boss suggests Stanford Health as an option. She asks you to do an analysis on their financials for 2 years to determine if this relationship will be a good fit. There is a leadership meeting next month where you will share your findings on whether to pursue a relationship with Stanford Health.
Create a 10- to 15-slide auditing proposal presentation with your financial analysis and recommendations. Include speaker notes as if you were presenting this in person. Use the Excel template provided to track your calculation and add visuals to your presentation.
Include the following items in your auditing proposal:
Background & Operational Structure:
• Describe the health care organization.
• Include the history and purpose; identify the service or product they offer.
• This information is typically found in the annual report.
• Describe the company’s operational structure (e.g., sole-proprietorship, corporation, partnership).

Financial Analysis and Stability:
• Explain the purpose of financial analysis.
• Describe the 3 basic tools of financial analysis (vertical, horizontal, and financial ratios).
• Explain the purpose of each tool.

Calculations & Interpretation:
• Using the Excel template provided, calculate and explain what the results are saying about the company’s financial status for each type of analysis (one or more slides per analysis).
• Horizontal Analysis (provide both the $ and % change)
• Cash and cash equivalents
• Total Liabilities
• Operating Revenues
• Operating Expenses
• Vertical Analysis for the Current and Prior Year (using Net Patient Service Revenue as the base figure)
• Salary and Benefits
• Supplies
• Purchase Services
• Financial Ratios Analysis for Current and Prior Year
• Current ratio (liquidity ratio)
• Debt to assets ratio (solvency ratio)
• Profit margin ratio (profitability ratio)

Recommendation For Leadership:
• Would you recommend pursuing a relationship with Stanford Health based on its financial health?
• Justify your recommendation.