Question

In: Accounting

The treasurer of Westmark Industrial, Inc., a wholesale distributor of household appliances, wants to estimate his...

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 2017. Using the information below, construct a monthly cash budget for Westmark for January through March 2017. Westmark’s sales are 25 percent for cash, with the rest on 30-day credit terms. Its purchases are all on 45-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?

Westmark Industrial selected information in $ thousands

2016 (Actual)

October: Sales 360, Purchases 510

November: Sales 420, Purchases 540

December: Sales 900, Purchases 850

2017 (Projected)

January: Sales 400, Purchases 150

February: Sales 300, Purchases 300

March: Sales 240, Purchases 120

Wages payable monthly                                                    200

Principal payment on debt due in March                      190

Interest due in March                                                        75

Dividend payable in March                                               180

Cash balance on 1 January 2017                                     285

Minimum desired cash balance                                       175

Solutions

Expert Solution


Related Solutions

Westex Products is a wholesale distributor of industrial cleaning products. When the treasurer of Westex Products...
Westex Products is a wholesale distributor of industrial cleaning products. When the treasurer of Westex Products approached the company’s bank in late 2019 seeking short-term financing, he was told that money was very tight and that any borrowing over the next year would have to be supported by a detailed statement of cash receipts and disbursements. He was also told that it would be very helpful to the bank if borrowers would indicate the quarters in which they would be...
The treasurer of Pablitos wants to estimate the operating cash flow of company for the next...
The treasurer of Pablitos wants to estimate the operating cash flow of company for the next six months. Using the following information, build a monthly cash flow budget for pablitos from october to March 2018. Do you think that the treasurer should be concerned about inversting the excess of cash for a bank loan ? Sales (40% in cash, the rest on credit at 30 days) 2017 projected October 550 000 November 670 000 December 280 000 2018 projected January...
Costco Wholesale Corporation operates membership warehouses selling food, appliances, consumer electronics, apparel and other household goods...
Costco Wholesale Corporation operates membership warehouses selling food, appliances, consumer electronics, apparel and other household goods at 582 locations across the U.S. as well as in Canada, the United Kingdom, Japan, Australia, South Korea, Taiwan, Mexico and Puerto Rico. As of its fiscal year-end 2010, Costco had approximately 60 million members. Selected fiscal-year information from the company's balance sheets follows. ($ millions). Selected Balance Sheet Data ($ millions) 2010 2009 Merchandise inventories $5,638 $5,405 Deferred membership income (liability) 869 824...
Costco Wholesale Corporation operates membership warehouses selling food, appliances, consumer electronics, apparel and other household goods...
Costco Wholesale Corporation operates membership warehouses selling food, appliances, consumer electronics, apparel and other household goods at 582 locations across the U.S. as well as in Canada, the United Kingdom, Japan, Australia, South Korea, Taiwan, Mexico and Puerto Rico. As of its fiscal year-end 2010, Costco had approximately 60 million members. Selected fiscal-year information from the company's balance sheets follows. ($ millions). Selected Balance Sheet Data ($ millions) 2010 2009 Merchandise inventories $5,638 $5,405 Deferred membership income (liability) 869 824...
Quantum Logistics, Inc., a wholesale distributor, is considering the construction of a new warehouse to serve...
Quantum Logistics, Inc., a wholesale distributor, is considering the construction of a new warehouse to serve the southeastern geographic region near the Alabama–Georgia border. There are three cities being considered. After site visits and a budget analysis, the expected income and costs associated with locating in each of the cities have been determined. The life of the warehouse is expected to be 12 years and MARR is 15%/year. City Initial Cost Net Annual Income Lagrange $1,260,000 $480,000 Auburn $1,000,000 $410,000...
Context/Situation: A manufacturer and distributor of home appliances, ABC, Inc. in Tulsa Oklahoma owns the name...
Context/Situation: A manufacturer and distributor of home appliances, ABC, Inc. in Tulsa Oklahoma owns the name brand “Hercules” and wishes to manufacture or source, and market washing machines. John Smith the President is tasked with “Developing and Managing the Supply Chain for Washing Machines”. The Marketing Manager, Harold Casey is given the task of reporting to John Smith and “Managing the Channels of Distribution” for the washing machines division. Assignment: Please evaluate the context/situation and then explain in detail what...
The financial staff at Lehman Inc., a wholesale distributor has estimated the following sales figures for...
The financial staff at Lehman Inc., a wholesale distributor has estimated the following sales figures for the first half of 2019: Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000 August $180,000 Actual November and December 2018 sales were $200,000 and $90,000, respectively. Cash sales are 45% of the total and the rest are on credit. About 70% of credit sales are typically collected one month after the sale and 30% the second...
Pool Corporation, Inc., is the world's largest wholesale distributor of swimming pool supplies and equipment. It...
Pool Corporation, Inc., is the world's largest wholesale distributor of swimming pool supplies and equipment. It is a publicly-traded corporation that trades on the NASDAQ exchange. The majority of Pool's customers are small, family-owned businesses. Assume that Pool issued bonds with a face value of $900,000,000 on January 1 of this year and that the coupon rate is 6 percent. At the time of the borrowing, the annual market rate of interest was 2 percent. The debt matures in 9...
TM Office Supplies, Inc., is a wholesale distributor of office supplies. It sells pencils and pens,...
TM Office Supplies, Inc., is a wholesale distributor of office supplies. It sells pencils and pens, paper goods (including computer paper and forms), staplers, calendars, and other items, excluding furniture and other major items such as copy machines that you would expect to find in an office. Sales have been growing at 5 percent per year during the past several years. Mr. Marina, the president of TM Office Supplies, recently attended a national office supplies convention. In conversations during that...
The financial staff at Lehman Inc., a wholesale distributor has estimated the following sales figures for...
The financial staff at Lehman Inc., a wholesale distributor has estimated the following sales figures for the first half of 2019: Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000 August $180,000 Actual November and December 2018 sales were $200,000 and $90,000, respectively. Cash sales are 45% of the total and the rest are on credit. About 70% of credit sales are typically collected one month after the sale and 30% the second...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT