Please show your calculations so I am able to learn the concept. Thank you

38 Problem 17-3A (Algo) Transactions, working capital, and liquidity ratios LO P3 5 points Plum Corporation began the month of May with $1,500,000 of current assets, a current ratio of 2.40:1, and an acid-test ratio of 1701 During the month, it completed the following transactions (the company uses a perpetual inventory system) May 2 Purchased $70,000 of merchandise inventory on credit. May 8 Sold merchandise inventory that cost $60,000 for $120,000 cash. May 10 Collected $21,000 cash on an account receivable May 15 Paid $25,500 cash to settle an account payable. May 17 wrote off a $5,000 bad debt against the Allowance for Doubtful Accounts account. May 22 Declared a $1 per share cash dividend on its 60,000 shares of outstanding common stock. May 26 Paid the dividend declared on May 22. May 27 Borrowed 5115,000 cash by giving the bank a 30-day, 109 note. May 28 Borrowed 5145,000 cash by signing a long-term secured note. May 29 Used the $260,000 cash proceeds from the notes to buy new machinery. Required: Complete the table below showing Plum's (1) current ratio, (2) acid-test ratio, and (3) working capital after each transaction. (Do not round Intermediate calculations. Round your ratios to 2 decimal places and the working capitals to nearest dollar amount. Amounts to be deducted should be indicated with a minus sign) Current Assets $ 1.500.000 70,000 (Quick Assets $1.002.500 Answer is not complete. Current Current (Acid-Toat Liabili Ratio Ratio 5 625,000 2.40 1.70 70,000 Working 875.000 605.000 1.570.000 (00.000) 120,000 120,000 Transaction Beginning May 2 May 2 Balance after May 2 May May Balance after May May 10 May 10 Balance after May 10 May 15 May 15 Balance May 15 May 17 May 17 Balance for May 17 May 22 21.000 (21,000) 21,000 00 Amounts to be deducted should be indicated with a minus sign.) Transaction Current Assets $ 1,500,000 70,000 Quick Assets $ 1,062,500 Answer is not complete. Current Current Acid-Test Liabilities Ratio Ratio S 625.000 2.40 1.70 70,000 Working Capital $ 875,000 695,000 1,570,000 (60,000) 120,000 120,000 21,000 (21,000) 21.000 Beginning May 2 May 2 Balance after May 2 May 8 May 8 Balance after May 8 May 10 May 10 Balance after May 10 May 15 May 15 Balance after May 15 May 17 May 17 Balance after May 17 May 22 May 22 Balance after May 22 May 26 May 26 Balance after May 26 May 27 May 27 Balance after May 27 May 28 May 28 Balance after May 28 May 29 May 29 Balance after May 29