Please follow the instructions in an Excel spreadsheet. I will thumbs up the answer, thanks.

MGMT FFAC Chapter 2: Exercise These items are taken from the accounting records of Entity A for 2020. Accounts payable Accounts receivable Accumulated depreciation equipment Advertising expense Cash Common stock Copyright Depreciation expense Dividends Equipment Ford Motor Co. stock (long-term investment) Insurance expense Notes payable (due 2028) Prepaid insurance Rent expense Retained eamings (beginning) Salaries and wages expense Salaries and wages payable Service revenue Supplies Supplies expense $ 10,000 11,000 38,000 21,000 4,000 90,000 4,000 12,000 15,000 210,000 6,000 3,000 70,000 6,000 17,000 12,000 34,000 3,000 130,000 4,000 6,000 Instructions In good form (include headings), prepare an income statement, a retained camings statement, and a classified balance sheet as of December 31, 2020. Then compute the current ratio and the debt-to-total-assets ratios identifying which is a measure of liquidity and which is a measure of solvency