Everything is correct so far, couldnt figure out Surplus/Shortage and below.

Ending Cash Balance is $21,488

Cash Budget For the Quarter Ended March 31 January Febuary 17,000 0 234,000 320,000 251,000 320,000 March Total 0 17,000 337,000 891,000 337,000 908,000 168,363 179,726 101,000 111,000 7,500 26,000 295,363 298,226 180,634 110,000 1,500 5 Begging Cash Balance 16 Add Cash Recipts 7 Cash Avaiable 8 Less Payments 9 For Inventory Purchases 10 For Operating Exoenses 11 For Land Purchase 12 For Dividens 13 Total Budgeted Payments 14 Surplus/(Shortage) 15 Financing Activity 16 Borrowing 17 Intrest Expense 18 Repayment 19 Ending Cash Balance 20 21 22 23 24 25 528,723 322,000 9,000 26,000 885,723 292,134 0 0 0 0 Data Sales Purchases Operating Cash GS e. The company must maintain a minimum cash balance of $5,000. An open line of credit is available at a local bank for any borrowing that may be needed during the quarter. Borrowing and repayments are in multiples of $1,000 to ensure that you have a balance of at least $5,000. Interest is 1% per month and is paid each month based on the previous month's balance. Create a tab titled "Cash" that looks like the image at the top of the next page and make sure to follow the rules on the Microsoft Excel checklist. There are a few tricky cells here and the video will help you understand how to complete the formulas