Plz solve exercise E22-28, rest pictures are for reference to solve it.

22-26 Preparing a financial budget-schedule of cash receipts, sensitivity analysis Marcel Company projects the following sales for the first three months of the year: $11,200 in January; $12,300 in February; and $11,100 in March. The company expects 60% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1 . Round to the nearest dollar. Requirements 1. Prepare a schedule of cash receipts for Marcel for January, February, and March. What is the balance in Accounts Receivable on March 31? Feb, total cash receipts $12,080 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31? 22-27 Preparing a financial budget-schedule of cash payments Marcel Company has the following projected costs for manufacturing and selling and administrative expenses: End of Chapter: Master Budgets All costs are paid in month incurred except: direct materials, which are paid in the month following the purchase; utilities, which are paid in the month after incurred; and property taxes, which are prepaid for the year on January 2. The Accounts Payable and Utilities Payable accounts have a zero balance on January 1. Prepare a schedule of cash payments for Marcel for January, February, and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31. Mar. total cash pmts. $11,500 2-28 Preparing the financial budget-cash budget Use the original schedule of cash receipts completed in Exercise E22-26@, Requirement 1, and the schedule of cash payments completed in Exercise E22-27E to complete a cash budget for Marcel Company for January, February, and March. Additional information: 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 8% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Feb. ending cash bal. $5.780