M 5 Homework B - Graded K Marcel Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) (Click the icon to view the additional information.) 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 Question 5, EM5-28 (similar to) Part 2 of 4 Minimum cash balance desired Projected cash excess (deficiency) Financing: Complete a cash budget for Marcel 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.) Borrowing Principal repayments Total effects of financing Ending cash balance Marcel Company Cash Budget January, February, and March S (Click the icon to view the cash payments schedule) January February 5,000 $ 5,720 10,080 10,300 16,020 S 15,080 0 3,100 1,200 6,060 0 10,360 4,720 (5,000) (280) 1,000 0 1,000 5,720 3,900 3,800 440 4,950 13090 > (5,000) 10 HW Score: 54.69%, 17.5 of 32 points Points: 1.5 of 6 SCIER Save ncorrect: 0

Maktel Con pany has prepared the foliowng schedusgs and add tional informaton: More info Marcel's beginning cash balance is $5,000 and Marcel desires to maintain a minimum ending cash balance of $5,000. Marcel 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. Reference Reference fields. Enter a =0" for