PLEASE SOLVE IT ON EXCEL SHOWING THE fx steps

other payment is 2000 , 20000 , 25000, 21000, 21000 , 28000

Mual to Exercise (2): The following information relate to the cash budget re (4-64): Jordan Company during the last six months of 2016, an shown in Student Name Studeat ID EX2 Sloatk 90009 Jordia Company Casb Budget for the last Sir Sonths of 2016 Begleniny Balance Receipts from ComePaynidos de 1e Samplers One Pay Leding katawa 40000 722 2011 7 273 130000 172 2207 ?? 127 100000 1:7 2 72? 95000 727 2100 12 722 105000 177 2177 222 170000 777 22399 VEE (Figure 4-64) Required: 1. Create a new worksheet Chapter4 EX2, and enter the previous data in it. 2. Insert necessary equations in the related cells to calculate cash balance at the beginning of the month, payments. to the suppliers (40% of the receipts from customers), and cash balance at the end of each month for the six months. -----th-thar Scanned with CamScanner