Please submit your solution to problem in an excel file thorugh blackboard.

Review - Financial Statements Listed below are amounts taken directly from Holmes Company's financial statements prepared on December 31,2019, their second year of operation: Accounts payable Accounts receivable Accumulated depreciation-building Accumulated depreciation-equipment Advertising expense Allowance for doubtful accounts Building Cash Delivery expense Depreciation expense-Display equipment Depreciation expense-office equipment Equipment Franchise Freight-in Insurance expense Land Legal expense Merchandise inventory, January 1 Merchandise inventory, December 31 Notes Receivable Office salaries expense Patents Prepaid insurance Purchases Purchase returns and allowances $3,200 1,800 8,000 2,000 600 200 20,000 2,200 600 1,200 300 6,000 3,000 200 100 12,000 700 3,700 5,100 200 1,300 3,000 500 15,700 1,000 \begin{tabular}{|l|r|r|} \hline Office salaries expense & 1,300 \\ \hline Patents & 3,000 \\ \hline Prepaid insurance & 500 \\ \hline Purchases & 15,700 \\ \hline Purchase returns and allowances & 1,000 \\ \hline Purchase discounts & 100 \\ \hline Retained earnings & 6,000 \\ \hline Salaries payable & 400 \\ \hline Sales & 24,000 \\ \hline Sales discounts & 400 \\ \hline Sales returns and allowances & 200 \\ \hline Sales salaries expense & 3,700 \\ \hline Share capital, ordinary & ?? \\ \hline Share premium, ordinary & 5,000 \\ \hline Store rent expense & 1,200 \\ \hline Store supplies expense & 500 \\ \hline Supplies & 300 \\ \hline Required: & \\ \hline From the above information, you are required to prepare: & \\ \hline 1. Trial balance & \\ \hline 2. & & \\ \hline 3. & & \\ \hline S. Statement of shareholders' equity & & \\ \hline 5. Statement of financial position & & \\ \hline \end{tabular}