Problem solving – Skilled Papers

COMPLETE the accounting cycle from adjusting entries to post-closing trial balance. Below is the unadjusted trial balance for Walton Anvils as of December 31, 2016, and the data for the adjustments. There is also an Excel Template for this problem that you may download and use (or you may use your own).
Below are the attached
1. template with given entries
2. Requirements to complete
Open T-accounts using the balances in the unadjusted trial balance.
Complete the worksheet for the year ended December 31, 2016.
Prepare the adjusting entries and post to the T-accounts.
Prepare the adjusted trial balance.
Prepare the income statement, the statement of retained earnings, and the classified balance sheet in report form.
Prepare the closing entries and post to the T-accounts.
Prepare a post-closing trial balance.
Calculate the current ratio for the company.