Please solve for the remaining months. Also please explain how you got the "Borrowing" amount. Not sure what step I'm missing. Thank you.
Avery Company has prepared the following schedules and additional information (Click the icon to view the cash receipts schedule) Click the icon to view the cash payments schedule) Click the icon to view the additional information) Complete a cash budget for Avery Company for January, February and March (Complete all input fields Enter a "O" for any zero balances Round all amounts entered into the cash budget to the nearest whole dollar Enter a cash deficiency with a minus sign or parentheses.) Avery Company Cash Budget January, February, and March January $ 5,500 11 475 Beginning cash balance Cash receipts Cash available Cash payments Purchases of direct materials 16 975 0 Avery Company has prepared the following schedules and additional information (Click the icon to view the cash receipts schedule ) (Click the icon to view the cash payments schedule) Click the icon to view the additional information), Complete a cash budget for Avery Company for January February and March (Complete all input fields, Enter a *o" for any zero balances Round all amounts entered into the cash budget to the nearest whole dollar Enter a cash deficiency with a minus sign or parentheses) 3200 2100 7,440 0 Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess deficiency) Financing 13.040 3,935 (5,500) (1565) 5 Avery Company has prepared the following schedules and additional information (Click the icon to view the cash receipts schedule) (Click the icon to view the cash payments schedule) Click the icon to view the additional information) Complete a cash budget for Avery Company for January, February and March (Complete all input fields Enter a "0" for any zero balances Round all amounts entered into the cash budget to the nearest whole dollar Enter a cash deficiency with a minus sign or parentheses) Total cash payments 13.040 Ending cash balance before financing 3,935 Minimum cash balance desired (5,500) Projected cash excess (deficiency) (1565) Financing Borrowing 6500 Principal repayments Total effects of financing 10435 Ending cash balance 0 6500 More Info - X Avery's beginning cash balance is $5,500 and Avery desires to maintain a minimum ending cash balance of $5,500. Avery borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rate on amounts borrowed is 12% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Cash Receipts from Customers Total January February March $ 13,500 $ 14,600 $ 15,800 5 January February March Total sales 43,900 Total $ 9,450 2025 $ Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales collection of February sales in February February-Credit sales, collection of February sales in March March-Cash sales 2.025 10,220 2.190 A 2 190 11 060 9,450 2.025 $ Accounts Receivable balance, January 1 January-Cash sales January--Credit sales, collection of January sales in January JanuaryCredit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in February February-Credit sales collection of February sales in March March-Cash sales March-Credit sales, collection of March sales in March Total cash receipts from customers 2,025 10.220 2,190 $ 2 190 11,060 2370 15,620 11,475$ 14,435 41530 Accounts Receivable balance, March 31: March-Credit sales collection of March ales in April 2.370 January February March Total ge Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March Total payments for direct materials 3,400 4,400 0 3.400 4,400 $ 7,800 Direct Labor: Total payments for direct labor 3,200 3.400 3,500 10,100 Manufacturing Overhead: Utilities for plant 640 640 1280 Property taxes on plant Total payments for manufacturing overhead 2,400 2,400 3,680 2.400 640 640 320 320 Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin, expenses 640 1.440 6,000 6,000 5,000 1.440 18,000 20,080 7,440 6,320 6,320 S 13.040 $ 13,760 5 14,860 5 41.660 Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable 2.880 4.600 5 Total payments for manufacturing overhead 2,400 640 640 3,680 320 Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin, expenses 320 640 1,440 6.000 7,440 6,000 6,320 6,000 6,320 1.440 18.000 20,080 S 13,040 13,760 5 14,860 S 41,660 Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable $ 2,880 4.600 S S 960