Using Worksheets to Create Adjusting Entries and Financial Statements Part 1: Barnes Wallis Enterprises A Senior Manager at Barnes Wallis Enterprises has just emailed you the following Trial Balance: Bames Wallace Enterprises Unadjusted Trial Balance Dec. 31st 2021 Debit Credit Cash $ 1,160,000 Accounts Receivable Inventory 150,000 300,000 Office Supplies 60,000 Prepaid Rent 75,000 Equipment 800,000 Accumulated Depreciation Accounts Payble Wages Payable $ 200,000 100,000 Interest Payable Income Tax Payable Unearned (Deferred) Revenue 250,000 Long-Term Debt 500,000 Common Stock 1,000,000 Retained Earnings 250,000 545,000 Sales Revenue Office Supplies Expense Wages Expense Depreciation Expense 300,000 Interest Expense Rent Expense Income Tax Expense $ 2,845,000 $ 2,845,000 This manager has just returned from a meeting with the finance department. He has also provided you with the following notes from this meeting: 1. Office supplies were counted and it was determined that $20,000 were on-hand. 2. On January 1st 2021 $75,000 was paid in advance on a three year rent contract - ending Dec. 31st of 2023 3. Depreciation on equipment is taken annually at a rate of 30%. 4. The sales manager has confirmed that 50% of deferred revenues were earned during the year. 5. Long-Term Debts are owed to Local Bank Inc.. Interest is paid annually (Jan. 1st) based on a 12% per year interest rate. 6. It was determined that the company owes $60,000 in wages. Payment is to be made in January of next year. 7. Income Tax is expected to be 20% of Net Income. This is expected to be paid on Jan. 30th of next year. In his email the Senior Manager has asked you to complete the following: 1. Provide all relevant adjusting entries for the period just ended. 2. Create an income statement, balance sheet, and statement of retained earnings which will be proposed to the Board of Directors at their next meeting. 3. You have also been asked to provide the following financial ratios: a. Net After-Tax Profit Margin b. Current Ratio c. Quick Ratio (also referred to as the Acid Test) d. Debt-to-Equity Ratio e. Return on Equity Barnes Wallace Enterprises Unadjusted Trial Balance Adjusted Trial Balance Dec. 31st 2021 Adjustments Dec. 31st 2021 Income Statement Balance Sheet Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Cash Accounts Receivable Inventory Office Supplies Prepaid Rent Equipment Accumulated Depreciation Accounts Payble Wages Payable Interest Payable Income Tax Payable Unearned (Deferred) Revenue Long-Term Debt Common Stock Retained Earnings Sales Revenue Office Supplies Expense Wages Expense Depreciation Expense Interest Expense Rent Expense Income Tax Expense Total Balance Sheet as at Dec. 31st Assets Current Assets Cash Acct. Receivable Inventory Office Supplies Prepaid Rent Total Current Assets Long-Term Assets Equipment Less: Accum. Deprec. Total Long-Term Assets Total Assets Current Liabilities Acct. Payable Wages Payble Interest Payable Income Taxes Payable Unearned (Deferred) Revenue Total Current Liab. Long-Term Debts Total Liabilities Shareholder's Equity Common Stock Retained Earnings Total Shareholder's Equity Total Liab. & Shareholder's Equity Income Statement for the period ending Dec. 31st Net After-Tax Income Sales Revenue Less: Office Supplies Expense Wages Expense Depreciation Expense Interest Expense Rent Expense Total Expenses Before Tax Net Income Income Tax Expense After- Tax Net Income Total Assets Income Statement for the period ending Dec. 31st Sales Revenue Less: Office Supplies Expense Wages Expense Depreciation Expense Interest Expense Rent Expense Total Expenses Before Tax Net Income Income Tax Expense After- Tax Net Income Statement of Retained Earnings as at Dec. 31st Opening Retained Earnings Add: Net After-Tax Income Less: Dividends Closing Retained Earnings Total Liab. & Shareholder's Equity