Instructions Review the details of your assessment including the rubric. You will have the ability to submit the assessment once you submit your required pre-assessments and engage with your Faculty Subject Matter Expert (SME) in a substantive way about the competency. Overview In this Assessment, you will use information from several case studies and other documents to demonstrate your ability to make recommendations for organizational decisions based on analyses of financial data. Access the following to complete this Assessment: Jiranna Finances Excel File Capital Project Case Study CSIMarket.com (2020). Healthcare Sector Financial Strength Information. CSIMarket.com. https://csimarket.com/Industry/industry_Financial_... Academic Writing Expectations Checklist This Assessment requires submission of two (2) files. Save your files as follows: Save the written sections of Parts I, II, and III as FM007_firstinitial_lastname (for example, FM007_J_Smith). Save the spreadsheet for Part II as FM007_spreadsheet_firstinitial_lastname (for example, FM007_spreadsheet_J_Smith). You may submit a draft of your assignment to the Turnitin Draft Check area to check for authenticity. When you are ready to upload your completed Assessment, use the Assessment tab on the top navigation menu. To complete this Assessment: Download the Academic Writing Expectations Checklist to use as a guide when completing your Assessment. Responses that do not meet the expectations of scholarly writing will be returned without scoring. Properly formatted APA citations and references must be provided, where appropriate. Be sure to use scholarly academic resources as specified in the rubric. This means using Walden Library databases to obtain peer reviewed articles. Additionally, .gov (government expert sources) are a quality resource option. Note: Internet and .com sources do not meet this requirement. Contact your coach or SME for guidance on using Library Databases. Carefully review the rubric for the Assessment as part of your preparation to complete your Assessment work. Instructions Before submitting your Assessment, carefully review the rubric. This is the same rubric the assessor will use to evaluate your submission and it provides detailed criteria describing how to achieve or master the Competency. Many students find that understanding the requirements of the Assessment and the rubric criteria help them direct their focus and use their time most productively. Rubric This Assessment considers a Capital Proposal Case Study to add a specialized nurse triage center, an offsite center that would be staffed by registered nurses with a multitude of specialties, including emergency department (ED) nurses, critical care, surgical, and even some nurse practitioners. These nurses are able to offer callers medical advice encompassing the treatment of fevers, wound care, and emergent conditions, such as chest pain. The nurses are trained to triage conditions to the appropriate level of care, be that at home, at an urgent care center, or at the ED. This assessment has three-parts. Click each of the items below to complete this assessment. Part I: Analyze Organizational Financial Data For this part of the Final Assessment, you will conduct a 5-year analysis of Jiranna Healthcare’s outpatient operational and financial data in order to determine whether or not the capital project is an attractive project. Refer to “Jiranna Finances” for financial statements to analyze. Prepare a 2- to 3-page financial analysis including a supporting Excel spreadsheet to show your work. The focus must be on the content and the depth of your analysis. Unless otherwise indicated, a 5-year trend analysis is expected. Complete your analysis as follows:  Calculate the 5-year net sales, operating expenses, operating income, and net income of Jiranna Healthcare. Once the calculations are complete, interpret the resulting data and explain the significance of the trend results. Calculate the 5-year total profit margin, asset turnover, return on assets, and return on net worth. Once the calculations are complete, interpret the resulting data and determine the company’s profitability. Calculate the 5-year current ratio, day’s cash on hand, and working capital. Once the calculations are complete, interpret the resulting data and assess the company’s liquidity. Calculate the 5-year debt ratio and times interest earned ratio. Once the calculations are complete, interpret the resulting data and explain the company’s long-term solvency. Complete a DuPont analysis for each of the five most recent years. Once calculations are complete, interpret the resulting data and determine the company’s individual DuPont characteristics (e.g., total margin, total asset turnover & equity multiplier) and trends across the analysis period. Ultimately a decision has to be made. Would you recommend the capital project to Jiranna Healthcare? Explain the rationale for your decision. Part II: Conduct an Operating Indicator Evaluation For the next part of the Final Assessment, you are expected to complete a number of calculations, and then interpret the numbers to provide recommendations based on these analyses. It is essential both to show your work and calculation using current technology like Excel Workbook, and to demonstrate how these calculations support your conclusions. Be sure to explain your reasoning. You will be assessed on the accuracy of your quantitative analyses and the quality of the evidence you use to support your conclusions. Imagine that you are an administrator at Jiranna Healthcare who has been asked to analyze cash-flow data to determine the costs and benefits of implementing a new capital project. For background, read “Capital Project Case Study.” Then, complete the “Capital Project Case Study Spreadsheet”, which provides cash-flow data (costs and benefits) for the proposal. Download and save the Excel spreadsheet in your working Excel Workbook, and use the information provided to complete the following:  Calculate the cash inflows and outflows for each year. Evaluate the capital project by calculating the following metrics:  Net present value (NPV) Internal rate of return (IRR) Modified internal rate of return (MIRR) Payback period Discounted payback period In a 1- to 2-page report including a supporting Excel spreadsheet to show your work, provide your recommendation with rationale, as to whether the project is acceptable, assuming Jiranna Healthcare has a corporate policy of not accepting projects that take more than 3.5 years to pay for themselves, and assuming an 11% cost of capital. Part III: Conducting a Budgeting Evaluation You are an administrator at Jiranna Healthcare. You have been asked to conduct a budget variance analysis: analyzing performance by comparing budgeted workload, revenue, and expenses for a range of different service lines, with actual workload, revenue, and expenses for those service lines. Open the document “Variance Analysis Case Study,” where you will find data on the expenses, revenue, and outpatient product lines at Jiranna Healthcare. Analyze the data and prepare a 3- to 4-page report including a supporting Excel spreadsheet to show your work. In your report, address each of the five following questions. In each case, show the calculations that you conducted to answer the question. Then, explain your conclusion and how your calculations support your reasoning.  What was Jiranna's original profit forecast (assume away any issues with depreciation, taxes, etc.)? Halfway through the fiscal year, what is the hospital's revised projection for FY11 profits? Which outpatient service lines are over budget? Which outpatient service lines are over budget after accounting for workload increases? What two actions would you recommend be taken at the mid-year point if you oversaw a fee-for-service healthcare organization? In other words, where are the problem areas on which you would focus your attention, and who might provide ideas for "best practices" based on their performance? What two actions would you recommend be taken at the mid-year point if you oversaw a capitated healthcare organization? In this case, the revenue spreadsheet would be replaced with an overall budget of $50 million with which to operate (rather than being able to bill for each episode of patient care). Federal, state, county, and city healthcare organization normally operate under a capped budget. Additionally, many HMOs also operate under a fixed per member, per month (PMPM) capitated process.