Revenue Cost of Revenue, Total Gross Profit Selling/General/Admin. Expenses, Total Depreciation/Amortization Unusual Expense (Income) Operating Income Gain (Loss) on Sale of Assets Income Before Tax Income After Tax Cash & Equivalents Short Term Investments Total Receivables, Net Other Current Assets, Total Total Current Assets Long Term Investments Other Long Term Assets, Total Total Assets The Assignment 2 Company Income Statement For the Years 2016 to 2019 Property/Plant/Equipment, Total - Gross Accumulated Depreciation, Total Long-Term Note Receivable Goodwill, Net Intangibles, Net Accounts Payable Accrued Expenses Notes Payable/Short Term Debt Other Current liabilities, Total Total Current Liabilities Total Debt Deferred Income Tax Other Liabilities, Total Total Liabilities 30-Jun-19 11667.8 6628.7 5039.1 2637 Total Equity Total Liabilities & Shareholders' Equity Total Common Shares Outstanding 211.6 -29.1 2219.6 13.9 2233.5 1493.4 The Assignment 2 Company Balance Sheet For the Years Ending June 30 2016 to 2019 30-Jun-19 30-Jun-18 3191.1 23.5 1742.8 34543 39500.4 1840.8 -1155.8 27.1 1682 534.2 7.8 1233.5 43670 152.3 1863.5 0 33831.6 35847.4 2007.7 251.1 1082.2 39188.4 4481.6 43670 455.7 30-Jun-18 10938.5 6220.7 4717.8 2496.9 206.9 -1.4 2015.4 0 2015.4 1376.5 Task Copy the Income Statement and paste it into a new worksheet. Reformat the data so that it is more readable, add any titles required, and insert formulas in place of the numbers where possible (ignoring any Income tax formulas--- leave any tax amounts as numbers). Copy the Balance Sheet and paste it into an area below the Income Statement. Reformat the data so that it is more readable, add any titles required, and insert formulas in place of the numbers where possible (leave any Retained Earnings (or Deficit) amounts in the Equity section as numbers). On a new worksheet, using the years of information you have, create a common-size income statement. Link all the formulas to the income statement worksheet, and ensure formatting and titles are appropriate. On the original income statement and balance sheet worksheet, choose any three financial ratios from our textbook's chapter 3. Using cell referencing, calculate these three ratios for the three most recent years of information you have. Place these ratio's names and calculations in a space to the right of the Income Statement, with applicable titles, formatting and column headers. Again to the right of these ratio calculations, for each ratio, add a brief summary of the performance over the years and what it may indicate about the company (if anything). 1639.3 26.6 1546.9 25596.4 28809.2 1776.4 -1103.7 32.2 1793.5 503.2 28.9 1270.8 33110.5 194.5 1786.5 0 25132.7 27113.7 9.2 172.1 1007 28302 4808.5 33110.5 466.4 30-Jun-17 10226.4 5842 4384.4 2370.3 199 0 1815.1 0 1815.1 1242.6 30-Jun-17 1584 2032.2 1498.8 22378 27493 1718.7 -1051.6 155.4 1883.5 491 54.1 1315.7 32059.8 152.1 1793.9 2173 20048.6 24167.6 2184.5 215.9 994.6 25389.6 6670.2 32059.8 480.2 What I'm looking for Use of Excel formatting, cell referencing anywhere there'd be a calculation within the statement. 30-Jun-16 9442 5380.2 4061.8 2200.4 193.9 42.7 1624.8 2.9 1627.7 1122.2 Use of Excel formatting, cell referencing anywhere there'd be a calculation within the statement. Using "time-effective" cell referencing to have created all the formulas. Appropriate titles/formatting. Am I going to know what ratio is calculated? Am I going to know for what years? Was it calculated correctly? 30-Jun-16 1699.1 I will manually change a ratio value...your "result" should change accordingly... 28 1595.3 22892.1 26214.5 2040.7 -1312.1 138.7 3039.2 643.2 314 1189.9 32268.1 156.5 1809.6 0 22766.7 24732.8 14.7 234.4 1096.3 26078.2 6189.9 32268.1 482.6