YEAR SALES REVENUE PAT DIRECT EXPENSES STOCK PRICE STOCK RETURN MARKET RETURN

2010 459.15
2011 2632.94 297.73 443.04 568.78 23.88 -0.05991509
2012 2795.86 288.99 461.95 592.71 4.21 0.009324444
2013 2995.97 335.77 513.93 516.06 -12.93 0.068235203
2014 2768.62 295.89 471.95 951.12 84.30 0.297947896
2015 2804.72 243.89 447.84 1235.56 29.91 0.15707939
2016 3184.77 255.89 509.95 1199.37 -2.93 0.002417213
2017 2523.33 202.77 416.91 1470.57 22.61 0.230667099
2018 2432.79 166.72 395.4 1652.46 12.37 0.95910071
2019 2372.92 190.08 358.29 1860.62 12.60 0.016595245
2020 2566.75 208.49 400.2 1547.80 -16.81 -0.03099082

SALES REVENUE PAT

Mean 2707.867 Mean 243.165555556

Standard Error 80.18678 Standard Error 18.6763220647
Median 2700.78 Median 243.89
Mode #N/A Mode #N/A
Standard Deviatio 253.5729 Standard Devia56.0289661941
Sample Variance 64299.2 Sample Varian 3139.24505278
Kurtosis -0.185867 Kurtosis -0.98620915461
Skewness 0.56465 Skewness 0.30613360955
Range 811.85 Range 169.05
Minimum 2372.92 Minimum 166.72
Maximum 3184.77 Maximum 335.77
Sum 27078.67 Sum 2188.49
Count 10 Count 9

1200

1000

800

600

400

200

0
1 2 3 4 5 6 7 8 9 10

Sales Revenue Linear (Sales Revenue) Profit & loss

 400

200

0
1 2 3 4 5 6 7 8 9 10

Sales Revenue Linear (Sales Revenue) Profit & loss

1200 1200

1000
1000

800
800
600
600
400
400
200
200
0
1 2 3 4 5 6 7 8 9 10
0
-200 1

Stock returns Linear (Stock returns) Market returns

GDP GROWTH RATE correlation of all variable companies
2632.94 297.73
8.50% 2632.94 1
5.24% 297.73 0.760706 1
5.46% 443.04 0.95379 0.858724
6.39% 568.78 -0.712657 -0.944881
7.41% 23.87592 -0.112201 0.109101
8.00% -0.059915 -0.402624 -0.43105
8.26% 0.0524 0.356183 0.280214
6.80%
6.53%
4.04%
-7.96%

DIRECT EXPENSES STOCK PRICE

Mean 441.946 Mean 1095.837

Standard Error 15.873444855 Standard E 152.6444
Median 445.44 Median 1199.37
Mode #N/A Mode #N/A
Standard Deviation 50.196240054 Standard D 506.2644
Sample Variance 2519.6625156 Sample Var 256303.6
Kurtosis -0.6846370889 Kurtosis -1.601812
Skewness -0.0571373328 Skewness 0.036528
Range 155.64 Range 1401.467
Minimum 358.29 Minimum 459.153
Maximum 513.93 Maximum 1860.62
Sum 4419.46 Sum 12054.2
Count 10 Count 11

1200

1000

800

600

400

200

0
1 2 3 4 5 6 7 8 9 10

Sales Revenue Linear (Sales Revenue) Selling Expenditure

 400

200

0
1 2 3 4 5 6 7 8 9 10

Sales Revenue Linear (Sales Revenue) Selling Expenditure

1200

1000

800

600

400

200

0
1 2 3 4 5 6 7 8 9 10

Sales Revenue Linear (Sales Revenue) Stock prices

 all variable companies
443.04 568.78 23.87592 -0.05991509 0.0524

1
-0.839638130532252 1
0.014138698758838 -0.024783682 1
-0.266644493288004 0.2887407226 0.285905 1
0.432619786769836 -0.304175591 0.438733 0.287330188174336 1

STOCK RETURN MARKET RETURN

Mean 15.719680025 Mean 0.16504613

Standard Error 9.0674468336 Standard Error 0.09566728
Median 12.482825 Median 0.04241522
Mode #N/A Mode #N/A
Standard Deviation 28.673784557 Standard Deviation 0.30252651
Sample Variance 822.1859208 Sample Variance 0.09152229
Kurtosis 3.4437055783 Kurtosis 6.18184146
Skewness 1.5335296897 Skewness 2.368282
Range 101.11682602 Range 1.0190158
Minimum -16.81267534 Minimum -0.0599151
Maximum 84.30415068 Maximum 0.95910071
Sum 157.19680025 Sum 1.65046129
Count 10 Count 10

9 10

xpenditure
 9 10

xpenditure

9 10

prices
 SALES REVENUE PATDIRECT EXPENSES
SALES REVENUE 1
PAT 0.686962603336583 1
DIRECT EXPENSES 0.947812255296274 0.818634 1

GDP Growth Rate SUMMARY OUTPUT

Mean 0.05017 Regression Statistics

Standard Error 0.0149851115 Multiple R 0.877906
Median 0.0646 R Square 0.770718
Mode #N/A Adjusted R 0.656078
Standard Deviat 0.047387083332 Standard E 32.58973
Sample Varianc 0.002245535667 Observatio 10
Kurtosis 8.040589756687
Skewness -2.741143271334 ANOVA
Range 0.1622 df SS MS
Minimum -0.0796 Regression 3 21420.97 7140.323
Maximum 0.0826 Residual 6 6372.542 1062.09
Sum 0.5017 Total 9 27793.51
Count 10
Coefficients
Standard Error t Stat
Intercept -51.96223 126.0417 -0.412262
SALES REV -0.21296 0.137151 -1.552743
DIRECT EX 2.007696 0.719168 2.791693
GDP GROW-200.1382 259.5432 -0.771117

RESIDUAL OUTPUT

Observation
Predicted PATResiduals
1 266.3286 31.40142
2 269.1583 19.83167
3 329.0416 6.728397
 4 291.1336 4.756371
5 233.8594 10.0306
6 277.1015 -21.21149
7 234.0879 -31.3179
8 210.7242 -44.00416
9 153.9519 36.12807
10 220.833 -12.34297
 SUMMARY OUTPUT

Regression Statistics
Multiple R
R Square
Adjusted R
Standard E
Observatio

ANOVA
F Significance F
6.722896 0.023984 Regression
Residual
Total

P-value Lower 95%Upper 95%Lower 95.0%

Upper 95.0% Coefficients
0.694472 -360.3751 256.4507 -360.3751 256.4507 Intercept
0.171473 -0.548557 0.122636 -0.548557 0.122636 PAT
0.031507 0.247955 3.767437 0.247955 3.767437 MARKET R
0.469905 -835.2176 434.9411 -835.2176 434.9411 GDP GROW

RESIDUAL OUTPUT

Observation
1
2
3
 4
5
6
7
8
9
10
SUMMARY OUTPUT

Regression Statistics
0.950051
0.902597
0.853895
185.3893
10

df SS MS F Significance F
3 1910918 636972.7 18.53325 0.001946
6 206215.1 34369.19
9 2117133

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
3375.279 357.9302 9.429991 8.086E-05 2499.455 4251.102 2499.455 4251.102
-8.834242 1.437335 -6.146266 0.00085 -12.35127 -5.31721 -12.35127 -5.31721
-202.3006 264.1437 -0.765873 0.472795 -848.6369 444.0357 -848.6369 444.0357
279.0921 1540.295 0.181194 0.862181 -3489.874 4048.058 -3489.874 4048.058

RESIDUAL OUTPUT

Predicted STOCK PRICE

Residuals
771.8052 -203.0252
835.6233 -242.9133
413.0353 103.0247
721.7206 229.3994
1211.246 24.31437
1137.249 62.12139
1556.274 -85.7037
1726.632 -74.17203
1703.984 156.6359
1517.481 30.31861
YEAR SALES REVENUE PAT DIRECT EXPENSES STOCK PRICE STOCK RETURN MARKET RETURN

2010 37.57
2011 942.18 269.34 141.43 34.93 -7.03 -0.05991509
2012 1010.52 333.83 121.95 52.81 51.19 0.009324444
2013 1107.57 282.49 125.22 58.63 11.02 0.068235203
2014 741.23 143.88 105.88 170.84 191.39 0.297947896
2015 666.37 140.28 81.42 252.77 47.96 0.15707939
2016 616.33 131.57 91.98 257.81 1.99 0.002417213
2017 815.58 115.79 91.52 456.32 77.00 0.230667099
2018 742.6 86.15 97.01 574.37 25.87 0.95910071
2019 585.22 68.66 74.99 957.55 66.71 0.016595245
2020 468.49 54.81 66.47 1059.18 10.61 -0.03099082

SALES REVENUE PAT

Mean 769.609 Mean 162.68

Standard Error 63.64043 Standard Error 30.7999560966
Median 741.915 Median 135.925
Mode #N/A Mode #N/A
Standard Deviatio 201.2487 Standard Devia97.3980130986
Sample Variance 40501.04 Sample Varian 9486.37295556
Kurtosis -0.700283 Kurtosis -0.82869884116
Skewness 0.332332 Skewness 0.79083315112
Range 639.08 Range 279.02
Minimum 468.49 Minimum 54.81
Maximum 1107.57 Maximum 333.83
Sum 7696.09 Sum 1626.8
Count 10 Count 10

1200 1200

1000 1000

800 800

600 600

400 400

200 200

0 0
1 2 3 4 5 6 7 8 9 10 1

Sales Revenue Linear (Sales Revenue) Profit & loss

 0 0
1 2 3 4 5 6 7 8 9 10 1

Sales Revenue Linear (Sales Revenue) Profit & loss

1200 1200

1000 1000

800
800

600
600
400
400
200
200
0
1 2 3 4 5 6 7 8 9 10
0
-200 1

Stock returns Linear (Stock returns) Market returns

GDP GROWTH RATE correlation of all variable companies
942.18 269.34 141.43 34.93
8.50% 942.18 1
5.24% 269.34 0.882517 1
5.46% 141.43 0.934801 0.881627 1
6.39% 34.93 -0.751082 -0.793835 -0.836609 1
7.41% -7.02688315145 0.021077 -0.043634 0.130568 -0.189467
8.00% -0.05991509 0.04765 -0.260666 0.097502 0.005553
8.26% 0.0524 0.467114 0.343618 0.518621 -0.723117
6.80%
6.53%
4.04%
-7.96%

DIRECT EXPENSES STOCK PRICE STOCK RETURN

Mean 99.787 Mean 355.7073 Mean 47.67148

Standard Error 7.534045 Standard Error 110.9255 Standard E 18.30586
Median 94.495 Median 252.77 Median 36.91358
Mode #N/A Mode #N/A Mode #N/A
Standard Deviation 23.82474 Standard Deviatio 367.8983 Standard D 57.8882
Sample Variance 567.6183 Sample Variance 135349.2 Sample Var 3351.044
Kurtosis -0.680761 Kurtosis 0.005489 Kurtosis 4.303462
Skewness 0.413791 Skewness 1.104628 Skewness 1.88375
Range 74.96 Range 1024.25 Range 198.4135
Minimum 66.47 Minimum 34.93 Minimum -7.026883
Maximum 141.43 Maximum 1059.18 Maximum 191.3867
Sum 997.87 Sum 3912.78 Sum 476.7148
Count 10 Count 11 Count 10

1200

1000

800

600

400

200

0
1 2 3 4 5 6 7 8 9 10

Sales Revenue Linear (Sales Revenue) Selling Expenditure

 0
1 2 3 4 5 6 7 8 9 10

Sales Revenue Linear (Sales Revenue) Selling Expenditure

1200

1000

800

600

400

200

0
1 2 3 4 5 6 7 8 9 10

Sales Revenue Linear (Sales Revenue) Stock prices

-7.026883 -0.059915 0.0524 SALES REVENUE PAT DIRECT EXPENSES
SALES REV 1
PAT 0.892651 1
DIRECT EX 0.888495 0.87851451131 1

1
0.119925 1
0.270916 0.28733 1

MARKET RETURN GDP GROWTH RATE

Mean 0.165046 Mean 0.053336

Standard E 0.095667 Standard E 0.013919
Median 0.042415 Median 0.0653
Mode #N/A Mode #N/A
Standard D 0.302527 Standard D 0.046166
Sample Var 0.091522 Sample Var 0.002131
Kurtosis 6.181841 Kurtosis 8.54068
Skewness 2.368282 Skewness -2.808214
Range 1.019016 Range 0.1646
Minimum -0.059915 Minimum -0.0796
Maximum 0.959101 Maximum 0.085
Sum 1.650461 Sum 0.5867
Count 10 Count 11
RECT EXPENSES

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.916966
R Square 0.840826
Adjusted R Sq 0.761239
Standard Error 47.59174
Observations 10

ANOVA
df SS MS F Significance F
Regression 3 71787.52 23929.17 10.56488 0.008277
Residual 6 13589.84 2264.974
Total 9 85377.36

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%Upper 95.0%
Intercept -208.8085 69.46382 -3.006004 0.023823 -378.7804 -38.83669 -378.7804 -38.836691
SALES REVENU 0.277008 0.174849 1.584273 0.164223 -0.150831 0.704847 -0.150831 0.70484732
DIRECT EXPEN 1.69853 1.452643 1.169268 0.286641 -1.855961 5.25302 -1.855961 5.25302033
GDP GROWTH -223.0521 375.359 -0.594237 0.574061 -1141.522 695.4182 -1141.522 695.418157

RESIDUAL OUTPUT

ObservationPredicted PATResiduals
1 280.718 -11.37802
2 266.0707 67.75932
3 296.4341 -13.94411
4 159.8303 -15.95029
 5 96.23143 44.04857
6 99.72648 31.84352
7 157.3956 -41.60557
8 147.1067 -60.95669
9 71.66354 -3.003542
10 51.62318 3.186825
 SUMMARY OUTPUT

Regression Statistics
Multiple R 0.361425
R Square 0.130628
Adjusted R S -0.304058
Standard Err 66.10564
Observations 10

ANOVA
df SS MS F Significance F
Regression 3 3939.659 1313.22 0.300511 0.824314
Residual 6 26219.73 4369.956
Total 9 30159.39

pper 95.0% Coefficients

Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Intercept 52.69854 49.55166 1.063507 0.328469 -68.55001 173.9471 -68.55001
PAT -0.159209 0.269681 -0.59036 0.576493 -0.819095 0.500677 -0.819095
MARKET RET 3.078201 85.3992 0.036045 0.972416 -205.8861 212.0425 -205.8861
GDP GROWTH405.9201 543.3421 0.74708 0.483253 -923.59 1735.43 -923.59

RESIDUAL OUTPUT

Observation
Predicted STOCK RETURN
Residuals
1 30.90297 -37.92986
2 21.74175 29.44635
3 33.87193 -22.85129
4 60.78737 130.5993
 5 63.32183 -15.36468
6 65.28785 -63.29395
7 62.57634 14.42223
8 68.44157 -42.57157
9 58.2175 8.49559
10 11.56566 -0.952114
Upper 95.0%
173.947081
0.50067741
212.042509
1735.43021
Date Price Stock Information
Dec-10 507.78
Nov-10 487.55 FY Stock prices Stock returns
Oct-10 540.97 2010 459.15
Sep-10 543.43 2011 568.78 23.88
Aug-10 519.77 2012 592.71 4.21
Jul-10 505.09 2013 516.06 -12.93
Jun-10 441.3 2014 951.12 84.30
May-10 453.05 2015 1235.56 29.91
Apr-10 461.6 2016 1199.37 -2.93
Mar-10 348.5 2017 1470.57 22.61
Feb-10 338.2 2018 1652.46 12.37
Jan-10 362.6 459.1533 2019 1860.62 12.60
2020 1547.80 -16.81
Dec-11 539.26
Nov-11 557.18
Oct-11 611.11
Sep-11 623.15
Aug-11 592.45
Jul-11 611.25
Jun-11 631.2
May-11 569.58
Apr-11 589.17
Mar-11 533.29
Feb-11 482.18
Jan-11 485.65 568.7892

Dec-12 592.5
Nov-12 590.69
Oct-12 599.77
Sep-12 618.43
Aug-12 565
Jul-12 564.72
Jun-12 569.4
May-12 592.45
Apr-12 614.44
Mar-12 640.05
Feb-12 602.82
Jan-12 562.36 592.7192

Dec-13 615.83

Nov-13 604.63

Oct-13 558.8

Sep-13 466.39

Aug-13 442.82
Jul-13 463.61

Jun-13 480.28

May-13 523.15

Apr-13 513.52

Mar-13 510.37

Feb-13 476.94

Jan-13 536.39 516.0608

Dec-14 1,249.95

Nov-14 1,264.03

Oct-14 1,150.65

Sep-14 1,019.07

Aug-14 1,061.34

Jul-14 1,091.76

Jun-14 996.48

May-14 867.18

Apr-14 750.93

Mar-14 749.82

Feb-14 620.37

Jan-14 591.9 951.12

Dec-15 1,135.83
Nov-15 1,135.83
Oct-15 1,156.39
Sep-15 1,158.47
Aug-15 1,112.13
Jul-15 1,198.29
Jun-15 1,310.42
May-15 1,305.05
Apr-15 1,308.24
Mar-15 1,305.60
Feb-15 1,319.54
Jan-15 1,380.93 1,235.56

Dec-16 1,168.89
Nov-16 1,123.29
Oct-16 1,301.48
Sep-16 1,298.33
Aug-16 1,296.34
Jul-16 1,265.28
Jun-16 1,282.55
May-16 1,145.32
Apr-16 1,172.41
Mar-16 1,170.56
Feb-16 1,087.59
Jan-16 1,080.37 1,199.37

Dec-17 1,787.78
Nov-17 1,547.96
Oct-17 1,522.18
Sep-17 1,405.83
Aug-17 1,396.34
Jul-17 1,440.65
Jun-17 1,449.81
May-17 1,477.73
Apr-17 1,580.05
Mar-17 1,481.30
Feb-17 1,368.75
Jan-17 1,188.47 1,470.57

Dec-18 1,765.97
Nov-18 1,765.65
Oct-18 1,652.13
Sep-18 1,559.54
Aug-18 1,660.46
Jul-18 1,553.94
Jun-18 1,585.51
May-18 1,651.94
Apr-18 1,733.56
Mar-18 1,623.33
Feb-18 1,648.19
Jan-18 1,629.35 1,652.46

Dec-19 2,014.31
Nov-19 1,973.38
Oct-19 2,023.38
Sep-19 1,992.04
Aug-19 1,715.14
Jul-19 1,707.82
Jun-19 1,856.02
May-19 1,752.78
Apr-19 1,828.61
Mar-19 1,893.24
Feb-19 1,792.87
Jan-19 1,777.82 1,860.62

Dec-20 1,705.35
Nov-20 1,570.05
Oct-20 1,476.20
Sep-20 1,461.50
Aug-20 1,625.45
Jul-20 1,470.00
Jun-20 1,545.51
May-20 1,336.76
Apr-20 1,373.75
Mar-20 1,360.74
Feb-20 1,731.30
Jan-20 1,917.04 1,547.80
Dec-10 39 Stock Information
Nov-10 36.55
Oct-10 41.83 FY Stock prices
Stock returns
Sep-10 40.92 2010 37.57
Aug-10 37.45 2011 34.93 -7.03
Jul-10 36.88 2012 52.81 51.19
Jun-10 35.1 2013 58.63 11.02
May-10 34.25 2014 170.84 191.39
Apr-10 37.88 2015 252.77 47.96
Mar-10 35.83 2016 257.81 1.99
Feb-10 36.27 2017 456.32 77.00
Jan-10 38.88 37.57 2018 574.37 25.87
2019 957.55 66.71
Dec-11 33.9 2020 1059.18 10.61
Nov-11 33.92
Oct-11 31.23
Sep-11 33.13
Aug-11 32.42
Jul-11 36.47
Jun-11 36.65
May-11 37.55
Apr-11 37.9
Mar-11 35.5
Feb-11 35.1
Jan-11 35.42 34.9325

Dec-12 79.78
Nov-12 62.28
Oct-12 62.5
Sep-12 52.53
Aug-12 50
Jul-12 48.15
Jun-12 54.65
May-12 54.88
Apr-12 46.47
Mar-12 41.72
Feb-12 41.65
Jan-12 39.13 52.81166667

Dec-13 95.5
Nov-13 85.1
Oct-13 55.65
Sep-13 46.25
Aug-13 42.5
Jul-13 51.15
Jun-13 50.85
May-13 53.03
Apr-13 52.5
Mar-13 51.88
Feb-13 50.75
Jan-13 68.5 58.63833333

Dec-14 215.18
Nov-14 210.8
Oct-14 214.13
Sep-14 210.3
Aug-14 209.7
Jul-14 174.35
Jun-14 165.25
May-14 134.63
Apr-14 133.2
Mar-14 140.52
Feb-14 130.57
Jan-14 111.47 170.8416667

Dec-15 234.15
Nov-15 197.07
Oct-15 214.75
Sep-15 227.65
Aug-15 244.55
Jul-15 275.85
Jun-15 262.3
May-15 289.75
Apr-15 300.77
Mar-15 261.95
Feb-15 253.32
Jan-15 271.15 252.7716667

Dec-16 294.25
Nov-16 297.63
Oct-16 295.35
Sep-16 310.42
Aug-16 297.65
Jul-16 273.95
Jun-16 274.1
May-16 233.25
Apr-16 227.77
Mar-16 194.52
Feb-16 187.63
Jan-16 207.2 257.81

Dec-17 498.95
Nov-17 486.92
Oct-17 509.95
Sep-17 481.77
Aug-17 512.55
Jul-17 518.88
Jun-17 460.27
May-17 464.13
Apr-17 432.65
Mar-17 379
Feb-17 362.45
Jan-17 368.4 456.3266667

Dec-18 826.7
Nov-18 725.4
Oct-18 775.5
Sep-18 599.88
Aug-18 706.35
Jul-18 482.8
Jun-18 473.4
May-18 499.7
Apr-18 449.4
Mar-18 451.27
Feb-18 426.13
Jan-18 476.02 574.3791667

Dec-19 991.9
Nov-19 995.35
Oct-19 1,083.68
Sep-19 1,074.78
Aug-19 1,059.72
Jul-19 908.4
Jun-19 1,063.85
May-19 1,078.00
Apr-19 901.2
Mar-19 822.17
Feb-19 722.17
Jan-19 789.38 957.55

Dec-20 1,208.20
Nov-20 1,177.85
Oct-20 1,209.65
Sep-20 1,336.55
Aug 2020 E 1,007.45
Jul-20 977.95
Jun-20 964.2
May-20 1,016.60
Apr-20 985.6
Mar-20 774.55
Feb-20 939.75
Jan-20 1,111.85 1,059.18