5. please help me completing the (4) parts. All info listed

Armand Company has prepared the following schedules and additional information: January Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials 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: Borrowing Principal repayments Total effects of financing Ending cash balance whes and dona information Click the icon to view the cash whe) Click the icon to view the chance Click the icon to view the additional Wormation) Complete a canh budget for Amand Company for Jawy, February and March (Computer de water wys om. Round wherred to be can bude newest w we reconocery with a minus signor parents G Armand Company Cash Budget January February, and March January Beginning cash balance Cash receptu Cash available Cash payment Purchases of material Debor Maructuring overhead Seling and administrative expenses intereses Total cash payments - - X More info Armand's beginning cash balance is $3,500 and Armand desires to maintain a minimum ending cash balance of $3,500. Armand 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 10% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Print Done 9 sched Reference schedul ormation any for January February March Total the nearest whole de 0 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,900 S Arma 4,400 4,400 $ 0 3,900 8,300 Cal anuary, F Direct Labor: Total payments for direct labor 2,600 3,900 3,500 10,000 850 850 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 3,600 3,600 1,700 3,600 5,300 850 850 Selling and Administrative Expenses: Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 850 850 1,700 3,600 3,600 5,300 3,600 850 850 Selling and Administrative Expenses: Utilities for office 460 460 920 Property taxes on office 1,920 1.920 Office salaries 4,000 4,000 5,9 4,000 4,460 12,000 14,840 Total payments for Selling and Admin. expenses 4,460 12,120 13,110 $ 13,210 $ 38,440 Total cash payments $ 4,140 Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable $ 4,300 $ 1,310 Reference pared the following sch the cash receipts sche the additional informat Total Dr Armand Company fo theses.) Total sales January February March $ 12,600 $ 15,900 $ 14,100 5 January February March nearest whole dollar 42.000 Total $ Ar 10,080 1.200 s 1.260 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 March Credit sales, collection of March sales in March January 12.720 1,500 S 1,500 11,280 1.410 14,280$ 11,340 S 15.570 S 41.190 Total cash receipts from customers materials Accounts Receivable balance, March 31: MarchCredit sales, collection of March sales in April bad $ 1,410 rative expenses