Calculate the moving average forecast for November's Day 11 net cash flow using a 5 day window a. $10,500 b. $29,000 c. $27,000 d. $21,670
Question Completion Status: 3 4 8 1 2 7 9 10 11 120 130 140 15 16 170 You are an analyst in the Treasurer's department with Wilson Inc., a multinat accounts at other banks in the U.S. You have been tasked with answering q you requested to help in answering the questions. U.S. BANKING INFORMATION Monthly average ledger balance at U.S. Bank $3,500,000.00 Monthly average deposit float $750,000.00 Monthly Service Charge_US Bank $1,000.00 Earnings Credit Rate_ US Bank 0.007 Required Reserves Ratio 0.03 30/365 0.0822 Wire Transfer Cost $15 ACH cost $0.50 4 9000 $25,000.00 2 2 NNN 2 INFO ON COLLECTIONS FROM CUSTOMERS Number of remittances per month Average face value of monthly remittances Mailfloat - in house processing Processing float - in house processing Availability float - in house processing Days float Per check Variable cost of in-house Processing Fixed Cost of in-house check processing Days float with lockbox alternative Per check variable cost of lockbox alternative Fixed Cost of lockbox alternative INFO ON DISBURSEMENTS TO SUPPLIERS Disbursements per year Check cost_ per check 6 0.4 $2,500.00 4 0.8 $3,000.00 3500 $1.50 - . bb.uhd.edu/webapps/assessment/take/launch.jsp?course_assessment id=_254521_1814 Remaining Time: 2 hours 08 minutes. 07 seconds. Question Completion Status: 1 2 3 4 50 6 7 8 9 10 11 120 130 15 16 170 3500 $1.50 $0.50 $25.000 Disoursements per year Check cost_ per check ACH costs_per check upfront cost to switch fully to ACH system DAILY NET CASH FLOWS (10 days into November) Day 1 2 Net Cash Flow 18000 20000 23000 3 4 25000 5 6 7 26000 35000 32000 25000 8 9 25000 27000 $500.000.00 0.7 0.3 10 MONTHLY SALES FORECASTS INFORMATION October sales % of sales collected in month of sale % of sales collected in following month % of sales in Cost of goods sold Monthly lease payment Cash position end of October Target cash balance Sales forecast for November Sales forecast for December MISCELLANEOUS INFO Company's Discount Rate 0.75 $125,000.00 5120 000.00 $80.000.00 $450,000.00 $350,000.00 124 Question Completion Status: 3 4 8 1 2 7 9 10 11 120 130 140 15 16 170 You are an analyst in the Treasurer's department with Wilson Inc., a multinat accounts at other banks in the U.S. You have been tasked with answering q you requested to help in answering the questions. U.S. BANKING INFORMATION Monthly average ledger balance at U.S. Bank $3,500,000.00 Monthly average deposit float $750,000.00 Monthly Service Charge_US Bank $1,000.00 Earnings Credit Rate_ US Bank 0.007 Required Reserves Ratio 0.03 30/365 0.0822 Wire Transfer Cost $15 ACH cost $0.50 4 9000 $25,000.00 2 2 NNN 2 INFO ON COLLECTIONS FROM CUSTOMERS Number of remittances per month Average face value of monthly remittances Mailfloat - in house processing Processing float - in house processing Availability float - in house processing Days float Per check Variable cost of in-house Processing Fixed Cost of in-house check processing Days float with lockbox alternative Per check variable cost of lockbox alternative Fixed Cost of lockbox alternative INFO ON DISBURSEMENTS TO SUPPLIERS Disbursements per year Check cost_ per check 6 0.4 $2,500.00 4 0.8 $3,000.00 3500 $1.50 - . bb.uhd.edu/webapps/assessment/take/launch.jsp?course_assessment id=_254521_1814 Remaining Time: 2 hours 08 minutes. 07 seconds. Question Completion Status: 1 2 3 4 50 6 7 8 9 10 11 120 130 15 16 170 3500 $1.50 $0.50 $25.000 Disoursements per year Check cost_ per check ACH costs_per check upfront cost to switch fully to ACH system DAILY NET CASH FLOWS (10 days into November) Day 1 2 Net Cash Flow 18000 20000 23000 3 4 25000 5 6 7 26000 35000 32000 25000 8 9 25000 27000 $500.000.00 0.7 0.3 10 MONTHLY SALES FORECASTS INFORMATION October sales % of sales collected in month of sale % of sales collected in following month % of sales in Cost of goods sold Monthly lease payment Cash position end of October Target cash balance Sales forecast for November Sales forecast for December MISCELLANEOUS INFO Company's Discount Rate 0.75 $125,000.00 5120 000.00 $80.000.00 $450,000.00 $350,000.00 124
