Please show all your work in excel.

Problem 1: Cash to Accrual: (20 Points) 327 Coffee Express maintains its records on the cash basis. You have been hired to convert its cash basis income statement to the accrual basis. The cash basis income statement, along with additional information, follows: 327 Coffee Express (sole proprietorship) Income Statement (Cash Basis) For the Year Ended December 31, 2020 $425,000 Cash receipts from customers Cash payments: Coffee Salaries and wages Insurance Net income $170,000 90,000 40,000 300,000 $125,000 Additional information: Accounts receivable Inventory - Coffee Salaries and Wages payable Prepaid insurance Accumulated depreciation Accounts payable - Coffee suppliers Balances at 12/31 2020 2019 $55,000 $30,000 50,000 40,000 19,000 24,000 8,000 9,000 95,000 80,000 9,000 3,000 No plant assets were sold during 2020. Required: Prepare a multi-step income statement using the accrual basis of accounting on the next page. You have space below, and at the top of the next page to make your calculations. Do not put your calculations in the body of the Income Statement