I need to know how to solve as well as the Excel formulas

AutoSave OFF 3Excel Assign 1 For 3190 Class Spring 2021 Due 3 12 2021 ~ Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 10 AA = al Wrap Text General Insert v Ex AY- O. Ex Delete Paste Sort & Ideas BIUV MVAv E Merge & Center v $ ~ % " Conditional Format Cell Find & Sensitivity Formatting as Table Styles Format Filter Select F5 fx C D E F G H K L M N 1 ACCOUNTING 3190 EXCEL ASSIGN NO. 1: SPRING 2021 At 12/31 - Butch Co. had the following Stockholder's Equity 3 components that would be part of would be part of the balance sheet: (1) Numers after a 100% (2) Numbers after a 2 for 1 (3) Numbers after a $5000 Stockerholders Equity At 12/31/2020 Stock Dividend Stock Splint Cash Dividend No. of Commn shares outstanding 5000 Par value per common share Common Stock, at Par $5,00 10 Additional Paid-in Capital $745,00 11 Total Contributed Capital 750,000 12 Retained Earnings 980,000 13 Total Stockholder's Equity 1730000 14 15 Butch Company is considering 3 alternative distributions subsequent to 12/31/2020. For this assignment, consider each alternative 16 totally independent of the others. For cells C7 to E13, use cell formulas and cell references so that your spreadsheet will 17 automatically update all numbers displayed in coluns C-E when I change the number in cell B7. B7 is the only cell I will manipulate for this assign. 18 EG: If I change cell B7 to 8000, your spreadsheet should be programmed to automatically display 16000 in cell C7, and in D8, 8000 in E7. 19 20 This revised assignment is due in the iLearn Assessments/Ass /Assessments folder = 3/12/2021 at 11:55 PM. 21 Be sure to submit a fully automatic excel spreadsheet / Not a word document where you show just one set of number.s 22 23 24 25 26 27 28 29 30 31 32 33 D Sheet1 + Ready + 125%