Fill in the blanks please and explain
The following table includes quarterly working capital levels for your firm for the next year. 4 Quarter ($000) 1 2 3 Cash 100 100 100 100 Accounts Receivable 200 100 100 600 Inventory 200 500 900 50 Accounts Payable 100 100 100 100 If you choose to enter the year with $400,000 total in cash and maintain a minimum cash balance of$100,000, what is your maximum short-term borrowing? (Note that $400,00 would be 400 and $100,000 would be 100 in the table because the figures are in thousands in the table.) Answer: Calculate the temporary working capital for each quarter below: (Round to the nearest integer in the table. Note that all figures in this question are in thousands.) Quarter Q2 Q4 Q1 100 Q3 100 100 100 200 100 100 600 ($000) Cash Accounts receivable Inventory Accounts payable 200 500 900 50 100 100 100 100 400 600 1,000 650 NWC (400) (400) (400) (400) - Permanent WC needs Temporary WC needs 0 200 600 250 200 800 Temporany ve needs Answer: Use the table below to determine the maximum amount of short-term borrowing needed if the firm enters the year with $400,000 in cash. (Note that $400,000 is 400 in the table. Round to the nearest integer in the table.) Quarter ($000) Q1 Q2 Q3 04 400 Cash at beginning of quarter Minimum cash balance Temporary working capital needs 0 Change in NWC Financing Starting available excess cash 300 300 100 Existing ST Debt 0 Increase (decrease) 0 0 300 Financing Starting available 300 300 100 excess cash Existing ST Debt 0 0 0 300 Increase (decrease) ST Debt 0 0 Total short term borrowing 300 300 100 0 Ending excess cash 400 200 100 Ending cash balance Answer: The maximum short-term borrowing occurs in (answer"Q1" "Q2 "Q3", or "Q4") and is $ (000). (Round to the nearest integer.) The following table includes quarterly working capital levels for your firm for the next year. 4 Quarter ($000) 1 2 3 Cash 100 100 100 100 Accounts Receivable 200 100 100 600 Inventory 200 500 900 50 Accounts Payable 100 100 100 100 If you choose to enter the year with $400,000 total in cash and maintain a minimum cash balance of$100,000, what is your maximum short-term borrowing? (Note that $400,00 would be 400 and $100,000 would be 100 in the table because the figures are in thousands in the table.) Answer: Calculate the temporary working capital for each quarter below: (Round to the nearest integer in the table. Note that all figures in this question are in thousands.) Quarter Q2 Q4 Q1 100 Q3 100 100 100 200 100 100 600 ($000) Cash Accounts receivable Inventory Accounts payable 200 500 900 50 100 100 100 100 400 600 1,000 650 NWC (400) (400) (400) (400) - Permanent WC needs Temporary WC needs 0 200 600 250 200 800 Temporany ve needs Answer: Use the table below to determine the maximum amount of short-term borrowing needed if the firm enters the year with $400,000 in cash. (Note that $400,000 is 400 in the table. Round to the nearest integer in the table.) Quarter ($000) Q1 Q2 Q3 04 400 Cash at beginning of quarter Minimum cash balance Temporary working capital needs 0 Change in NWC Financing Starting available excess cash 300 300 100 Existing ST Debt 0 Increase (decrease) 0 0 300 Financing Starting available 300 300 100 excess cash Existing ST Debt 0 0 0 300 Increase (decrease) ST Debt 0 0 Total short term borrowing 300 300 100 0 Ending excess cash 400 200 100 Ending cash balance Answer: The maximum short-term borrowing occurs in (answer"Q1" "Q2 "Q3", or "Q4") and is $ (000). (Round to the nearest integer.)
