i need excel formula for all these

the first photo is blurry

i hope the photos are clear

pd is period

and i believe rng is range

Orie content 1959 555 1714 3631 555, Buy Opine.chech Oplech Mein Dhe New Che WCAGR CAGR MAX They IN ley NNNN IN IN IN'S FY lind 1979 2020 121 518 100 101 11TL 2014 1 0 JU 11.LT 12304, 1001 11 2014 1 11.05 SEL 2012 2013 $121,51 2011 2011 TS WU DANE SM 145.00 32 SH ST TV 2 REVUE HD 540 I.DE neo. Page Layout Formulas 712 2200 F1-xin Timpit Dist v2 100% Wed 12:19 PM Drun Data Revik View Tolme a Calibre del SA A - A wa Percentage Merge $% Canal Form Cel Formatting Table yet Oulu Sale F M N 0 P V NE OWODOW ON GAGRAGAD NEAR ce NI NNNNNNNNN S. 1411 25 7025 2026 23151.5404 2010 1011 31,177,673 1 1 51472103 101 1011121313 2011 013123130110 2015 5 141,22 2014 $1.047835 2011 IN s. 1844 1 15. $70.738 545.40 3351 TE HOE TELTOE TO 1, S4, LE 14 FUN 100N AP Rur Op Margin Net Margin (%) (%) 6.0% 4.3% 12m End Revenue 2020 2020-12-31 $1,588,404 2019 2019-12-31 $1,372,673 2018 2018-12-31 $1,418,802 2017 2017-12-31 $1,331,778 2016 2016-12-31 $1,204,199 2015 2015-12-31 $1,143,282 2014 2014-12-31 $1,057,536 2013 2013-12-31 $983,112 2012 2012-12-31 $825,581 2011 2011-12-31 $718,515 Operating Income Net Income $95.279 $69,082 $79,534 $63,192 $84,239 $55,122 585,732 $50,556 $75,751 $44,747 $70,710 $45,840 $60,098 $35,273 $58,745 $34,830 $39,574 $23,367 $40,568 $23,727 5.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 Scorcht Grp (a) Agr NM Grp (9) Agr MRFY SYMBL) PLUS M Op Margin Net Margin 1%) 6.0% 4.3% Rynu Che Op Inc Che Net Inc Cho Rynu Chg (pd Op Inc Iyoy Tyoy) fyoyX) 2y, X) (pd 2y 15.7 19.8% 9.33 ome ,082 ,192 -,122 0,556 5,747 5,840 5,273 4,830 3,367 3,727 00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 M N o P a R S T Bin Rvnu Chg (yoy %) 15.7% Op Inc Chg Net Inc Chg Rvnu Chg (pd Op Inc Chg Net Inc Chg Rvnu Chg Op Inc Chg (yoy %) (yoy %) 2y,%) (pd 2y,%) (pd 2y,%) (rng 4y,%) (rng 4y,%) 19,8% 9.3% 3% OD 10.00 10,00 10.00 10.00 10.00 10.00 10.00 10.00 10 PLUS otv s thg Rvnu Chg (pd Op Inc Chg Net Inc Chg Rvnu Chg Op Inc Chg Net Inc Cho Rynu CAGRO %) 2y,%) (pd 2y, %) (pd 2y,%) (rng 4y,%) (mg 4y,%) (rng 4y,%) (p3,r5, ) 3% 5.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10 etv W Format Insert Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select R $ T C W 14 14 14 14. 14. 14. 14.4 14.4 Chg Net Inc Chg Rvnu Chg Op Inc Chg Net Inc Chg Rvnu CAGR OI CAGR (P3, NI CAGR (p3, Ry,%) (pd 2y,%) (rng 4y,%) (rng 4y,%) (rng 4y,%) (p3, r5,%) r5, %) r5, %) 14,4 14.4 14.4 14.4 14,4 14,4 14.4 14.4 14.4 14.4 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 4 100% tv A a Operating Income FY 12m End Revenue 2020 2020-12-31 $1,588,404 2019 2019-12-31 $1,372,673 2018 2018-12-31 $1,418,802 2017 2017-12-31 $1,331,778 2016 2016-12-31 $1,204,199 2015 2015-12-31 $1,143,282 2014 2014-12-31 $1,057,536 2013 2013-12-31 $983,112 2012 2012-12-31 $825,581 2011 2011-12-31 $718,515 $95,279 $79,534 $84,239 $85,732 $75,751 $70,710 $60,098 $58,745 $39,574 $40,568 Net Op Margin Net Mary Income (%) ( $69,082 6.0% 4.3 $63,192 5.8% 4.6 $55,122 5.9% 3.9 $50,556 6.4% 3.89 $44,747 6.3% 3.79 $45,840 6.2% 4.09 $35,273 5.7% 3.3% $34,830 6.0% 3.5% $23,367 4.8% 2.8% $23,727 5.6% 3.3% 3.0 6.00 10.00 10.00 10.00 10.00 10.00 100 Net Op Margin Net Margin ncome (%) (%) 69,082 6.0% 4.3% 63,192 5.8% 4.6% -55,122 5.9% 3.9% 550,556 6.4% 3.8% $44,747 6.3% 3.7% $45,840 6.2% 4.0% $35,273 5.7% 3.3% $34,830 6.0% 3.5% $23,367 4.8% 2.8% $23,727 5.6% 3.3% Net Inc Rynu Chg Op Inc Chg Chg (yoy Rvnu (yoy %) (yoy %) %) (pd 2 15.7% 19.896 9.3% 7 -3.3% -5.6% 14.6% 10 6.5% -1.7% 9.0% 17 10.6% 13.2% 13.0% 15 5.3% 7.1% -2.4% 15. 8.1% 17.7% 30.0% 21. 7.6% 2.3% 1.3% 32. 19.1% 48.4% 49.1% 25.9 14.9% -2.5% -1.5% N/A N/A N/A N/A N/A 10.00 10.00 10.00 10.00 10.00 10.00 10.00 b vnu Chg Op Inc Chg (yoy %) (yoy %) 15.7% 19.8% -3.3% -5.6% 6.5% -1.7% 10.6% 13.2% 5.3% 7.1% 8.1% 17.7% 7.6% 2.3% 19.1% 48.4% 14.9% -2.5% N/A N/A Net Inc Net Inc Chg (yoy Rvnu Chg Op Inc Chg Chg (pd 2y, Rvnu Chg %) (pd 2y,%) (pd 2y, %) %) (rng 4y,%) 9.3% 7.7% 2.8% 25.2% 14.6% 10.1% 1.4% 24.1% 9.0% 17.2% 16.1% 16.7% 13.0% 15.2% 23.5% 17.5% -2.4% 15.0% 23.2% 29.2% 30.0% 21.7% 33.0% 39.4% 1.3% 32.2% 48.3% 48.9% 49.1% 25.9% 21.2% 22.6% -1.5% N/A N/A N/A N/A N/A N/A N/A 10.00 10.00 10.00 10.00 10.00 10.00 10.00 Net Inc Chg (rng Rvnu CAGR 4y, %) (p3, r5, %) Net Inc Rvnu Chg Op Inc Chg Chg (pd 2y, Rvnu Chg Op Inc Chg pd 2y,%) (pd 2y, %) %) (rng 4y,%) (rng 4y, %) 7.7% 2.8% 25.2% 10.1% 1.4% 24.1% 17.2% 16.1% 16.7% 15.2% 23.5% 17.5% 15.0% 23.2% 29.2% 21.7% 33.0% 39.4% 32.2% 48.3% 48.9% 25.9% 21.2% 22.6% N/A N/A N/A N/A N/A N/A 10.00 10.00 10.00 10.00 10.00 10.00 10.00 2y, Net Inc Chg (rng Rvnu CAGR OI CAGR NI CAGR 4y,%) (p3, r5,%) (p3, r5,%) (p3, r5, %) Inc Rynu Chg Op Inc Chg %) (rng 4y,%) (rng 4y,%) 5.2% 4.1% 6.7% 7.5% -9.2% 39.4% 48.9% 22.6% .00 10nn 1AA Orie content 1959 555 1714 3631 555, Buy Opine.chech Oplech Mein Dhe New Che WCAGR CAGR MAX They IN ley NNNN IN IN IN'S FY lind 1979 2020 121 518 100 101 11TL 2014 1 0 JU 11.LT 12304, 1001 11 2014 1 11.05 SEL 2012 2013 $121,51 2011 2011 TS WU DANE SM 145.00 32 SH ST TV 2 REVUE HD 540 I.DE neo. Page Layout Formulas 712 2200 F1-xin Timpit Dist v2 100% Wed 12:19 PM Drun Data Revik View Tolme a Calibre del SA A - A wa Percentage Merge $% Canal Form Cel Formatting Table yet Oulu Sale F M N 0 P V NE OWODOW ON GAGRAGAD NEAR ce NI NNNNNNNNN S. 1411 25 7025 2026 23151.5404 2010 1011 31,177,673 1 1 51472103 101 1011121313 2011 013123130110 2015 5 141,22 2014 $1.047835 2011 IN s. 1844 1 15. $70.738 545.40 3351 TE HOE TELTOE TO 1, S4, LE 14 FUN 100N AP Rur Op Margin Net Margin (%) (%) 6.0% 4.3% 12m End Revenue 2020 2020-12-31 $1,588,404 2019 2019-12-31 $1,372,673 2018 2018-12-31 $1,418,802 2017 2017-12-31 $1,331,778 2016 2016-12-31 $1,204,199 2015 2015-12-31 $1,143,282 2014 2014-12-31 $1,057,536 2013 2013-12-31 $983,112 2012 2012-12-31 $825,581 2011 2011-12-31 $718,515 Operating Income Net Income $95.279 $69,082 $79,534 $63,192 $84,239 $55,122 585,732 $50,556 $75,751 $44,747 $70,710 $45,840 $60,098 $35,273 $58,745 $34,830 $39,574 $23,367 $40,568 $23,727 5.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 Scorcht Grp (a) Agr NM Grp (9) Agr MRFY SYMBL) PLUS M Op Margin Net Margin 1%) 6.0% 4.3% Rynu Che Op Inc Che Net Inc Cho Rynu Chg (pd Op Inc Iyoy Tyoy) fyoyX) 2y, X) (pd 2y 15.7 19.8% 9.33 ome ,082 ,192 -,122 0,556 5,747 5,840 5,273 4,830 3,367 3,727 00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 M N o P a R S T Bin Rvnu Chg (yoy %) 15.7% Op Inc Chg Net Inc Chg Rvnu Chg (pd Op Inc Chg Net Inc Chg Rvnu Chg Op Inc Chg (yoy %) (yoy %) 2y,%) (pd 2y,%) (pd 2y,%) (rng 4y,%) (rng 4y,%) 19,8% 9.3% 3% OD 10.00 10,00 10.00 10.00 10.00 10.00 10.00 10.00 10 PLUS otv s thg Rvnu Chg (pd Op Inc Chg Net Inc Chg Rvnu Chg Op Inc Chg Net Inc Cho Rynu CAGRO %) 2y,%) (pd 2y, %) (pd 2y,%) (rng 4y,%) (mg 4y,%) (rng 4y,%) (p3,r5, ) 3% 5.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10 etv W Format Insert Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select R $ T C W 14 14 14 14. 14. 14. 14.4 14.4 Chg Net Inc Chg Rvnu Chg Op Inc Chg Net Inc Chg Rvnu CAGR OI CAGR (P3, NI CAGR (p3, Ry,%) (pd 2y,%) (rng 4y,%) (rng 4y,%) (rng 4y,%) (p3, r5,%) r5, %) r5, %) 14,4 14.4 14.4 14.4 14,4 14,4 14.4 14.4 14.4 14.4 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 4 100% tv A a Operating Income FY 12m End Revenue 2020 2020-12-31 $1,588,404 2019 2019-12-31 $1,372,673 2018 2018-12-31 $1,418,802 2017 2017-12-31 $1,331,778 2016 2016-12-31 $1,204,199 2015 2015-12-31 $1,143,282 2014 2014-12-31 $1,057,536 2013 2013-12-31 $983,112 2012 2012-12-31 $825,581 2011 2011-12-31 $718,515 $95,279 $79,534 $84,239 $85,732 $75,751 $70,710 $60,098 $58,745 $39,574 $40,568 Net Op Margin Net Mary Income (%) ( $69,082 6.0% 4.3 $63,192 5.8% 4.6 $55,122 5.9% 3.9 $50,556 6.4% 3.89 $44,747 6.3% 3.79 $45,840 6.2% 4.09 $35,273 5.7% 3.3% $34,830 6.0% 3.5% $23,367 4.8% 2.8% $23,727 5.6% 3.3% 3.0 6.00 10.00 10.00 10.00 10.00 10.00 100 Net Op Margin Net Margin ncome (%) (%) 69,082 6.0% 4.3% 63,192 5.8% 4.6% -55,122 5.9% 3.9% 550,556 6.4% 3.8% $44,747 6.3% 3.7% $45,840 6.2% 4.0% $35,273 5.7% 3.3% $34,830 6.0% 3.5% $23,367 4.8% 2.8% $23,727 5.6% 3.3% Net Inc Rynu Chg Op Inc Chg Chg (yoy Rvnu (yoy %) (yoy %) %) (pd 2 15.7% 19.896 9.3% 7 -3.3% -5.6% 14.6% 10 6.5% -1.7% 9.0% 17 10.6% 13.2% 13.0% 15 5.3% 7.1% -2.4% 15. 8.1% 17.7% 30.0% 21. 7.6% 2.3% 1.3% 32. 19.1% 48.4% 49.1% 25.9 14.9% -2.5% -1.5% N/A N/A N/A N/A N/A 10.00 10.00 10.00 10.00 10.00 10.00 10.00 b vnu Chg Op Inc Chg (yoy %) (yoy %) 15.7% 19.8% -3.3% -5.6% 6.5% -1.7% 10.6% 13.2% 5.3% 7.1% 8.1% 17.7% 7.6% 2.3% 19.1% 48.4% 14.9% -2.5% N/A N/A Net Inc Net Inc Chg (yoy Rvnu Chg Op Inc Chg Chg (pd 2y, Rvnu Chg %) (pd 2y,%) (pd 2y, %) %) (rng 4y,%) 9.3% 7.7% 2.8% 25.2% 14.6% 10.1% 1.4% 24.1% 9.0% 17.2% 16.1% 16.7% 13.0% 15.2% 23.5% 17.5% -2.4% 15.0% 23.2% 29.2% 30.0% 21.7% 33.0% 39.4% 1.3% 32.2% 48.3% 48.9% 49.1% 25.9% 21.2% 22.6% -1.5% N/A N/A N/A N/A N/A N/A N/A 10.00 10.00 10.00 10.00 10.00 10.00 10.00 Net Inc Chg (rng Rvnu CAGR 4y, %) (p3, r5, %) Net Inc Rvnu Chg Op Inc Chg Chg (pd 2y, Rvnu Chg Op Inc Chg pd 2y,%) (pd 2y, %) %) (rng 4y,%) (rng 4y, %) 7.7% 2.8% 25.2% 10.1% 1.4% 24.1% 17.2% 16.1% 16.7% 15.2% 23.5% 17.5% 15.0% 23.2% 29.2% 21.7% 33.0% 39.4% 32.2% 48.3% 48.9% 25.9% 21.2% 22.6% N/A N/A N/A N/A N/A N/A 10.00 10.00 10.00 10.00 10.00 10.00 10.00 2y, Net Inc Chg (rng Rvnu CAGR OI CAGR NI CAGR 4y,%) (p3, r5,%) (p3, r5,%) (p3, r5, %) Inc Rynu Chg Op Inc Chg %) (rng 4y,%) (rng 4y,%) 5.2% 4.1% 6.7% 7.5% -9.2% 39.4% 48.9% 22.6% .00 10nn 1AA