1. Please check my answers for the trail balance worksheet. Below are instructions I followed.

Instructions to Complete Working Trial Balance:

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.

2. Prepare the Balance Sheet and calculate the ratios by filling in all the cells that are with "?" (Instructions are within the image, however I'll list it above the image again)

Instructions for the Balance Sheet :

A. Please prepare the Balance Sheets & Variance column for the comparative years by:

1. Typing the necessary account names from the Working Trial Balance.

2. Linking by formula the dollar amounts for the comparative years from the Working Trial Balance.

3. Creating the necessary formulas to foot and cross foot all columns ensuring the figures mathematically add up and reconcile.

B. Create formulas for each ratio listed below to properly compute the ratios:

Silver Tone Partners, Inc. Trial Balance Worksheet 1231/15 1231/16 123116 310,000 46,750 10.000 46.750 0000-Cash - Checking 12000-Accounts Receivable 3200-Inventory 15000-Furniture and Equipment 7000-Acumulated Depreciation 8000-Prepaid Rent 8700-Prepaid insurance 312,000 46,750 6,250 13,000 21,000 35,000 12,000 38,000 38,000 11,000 38,000 19,000 2,000 Accounts Payable 8,000 21000-Payroll Payable 23000-Aocrued Expenses 24000-Note Payable-Current 28000-Note Payable-Long Term 30100-Capital Stock 30200-Dividends Paid 2,000 88,000 12,000 88.000 88.000 210.000 378.750378 750 232.500 210,000 378,750 210,000 2000- Retained Eamings 7900-Sales 153.750 153,760 00-Cost of Goods Sold 2400-Depreciation Expense 3300-Insurance Expense 63400-Interest Expere 64300-Meals and Entertainment ,000 10,000 10,000 110,000 10,000 3,000 42,300 02,000 5600-Payrol Expenses 00-Professional Fees 66750-Rent Expense 8400-Travel Expense 43,300 Upon re of the 2016 financial recrds te bow ng nformation was determined by the Acoring Manager and he made the appropriate Adusing Jounal Entries in the accounting records: a dividend on 12/31/16 in the amount of $2,000, which had not yet been recorded Upon analyzing Rent Expense it was determined that the expense account was overstated by $1,000 and that amount should be reclassified to Upon reviewing the insurance policy it was deteemined that the proper balance at yearend Upon reviewing tre paynoll reports from Paychex it was determined that the amount $8.000 5 Upon reviewing the depreciation poicy, it was determined the depreciation expense to be $2.000 for the year