Just needing the 3 boxes in red.

Newman Medical Clinic has budgeted the following cash flows January February $114,000 $120,000 $140,000 March Cash receipts Cash payments For inventory purchases 97,00079,000 92,000 38,000 39,000 34,000 For S&A expenses Newman Medical had a cash balance of $15,000 on January 1. The company desires to maintain a cash cushion of $7,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 3 percent per month. Repayments may be made in any amount available Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) Answer is complete but not entirely correct. Cash Budget January February March Beginning cash balance Add: Cash receipt Cash available Less: Cash payments $ 15,000 7,800 9,150 140,000 149,150 114,000 120,000 129,000 127,800 For inventory purchases For S&A expenses Interest expense per month 97,00079,00092,000 34,000 1,620 38,000 1,200 39,000 1,650 Total budgeted payments 136,200 119,650 127,620 Payments minus receipts Surplus (shortage) (7.200) 8,150 21,530 Financing Activity Borrowing (repayment) 5,00010 12,000 Ending cash balance $7,800 $9,150 33,530