Example Revenue Projection Calculation

Owned by Štěpán Vacek
yesterday at 11:25 am
1 min read

regressionFactor

 

 

 

 

 

 

Slope

161.24

 

 

 

 

 

interception

-310.7

 

 

 

 

 

 

 

 

 

 

 

 

 

Month

Revenue

Seasonality Adjustment

regression

Projected Revenue

 

1

Jan-21

100

 

 

 

 

2

Feb-21

150

 

 

 

 

3

Mar-21

200

 

 

 

 

4

Apr-21

150

 

 

 

 

5

May-21

300

 

 

 

 

6

Jun-21

200

 

 

 

 

7

Jul-21

100

 

 

 

 

8

Aug-21

80

 

 

 

 

9

Sep-21

350

 

 

 

 

10

Oct-21

500

 

 

 

 

11

Nov-21

600

 

 

 

 

12

Dec-21

650

 

 

 

 

13

Jan-22

 

0.36

1,785.42

633.88

 

14

Feb-22

 

0.53

1,946.66

1,036.68

 

15

Mar-22

 

0.71

2,107.90

1,496.73

 

 

 

 

 

 

 

 

==> Average Value

281.6667

 

 

Â