|PLTR.xlsx
|
MainModels
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q42220202021202220232024202520262027202820292030
3Revenue251.889289.366322.091341.234375.642392.146432.867446.357470490.1825541.083751092.6731541.8891947.62324999999992337.14792804.577483365.4929764038.59157119999964846.309885445815.571862528
4COGS68.41149.3470.50374.11190.92686.80487.56394.4039498.03649999999999108.21674999999999352.547339.404389.52464999999984467.42958560.9154960000001673.0985951999996807.7183142399999969.26197708799961163.1143725056
5Gross Profit183.479140.02599999999998251.58800000000002267.123284.716305.342345.30400000000003351.954376392.146432.867740.1261202.4851558.09861869.718322243.6619842692.39438080000043230.87325695999973877.0479083524652.4574900224
6S&M102.518334.911147.619136.097162.379153.443162.593160.485161.485162.485163.485683.701614.512675.9632743.5595200000001817.9154720000002899.7070192000003989.67772112000051088.64549323200051197.5100425552007
7R&D86.815313.91594.1398.471110.52494.31684.17688.60189.60190.60191.601560.66387.487426.23570000000007468.8592700000001515.7451970000002567.3197167000003624.0516883700004686.4568572070006755.1025429277007
8G&A93.291338.977166.411146.569157.961149.524157.478142.307143.307144.307145.307669.444611.532672.6852000000001739.9537200000002813.9490920000003895.3440012000004984.87840132000051083.36624145200061191.7028655972008
9OpEx282.624987.803408.15999999999997381.137430.86400000000003397.283404.247391.39300000000003394.39300000000003397.39300000000003400.393000000000031913.80499999999981613.5311774.88410000000021952.37251000000042147.60976100000062362.3707371000012598.60781081000142858.4685918910023144.3154510801023
10OpInc-99.14500000000001-847.777-156.57199999999995-114.01400000000001-146.14800000000002-91.94100000000003-58.942999999999984-39.43900000000002-18.39300000000003-5.24700000000001432.47399999999999-1173.6789999999999-411.04600000000005-216.78550000000018-82.6541900000004396.05222299999923330.0236436999994632.26544614999831018.57931646099811508.1420389422974
11IntInc-5.095-1.591-1.4460000000000002-1.464-0.21799999999999997-0.22999999999999998-0.121-0.04699999999999993000-9.459-2.03300000000000040000000
12Pretax Income-94.05000000000001-846.186-155.12599999999995-112.55000000000001-145.93000000000004-91.71100000000003-58.82199999999998-39.392000000000024-18.39300000000003-5.24700000000001432.47399999999999-1183.138-413.07900000000006-216.78550000000018-82.6541900000004396.05222299999923330.0236436999994632.26544614999831018.57931646099811508.1420389422974
13Taxes0.943-8.543-7.5933.102-5.6611.43833.0062.023000-12.63631.88500033.00236436999994563.22654461499983101.85793164609981150.81420389422973
14Net Income-94.99300000000001-837.643-147.53299999999996-115.65200000000002-140.26900000000003-93.14900000000003-91.82799999999997-41.41500000000003-18.39300000000003-5.24700000000001432.47399999999999-1170.502-444.96400000000006-216.78550000000018-82.6541900000004396.05222299999923297.02127932999946569.0389015349984916.72138481489831357.3278350480678
15Shares-0.14827157237200492-0.9251001146376104-0.08365853630875625-0.06350464923965961-0.07403597370640652-0.0474186708884924-0.045645513091992884-0.020338288872945007-0.00903252800289938-0.0025767234508352690.01594749711119197-1.195206927184912-0.23131631712549852-0.1064601261008287-0.040590240076766630.0471698142765306150.14586272076361740.279446518395801040.4501882009023680.6665634577929889
16S/O640.669905.4621763.5141821.1581894.6061964.3952011.7642036.3072036.3072036.3072036.307979.331923.6172036.3072036.3072036.3072036.3072036.3072036.3072036.307
17
18
19Revenue Growth0.491299739170825140.35519031261447440.343927647776560040.30806719142875580.25119129383828230.250.250.411116592063682340.263141023770193660.199999999999999960.199999999999999960.199999999999999960.199999999999999960.199999999999999960.19999999999999996
20Gross Margin0.72841211803611920.483906194922693040.78110844450791860.78281472537906540.75794506471587310.77864366842961540.79771384744043780.7885033728607370.80.80.80.67735360899372450.77987779924495220.80.80.79999999999999990.80000000000000020.80.80.8
21
22
23Cash2585.0000000000005
24AR256.554
25Prepaids115.042
26PP&E41.866
27Lease224.888
28Other95.829
29Assets3319.1790000000005
30
31AP27.454
32AL150.176
33DR251.765
34Customer255.184
35Lease267.662
36ONCL2.192
37SE2364.746
38L+SE3319.179
39
40CFFO11688135477-296608333851