Keiser, Inc. sells specialized metal stampers. All of the company's products are sold to manufacturing companies. The company has a 45-day average collection period and wishes to maintain a $25 million cash balance. Show your work to receive partial credit. 1. Complete the cash budget using an Excel template. (10 points), 2. Based on the information you calculate, discuss the stratgy Keiser, Inc must employ to manage its cash position. (6 points) 3. Calculate the company's cash conversion cycle. Use 45 days. (6 points) 4. How might managing the CCC assist with the company's cash financing needs? (6 points) Average Receivables $10,000 Average Inventory $6,500 Average Payables $7,000 Sales $34,500 Cost of Goods Sold $25,000 Quarter Quarter 1 2 Quarter 3 Quarter 4 Beginning Receivables $360 Sales $290 $385 $472 $355 Cash Collections Ending Receivables Total Cash Collections Total Cash Disbursements $240 $480 $540 $480 Net Cash Inflow Beginning Cash Balance $25 Net Cash Inflow Ending Cash Balance Minimum Cash Balance Cumulative surplus/deficit