1. PLEASE use at least 3 of my resources I provided 2. Please use in-text citations for all resources 3. Complete the Financial Analysis Workbook Excel spreadsheet with two worksheets. a. Use the first worksheet to perform the horizontal and vertical analyses. b. Use the second worksheet to perform the ratio analysis. Refer to the Lueders Clinic 2017–2018 Financial Statements to calculate each ratio. Your workbook must include two completed worksheets (Horizontal and Vertical Analysis and Ratio Analysis). It should be presentable and annotated for your audience. 3. Brief to the Board of Directors -The brief to the hospital’s board of directors should be 250–500 words or about 1–2 pages in length 4. PLEASE answer each question thoroughly on the Rubric Requirements A. Accurately selects the base amounts from the financial statements to perform vertical analysis B. Accurately calculates the ratios using the formulas provided C. Validates the ratios by showing the calculations and using the appropriate units D. Examines the business’s financial performance by comparing the business’s finances against industry averages and past performance E. Discusses the strengths and weaknesses of the business’s financial performance F. Recommends appropriate actions G. Supports recommendation using the financial analysis
