Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please put in an excel template if possible. Thank you. begin{tabular}{|c|c|c|c|c|} hline multicolumn{5}{|c|}{ Walton Anvils } hline multicolumn{5}{|c|}{ Unadjusted Trial Balance } hline

please put in an excel template if possible. Thank you. image text in transcribed
image text in transcribed
image text in transcribed
\begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Walton Anvils } \\ \hline \multicolumn{5}{|c|}{ Unadjusted Trial Balance } \\ \hline \multicolumn{5}{|c|}{ December 31, 2016} \\ \hline \multirow[b]{2}{*}{ Account Title } & \multicolumn{4}{|c|}{ Balance } \\ \hline & & Debt & & Credit \\ \hline Cash & $ & 16,900.00 & & \\ \hline Accounts Receivable & & 17,500 & & \\ \hline Prepaid Rent & & 2,500 & & \\ \hline Office Supplies & & 1,900 & & \\ \hline Equipment & & 23,000 & & \\ \hline Accumulated Depreciation - Equipment & & & $ & 7,000.00 \\ \hline Accounts Payable & & & & 6,200.00 \\ \hline \multicolumn{5}{|l|}{ Salaries Payable } \\ \hline Unearned Revenue & & & & 5,600.00 \\ \hline Common Stock & & & & 28,000.00 \\ \hline Retained Earnings & & & & 1,600.00 \\ \hline \begin{tabular}{|l} Dividends \\ \end{tabular} & & 4,500 & & \\ \hline Service Revenue & & + & & 20,800.00 \\ \hline Salaries Expense & & 2,900 & & \\ \hline \multicolumn{5}{|l|}{ Rent Expense } \\ \hline \multicolumn{5}{|l|}{ Depreciation Expense - Equipment } \\ \hline \multicolumn{5}{|l|}{ Supplies Expense } \\ \hline Total & $ & 69,200.00 & & 69,200.00 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline a. Unearned revenue still unearned at December 31, 2016 & $1,800 \\ \hline b. Prepaid rent still in force at December 31, 2016 & $2,300 \\ \hline c. Office supplies used & $1,400 \\ \hline d. Depreciation & $380 \\ \hline e. Accrued Salaries Expense at December 31, 2016 & $210 \\ \hline \end{tabular} 1. Open T-accounts using the balances in the unadjusted trial balance. 2. Complete the worksheet for the year ended December 31, 2016. 3. Prepare the adjusting entries and post to the T-accounts. 4. Prepare the adjusted trial balance. 5. Prepare the income statement, the statement of retained earnings, and the classified balance sheet in report form. 6. Prepare the closing entries and post to the T-accounts. 7. Prepare a post-closing trial balance. 8. Calculate the current ratio for the company

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Auditing

Authors: Graham Cosserat

2nd Edition

0470863226, 978-0470863220

More Books

Students also viewed these Accounting questions