cash receipts excel managerial accounting

Paste B IV AA 33 x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check A1 f* Please complete Exercise as follows: F Please complete Exercise as follows: G H 1 3 4 1) Franke Co. budgeted the following cash receipts and cash disbursements for the first three months of next year. 5 6 7 8 January February Cash Receipts $525,000 $411,000 $456,000 Cash Disbursements $484,000 $350,000 $520,000 According to a credit agreement with the company's bank, Franke promises to have a minimum cash balance of $20,000 at each month-end. In return, the bank has agreed that the company can borrow up to $160,000 at an annual interest rate of 12%, paid on the last day of each month. The company has a cash balance of $20,000 and a loan balance of $40,000 at January 1. Prepare monthly cash budgets for each of the first three months of next year. Check: January ending cash balance $20,600 2) Ilse the following information abundant for Alor Co It should show