kk

Question 2 ( 2.5 points ) : Create macro and join it with a button to prepare Adjested trial balance But your button here ACCT.NO Account Name Trial Balance Adjustments Adjusted Trial Balance Debit Credit Debit Credit Debit Credit 1 Cash 2 12,540 Accounts Receivable Assets 1 20 3 12,360 4 Supplies 4,570 3,195 Liabilitys 21 40 Equipment 32,000 Owner Equity 41 60 21 Accumulated Depreciation - Equipment 14,000 61 2,000 Revenue BO 22 Accounts Payable 23 7,850 Expenses B1 100 Accrued Car operating expenses 1,450 41 845 5 K . Felder , Capital K . Felder, Drawing 57,230 61 24,700 Commissions Eamed 81 249,500 Sign Rental Expense 82 17,500 Telephone Expense 83 6,720 Wages Expense 84 102,450 Advertising Expense 950 B5 64,500 Car Operating Expense 1,450 86 27,870 Office Rental Expenses 845 87 18,000 Utilities Expense BB 5,370 385 328,580 328,580 89 Depreciation Expense - Equipment 90 Supplies Expense 2,000 24 Utilities Payable 3,195 25 Wages Payable 385 950 8,825 8,825K7 X Vfx A B C D E F G H Question 1 : ( 2.5 pints ) Asset Depreciation system Requirements: Create nested function ( IF Function + Depreciation functions DDB and SYD) Initial cost Salvage value Enter any data in Useful life (years) input section C Factor Insert DDB and SYD Annual Depreciation Amounts Under Various Methods functions here to Double Declining Sum of Years calculate the depreciation expenses Years Balance Digits for the years in first colmun 16 Asset Depreciation Worksheet +