Colorado Adventures, Inc., sells snowsport equipment. Maya Grenier is the controller for Colorado Adventures and put together the below initial cash budget for the fourth quarter of the year. Colorado Adventures, Inc. Cash Budget For the Quarter Ended December 31 The company generally borrows money during this quarter to support peak sales. The above cash budget was based on assembling the following data: a. Budgeted monthly income statements for October-January are: *Includes $10,000 of depreciation each month. b. Each month, 20 percent of sales are for cash and 80 percent are on credit. The collection pattern for credit sales is 10 percent collected in the month of sale, 70 percent in the first month following the month of sale, and 20 percent in the second month following the month of sale. August's sales totaled $100,000, and September's sales totaled $150,000. c. Inventory purchases are on account. Of those purchases, 50 percent are paid in the month of purchase. The remaining 50 percent is paid in the following month. Accounts payable at September 30 for inventory purchases during September total $63,000. d. The merchandise inventory on October 1 is $42,000. The desired ending inventory for each month is 20 percent of the cost of the merchandise to be sold the next month. e. Dividends of $24,500 will be declared and paid in October. f. Land costing $8,000 will be purchased for cash in November. g. The cash balance on October 1 is $26,000. The company wants to have an ending cash balance of at least $20,000. If a cash shortage develops, sufficient cash is borrowed to cover the shortage and provide the desired ending balance. Any cash borrowed must be borrowed in increments of $500 at the beginning of each month. The interest rate on these loans is 1 percent per month (simple interest - that is, assume no compounding). The company would, as possible given minimum requirement, repay the loan plus accumulated interest at the end of the quarter. Colorado Adventures' president wants to know how reducing inventory levels and collecting accounts receivable sooner will impact the cash budget. She has asked Maya and her staff to revise the cash collection and ending inventory assumptions as follows: a. Credit sales still account for 80 percent of total sales. However, the collection period for October, November, and December credit sales is 32 percent collected in the month of sale, 55 percent collected in the month following sale, and 13 percent in the second month following sale. (Any credit sales from August and September collected during the fourth quarter use the collection percentages noted originally in the previous section.) b. The company maintains its ending inventory levels for October, November, and December at 16 percent of the cost of merchandise to be sold in the following month. (The merchandise inventory at October 1 remains $42,000 and accounts payable for inventory purchases at September 30 remains $63,000 as noted originally in the previous section.) In addition, the president is considering increasing dividends declared and paid in October by 45% and wants this reflected on the revised cash budget. Finally, due to inflation concerns, the president is considering increasing the minimum required cash balance to $26,000. Further, there is the possibility that interest rates will increase. Therefore, she wants the impact of a 1.2 percent monthly interest rate on loans also reflected on the cash budget. 1. Prepare the schedule of expected cash collections for October, November, and December and for the quarter in total. 2. Prepare the merchandise purchases budget for October, November, and December and for the quarter in total. 3. Prepare the schedule of expected cash disbursements for merchandise purchases for October, November, and December and for the quarter in total. 4. Prepare the cash budget for October, November, and December, and for the quarter in total. 5. Compare the original cash budget to your revised cash budget. To better prepare Maya for her meeting with the president, discuss (explain) how the revised collection and inventory assumptions affect the cash budget. That is, not only note the changes but also discuss why changes in accounts receivables collections and inventory levels have an impact. Type in your response on the "Requirement 5 " worksheet