Can you please help me with this assignment I need to conduct a 5-year analysis of Jiranna Healthcare's outpatient operational and financial data in order to determine whether its capital project is an attractive project below its what needs to be answered and the picture that was provided by the teacher and the analysis required an excel spreadsheet as well !!

part I

1.1: Calculate and interpret net sales, operating expenses, operating income, and net income data to determine the significance of trend result.

1.2: Calculate and interpret profit margin, asset turnover, return on assets, and return on net worth data to assess a company's profitability

1.3: Calculate and interpret the current ratio, day's cash on hand, and working capital data to evaluate a company's liquidity

1.4: Calculate the debt ratio and times interest earned ratio to evaluate a company's long-term solvency.

1.5: Conduct a DuPont analysis to determine the organization's DuPont characteristics and trends across an analysis period.

1.6: Make recommendations for management decisions based on evaluation of financial information.

Part I

2.1 Apply mathematical principles to accurately calculate cash inflows and outflows.

2.2: Apply strategies to accurately calculate the profitability of a capital project.

2.3: Make recommendations for management decisions based on operative indicator evaluation.

3.2: Apply the features of Excel to communicate information effectively.

Part III

3.1: Calculate Jiranna's profit forecast and related projections.

3.2: Identify outpatient service lines over budget and those over budget after accounting for workload increases.

3.3: Recommend actions to be taken to improve performance at Jiranna as a feefor-service healthcare organization.

A Jiranna Healthcare Cash Flows, 2021 (in thousands) Cash Flows from Operating Activities Cash received from patient and third-party payers Cash received from operating revenue sources Cash received from nonoperating revenue sources Cash payments to employees Cash payments to suppliers of goods and services Net cash flow from operating activities B C D $ 10,671 800 270 (5,600) (4,800) $ 1,341 Cash flows from Investing Activities Cash payments for purchase of plant assets (1,200) Cash payments for purchase of long-term investments (670) Proceeds from sales of plant assets 80 Proceeds from sale of long-term investments 60 Net cash flow from investing activities (1,730) Cash flows from Financing Activities Proceeds from issuance of 6% bonds payable 4,000 Principal payments on long-term debt Cash payments to retire 7% bonds payable (300) (3,200) Net cash flow from financing activities 500 Net increase/(decrease) in cash $ 111