Need help solving this.
Ingraham & Jenkins 17. Insert a new worksheet en and utilizing cet entitled "Balance Sheet" and create a comparative classified Balance Sheet employing the same general formatting technight, lizing formulas as before (see Figure 8). Determine your columb widths as you deem appropriate. Use a single column to present the varinn account balances for 20XW and a single column to present the accous balances for 20XX. Data Adjus width Home Then Arial type 10 Delete $ . % Conditional Format as Call Formatting . Table . Styles . . Format . . Sort & Find & Filter . Select T 13 fx '20XX A B C D E H K CHATEAU AMERICANA Balance Sheet For the Year Ending 12-31-20XX w 20XW 20XX ca DUIAWN - ASSETS fo 7 6 CURRENT ASSETS Cash & Cash Equivalents $2,992, 137.93 $3,007,233.29 8 Accounts Receivable 4,913,697.13 5,366,569.32 9 (97,459.89) 10 Less: Allowance for bad debts Inventory 14.309,621.78 11 Prepaid Expenses 84,636.54 12 Investments - Available for Sale 2,080,764.31 Sample 13 Total Current Assets $24,283,397.80 14 15 PROPERTY, PLANT & EQUIPMENT $28, 179,845.29 $30,230, 118.44 16 Less: Accumulated Depreciation (14,140,830.31) 17 $14,039,014.98 (15,341,679.47) $14.888.438.97 18 19 TOTAL ASSETS $38,322,412.78 $41,963,735.93 20 21 LIABILITIES AND STOCKHOLDER'S EQUITY Figure 8 18. Create the following cell or range names for the Balance Sheet: . Beginning Inventory Ending Inventory . Current Assets (for 20XX only) . Beginning Total Assets . Ending Total Assets Current Liabilities (for 20XX only) Ending Total Liabilities Beginning Stockholders Equity . Ending Stockholders EquityAutoSave (. Off ) CA_Computerized_Excel Workbook(2) (1).xIsx - Excel O Search Conner Seckman CS File Home Insert Draw Page Layout Formulas Data Review View Help Geneva - 10 ~ A A E - AY O Paste CA General insert " BID ZA Delete % " Conditional Format as Cell Formatting Ideas Table ~ Styles Format Sort & Find & Filter ~ Select v Clipboard Font Alignment Number Styles Cells Editing Ideas E70 X V 14475 A W 12/31/20XX G M N 12-31-20XW POST CLOSING 12-31-20XX ACCT ACCOUNT NO TITLE TRIAL BALANCE UNADJUSTED ADJUSTMENTS ADJUSTED INCOME BALANCE DEBIT CREDIT TRIAL BALANCE TRIAL BALANCE STATEMENT SHEET ASSETS DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT 10 111000 General checking account 138,784.99 112000 Payroll checking account 28,726.39 2, 144.153.91 11 113000 Money market account 75,549.73 1,000.00 7,000.00 1,000.00 7,000.00 82,546.49 114000 Savings account 82,546.49 1,000.00 12 48,576.82 182,546.49 13 119000 Petty cash 500.00 51,745.56 61,745.56 4,913,697.13 500.00 500.00 51,745.56 14 121000 Accounts receivable 15 129000 Allowance for bad debts 5,366,569.32 97,459.89 10,989.33 5,355,579.99 500.00 95 401.58 95,401.58 5,355,579.99 16 141000 Inventory - production 95,401.58 17 10,407.164.74 145000 Inventory - finished goods 3,902,457.04 11,607,286.54 4,000 303.19 1,607,286.54 11,607,286.54 18 150000 Prepaid expenses 84.636.54 15,350,295.73 142,465.96 4,000,303. 19 000,303. 19 19 160000 Land and buildings 16,358,487.34 142,465.96 16,358,487.34 142,465.96 20 170000 Equipment 12,829,549.56 16,358,487.34 21 180000 Accumulated depreciation 22 2,080,764.31 14, 140,830.31 13,871.421 10 13.871,421 10 13,871,421.10 191000 Investments 3. 103,492.56 15,341,658.47 15,341,658.47 15,341 658.47 23 3,103,492.56 3,103,492.56 24 LIABILITIES 25 210000 Accounts payable 26 .682,954.12 987,975.79 222100 Federal income tax withheld 64.442.36 67,565.78 4.987,975.79 4,987.975.79 27 222200 FICA withheld 12,107.35 12,767.80 67.565.78 12,767.80 67.565.78 28 222300 Medicare withheld 2,986.00 12,767.80 2,831.56 12, 107.35 12,767.80 2,986.00 2,986.00 29 223100 FICA payable - employer 2,831.56 2,767 80 12,767.80 30 223200 Medicare payable - employer 2,986.00 223300 Unemployment taxes payable 846.39 943.57 2,986 00 68,998.06 599 403.23 155,146.90 943.57 2,986.00 943.57 32 230000 Other accrued expenses 754,550.13 754,550.13 33 235000 Federal income taxes payable 157,448.31 0.00 0.00 236000 Property taxes payable 0.00 0.00 0.00 35 239000 Dividends payable 0.00 50,000.00 50,000.00 50,000.00 36 240000 Mortgages payable 442,445.94 639,067.73 813,000.00 7.639.067.73 7,639,067.73 37 261000 Notes payable 654,000.00 813.000.00 813,000.00 Income Statement Y-E Worksheet Balance Sheet Sales Commissions Payroll Journal What ... + Ready Type here to search O e 9 X DELL230000 Other accrued expenses 846.39 943.57 568,998.06 599,403.23 155,146.90 943.57 754,550.13 943.57 235000 Federal income taxes payable 236000 Property taxes payable 157.448.31 0.00 0.00 754.550.13 0.00 239000 Dividends payable 0.00 0.00 0.00 240000 Mortgages payable 7 442,445.94 50,000.00 261000 Notes payable 654,000.00 7 639,067.73 50,000.00 813,000.00 639.067.73 50,000.00 813,000.00 7.639.067.73 STOCKHOLDERS' EQUITY 813,000.00 310000 Common stock 311000 Paid-in capital in excess of par - common 90,000.00 90,000.00 90,000.00 90,000.00 312000 Dividends - common 3,567,265.00 3,567,265.00 0.00 3,567,265.00 567,265.00 390000 Retained earnings 22,064,134.78 50,000.00 22,064,134.78 (50,000.00) 22,064,134.78 (50,000.00) 22,064 134.78 REVENUE 410000 Sales 420000 Sales discounts 348,218.60 22,342,575.63 430000 Sales returns and allowances 15,693.00 348,218.60 22,342,575.63 348,218.60 22,342,575.63 451000 Gain/Loss - Fixed Assets 15,693.00 15,693.00 491000 Dividend income 0.00 492000 Interest income 4,000.00 23,482.56 4,000.00 23,482.56 4,000.00 23,482.56 COST OF GOODS SOLD 510000 Costs of Goods Sold 11,557 835.23 11,557,835.23 11,557,835.23 EXPENSES 601000 repairs and maintenance 601500 973.715 17 1,973,715.17 Sales commissions expense 771,665.60 1,973,715.17 602100 FICA tax expense 244 654.68 771,665.60 244.654.68 771.665.60 244,654.68 602200 Medicare tax expense 602300 FUTA expense 57,217.61 7,392.00 57,217.61 57,217.61 22 176.00 7,392.00 7,392.00 602400 SUTA expense 611000 Utilities expense 325,954.67 22,176.00 230,910.91 25,954.67 22, 176.00 325,954.67 611300 Irrigation & waste disposal expense 230,910.91 230,910.91 Income Statement Y-E Worksheet Balance Sheet Sales Commissions Payroll Journal What ... + Ready Type here to search O e X X DELL F4 F5 FO F7 F8 F9 F10 F11 F12 # 2 B 4 5 6 2
