Text box options on the left side (under assets) are: accounts payable, accounts receivable, cash, common stock, dividends, insurance expense, prepaid insurance, pre-paid rent, rent expense, retained earnings, salaries expense, salaries payable, utilities expense.

Format it the way it's displayed in the images - Please insure the formatting isn't confusing in the final post - some tables are incorrectly made and hard to understand where the numbers are supposed to be placed, please show me where the numbers are coming from and how you came to the solution. If possible, replicate these tables in excel and format it the same way as shown in the photos.

During Year 1 , Chung Corporation earned $6,700 of cash revenue and accrued $3,200 of salaries expense. Required Based on this information alone: a. Prepare the December 31 , Year 1 , balance sheet. b. Determine the amount of net income that Chung would report on the Year 1 income statement. c. Determine the amount of net cash flow from operating activities that Chung would report on the Year 1 statement of cash flows. Complete this question by entering your answers in the tabs below. Based on this information alone: (Not all cells require input. Enter any decreases to account balances with a minus sign.) During Year 1 , Chung Corporation earned $6,700 of cash revenue and accrued $3,200 of salaries expense. Required Based on this information alone: a. Prepare the December 31, Year 1, balance sheet. b. Determine the amount of net income that Chung would report on the Year 1 income statement. c. Determine the amount of net cash flow from operating activities that Chung would report on the Year 1 statement of cash flows. Complete this question by entering your answers in the tabs below. Prepare the December 31, Year 1, balance sheet. Determine the amount of net income that Chung would report on the Year 1 income statement. Determine the amount of cash flow from operating activities that Chung would report on the Year 1 statement of cash flows