Please answer the following question in excel, please show works.

P1-2 Accrual income versus cash flow for a period Thomas Book Sales, Inc., supplies textbooks to college and university bookstores. The books are shipped with a proviso that they must be paid for within 30 days but can be returned for a full refund credit within 90 days. In 2018, Thomas shipped and billed book titles total- ing $760,000. Collections, net of return credits, during the year totaled $690,000. The company spent $300,000 acquiring the books it shipped. a. Using accrual accounting and the preceding values, show the firm's net profit for the past year. b. Using cash accounting and the preceding values, show the firm's net cash flow for the past year. c. Which of these statements is more useful to the financial manager? Why