The treasurer of Westmark Industrial, Inc., a wholesale distributor of household appliances, wants to estimate his company€™s cash balances for the first three months of 2015. Using the information below, construct a monthly cash budget for Westmark for January through March 2015. Westmark€™s sales are 20 percent for cash, with the rest on 30-day credit terms. Its purchases are all on 60-day credit terms. Does it appear from your results that the treasurer should be concerned about investing excess cash or looking for a bank loan?

Transcribed Image Text:

Westmark Industrial, Inc. Selected Information (S thousanols) 2014 (Actual) 2015 (Projected) October November December January February March Sales Purchases 360 510 420 540 1,200 1,200 6O0 300 240 120 240 120 Wages payable monthly Principal payment on debt due in March Interest due in March Dividend payable in March Taxes payable in February Addition to accumul ated depreciation in March Cash balance on January 1, 2015 Minimum desired cash balance 180 210 90 300 180 30 300 150