10. Prepare an adiusted trial balance: on the worksheet: enter the adjusted trial balance using formulas to combine the trial balance and adjusting entry amounts. 11. Finish the worksheet: extend the account balances from the adjusted trial balance columns to the income statement or balance sheet columns using cell references. 12. Prepare a detailed multiple step income statement for the year ended Dec. 31: 2017 in good form on the income statement worksheet. DO NOT ENTER DOLLAR AMOUNTS MANUALLY, reference the "Worksheet". 13. Prepare the statement of retained earnings for 2017 in good form on the Retained Earning worksheet. DO NOT ENTER DOLLAR AMOUNTS MANUALLY. Reference cells in the Worksheet. 14. Prepare the December 31. 2017 balance sheet in good form on the Balance Sheet worksheet. DO NOT ENTER DOLLAR AMOUNTS MANUALLY. Reference cells in the worksheet 15. Prepare the Cash Flow Statement for 2017 in good form on the CFS worksheet. To prepare a cash flow statement use the indirect method for Cash Flows from Operations section. For cash flours from financing and investing activities: carefully review all transactions a) - p) and note any cash inflows or outflows relating to financing or investing activities (those involving non-current assets and non-current liabilities). Make sure to reference differences m current assets and current liabilities: do not enter amounts manually. Reference investing and financing activities' amounts from the general journal or "Cash" general ledger. 16. Prepare and post closing entries: journalize the closing entries in the GJ worksheet and post them to the GL worksheet. Update account balances in the GL. Reference closing entries in General Ledger as c], c2, etc. 17 _ post clQsing trial balance: prepare a post-closing trial balance on the last worksheet by referencing ending account balances in the GL worksheet Do not leave accounts with zero balances in the post-closing trial balance