How to recreate this on excel.

instruction:

all mumbers and dates under the words impact area must be a formula.

dont highlight any cells or place grids around all of them.

$162,600 74 $75,000 285,000 10,000 50,000 $420,000 125,000 235,000 360,000 LOS DIVICIUS 70 Balance at December 31 2021 72 Samson Corporation 73 Balance Sheet December 31, 2021 75 Assets 76 Current assets: 77 Cash 78 Accounts receivable $300,000 79 Less: Allowance for uncollectible accounts 15,000 80 Net Accounts Receivables 81 Prepaid rent 82 Inventory 83 Total current assets 84 Property, Plant and Equipment 85 Property 86 Equipment 475 000 87 Less: Accumulated depreciation 240.000 88 Total Property. Plant and Equipment 89 Intangibles 90 Goodwill 91 Trademark 92 Total Intangibles 93 Total assets 94 Liabilities and Shareholders' Equity 95 Current liabilities 96 Accounts payable $14,000 97 Note payable 10,000 98 Salaries payable 8,000 99 Interest payable 2.000 100 Total current liabilities 101 Long-term Liabilities 102 Loans payable 49.400 103 Bonds payable 50.000 104 Total Long-term Liabilities 105 Total Liabilities 106 Shareholders' equity 107 Common stock 108 Retained earnings 109 Total shareholders' equity 110 Total liabilities and shareholders' equity 112 Created by Student Name =NOWO 710 290 1,000 $781,000 $34.000 99,400 $133,400 485.000 162.600 647 600 $781 000 Page of 2 -B26 47 $846,600 490.000 356,600 43 For the Year Ended December 31, 2021 44 Sales revenue $869,000 45 Sales discounts 46 Sales returns and allowances (15400 Net sales Type or copy this formula as given, do not change it. 48 Cost of goods sold ="For the Year Ended "&TEXT(A4,"mmmm d, yyyy") 49 Gross profit All cells with purple highlights should have this formula. 50 Operating expenses: 51 Salaries expense 120,000 52 Rent expense 30,000 Review excel 53 Wages expense 85,000 54 Depreciation expense notebook in course 60,000 55 Bad debt expense materials for 5,000 56 Total operating expenses assistance. 57 Operating income 58 Other Income (expense) 59 Interest revenue 20.000 60 Interest expense 61 Total other income (expenses) 62 Net income 300,000 56 600 16.000 $72,600 D A Samson Corporation Retained Earnings Statement 64 65 66 67clance 01 68 Net income 69 Less: Dividends 70 Halangal Decem 72 $100.000 72.600 10,000 $162 600 Samson Corporation Balance Sheet Page > of 2 1 Input Area Merge and center columns A 2 Samson Corporation thru C for rows 2 thru 4. Do this 3 for all Financial Statement Adjusted Trial Balance 4 headings December 31, 2021 5 Account Title Debits Credits 6 Cash $75,000 7 Accounts receivable 300,000 8 Allowance for uncollectible accounts Warning!!! Do not $15,000 9 Prepaid rent type in any Sorin 10,000 10 Inventory your numbers. Use 50.000 11 Property the currency and 125,000 12 Equipment comma icon to 475,000 13 Accumulated depreciation equipment obtain these 240,000 14 Goodwill characters. Do this 710 15 Trademark all semester. 290 16 Accounts payable 14,000 17 Note payable (due in six months) 10,000 18 Salaries payable 8,000 19 Interest payable 2,000 Warning, all highlighted 20 Loans payable 49,400 21 Bonds payable areas must be formulas. 50.000 22 common stock Also, do not shade your 485,000 23 Retained earnings areas on your 100.000 24 Dividends spreadsheet. 10,000 25 Sales revenue 869,000 26 Sales discounts 7,000 27 Sales returns and allowances 15,400 Cells with orange 28 interest revenue 20,000 highlights should be 29 Cost of goods sold 490,000 30 Salaries expense =sum formulas. 120,000 31 Rent expense For example, cell B36 is 30,000 32 Wages expense =SUM(B6:835) 85.000 33 Depreciation expense 60,000 34 interest expense 4,000 35 Bad debt expense When finished, do a 5.000 36 Totals spell check $1,862,400 $1,862,400 38 Beginning date of fiscal year January 1, 2021 40 Impact Area: 41 Samson Corporation +C25 42 Income Statement 43 For the Year Ended ber 312021 -B26