Excel File Edit View Insert Format Tools Data Window Help G2 Sun Mar 6 4:59 PM OO AutoSave OFF onvo v O... 9.2 Build A Model Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) V 11 AA as Wrap Text General AVTT V O Fan H2 LIN Paste BI U CA Merge & Center $ % $ V 60 .00 0 Insert 20 Delete Format V Conditional Format Cell Formatting as Table Styles Sort & Filter v Find & Select Analyze Data J21 fox A L M N o P Q R S T U V w B D E F G G H ----------------------------------- Contain formulas and references to calculations. Click on the cells and see the calculations or references 1 2 3 Answers Contain formulas and references to calculations. Click on the cells and see the calculations or references 5 i 6 6 12-7 71 2019 8 Sales 350.00 9 Net Income 10.50 10 M (Profit Margin) 11 Dividends Paid $ 4.20 12 Payout Ratio 40.00% 13 RR 60.00% 141 15 2020 16 Sales - Increase 70.00 17 % Increase 18 Sales 19 M (Profit Margin) 20 Net Income 21 Payout Ratio 22 Dividends Paid 23 RR 24 25 AFN = (A/S,MAS - (L*/5.AS.MS,(RR) 26 27 (A/S, AS 28 (L*/5.45 29 MS (RR) 30 AFN 31 32 12-b 33 AFN = (A/S, AS - (L*/S. AS - MS(RR) 34 Step 1 Find S. 35 S. S times ((A/5.) - (L*/5.(A/S.)-(L*/5.)-MS(RR)) 12-7 + Select destination and press ENTER or choose Paste + 100% 123 MAR . dL ISO 6