How to find absolute value and the function you would input in the cell to find the ABS and if it is in increase or decrease?

A H H I I 3 Actual Year 2019 Forecast Year 2020 Enter the absolute value (ABS in excel) of the relevant amount for each account here. Hint: for ALL but ONE of the accounts, the Increase or decrease cash? In this amount is going to be one of four things: 0 column, enter 1 if the number in the (if the account is irrelevant), the 2019 previous column increases cash, -1 if number, the 2020 number, or the 2020 decreases (burns) cash, or if it is cash number minus the 2019 number. neutral. 4 5 Sales revenue 6 Cost of goods sold expense 7 Commissions expense 7 s other fixed expenses 9 Income tax expenses 10 Cash 11 Accounts receivable 12 Inventory 13 Prepaid rent 14 Prepaid insurance $37,240,227 $17,706,034 $2,793,025 $16.995,039 $0 $2,038,500 $6,427,067 $4,042,061 $429,024 $183,939 $92,252,678 $43,782,198 $6,918,888 $36,689,910 $0 $5,165,799 $15,876,275 $11,276,934 $1,003,286 $429,967 Use the numbers entered into this column to answer the question on the Cash Burn Individual Assignment $0 The formula in column G is column Etimes column $0 $0 $0 Hint: this account needs special attention. SD $0 $0 $0 0 $0 $0 Fixed assets, net of accumulated depreciation $2,283,254 $4,482,557 15 $D $0 SD $1,515,561 $1,069,345 $344,321 $117,506 $3,440,806 $3,125,725 $834,4901 $295,154 SD $0 $96,110 $253,154 16 Accounts payable 17 Salaries payable 18 Commissions payable 19 Payroll taxes payable Warranty liability (Rachio offers a 12-month 20 warranty 21 Long-term debt 22 Common and preferred stock 23 Retained earnings (Accumulated deficit) 24 Capital expenditure 25 $D SO $20.811.000 ($8,549,990) $0 $0 $0 $20,811,000 $3,688,308) $3,300,000 $0 $D Total cash burn $0 26 27 Data Template Cash Flow Statement Balance Sheet Income Statement Sensitivity Analysis + Ready , + 114%