Instructions to Complete Working Trial Balance (Excel Project):

A. Using the proper rows and columns of the Working Trial Balance above, please: A(1). Prepare and post any necessary adjusting journal entries for each of the five (5) items listed above under Additional Information. A(2). Create the necessary formulas to mathematically foot (add numbers in a column) and cross foot (extend) all rows and columns. A(3). Prepare and post the Closing Entry for all temporary accounts. A(4). Prepare the formulas under the Post Closing Trial Balance columns and ensure the columns foot.

Additional Analysis & Questions:

B1, B2, C

?

Silver Tone Partners, Inc. 12/31/2016 12/31/2017 12/31/2017 12/31/2017 Credit redit ebit redit redit ebit redit 8 3 017000Accumulated Depreciation Insurance 42,500 2,000 7 28000Note Payable - Long Term 1,000 210,000 0 5 22 51000Cost of Goods Sold 0 $ 256,500 $ 256,500 $ 741,250 741,250 Working Trial Balance BS Comparatives IS 12-31-17 2017 Cash Flows 2017 Statement of RE Silver Tone Partners, Inc. 12/31/2016 12/31/2017 12/31/2017 12/31/2017 Credit redit ebit redit redit ebit redit 8 3 017000Accumulated Depreciation Insurance 42,500 2,000 7 28000Note Payable - Long Term 1,000 210,000 0 5 22 51000Cost of Goods Sold 0 $ 256,500 $ 256,500 $ 741,250 741,250 Working Trial Balance BS Comparatives IS 12-31-17 2017 Cash Flows 2017 Statement of RE