. Compute the ending balances using formulas and cell references. Insert rows as needed. For full points use IF statements to compute the Adjusted Trial. Should be and IF function in the adjusted trial balance that takes fixed amounts and either adds or subtracts the adjusted to unadjusted.

18 xv fx B C D E F G H I 1 2 Zarle Company Worksheet Analysis to Adjust Financial Statements for Year 2020 3 4 JE# 5 6 Adjusted Trial Balance Dr. 7 Cr. Cr. Adjustments Dr. Cr. 5,000.00 $ 5,000.00 $ 3 $ $ 3 Trial Balance - Unadjusted Dr. 119,779.00 20,600.00 $ 3,000.00 8,500.00 34,000.00 10.00 24,300.00 $ 1.00 $ $ $ $ 9 $ 6,000.00 6 $ 2,000.00 $ $ 112,000.00 8 Cash 9 Accounts Receivable 10 Allowance for Doubtful Accounts 11 Notes Receivable 12 Inventory 13 Prepaid Insurance 14 Investments - Trading 15 Fair Value Adjustment 16 17 PPE 18 Accumulated Depreciation-PPE 19 Intangibles - Trademark 20 21 Accounts Payable 22 Salaries & Wages Payable 23 Lawsuit Liability 24 Notes Payable 25 Capital Stock 26 Retained Earnings 27 28 Current Net Income $ 4,8 83,500.00 1,4,8 10 $ 40,000.00 $ 21,300.00 $ 25,000.00 $ 8,200.00 $ 10,000.00 $ 50,000.00 3,800.00 $ 125,000.00 $ $ $ $ $ $ 14,500.00 16,000.00 $ 1.00 5 10,000.00 83,500.00 54,000.00 2,9,10 $ 5,000.00 $ 29,000.00