Please Note: Blog posts are not selected, edited or screened by Seeking Alpha editors.

Past, Present And Future Stock Prices For Ford Motor Inc

|Includes: Ford Motor Company (F)
Summary

Using it's ten year price history & earnings data my spreadsheet I made gives me these results.

My objective is to decode the algorithms which are the main drivers of stock prices as they decide what the high speed computers do with stock & economic news.

I call my effort to decode the algorithms my Venona Project after the FBI decryption efforts to decode Soviet cryptographic communications.

Pattern analysis and the results of the formulas in myspreadsheet can provide an insight into likely future price movements in thefuture.

The projected prices are the result of the spreadsheet, not megerrymandering the data to make it look better. Results generated immediatelyupon data entered.

<>

HIGH

<>

LOW

<>

P/E

P/E

LONG RANGE

<>

P/E

LONG

<>

<>

HIGH

<>

RANGE

<>

<>

25.70

<>

-10.50

<>

<>

<>

<>

<>

<>

<>

CORR'D

<>

<>

EARN DATE

DATE OF

REAL

DELTA

REAL

REAL

DELTA

<>

<>

EX-DIV DATE

HI LOW

HIGH

QTR

DIV BY

PROJ'D

REAL>

<>

<>

APPROX'Y

IN QTR

LOW

HI-LO

PROJ'\D

PRICE

PRED

<>

<>

<>

<>

<>

<>

<>

~Q3>2018/10/25

12/31/2019

20.00

-0.80

-2.30

7.09

0.646

<>

<>

~16/10/2018

12/31/2019

4.00

Q3>18

0.19

8.42

-1.106

<>

<>

<>

<>

<>

<>

<>

Q2>2018/07/25

10/12/2018-F

8.55

0.19

-0.81

8.50

0.006

<>

<>

~7/24/2018

7/26/2018

10.16

Q2>18

0.40

10.20

-0.004

<>

<>

<>

<>

<>

<>

<>

Q1>2018/04/25

7/25/2018

10.12

0.20

-0.81

10.37

-0.025

<>

<>

4/19/2018

6/13/2018

12.15

Q1>18

0.40

11.81

0.028

<>

<>

<>

<>

<>

<>

<>

Q4- 2018/01/29

3/2/2018-F

10.14

0.14

-0.83

12.05

-0.189

<>

<>

~1/29/2018

4/10/2018

11.55

Q4>17

0.39

14.20

-0.230

<>

<>

<>

<>

<>

<>

<>

Q3-2017/10/26

1/24/2018

11.44

0.18

-0.99

10.73

0.062

<>

<>

~10/20/2017

1/15/2018

13.48

Q3>17

0.47

12.76

0.053

<>

<>

<>

<>

<>

<>

<>

Q2-2017/07/26

8/18/2017-F

10.47

0.19

-0.92

12.68

-0.211

<>

<>

~7/20/2017

10/4/2017

12.46

Q2>17

0.45

14.06

-0.128

<>

<>

<>

<>

<>

<>

<>

Q1-2017/04/27

5/17/2017

10.67

0.11

-1.12

12.23

-0.146

<>

<>

4/18/2017>E-D

7/19/2017

11.83

Q1>17

0.51

14.13

-0.195

<>

<>

<>

<>

<>

<>

<>

Q4-2017/01/26

4/18/2017

11.08

0.16

-1.28

9.41

0.150

<>

<>

1/18/2017>E-D

1/30/2017

12.80

Q4>16

0.61

11.28

0.118

<>

<>

<>

<>

<>

<>

<>

Q3-2016/10/27

11/14/2016

11.07

0.20

-1.09

9.76

0.118

<>

<>

10/25/2016

1/9/2017

13.27

Q3>16

0.53

11.68

0.119

<>

<>

<>

<>

<>

<>

<>

Q2-2016/07/28

10/18/2016

11.69

0.20

-0.96

10.35

0.114

<>

<>

7/26/2016

8/1/2016

13.99

Q2>16

0.47

12.27

0.123

<>

<>

<>

<>

<>

<>

<>

Q1-2016/04/28

6/30/2016

12.00

0.19

-0.85

10.08

0.160

<>

<>

4/27/2016

5/3/2016

14.22

Q1>16

0.41

12.70

0.107

<>

<>

<>

<>

<>

<>

<>

Q4-2016/01/28

2/8/2016

11.02

0.26

-0.72

11.73

-0.065

<>

<>

Q4-2015

4/26/2016

13.88

Q4>15

0.37

16.20

-0.167

<>

<>

<>

<>

<>

<>

<>

Q3-2015/10/27

1/25/2016

11.47

0.38

-0.76

13.16

-0.147

<>

<>

10/28/2015

10/29/2015

15.84

Q3>15

0.43

19.77

-0.248

<>

<>

<>

<>

<>

<>

<>

Q2-2015/07/28

8/27/2015

10.44

0.50

-0.87

17.51

-0.677

<>

<>

7/29/2015

10/26/2015

15.69

Q2>15

0.54

19.75

-0.259

<>

<>

<>

<>

<>

<>

<>

Q1-2015/04/28

7/14/2015

14.27

0.13

-1.47

16.80

-0.177

<>

<>

4/29/2015

5/4/2015

16.10

Q1>15

0.68

19.67

-0.222

<>

<>

<>

<>

<>

<>

<>

Q4-2015/01/29

2/3/2015

14.30

0.17

-1.73

14.53

-0.016

<>

<>

1/28/2015

3/26/2015

16.74

Q4>14

0.83

17.13

-0.023

<>

<>

<>

<>

<>

<>

<>

Q3-2014/10/24

10/30/2014

13.68

0.18

-1.75

12.28

0.102

<>

<>

10/29/2014

12/3/2014

16.13

Q3>14

0.84

16.55

-0.026

<>

<>

<>

<>

<>

<>

<>

Q2-2014/07/23

10/15/2014

13.26

0.35

-1.57

14.94

-0.127

<>

<>

7/30/2014

9/3/2014

17.87

Q2>14

0.87

17.54

0.018

<>

<>

<>

<>

<>

<>

<>

Q1-2014/04/24

5/7/2014

15.43

0.17

-1.77

12.78

0.172

<>

<>

4/30/2014

7/24/2014

18.12

Q1>14

0.85

14.63

0.192

<>

<>

<>

<>

<>

<>

<>

Q4-2014/01/24

2/3/2014

14.40

0.15

-1.47

15.21

-0.056

<>

<>

1/29/2014

4/4/2014

16.49

Q4>13

0.69

18.15

-0.101

<>

<>

<>

<>

<>

<>

<>

Q3-2013/10/22

12/24/2013

15.10

0.19

-1.55

14.77

0.022

<>

<>

10/30/2013

10/24/2013

18.02

Q3>13

0.76

16.70

0.073

<>

<>

<>

<>

<>

<>

<>

Q2-2013/07/22

8/28/2013

15.71

0.13

-1.52

13.47

0.143

<>

<>

7/31/2013

9/19/2013

17.77

Q2>13

0.70

17.76

0.000

<>

<>

<>

<>

<>

<>

<>

Q1-2013/04/23

4/23/2013

13.11

0.32

-1.30

12.53

0.044

<>

<>

AFTER

7/15/2013

17.29

Q1>13

0.70

14.31

0.172

<>

<>

<>

<>

<>

<>

<>

Q4-2013/01/23

2/25/2013

12.10

0.14

-1.24

3.32

0.726

<>

<>

Q4=2012

1/28/2013

13.82

Q4>12

0.58

4.65

0.664

<>

<>

<>

<>

<>

<>

<>

Q3-2012/10/25

10/26/2012

10.22

0.40

-0.34

8.80

0.139

<>

<>

AFTER

1/17/2013

14.30

Q3>12

0.19

10.64

0.256

<>

<>

<>

<>

<>

<>

<>

Q2-2012/07/24

8/2/2012

8.82

0.21

-0.29

8.41

0.046

<>

<>

AFTER

9/19/2012

10.66

Q2>12

0.14

10.11

0.051

<>

<>

<>

<>

<>

<>

Q1-2012/05/21

7/23/2012

9.05

0.20

-0.28

9.44

-0.043

<>

<>

AFTER

5/29/2012

10.88

Q1>12

0.14

12.36

-0.136

<>

<>

<>

<>

<>

<>

<>

Q4-2012/01/23

5/18/2012

9.96

0.31

-0.29

28.84

-1.896

<>

<>

Q4-2011

1/26/2012

13.05

Q4>11

0.16

38.40

-1.942

<>

<>

<>

<>

<>

<>

<>

Q3-2011/10/25

11/25/2011

9.75

0.33

-0.85

8.59

0.119

<>

<>

AFTER

1/25/2012

12.98

Q3>11

0.46

12.75

0.018

<>

<>

<>

<>

<>

<>

<>

Q2-2011/07/24

4/10/2011

9.05

0.49

-0.74

12.56

-0.388

<>

<>

AFTER

7/26/2011

13.44

Q2>11

0.45

16.09

-0.197

<>

<>

<>

<>

<>

<>

<>

Q1-2011/05/21

7/18/2011

12.63

0.28

-1.03

14.66

-0.161

<>

<>

AFTER

4/26/2011

16.18

Q1>11

0.54

20.13

-0.244

<>

<>

<>

<>

<>

<>

<>

Q4-2011/01/23

3/15/2011

13.75

0.37

-1.20

12.28

0.107

<>

<>

Q4-2010

1/27/2011

18.88

Q4>10

0.67

16.93

0.103

<>

<>

<>

<>

<>

<>

<>

Q3-2010/10/25

10/26/2010

13.77

0.38

-1.07

12.27

0.109

<>

<>

AFTER

1/13/2011

18.97

Q3>10

0.60

15.87

0.164

<>

<>

<>

<>

<>

<>

<>

Q2-2010/07/24

8/25/2010

10.95

0.29

-0.96

8.26

0.246

<>

<>

AFTER

10/21/2010

14.16

Q2>10

0.50

12.34

0.129

<>

<>

<>

<>

<>

<>

<>

Q1-2010/05/21

6/29/2010

9.75

0.49

-0.72

23.91

-1.452

<>

<>

AFTER

4/26/2010

14.57

Q1>10

0.44

33.14

-1.274

<>

<>

<>

<>

<>

<>

<>

Q4-2010/01/23

5/2/2010

10.49

0.39

-1.77

-2.99

1.285

<>

<>

Q4-2009

3/18/2010

14.54

Q4>09

1.00

-5.33

1.366

<>

<>

<>

<>

<>

<>

<>

Q3-2009/10/25

10/30/2009

6.81

0.78

0.50

5.66

0.169

<>

<>

AFTER

11/1/2010

12.14

Q3>09

-0.37

7.58

0.375

<>

<>

<>

<>

<>

<>

<>

Q2-2009/07/24

2/10/2009

6.61

0.34

0.42

1.39

0.790

<>

<>

AFTER

3/8/2009

8.86

Q2>09

-0.23

2.29

0.742

<>

<>

<>

<>

<>

<>

<>

Q1-2009/05/21

4/23/2009

4.31

0.65

0.09

1.65

0.617

<>

<>

AFTER

7/23/2009

7.10

Q1>09

-0.06

4.86

0.315

<>

<>

<>

<>

<>

<>

<>

Q4-2009/01/23

2/20/2009

1.50

1.95

0.03

1.23

0.182

<>

<>

Q4-2008

4/22/2009

4.42

Q4>08

-0.04

4.30

0.027

<>

<>

<>

<>

<>

<>

<>

Q3-2008/10/25

11/20/2008

1.01

2.50

0.03

1.83

-0.810

<>

<>

AFTER

8/12/2008

3.54

Q3>08

-0.04

5.69

-0.607

<>

<>

<>

<>

<>

<>

<>

Q2-2008/07/24

10/10/2008

1.88

2.11

0.05

19.93

-9.603

<>

<>

AFTER

7/24/2008

5.85

Q2>08

-0.06

40.75

-5.965

<>

<>

<>

<>

<>

<>

<>

Q1-2008/05/21

3/7/2008

4.30

1.04

0.53

4.23

0.016

<>

<>

AFTER

4/24/2008

8.79

Q1>08

-0.44

6.72

0.235

<>

<>

<>

<>

<>

<>

<>

Q4-2008/01/23

3/17/2008

4.95

0.59

0.52

-151.80

31.667

<>

<>

Q4-2007

4/22/2008

7.86

Q4>07

-0.34

-248.12

32.568

<>

<>

<>

<>

<>

<>

<>

Q3-2007/10/25

1/22/2008

5.50

0.63

-15.93

0.00

1.000

<>

<>

AFTER

5/11/2007

8.99

Q3>07

10.63

0.00

1.000

<>

<>

<>

<>

<>

<>

THEORETICAL HIGHS AND LOWS are BASED ON HIGH & LOW P/E’S QTR BY QTR. This is then corrected by multiplying by the REAL/Proj’d column Which is determined from the prior qtr’ly results acting as a current SENTIMENT

VARIABLE which in reality is how the market currently views the given stock.

FIRST 5 YEARS AT LEAST USING NON GAAP EARNINGS, LAST FIVE FROM

NASDAQ WHICH LIKELY USES GAAP EPS. The projected prices are automatically

Generated once eps entered on date of earnings.

4-QTR                                  PROJ       PROJ

DATE            QTR EPS      %+- TR-EPS    HIGH      LOW

<>

10/26/2018

Q3>18

0.33

1.42

24.01

-9.81

<>

<>

7/25/2018

Q2>18

0.27

<<<<

1.52

25.70

-10.50

<>

<>

4/25/2018

Q1>18

0.43

1.81

30.60

-12.50

<>

<>

29-Jan-18

Q4>17

0.39

1.77

29.93

-12.23

<>

<>

10/26/2017

Q3>17

0.43

1.68

28.40

-11.60

<>

<>

26-Jul-17

Q2>17

0.56

1.64

27.73

-11.33

<>

<>

27-Apr-17

Q1>17

0.39

1

1.38

23.33

-9.53

<>

<>

1/26/2017

Q4>16

0.3

,13+

1.25

21.13

-8.63

<>

<>

10/27/2016

Q3>16

0.39

,03+

1.47

24.85

-10.15

<>

<>

7/28/2016

Q2>16

0.3

,01-

1.76

29.76

-12.16

<>

<>

4/28/2016

Q1>16

0.26

,06+

2.04

34.49

-14.09

<>

<>

1/28/2016

Q4>15

0.52

,08-

2.23

37.70

-15.40

<>

<>

10/27/2015

Q3>15

0.68

,22 +

2.18

36.86

-15.06

<>

<>

7/28/2015

Q2>15

0.58

,08 +

1.73

29.25

-11.95

<>

<>

4/28/2015

Q1>15

0.45

,02 -

1.41

23.84

-9.74

<>

<>

1/29/2015

Q4>14

0.47

,1 +

1.2

20.29

-8.29

<>

<>

10/24/2014

Q3>14

0.23

,03-

1.13

19.10

-7.80

<>

<>

7/23/2014

Q2>14

0.26

,03+

1.22

20.63

-8.43

<>

<>

4/24/2014

Q1>14

0.24

,05+

1.26

21.30

-8.70

<>

<>

1/24/2014

Q4>13

0.4

,03+

1.42

24.01

-9.81

<>

<>

10/22/2013

Q3>13

0.32

,06-

1.41

23.84

-9.74

<>

<>

7/22/2013

Q2>13

0.3

1.5

25.36

-10.36

<>

<>

4/23/2013

Q1>13

0.4

1.46

24.68

-10.08

<>

<>

1/23/2013

Q4>12

0.39

1.41

23.84

-9.74

<>

<>

10/25/2012

Q3>12

0.41

4.34

73.38

-29.98

<>

<>

7/24/2012

Q2>12

0.26

4.35

73.55

-30.04

<>

<>

5/21/2012

Q1>12

0.35

4.68

79.12

-32.32

<>

<>

~1/26/2012

Q4>11

3.32

4.94

83.52

-34.12

<>

<>

~10/23/2011

Q3>11

0.42

1.67

28.23

-11.53

<>

<>

~7/24/2011

Q2>11

0.59

1.76

29.76

-12.16

<>

<>

~4/23/2011

Q1>11

0.61

1.77

29.93

-12.23

<>

<>

~1/26/2011

Q4>10

0.05

1.66

28.07

-11.47

<>

<>

~10/23/2010

Q3>10

0.51

1.86

31.45

-12.85

<>

<>

~7/24/2010

Q2>10

0.6

1.66

28.07

-11.47

<>

<>

~4/23/2010

Q1>10

0.5

1.96

33.14

-13.54

<>

<>

~1/26/2010

Q4>09

0.25

0.86

14.54

-5.94

<>

<>

~10/23/2009

Q3>09

0.31

-1.96

-33.14

13.54

<>

<>

~7/24/2009

Q2>09

0.9

-2.29

-38.72

15.82

<>

<>

~4/23/2009

Q1>09

-0.6

-7.11

-120.21

49.11

<>

<>

~1/26/2009

Q4>08

-2.57

-6.46

-109.22

44.62

<>

<>

~10/23/2008

Q3>08

-0.02

-5.32

-89.95

36.74

<>

<>

~7/24/2008

Q2>08

-3.92

-5.47

-92.48

37.78

<>

<>

~4/23/2008

Q1>08

0.05

-1.18

-19.95

8.15

<>

<>

~1/26/2008

Q4>07

-1.43

XXXX

-1.38

-23.33

9.53

<>

<>

~10/23/2007

Q3>07

-0.17

0.05

0.85

-0.35

<>

<>

~7/24/2007

Q2>07

0.37

0.22

3.72

-1.52

<>

<>

~4/23/2007

Q1>07

-0.15

-0.15

-2.54

1.04

<>

Disclosure: I am/we are long F.

Additional disclosure: I,ve been an on again off again stakeholder in Ford motor since 2000