Use regression to forecast 2022

File Home Insert Draw Page Layout Formulas Data Review View Help e se X Calibri ' General 11 ab Wrap Text M LE 20 200 v Paste BIU a. Av $ % 9 Merge & Center Conditional Fo Formatting Number Styl Undo Clipboard Font Alignment M23 B E H D F 12 Months Ended 2020 G Forecast 2021 2019 2022 $588,886 $ 404,459 $ 333,837 S 697,443 51,253 (27,445) (28,803) (3,817) (1,933) 845 (4,905) 3,364 49,712 $ 638,598 10,504 (1,689) 775 9,590 (3,332) (21,187) $ 383,272 763 3,726 417 4,906 2,440 (21,457) S 312,380 1 CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME- USD ($) $ in Thousands 2. 3 Statement of Comprehensive Income (Abstract] 4 Net income 5 Other comprehensive income (loss) 6 Foreign currency translation adjustment 7 Cash flow hedges: 8 Change in unrealized gains 9 Reclassification to earings 10 Tax effect on effective cash flow hedges 11 Change in fair value of cash flow hedges 17 Change in fair value of available for sale securities 13 Other comprehensive income (loss) 14 Comprehensive income 15 16 17 18 79 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 36 37 38 39 40 2022 2021 2020 2019 697443 $588,886 $ 404,459 S $333,837 SUMMARY OUTPUT Regression Statistics Multiple R 0.968381735 R Square 0.937763185 Adjusted R Square 0.87552637 Standard Error 46460.6967 Observations ANOVA df 42 45 44 45 46 47 48 49 50 Significance 15.06766024 0.16051482 Regression Residual Total SS MS 32524996201 32524996201 2158596338 2158596338 34683592538 1 1 2 Intercept X Variable 1 1 Coefficients 257157096 127524,5 Standard Error Stat 66362406.28 3.87504177 32852.67369 3.881708417 P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% % 0.160779385 -1100371412 586057225 1100371417 586057225 0.160514819-289908,298 5449523289908.298 5449573 Balance Sheet Ratio Analysis Income Statement Forecast Statement of Cash Flows Circular Refren File Home Insert Draw Page Layout Formulas Data Review View Help e se X Calibri ' General 11 ab Wrap Text M LE 20 200 v Paste BIU a. Av $ % 9 Merge & Center Conditional Fo Formatting Number Styl Undo Clipboard Font Alignment M23 B E H D F 12 Months Ended 2020 G Forecast 2021 2019 2022 $588,886 $ 404,459 $ 333,837 S 697,443 51,253 (27,445) (28,803) (3,817) (1,933) 845 (4,905) 3,364 49,712 $ 638,598 10,504 (1,689) 775 9,590 (3,332) (21,187) $ 383,272 763 3,726 417 4,906 2,440 (21,457) S 312,380 1 CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME- USD ($) $ in Thousands 2. 3 Statement of Comprehensive Income (Abstract] 4 Net income 5 Other comprehensive income (loss) 6 Foreign currency translation adjustment 7 Cash flow hedges: 8 Change in unrealized gains 9 Reclassification to earings 10 Tax effect on effective cash flow hedges 11 Change in fair value of cash flow hedges 17 Change in fair value of available for sale securities 13 Other comprehensive income (loss) 14 Comprehensive income 15 16 17 18 79 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 36 37 38 39 40 2022 2021 2020 2019 697443 $588,886 $ 404,459 S $333,837 SUMMARY OUTPUT Regression Statistics Multiple R 0.968381735 R Square 0.937763185 Adjusted R Square 0.87552637 Standard Error 46460.6967 Observations ANOVA df 42 45 44 45 46 47 48 49 50 Significance 15.06766024 0.16051482 Regression Residual Total SS MS 32524996201 32524996201 2158596338 2158596338 34683592538 1 1 2 Intercept X Variable 1 1 Coefficients 257157096 127524,5 Standard Error Stat 66362406.28 3.87504177 32852.67369 3.881708417 P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% % 0.160779385 -1100371412 586057225 1100371417 586057225 0.160514819-289908,298 5449523289908.298 5449573 Balance Sheet Ratio Analysis Income Statement Forecast Statement of Cash Flows Circular Refren