Please complete the second part, quarters 1-4

The following table includes quarterly working capital levels for your firm for the next year. (Click on the following icon in order to copy the contents into a spreadsheet.) Quarters 1 2 3 4 (5000) Cash Accounts Receivable Inventory Accounts Payable 96 206 197 107 96 106 508 102 96 95 906 109 96 607 47 103 If you choose to enter the year with $394,000 total in cash and maintain a minimum cash balance of $96,000, what is your maximum short-term borrowing? Cash $ 96 $ 96 $ 96 $ 96 $ 206 $ 106 95 $ 607 $ $ $ 197 $ 508 906 $ 47 $ 107 $ 102 $ 103 Accounts receivable Inventory Accounts payable NWC Permanent WC needs Temporary WC needs $ 647 109 $ 988 $ (392) $ 392 $ (392) $ 0 0 $ $ 608 $ (392) $ 216 $ (392) 255 $ 596 $ Below, determine the maximum amount of short-term borrowing needed if the firm enters the year with $394,000 in cash. (Round to the nearest integer.) Q1 $ $ $ $ (5000) Cash at beginning of quarter Minimum cash balance Temporary working capital needs Change in NWC Financing Starting available excess cash - Increase (decrease) in NWC + Increase (decrease) ST Debt = Ending excess cash Ending total cash balance Total-short term borrowing $ $ $ $ $ $ The following table includes quarterly working capital levels for your firm for the next year. (Click on the following icon in order to copy the contents into a spreadsheet.) Quarters 1 2 3 4 (5000) Cash Accounts Receivable Inventory Accounts Payable 96 206 197 107 96 106 508 102 96 95 906 109 96 607 47 103 If you choose to enter the year with $394,000 total in cash and maintain a minimum cash balance of $96,000, what is your maximum short-term borrowing? Cash $ 96 $ 96 $ 96 $ 96 $ 206 $ 106 95 $ 607 $ $ $ 197 $ 508 906 $ 47 $ 107 $ 102 $ 103 Accounts receivable Inventory Accounts payable NWC Permanent WC needs Temporary WC needs $ 647 109 $ 988 $ (392) $ 392 $ (392) $ 0 0 $ $ 608 $ (392) $ 216 $ (392) 255 $ 596 $ Below, determine the maximum amount of short-term borrowing needed if the firm enters the year with $394,000 in cash. (Round to the nearest integer.) Q1 $ $ $ $ (5000) Cash at beginning of quarter Minimum cash balance Temporary working capital needs Change in NWC Financing Starting available excess cash - Increase (decrease) in NWC + Increase (decrease) ST Debt = Ending excess cash Ending total cash balance Total-short term borrowing $ $ $ $ $ $