Please do it in EXCL sheets with the cell references provided it is easier to understand thank you!

PROBLEM 3-15 WORKING WITH FINANCIAL STATEMENTS Given the information below for Knapp Inc.: a. How much is the firm's net working capital and what is the debt ratio? b. Complete a common-sized income statement, a common-sized balance sheet, and a s Complete the steps below using cell references to given data or previous calculations. . is all you need. To copy/paste a formula across a row or down a column, an absolute c may be preferred. If a specific Excel function is to be used, the directions will specify th numerical data into a cell or function. Instead, make a reference to the cell in which th compulations only in the blue cells highlighted below. In all cases, unless olherwise din Taxes (40%) Net income before taxes 80$120 SOIUJTION a. How much is the firm's net working capital and what is the debt ratio? b. Complete a common-sized income statement a common-sized balance sheet, and a : Knapp Inc. Common-sized Income Statement for 2018: Knapp Inc. Common-sized Balance Sheet for 2018: Knapp Inc. Statement of Cash Flows for 2018 : 1. Start Exeel. Download and open the workbook named: Kcown_Martin_Petty_Problc Important note: All calculations must be shown using eell references. Do NOT enter nt 2. In cell B44, calculate the net working capital for 2017 . (1 point) 3. In cell B45, calculate the debt ratio for 2017. (1 point) 4. Copy cells B44:B45 and paste onto cells C44:C45. (1 point) 5. To prepare the common-sized income statement, find the ratio between each account amount. In cell B49, divide the sales amount by the sales datum in cell E30 and make an absolu copying and pasting purposes. (1 point) 6. Copy cell 349 and paste onto the cell ranges B50:B51 and B54:B58. (1 points) 7. In cell B52, divide the selling, general, and administrative expense by the sales datur cell reference to the sales datum for copying and pasting purposes. (1 points) 8. Copy cell B52 and paste onto the cell B53. (1 points) 9. To prepare the common-sized balance sheet, find the ratio between each account in t balance sheet. In cell 362 , divide the cash amount by the total assets datum in cell C16 and make an a assets datum for copying and pasting purposes. (1 point) 10. Copy cell B62 and paste onto the cells B63:B69. (1 points) 11. In cell B71, divide the accounts payable amount by the total liabilities and owners'' absolute cell reference to the total liabilities and owners' equity datum for copying and 12. Copy cell B71 and paste onto the cell ranges B72:B74 and B76:B79. (1 points) 13. In cell C83, input the net income amount. Note: The oulpul of the expression or function you typed in this cell is expected as a pc and as a negative number in case of cash outflow. (1 point) 14. In cell B84, input the depreciation expense. Note: The output of the expression or function you typed in this cell is expected as a pc and as a negative number in case of cash outflow. (1 point) 15. In cell B85, calculate the decrease in accounts receivable. Note: The output of the expression or function you typed in this cell is expected as a pc. and as a negative number in case of cash outflow. (1 point) 16. In cell B86, calculate the increase in inventory. Note: The output of the expression or function you typed in this cell is expected as a pc and as a negative number in case of cash outflow. (1 point) 17. In cell B87, calculate the decrease in account payable. Note: 'The output of the expression or function you typed in this cell is expected as a pc and as a negative number in case of cash outflow. (1 point) 18. In cell C88, input the function SUM to calculate the net cash provided by operating Note: The output of the expression or function you typed in this cell is expected as a pc and as a negative number in case of cash outflow. (1 point) 19. In cell C90, calculate the increase in plant and equipment. Note: The output of the expression or function you typed in this cell is expected as a pc and as a negative number in case of cash outflow. (1 point) 20. In cell B92, calculate the increase in notes payable. Note: The output of the expression or function you typed in this cell is expected as a pc and as a negative number in case of cash outflow. (1 point) 21. In cell B93, calculate the dividends amount. Note: The output of the expression or function you typed in this cell is expected as a pc and as a negative number in case of cash outflow. (1 point) 22. In cell C94, input the function SUM to calculate the net cash provided by financing Note: The output of the expression or function you typed in this cell is expected as a pc and as a negative number in case of cash outflow. (1 point) 23. In cell C95, calculate the net decrease in cash. Note: The output of the expression or function you typed in this cell is expected as a pc and as a negative number in case of cash outflow. (1 point) 24. In cell C96, input the beginning cash amount. (1 point) 25. In cell C97, calculate the ending cash amount. (1 point) 26. Save the workbook. Close the workbook and then exit Excel. Submit the workbook