Please use the provided excel and show work / formula in working cell for a thumb up.

Please use the provided excel and show work / formula in working cell for a thumb up.

6-11 CALCULATING OPERATING NETWORKING CAPITAL Hildebrand Corp. had the follow- ing current asset and current liability account balances for 2012 through 2015: 2012 In Millions of Dollars Cash and equivalents Short-term investments Cash and short-term investments Accounts receivable Inventories Total current assets Accounts payable Accrued expenses Notes payable/short-term debt Current portion of long-term debt Total current liabilities 2015 2014 2013 $ 807,926 $ 560,960 $ 617,866 178,994 197,408 182,442 986,920 758,368 800,308 2,028,060 2,365,823 2,341,609 1,456,271 1,441,024 1,450,258 4,471,251 4,565,215 4,592,175 1,138,770 1,601,413 1,584,959 878,454 901,546 902,164 1,038,633 789,285 979,675 531,635 386,879 303,214 $3,587,492 $3,679,123 $3,770,012 $ 658,255 614,513 1,272,768 2,302,447 1,262,308 4,837,523 1,416,367 863,683 821,126 248,028 $3,349,204 a. Compute Hildebrand's operating net working capital for 2012 to 2015. b. What are the annual changes in operating net working capital for 20132015? c. Analyze the firm's needs for additional capital to support its need for operating working capital. PROBLEM 6-11 In Millions of $ Cash & Equivalents Short Term Investments Cash and Short Term Investments Accounts Receivable Inventories Total Current Assets Given: 2015 2014 2013 2012 $ 807,926 $ 560,960 $ 617,866 $ 658,255 178,994 197,408 182 442 614,513 986,920 758,368 800,308 1,272,768 2,028,060 2,365,823 2,341,609 2,302.447 1,456,271 1,441,024 1,450,258 1.262 308 4,471,251 4.565,215 4,592,175 4,837,523 Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output Accounts Payable Accrued Expenses Notes Payable/Short Term Debt Current Port of LT Debt Total Current Liabilities 1,138,770 1,601,413 1,584,959 1,416,367 878,454 901,546 902, 164 863,683 1,038,633 789,285 979,675 821, 126 531,635 386,879 303,214 248,028 $3,587,492 $3,679,123 $3,770,012 $3,349,204 Solution a: Operating Current Assets Operating Current Liabilities Operating Net Working Capital Solution b: Change in Operating Net Working Capital Solution c