Please show and solve how this problem will show on an Excel worksheet. Thanks

Marsha will have to borrow 750000 Ending cash balance = Beginning cash balance + Receipts - Disbursements It is given that beginning cash balance is 500000, cash receipts are 2000000 and disbursements are 2500000. Marsha wants to have 10% of next years sales as ending cash balance. As next year's sales are 7500000, 10% of same is 750000. Using the given data, if Marsha doesnt borrow we have the below Ending cash balance = 500000+2000000-2500000 = 0