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 \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