Step In cdl B31, calculste the total asects 12 In cdl B33, input the notes payable amount. 13 In cdl B34, input the accounts payable amount. In cdll B35, calculste the total current labiities 15 In cdl B36, input the long-term deht amount 16 In cdll B37, calculste the total libilties 17 n cll B38, input the common stock amount. Since the balance sheet must balance, input the total labilities and equty amount in call B41 by making a cell reference to the total aets. In cal B40, calculste the total equity amount. In cal B39, calculste the retained earnings amount. 21 In cdl B43, calculate the net working capital. 22 In cdl B44, calculate the debt ratio. Save the workbock. Close the workbcok and then exit Excel. Submit the warkbook as directed