CASH FLOW LOGIC.XLS In the table below, the formula to calculate cell D28, New debts is =IF(D the purpose of -D17-D21? To calculate the amount of debt required based on net income loss and cras a income loss is greater than BOY cash balance then borrow that difference. To calculate the amount of debt required based on net income loss and class income loss is less than BOY cash balance then borrow the difference betwe balance and net income loss. c To calculate the amount of cash to be used to finance the net income loss. d. The If statement is unnecessary and serves no purpose. CASH FLOW LOGIC.XLS In the table below, the formula to calculate cell D28, New debts is =IF(D the purpose of -D17-D21? To calculate the amount of debt required based on net income loss and cras a income loss is greater than BOY cash balance then borrow that difference. To calculate the amount of debt required based on net income loss and class income loss is less than BOY cash balance then borrow the difference betwe balance and net income loss. c To calculate the amount of cash to be used to finance the net income loss. d. The If statement is unnecessary and serves no purpose