Benson borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount available. The company also pays its vendors on the last day of the month. It pays interest of 1 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $14,000 cash cushion. Prepare a cash budget. (Any repayments/shortage which should be indicated with a minus sign.)

Can someone tell me what I'm doing wrong here? Thanks!

Required A Required BRequired C Required D Required E Required FRequired G Benson borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount available. The company also pays its vendors on the last day of the month. It pays interest of 1 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $14,000 cash cushion. Prepare a cash budget. (Any repayments/shortage which should be indicated with a minus sign.) Show less Cash Budget October November Beginning cash balance Add: Cash receipts Cash available Less: Payments December S14,952 14,640 49,001 179,760 194,400 149.800 49,000 164,752 56,448 99,322 993113,7 For inventory purchases For selling and administrative expenses36,56038,632 Interest expense Purchase of store fixtures 2,2302,110 173,200 257,048 138,112 154,506 Total budgeted payments Payments minus receipts (208,048) 39,894 Surplus (shortage) Financing activity 26,640 223,0002,000 Borrowing (repayment) Ending cash balance (25,000) 14,894 $ 14,952 S 14,640