60.1K

Verified Solution

Link Copied!

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 ($000) Cash Accounts Receivable Inventory Accounts Payable 97 209 193 93 97 102 490 105 97 100 891 96 97 590 48 92 If you choose to enter the year with $401,000 total in cash and maintain a minimum cash balance of $97,000, what is your maximum short-term borrowing? .. ($000) Q1 $ 401 $ $ $ 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 $ $ $ $ $ $ Enter any number in the edit fields and then click Check Answer. 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 ($000) Cash Accounts Receivable Inventory Accounts Payable 97 209 193 93 97 102 490 105 97 100 891 96 97 590 48 92 If you choose to enter the year with $401.000 total in cash and maintain a minimum cash balance of $97,000, what is your maximum short-term borrowing? Calculate the temporary working capital for each quarter below: (Round to the nearest integer.) ($000) Q1 Q2 Q3 04 Cash $ 97 $ 97 S 97 S 97 Accounts recevable $ 209 $ 102 S S S 590 100 891 $ $ 490 S S 48 Inventory Accounts payable 193 93 $ $ 105 S 96 S 92 NWC $ 406 $ 584 S 992 S 643 $ (406) - Permanent WC needs Temporary WC needs (406) $ 0 $ (406) S 178 s (406) S 586 S $ 237 Below, determine the maximum amount of short-term borrowing needed if the fimm enters the year with $401,000 in cash. (Round to the nearest integer.) Q1 ($000) ( Cash at beginning of quarter $ 401

Answer & Explanation Solved by verified expert

See Answer