Please do in excel and show calculations. Please do all parts but I really need part C.

Thanks in advance!

On August 12, 2020, Espresso Inc. sells merchandise worth $20,000 (gross sales price) to Crescendo Inc., terms 4/10, n/30. Espresso grants cash discounts on amounts paid within the discount period. Espresso estimates unre- corded returns at the end of the reporting period. Required a. Prepare Espresso's journal entries (ignoring cost of goods sold) for the following transactions under the gross method. Aug. 12 Sales of $20,000 of merchandise to Crescendo. 17 Returns and allowances of $3,000 (gross) are granted Crescendo. 19 Espresso collects $11,520 cash from Crescendo on its account. 24 Returns and allowances of $2,400 (gross) are granted Crescendo on items not yet paid for. 27 Remainder of the Crescendo account is collected in full. Sep. 12 Returns and allowances of $1,000 cash (gross) are granted Crescendo on merchandise paid for on August 19. 14 Returns and allowances of $1,000 cash (gross) are granted Crescendo on merchandise paid for on August 27. b. Prepare Espressos journal entries (ignoring cost of goods sold) for these transactions under the net method. C. Prepare a table showing the effect on Espressos net income from sales, sales returns and allowances, and sales discounts under both the gross method and net method (ignoring cost of goods sold). Compute the net cash flow of these events and compare it to the net income effect. On August 12, 2020, Espresso Inc. sells merchandise worth $20,000 (gross sales price) to Crescendo Inc., terms 4/10, n/30. Espresso grants cash discounts on amounts paid within the discount period. Espresso estimates unre- corded returns at the end of the reporting period. Required a. Prepare Espresso's journal entries (ignoring cost of goods sold) for the following transactions under the gross method. Aug. 12 Sales of $20,000 of merchandise to Crescendo. 17 Returns and allowances of $3,000 (gross) are granted Crescendo. 19 Espresso collects $11,520 cash from Crescendo on its account. 24 Returns and allowances of $2,400 (gross) are granted Crescendo on items not yet paid for. 27 Remainder of the Crescendo account is collected in full. Sep. 12 Returns and allowances of $1,000 cash (gross) are granted Crescendo on merchandise paid for on August 19. 14 Returns and allowances of $1,000 cash (gross) are granted Crescendo on merchandise paid for on August 27. b. Prepare Espressos journal entries (ignoring cost of goods sold) for these transactions under the net method. C. Prepare a table showing the effect on Espressos net income from sales, sales returns and allowances, and sales discounts under both the gross method and net method (ignoring cost of goods sold). Compute the net cash flow of these events and compare it to the net income effect