Here is a three step excel problem.

B F 1 1. Prepare Robin Sporting Goods Company's single-step income statement for the year ended July 31, 2018. (Always use cell references and formulas where appropriate to receive full credit. If 2 you copy/paste from the Instructions tab you will be marked wrong.) 3 Robin Sporting Goods Company Income Statement 6 Year ended July 31, 2018 Sin Thousands 8 4 5 7 9 10 11 12 13 2. Prepare Robin Sporting Goods Company's statement of retained earnings for the year ended July 31, 2018. (Always use cell references and formulas where appropriate to receive full credit. If 14 you copy/paste from the Instructions tab you will be marked wrong.) + 15 16 17 18 $ in Thousands 19 20 21 22 23 A B C D 23 24 3. Prepare Robin Sporting Goods Company's classified balance sheet at July 31, 2018. (Always use cell references and formulas where appropriate to receive full credit. If you 25 copy/paste from the Instructions tab you will be marked wrong.) 26 27 28 29 30 $ in Thousands 31 Assets 32 Current Assets: 33 34 35 36 37 38 Total current assets + 39 40 Total assets 41 Liabilities 42 43 44 Total liabilities 45 Stockholders' Equity 46 47 48 Total stockholders' equity 49 Total liabilities and stockholders' equity 50 51 52 Paste Il copy Fomiat Punter BV. Do Es Merge Center $ % 9 *38-58 Conditionat formats Formatting Table About Font Clipboard A1 f Accrual Accounting and Income B C D E G Accrual Accounting and Income 2 Construct the financial statements 3 4 Suppose Robin Sporting Goods Company reported the following data at July 31, 2018, with amounts in thousands: 5 Retained earnings, July 31,2017 $ 31,500 Cost of goods sold $ 136,800 2 Accounts receivable 34,000 Cash 50,000 B Net revenues 191,000 Property and equipment, net 19,400 9 Total current liabilities 80,000 Common stock 26,000 10 All other expenses 29,000 Inventories 36,000 11 Other current assets 5,000 Long-term liabilities 11,700 12 Other assets 30,000 Dividends 0 6