Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

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

image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Exploring Economics

Authors: Robert L Sexton

5th Edition

978-1439040249, 1439040249

Students also viewed these Accounting questions