S & P Enterprises needs a cash budget for March, the following information is available:

DATA January Feb March

Actual jan/feb + exp. Mar sales

Cash Sales $1,600. $3,750. $5,100

Sales on account 25,000 30,000. 40,000

Total Sales $26,600 $33,750 $45,100

Accounts receivable collection

Month of sale: 15%

month of following sale: 60%

second month following sale: 22%

uncollectible: 3%

Acct payable for inventory purchases Mar 1 balance: $10,500

Budgeted inventory purchases in march: $23,500

inventory payments

month of purchase: 60%

month following purchase: 40%

total budgeted selling & admin expenses in march: $12,500

budgeted selling & admin depreciation in march: $3,200

Other budgeted cash disbursements in march

equipment purchases: $14,000

dividends to be paid: $2,000

minimum cash balance to be maintained: $10,000

march 1 cash balance: $11,500

march 1 outstanding borrowings: $0

march 1 interest due: 0$

the company has a line of credit available to bolster the cash balance as needed

Can you use this example problem to show me how to finish a different one in excel? I need to know how to prepare "cash budgets" following 1. schedule of expected cash collections for march 2. schedule of expected cash disbursements for inventory purchases for march. 3. Cash budget for march that indicated the financing section list any borrowing that will be needed in march assuming interest is not paid until following month.

please specify what formulas i need for excel so I know what I'm doing. I will give you the best rating for best accuracy please!!

A B C D E Expected cash collections: March cash collections March collections on account: January sales February sales March sales Total cash collections Payments to suppliers: Accounts payable for inventory purchases, beginning balance March purchases Total cash payments S & P Enterprises Cash Budget For the Month of March Cash balance, March 1 Add cash receipts: Collections from customers Total cash available Less disbursements: Payments to suppliers Selling and administrative expenses ... Budget Data Schedules and Cash Budget + 4Clipboard Font Styles A1 X V Expected cash collections: A B C D E 3 Payments to suppliers 4 Selling and administrative expenses Equipment purchases .6 Dividends paid Total disbursements 8 Preliminary cash balance Financing: 0 Additional loan Loan repayments 2 Interest 3 Total financing 4 Cash balance, March 31 5 36 8 39 3