Need excel formulas for the yellow cells. please Thank you.

Need excel formulas for the yellow cells. please Thank you.

. c.- 4. ; cash Budget with Supporting Cash Collections and Disbursements Schedules-Excel ? -e FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri Paste Blu- .2.A. Alignment Num ber Conditional Format as Cell Cells Editing Formatting Table Styles Clipboard Font A1 VXfS&P Enterprises needs a cash budget for March. The following information is 1 S& P Enterprises needs a cash budget for March. The following information is available 3 Data 4 Actual January and February and expected March sales 5 Cash sales 6 Sales on account 7 Total Sales Januar Februar March 1,600 3,750 5,100 25,000 30,000 40,000 9 Accounts Receivable Collections: 10 Month of sale 11Month following sale 12 Second month following sale 13 Uncollectible 14 15 Accounts payable for inventory purchases, March 1 balance 16 Budgeted inventory purchases in March 17 Inventory payments 18 Month of purchase 19 Month following purchase 20 21 Total budgeted selling & administrative expenses in March 22 Budgeted selling & administrative depreciation in March 23 15% 60% 22% 3% $10,500 $23,500 60% 40% $12,500 $3,200 Budget Dta Schedules and Cash Budget .. READY 100% 1 Expected cash collections 2 March cash collections 3 March collections on account: 4January sales 5 February sales 6 March sales 7 Total cash collections 9 Payments to suppliers 10 Accounts payable for inventory purchases, beginning balance 11 March purchases 12 Total cash payments 13 14 15 16 17 18 Cash balance, March 1 19 Add cash receipts 20 Collections from customers 21 Total cash available before current financing 22 Less disbursements: 23 Payments to suppliers 24 S& P Enterprises Cash Budget For the Month of March >... Budget Data Schedules and Cash Budget...+ 24 Selling and administrative expenses 25 Equipment purchases 26 Dividends paid 27 Total disbursements 28 Excess (deficiency) of cash available over disbursements 29 Financing: 30 Borrowings 31Repayments 32 Interest 33 Total financing 34 Cash balance, March 31 35 36