I do have excel file with more details

Instructions and Natesfar Each of the Files SLIA 9'\" Workbook F10.xlsm Opening the workbook The workbook contains macros. You must allow macros to operate to use the workbook. When you open the workbook, if you are asked if you want to enable macros select yes. Opening the workbook for the rst time When you open the workbook for the rst time enteryour name at the {gulf the title page. How to use this workbook You use this workbook in place of the SUA journals, Ledgers, and selected documents (Refer to the title page for a cross reference of forms and documents replaced by this workbook]. To use this workbook, follow all instructions and requirements in the instruction booklet except: 1 Substitute forms in this workbook for forms referenced in the instructions if they are listed on the title page. 2 Prepare the AIR aged trial balance described in step 6 of the yearend procedures using the schedule at the end of this workbook. a Financial statement templates have been prepared for you. Just fill in the numbers 4 Fill out the cashflow worksheet [see instructions below] Title Page You can jump to any schedule in the workbook from the title page. To Jump to a schedule, click on the link to that schedule in the table of contents. To return to the title page from any schedule press the shortcut key [Ctrl][h] for Windows users, [5h ift] [Command] [h] for MAC users. Entering data into the schedules The worksheets are protected. You can only enter data into the yellow cells on each schedule. Collapsing and expanding ledgers The ledgers have been grouped by Account or Name. To expand the Account or Name click on the + in the left margin. To collapse an account, click on the in the left margin. lfyou want to expand all accounts, click on the [2] at the top of the left margin. To collapse all, click on the [1] at the top of the left margin. SUA 91h FZBJKIS The worksheet has been prepared as a spreadsheet template to speed your completion of this project. The only columns you need to fill in are the UNADJUSTED TRIAL BALANCE columns and the ADJUSTMENTS columns, the remaining columns and the nancial statements Imill automatically be calculated. Instructions for making the federal income tax accrual A.IE: .- To find the proper federal income tax accrual: .- Fillingin allother AJE's. .- Looking at the difference between the debit and credit INCOME STATEMENT columns. This number is pretax income. .- Applying the appropriate ta): rates to the pretax income and make your nal federal income tax AJE in the ADJUSTMENTS columns. The spreadsheet will recalculate and the difference between the debit and credit INCOME STATEMENT columns is now the final aftertax income. SUA 9th All AP FA Templates Fzmlsx This file contains the templates for the accounts receivable, accounts payables, and fixed assets trial balance sheets. WAREN SPORTS SUPPLY, YEAR-END WORKSHEET, DECEMBER 31, 2017 TRANSACTIONS LIST A Student Name (Accounts with no activity in this worksheet are excluded in this solution.) Instructor_ Date Due_ ACCT 12/31/16 ACCOUNT 12/31/17 NO. POST CLOSING TRIAL BALANCE YEAR-END ADJUSTMENTS BALANCE TRIAL BALANCE UNADJUSTED ADJUSTED TRIAL BALANCE INCOME TITLE STATEMENT SHEET DEBIT CREDIT DEBIT CREDIT ID # DEBIT ID # CREDIT DEBIT CREDIT DEBIT CREDIT ASSETS DEBIT CREDIT 10100 Cash 10200 Accounts receivable 11,025.19 10300 0.00 Allowance for doubtful account 1,065.00 0.00 0.00 10400 Inventory 3,250.81 0.00 0.00 10600 Marketable securities 01,681.00 0.00 0.00 10800 Fixed assets 10900 320,665.00 0.00 0.00 Accumulated depreciation 0.00 81,559.50 0.00 0.00 0.00 20100 LIABILITIES 0.00 Accounts payable 20300 Federal income taxes withheld 11,279.35 20400 State unemployment taxes payable 1,326.76 0.00 0.00 0.00 20500 Federal unemployment taxes payable 81.17 0.00 0.00 20600 I.C.A. taxes payable 83.31 20/00 1,593.30 0.00 0.00 Federal incomes taxes payable 0.00 20900 nterest payable 29,797.00 0.00 0.00 0.00 21000 Notes payable 0.00 0.00 0.00 0.00 STOCKHOLDERS' EQUITY 0.00 26000 Common stock 29000 Retained earnings 225,000.00 90,264.99 0.00 0.00 0.00 REVENUE AND GROSS PROFIT 0.00 30100 Sales 30200 Sales retums and allowances 0.00 30300 0.00 Sales discounts taken 0.00 30400 Cost of goods sold 0.00 0.00 0.00 30500 0.00 30600 Purchases 0.00 0.00 30700 Purchases retums and allowances 0.00 Purchases discounts taken 0.00 30800 Freight-in 0.00 0.00 0.00 31200 Miscellaneous revenue 0.00 0.00 0.00 0.00 EXPENSES 40100 Rent expense 40200 Advertising expense 0.00 40300 0.00 Office supplies expense 0.00 40400 0.00 Depreciation expense 0.00 40500 0.00 0.00 Wages and salaries expense 40600 0.00 Payroll tax expense 0.00 40700 0.00 Federal income tax expense 0.00 40800 0.00 Interest expense 0.00 40900 0.00 Bad debt expense 0.00 41000 0.00 Other operating expense 0.00 0.00 0.00 Sub-totals 0.00 Net Income (Loss) 0.00 0.00 TOTALS 0.00 444,436.19 444,436.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00WAREN SPORTS SUPPLY BALANCE SHEET AT DECEMBER 31, 2017 AND 2016 ASSETS 2017 ENT ASSETS Cash $0.00 $11 Accounts receivable - net 0.00 Inventory 0.00 101 Marketable securities 0.00 Total current assets 0.00 120 ASSETS - Net of mulated depreciation 0.00 239 Total assets $0.00 $359 LIABILITIES AND STOCKHOLDERS' EQUITY ENT LIABILITIES Accounts payable $0.00 $11 Payroll taxes withheld and payable 0.00WAREN SPORTS SUPPLY BALANCE SHEET AT DECEMBER 31, 2017 AND 2016 ASSETS 2017 2016 RENT ASSETS Cash $0.00 $11,025.19 Accounts receivable - net 0.00 7,814.19 Inventory 0.00 101,681.00 Marketable securities 0.00 0.00 Total current assets 0.00 120,520.38 D ASSETS - Net of cumulated depreciation 0.00 239, 105.50 Total assets $0.00 $359,625.88 LIABILITIES AND STOCKHOLDERS' EQUITY RENT LIABILITIES Accounts payable $0.00 $11,279.35 Payroll taxes withheld and payable 0.00 3,284.54 Federal income taxes payable 0.00 29,797.00 Interest payable 0.00 0.00 Total current liabilities 0.00 44,360.89 E PAYABLE 0.00 0.00 Total liabilities 0.00 44,360.89 CKHOLDERS' EQUITY Common stock 0.00 225,000.00 Retained earnings 0.00 90,264.99 Total stockholders' equity 0.00 315,264.99 Total liabilities and stockholders' equity $0.00 $359,625.88WAREN SPORTS SUPPLY I STATEMENT OF INCOME AND RETAINED EARNINGS FOR THE YEAR ENDED DECEMBER 31 , 2017 REVENUE Sales Less: Sales returns and allowances Sales discounts taken Net sales COST OF GOODS SOLD Beginning inventory Net purchases Freight-in Goods available for sale Less: Ending inventory Cost of goods sold GROSS MARGIN OPERA11NG EXPENSES Rent expense Advertising expense Office supplies expense Depreciation expense Wages and salaries Payroll taxes Bad debt expense Other operating expense Total operating expenses Operating income OTHER INCOME - Miscellaneous income OTHER EXPENSE - Interest expense INCOME BEFORE TAXES FEDERAL INCOME TAXES NET INCOME RETAINED EARNINGS - Beginning of year RETAINED EARNINGS - End of year 101,681.00 0.00 0.00 101,681.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $0.00 0.00 0.00 0.00 101,681.00 (101,681.00) 0.00 (101,681.00) 0.00 0.00 (101,681.00) 0.00 (101,681.00) 90,264.99 $11,416.01! WAREN SPORTS SUPPLY STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31, 2017 CASH FLOWS FROM OPERATING ACTIVITIES Net income Adjustments to reconcile net income to net cash from operating activities ($101,001.00) Depreciation 0.00 (Increase) decrease in assets: Accounts receivable 7,814.19 Inventory 101,681.00 Increase (decrease) in liabilities: Accounts payable (11,279.35) Payroll taxes withheld and payable (3,284.54) Income taxes payable (29,797.00) Interest payable 0.00 Net cash provided by operating activities (36,546.70) CASH FLOWS FROM INVESTING ACTIVITIES Cash payments for fixed assets 320,665.00 Purchase of marketable securities 0.00 Net cash used in investing activities 320,665.00 CASH FLOWS FROM FINANCING ACTIVITIES Cash proceeds from loans 0.00 NET INCREASE IN CASH 284,118.30 CASH - Beginning of year 11,025.19 CASH - End of year $295,143.49 WAREN SPORTS SUPPLY POST-CLOSING TRIAL BALANCE December 31, 2017 ACCT. NO. ACCOUNT TITLE DEBIT CREDIT ASSETS 10100 Cash 0.00 10200 Accounts receivable 0.00 10300 Allowance for doubtful accounts 0.00 10400 nventory 0.00 10600 Marketable securities 0.00 10800 Fixed assets 0.00 10900 Accumulated depreciation 0.00 LIABILITIES 20100 Accounts payable 0.00 20300 Federal income taxes withheld 0.00 20400 State unemployment taxes payable 0.00 20500 Federal unemployment taxes payable 0.00 20600 F.I.C.A. taxes payable 0.00 20700 Federal income taxes payable 0.00 20900 Interest payable 0.00 21000 Notes payable 0.00 KHOLDERS' EQUITY 26000 Common stock 0.00 29000 Retained earnings 0.00 TOTALS $0.00 $0.00