fill out the following spreadsheet & answer below questions please- about the company Johnson and Johnson

Spreadsheet:

Part 2: Financial Analysis
Ratio Analysis	2021	2020
Liquidity
Current Ratio
Quick Ratio
Asset Management
Inventory Turnover
Days Sales Outstanding
Total Asset Turnover
Debt Management
Total debt to Total Capital
Times interest Earned
Profitability
Operating Margin
Profit Margin
Return on Assets
Return on common equity
Part 3: Market Analysis
	2021
Book Value per Share
Market Value per Share
Price/Earning Ratio
Required Rate of Return
Capital Asset Pricing Model

II. Financial Analysis: Conduct a financial analysis of the corporation. Use the Excel template provided (you must use formulas in the cells). You should calculate the listed ratios for two years.

III. Market Analysis: a. Compute the various market indicators listed on the Excel template. b. For the CAPM, assume that the Risk Free Rate is 2.5% and the expected market return is 9%. c. Examine the trend in the companys stock price over the past five years.

IV. Report the findings of the financial and market analyses.