Wildhorse Company expects to have a cash balance of $52.100 on January 1, 2022. These are the relevant monthly budpet data for the first two months of 2017 1 2. 3. 4. Collections from customers January 390.000. February 5134,200 Payments to suppliers: January $45,500. February $51.000 Wages January $35,000, February $41.000 Wapes are paid in the month they are incurred Administrative expenses: January $25,000. February $31.900 These costs include depreciation of $2.300 per month. All other costs are paid as incurred Selling expenses. January $19.900, February 523,400. These costs are exclusive of depreciation. They are paid as incurred Sales of short-term investments in January are expected to realize $14.400 in cash Wildhorse has a line of credit ata local bank that enables it to borrow up to 543,300. The company wants to maintain a minimum monthly cash balance of $26.000 5 6. Prepare a cash budget for January and February (Do not leave any answer held blank, Enter for armounts) WILDHORSE COMPANY For the Months Ending January 30 and February 28, 2022 Cash Budget February January $ 52100 S 334 Beginning Cash Flatance Add Recoints 90000 Collections from Customers 14400 Sale of Short Term investments January Ferry Beginning Cash Balance 32:00 S 334 Add Receipts Collections from Customers 90000 1543 Sale of Short Term investments 14400 Total Receipts 10000 1:14 Total Available Cash Les Distures Wapes Pariments to Suppliers Administrative Experten Selling Expenses Total Dissements Escow Decency of Available Cash Over Dubursements Financing Horrowing Repayments $ Ending Cash Balance