I need help filling out the correct adjustments
Assaf, Madinah AM utoSave @ off H U8A1_culmin_activity-2020[1] - Excel Search Share Home Insert Draw Page Layout Comm Formulas Data Review View Help Insert A" A" AY Arial - 10 de Wrap Text Number E Delete O IU Y Av E Merge & Center $ ~ % 9 100 Conditional Format as Cell deas Sensitivity Formatting v Table ~ Styles v Format Sort & Find & Filter ~ Select Cells :diting Ideas Sensitivity pboard Font Alignment Number Styles : * fx 1620 M Q R V W X Accounts Acc. Vo. Trial Balance DR CR Adjustments DR CF Income Statement CR Balance Sheet CR Bank 140,000.00 140,000.00 Accounts Receivable 68,000.00 68,000.00 Using the additional information below for Sandy Company, record the year-end Supplies 2,950.00 900.00 3 , 850.00 Prepaid Insurance 1,500.00 3.000.00 adjustments in the Adjustments column of the worksheet provided. Extend all amounts Equipment 18,000.00 to the Income Statement and the Balance Sheet column. Balance the worksheet. The Acc Depreciation/ Amortization 18.000.00 Equipment 1,800.00 1.620.00 3,420.00 year-end date is December 31, 2019. Accounts Payable 26,000.00 HST Payable 1,000.00 26.000.00 ,000.00 HST Recoverable Bank Loan 825.00 32.000.00 825.00 Additional Information: The fiscal period is one year. Mortgage 80,000.00 32,000.00 A. Lau, Capital 63.675.00 80.000.00 1. Supplies on hand at Dec. 31 are valued at $900 Lau, Drawings 8.600.00 255,000.00 8.600.00 63,675.00 Advertising Expense 15,000.00 847.50 15,847.50 255,000.00 2. Equipment depreciation or amortization is 10%, using the declining-balance method. Office Expenses 3,000.00 3.000.00 repair Expenses nterest Expenses 9,600.00 3. Late arriving invoice on Jan 4" for Advertising bought on Dec. 14th of $750.00 +HST Office Salaries Expense 72,000.00 600- 72,000.00 owed. Store Salaries Expense 16,000.00 59,475.00 459,475.00 16,000.00 20.447.50 255,000.00 $4.552.50 200.275.00 248,095.0 4. Insurance policy worth $1500 was purchased May 1, 2019. When you have completed the worksheet click the tab at the bottom to go to the Income Statement template. Instructions Worksheet Income Statment Balance Sheet Ready Circular References: D29 + Type here to search W I ENG 8:53 AM 2020-07-27 F2 DII F3 F4 F6 PrtSon F8 Home End F10 PgUp F11 Pgon % 6