How does the forecast of December's ending cash position differ from November's? a. It's $7500 lower b. It's $115,000 lower c. It's $800 higher d. There's no difference
Question Completion Status: 1 10 11 2 3 6 7 15 You are an analyst in the Treasurer's department with Wilson Inc., a accounts at other banks in the U.S. You have been tasked with ans 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 30/365 0.0822 Wire Transfer Cost ACH cost 003 $15 $0.50 9000 $25,000 00 2 2 12 6 INFO ON COLLECTIONS FROM CUSTOMERS Number of remittances per month Average face value of monthly remittances Mal float - 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 0.4 $2.500.00 4 0.8 $3,000.00 3500 $150 Disbursements per year 3500 $1.50 $0.50 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 $25,000 Net Cash Flow 1 18000 2 20000 3 23000 4 25000 5 26000 6 35000 7 32000 8 25000 9 26000 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 $120,000.00 $80.000.00 $450,000.00 $350,000.00 12% Click Save and Submit to save and submit Chick Save Almers to su Question Completion Status: 1 10 11 2 3 6 7 15 You are an analyst in the Treasurer's department with Wilson Inc., a accounts at other banks in the U.S. You have been tasked with ans 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 30/365 0.0822 Wire Transfer Cost ACH cost 003 $15 $0.50 9000 $25,000 00 2 2 12 6 INFO ON COLLECTIONS FROM CUSTOMERS Number of remittances per month Average face value of monthly remittances Mal float - 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 0.4 $2.500.00 4 0.8 $3,000.00 3500 $150 Disbursements per year 3500 $1.50 $0.50 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 $25,000 Net Cash Flow 1 18000 2 20000 3 23000 4 25000 5 26000 6 35000 7 32000 8 25000 9 26000 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 $120,000.00 $80.000.00 $450,000.00 $350,000.00 12% Click Save and Submit to save and submit Chick Save Almers to su