please help me with ratio analysis please provide excel spreadsheet please

Income Statement Spreadsheet Example Name: Jaspreet kaur Date: Jacob Corporation INTRODUCTION The purpose of financial analysis is to evaluate a firm's past, present, and future financial condition. It is to identify any weakness that could lead to future problem and/or any strength that the firm might capitalize upon. To do financial analysis, you need some tools, i.e., financial ratios. Through financial ratios you can have diagnosis of the firm's could compare the same ratio over a specified period of time. (2) Comparative ratio analysis. You compare a firm's ratios with those of other firms in the same industry, that is, to industry average figures. An easy way to conduct trend analysis or comparative ratio analysis is to graph ratios. You can produce graphs easily using Excel. For example, suppose you would like to graph the current ratios of the firm and the industry average. You should set up the following table containing the needed information: Next, follow the steps below: 1. Block the input range A1:E3 2. Click Insert 3. Select Chart (or click the Chart Wizard icon) 4. In the Chart Wizard box, click the Line Chart with dots Financial Ratios Exercise: This assignment is divided into two parts. The first part will be devoted to typing the ratio analysis format and creation of formulas, followed by a comparison of Jacob's Corp.'s 2010 through 2013 ratios. In the second part of the assignment, you are required to create a graph for Current Ratio. You need to begin this assignment by combining both the income statement and the balance sheet files into a single spreadsheet. After you have combined both files, go to the bottom of the Income Statement to begin preparing the ratio analysis worksheet. Refer to your lab manual for the necessary formulas. Be careful when entering formulas that contain more than one mathematical operator. Just like a basic algebraic formula, parentheses always take precedence over any other mathematical operator. The proper sequence of the mathematical operators to be utilized is of utmost importance to determine the correct answers to the formulas. Ratio Analysis Spreadsheet Example ASSIGNMENT # NAME: LAB TIME: JACOB CORPORATION RATIO ANALYSIS \begin{tabular}{lcccc} & 2018 & 2019 & 2020 & 2021 \\ \cline { 2 - 4 } LIQUIDITY RATIOS & & & & \\ Current Ratio & formula & formula & formula & formula \\ Quick or Acid Test Ratio & formula & formula & formula & formula \end{tabular} ASSET MANAGEMENT RATIOS InventoryTurnoverDaysSalesOutstanding(DSO)TotalAssetsTumoverformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformula DEBT MANAGEMENT RATIOS DebtRatioEquityMultiplierTimesInterestEarnedRatioformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformula PROFITABILITY RATIOS GrossProfitMarginOperatingProfitMarginNetProfitMarginReturnOnTotalAssets(ROA)ReturnOnEquity(ROE)BasicEarningPowerEarningsPerShareBookValuePerShareformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformulaformula GRAPH CURRENT RATIO OVER 2018-2021