i need help in finance valuation for psx company and i attached same paperwork from different company from last semester
cipbw1
faisal_psx.xlsSheet: PSX Income Statement
Sheet: Sheet3
Sheet: NOPLAT
Sheet: Beta
PHILLIPS 66 (PSX) CashFlowFlag INCOME STATEMENT
Fiscal year ends in December. USD in millions except per share data.
Common Size Analysis
Fiscal Year
Net Sales
1.0
1.0
1.0
1.0
1.0
Cost of Sales
0.8542899453358767
0.8480398606479072
0.8445293622418298
0.8818377580826862
0.8696655365407383
Gross profit
0.1457100546641234
0.15196013935209285
0.15547063775817016
0.11816224191731385
0.13033446345926164
Sales, General and administrative
0.01013449690114752
0.03251548833298057
0.009413848525601076
0.007023438045201232
0.009310085028522225
Other operating expenses
0.09877935073403497
0.08635138923053161
0.10980636555471732
0.07812017107480036
0.11215154450543537
Total operating expenses
0.10891384763518248
0.11886687756351218
0.11922021408031838
0.0851436091200016
0.12146162953395759
EBIT=Operating income
0.0367962070289409
0.03309326178858068
0.036250423677851765
0.03301863279731225
0.008872833925304057
Interest Expense
1.1470672949647904
0.0016271260809419049
0.0015731455474260478
6.270800094930027E-6
8.473984866459968E-5
6.726940049510279E-6
Interest Income
-1.5844673447374354E-4
9.152846821387915E-5
0.0013448355036572966
8.473984866459968E-5
6.726940049510279E-6
Income before taxes
0.03501063421352526
0.03161164470936851
0.036250423677851765
0.03301863279731225
0.008872833925304057
Provision for income taxes
0.010079649954598917
0.010548655961649571
0.013667027476192039
0.00919178123161893
0.0038948982886664514
Net income from continuing operations
0.024930984258926342
0.02106298874771894
0.022583396201659722
0.02382685156569332
0.0049779356366376065
Net income from discontinuing ops
0.004302438251479344
3.4895228506541423E-4
0.0
0.0
0.0
Other
-2.1329368102234708E-4
-9.72489974772466E-5
-3.8267676933337704E-5
-2.4923484901352847E-5
-3.3634700247551394E-5
Net income
0.02902012882938334
0.021314692035307108
0.022545128524726385
0.02380192808079197
0.0049443009363900545
EPS
0.0
0.0
0.0
0.0
0.0
Basic
5.11904834453633E-5
3.47236126286404E-5
3.580761198762314E-5
0.0
0.0
Diluted
5.0763896083318605E-5
3.4437586165472025E-5
3.5424935218289765E-5
Basic
Diluted
Sales Growth Rate
-0.06130119158624556
-0.0443522375657384
-0.08818925897494691
0.34951835109245505
Marginal Tax Rate
Weighted Average Shares Outstanding
0.0
0.0
0.0
EBITDA
0.04270139494067388
0.03860213146920353
0.042586457615814394
PHILLIPS 66 (PSX) CashFlowFlag BALANCE SHEETS
Fiscal year ends in December. USD in millions except per share data.
Fiscal Year
Total cash
0.03173200563095318
0.030890858022184213
0.018991701380916458
0.0
0.0
Receivables
0.03842942721505488
0.04519218118060283
0.04697630684116727
0.049971587227212455
0.06870223872564847
Inventories
0.0207016752695118
0.019186655149334417
0.018751161697335476
0.017276959733617793
0.027667904423635776
Prepaid expenses
0.005100766029020129
0.0048681704031256975
0.003580761198762314
0.0022780065199836503
0.0025427833387148854
Other current assets
0.005783305808291639
0.009907956684152418
0.009894927892763035
0.0
0.0
Total current assets
0.10174717995283163
0.11004582143939957
0.09819485901094456
0.06952655348081391
0.09891292648799914
Gross property, plant and equipment
0.16542448489576034
0.13972964778701324
0.13026863909207204
0.1154256432751453
0.16559035625874502
Accumulated Depreciation
-0.059716136581085114
-0.05164493818968131
-0.04604148216179574
-0.04179668417956872
-0.06193493703584114
Net property, plant and equipment
0.10570834831467521
0.08808470959733194
0.0842271569302763
0.07362895909557658
0.10365541922290389
Equity and other investments
0.06209283759819127
0.06418433833498276
0.057242977881282735
0.05137228707866849
0.06671779141104295
Goodwill
0.01995210033334755
0.017710758599385614
0.01828101595215447
0.016609010338261537
0.02443897319987084
Intangible assets
0.0054846946548603535
0.003992929425830478
0.0039579711571052145
0.0036487981895580567
0.005226832418469486
Other long-term assets
0.002047619337814532
8.523588602417496E-4
9.020238134286745E-4
6.081330315930094E-4
0.0034576471854482834
Total non-current assets
0.1952856002388889
0.17482509481777253
0.16461114573424737
0.14586718773365767
0.20349666343773545
Total assets
0.2970327801917205
0.2848709162571721
0.26280600474519195
0.21539374121447158
0.3024095899257346
Short-term debt
0.0051312365548804644
1.3729270232081873E-4
7.10685428761986E-5
1.4954090940811707E-4
1.9508126143579808E-4
Accounts payable
0.04563265952843814
0.05690782511197936
0.05854954570800669
0.05379484981107999
0.072321332472285
Taxes payable
0.005350624341074878
0.004988301517656414
0.00492559670241961
0.005418365617554109
0.00795124313852115
Accrued liabilities
0.007983277775407848
0.005405900153882237
0.004690523829829108
0.0023677310656285205
0.003639274566785061
Other current liabilities
0.0035102045791106265
0.006532844418765624
0.0
0.0
0.0
Total current liabilities
0.06760800277891196
0.07397216390460445
0.06823673478313161
0.06173048740367073
0.08410693143902702
Long-term debt
0.04778997275934988
0.03507256491370581
0.03805447130470911
0.0017994756098776755
0.0026100527392099882
Deferred taxes liabilities
0.03346273149982022
0.035038241738125614
0.029761319032155783
0.028926196576510115
0.03240367021849101
Minority interest
0.002724065011913976
0.0025284739344084116
1.6947114070478127E-4
1.445562124278465E-4
1.6817350123775698E-4
Other long-term liabilities
0.013876277476796695
0.012693854435412365
0.01301101015733482
0.00682903486297068
0.00821359380045205
Total non-current liabilities
0.09785304674788077
0.0853331350216522
0.0809962716349045
0.03769926326178632
0.04339549025939081
Total liabilities
0.16546104952679275
0.15930529892625667
0.1492330064180361
0.09942975066545705
0.12750242169841783
Common stock
3.6564631032402355E-5
3.432317558020468E-5
3.280086594286089E-5
0.0
0.0
Additional paid-in capital
0.11603176247615682
0.10804363619722096
0.10237150260766885
0.0
0.0
Retained earnings
0.056730025046772256
0.032160815518651784
0.0148314582171636
0.0
0.0
Treasury stock
-0.037990651642666046
-0.014884817143282096
-0.0019461847126097463
0.0
0.0
Accumulated other comprehensive income
-0.003235969846367609
2.1165958274459553E-4
-0.00171657865100972
0.11596399054901453
0.17490716822731675
Total stockholders' equity
0.1315717306649278
0.12556561733091545
0.11357299832715584
0.11596399054901453
0.17490716822731675
Total liabilities and stockholders' equity
0.2970327801917205
0.2848709162571721
0.26280600474519195
0.21539374121447158
0.3024095899257346
CHECK (total assets=total liabilities-total equity)
PHILLIPS 66 (PSX) Statement of CASH FLOW
Fiscal year ends in December. USD in millions except per share data.
Fiscal Year
Cash Flows From Operating Activities
Net income
0.029233422510405685
0.021411941032784352
0.022583396201659722
0.02382685156569332
0.0049779356366376065
Depreciation & amortization
0.0060636346462067245
0.005417341212408972
0.004991198434305333
0.004526104858085677
0.005919707243569045
Amortization of debt discount/premium and issuance costs
1.4625852412960942E-4
1.3729270232081873E-4
1.366702747619204E-4
0.0
0.0
Investment/asset impairment charges
9.14115775810059E-4
1.6589534863765596E-4
0.006330567126972152
0.0023527769746877086
0.011429071144117963
Deferred income taxes
-0.002973923323968725
0.0033979943824402636
0.0012081652288953762
0.0046407528886319
-2.219890216338392E-4
(Gain) Loss from discontinued operations
-0.004302438251479344
-3.4895228506541423E-4
0.0
0.0
0.0
Inventory
-5.179989396257E-4
2.1738011200796297E-4
3.0067460447622484E-4
0.003070573339846671
-0.0023140673770315357
Prepaid expenses
-0.0019257372343731908
1.1441058526734893E-4
-2.6240692754288714E-4
1.3957151544757593E-4
-1.3453880099020557E-5
Accounts payable
-0.02025071148677884
0.0020593905348122808
-0.005384808825619663
2.89112424855693E-4
0.020201000968679366
Income taxes payable
0.0029129822722480546
-1.0869005600398149E-4
-1.9133838466668855E-4
-9.969393960541138E-4
0.0010964912280701754
Other working capital
0.013565478113021275
0.002751574575679742
-7.817539716381846E-4
-9.271536383303259E-4
-0.02030863200947153
Other non-cash items
-0.0013589854533709543
-7.379482749744007E-4
-0.005444943746514908
-0.011968257449629637
-0.006693305349262727
Net cash provided by operating activities
0.021506097152224655
0.0344776298703156
0.0234854200150884
0.02495339308323447
0.014072758583575503
Cash Flows From Investing Activities
0.0
0.0
0.0
0.0
0.0
Investments in property, plant, and equipment
-0.022993058814209016
-0.010176821559530688
-0.009408381714610599
-0.005094360313836522
-0.007735981056936821
Other investing activities
0.009000993339143048
0.007636906566595541
0.0010168268442286876
0.01751622518867078
0.0033500161446561186
Net cash used for investing activities
-0.013992065475065969
-0.0025399149929351463
-0.008391554870381911
0.012421864874834258
-0.0043859649122807015
Cash Flows From Financing Activities
0.0
0.0
0.0
0.0
0.0
Debt issued
2487.0
7794.0
0.015156039562930776
0.0
0.042608324859776295
0.0
0.0
Debt repayment
-2.986111534312859E-4
-0.005834939848634796
-0.006614841298476946
-1.296021214870348E-4
-1.7490044128726725E-4
Common stock issued
6.094105172067059E-6
0.0023454169979806533
2.569401165524103E-4
0.0
0.0
Common stock repurchased
-0.01390674800265703
-0.012848308725523285
-0.0019461847126097463
0.0
0.0
Dividend paid
-0.006471939692735218
-0.004673672408171204
-0.030269732454270126
0.0
0.0
Other financing activities
-0.002785006063634646
-3.432317558020468E-5
-2.132056286285958E-4
-0.037245655836581695
-0.009511893230007534
Net cash provided by (used for) financing activities
-0.008300171244355335
-0.021045827159928837
0.003821300882343294
-0.03737525795806873
-0.009686793671294802
Effect of exchange rate changes
-3.900227310122918E-4
1.2585164379408384E-4
7.653535386667541E-5
0.0
0.0
Net change in cash
-0.0011761622982089425
0.011017739361245702
0.018991701380916458
0.0
0.0
Cash at beginning of period
0.032908167929162124
0.01987311866093851
0.0
0.0
0.0
Cash at end of period
0.03173200563095318
0.030890858022184213
0.018991701380916458
0.0
0.0
Free Cash Flow
0.0
0.0
0.0
0.0
0.0
Operating cash flow
0.021506097152224655
0.0344776298703156
0.0234854200150884
0.02495339308323447
0.014072758583575503
Capital expenditure
-0.022993058814209016
-0.010176821559530688
-0.009408381714610599
-0.005094360313836522
-0.007735981056936821
Free cash flow
-0.0014869616619843625
0.024300808310784915
0.014077038300477799
0.019859032769397947
0.006336777526638682
ROIC
0.1331
0.1745
0.146
0.5039
Stock Closing Price 12/29/2014
71.0
Shares Outstanding
Market Capitalization of Equity
40612.0
Interest Bearing Debt
Enterprise Value=EV interest bearing debt-market cap of eq
51573.0
EBITDA Multiple=EBIT/EBITDA
Historical NOPLAT
EBIT
6038.0
5785.0
6631.0
6624.0
1319.0
Adjusted EBITA
6038.0
5785.0
6631.0
6624.0
1319.0
Operating cash taxes
-2382.41
-2622.1099999999997
-2326.5
-2839.46
-579.88
NOPLAT
3655.59
3162.8900000000003
4304.5
3784.54
739.121
Operating Taxes on EBITA
Reported taxes
1654.0
1844.0
2500.0
1844.0
579.0
Tax shield on interest paid
4.73
0.44
Taxes on interest received
9.62
4.73
0.44
Taxes on EBITA
1762.4099999999999
1941.11
2685.5
1853.46
579.88
Decrease/(increase) in deferred taxes
Operating cash taxes
2382.41
2622.1099999999997
2326.5
2839.46
579.88
Reconciliation to net income
Net income
4762.0
1019.1999999999997
885.5999999999984
746.9000000000013
Increase/(decrease) in deferred taxes
-620.0
-681.0
359.0
-986.0
Adjusted net income
4142.0
338.1999999999997
1244.5999999999985
-239.09999999999866
After-tax interest paid
168.21
0.0
1.9529327050352094
0.2519913167787367
Loss (gain) from discontinued operations
-671.0
0.0
0.0
0.0
Total income available to all investors
3639.21
338.1999999999997
1246.5529327050338
-238.84800868321992
After-tax interest received
-17.324403028538146
-6.0477916026896805
NOPLAT
3655.59
328.1999999999997
1229.2285296764956
-244.8958002859096
Check
0.0
Historical Invested Captial
Cash and cash equivalents
Accounts receivable
Inventories
Other current assets
Operating Current Assets
Accounts payable
Accrued expenses
Income taxes payable
Other current liabilities
Operating Current Liabilities
Operating Working Captial
Net property, plant and equipment
Other Non-current Assets
Intangible assets
Operating Invested Captial
Non-Operating Assets
Short term investments
Long-term investments
Total funds invested
Short-term barrowing
Long-term liabilities
Other long-term liabilities
Debt & debt equivalents (Interest bearing debts)
Deferred income taxes (net of deferred taxes- assets)
Minority interest
Net common stock and paid-in-capital
Retained earnings
Treasury stock
Accumulated comprehensive income
Equity & equity equivalents
Total funds invested
Check
Historical Free Cash Flows
NOPLAT
Depreciation
Gross cash flow
(Increase)/decrease in operating working capital
Capital expenditures
(Increase)/decrease in other assets
(Increase)/decrease in intangibles and goodwill
Increase (decrease) in accumulated comprehensive income
Gross investment
Free Cash flow
444.59000000000015
After-tax interest received
154.98
(Increase) /decrease in sort-term investments
(Increase) /decrease in long term investments
Discontinued operations (-expense and + income)
Cash flows to investors
Financing flows
After-tax interest expense
154.98
Decrease/(increase) in debt
Flows to debt holders
Minority interests (gain) from income statement
Decrease (Increase) in minority interest op(IC)
Dividends (or adjustment to retained earnings)
Net Shares repurchased (issued)
Flows to equity holders
Cash flows available to investors
check
Month
PSX
Market
R(stock)
R(market)
1370.26001
1378.530029
-0.01837837837837837
0.006035364777229431
41022.0
34.110001
1403.359985
-0.06084799008810582
0.01801190795822703
1369.099976
-0.11580184357074622
-0.024412844434922434
1353.390015
0.05537135278514583
-0.011474663118393059
41043.0
31.379999
1295.219971
-0.014137637448947433
-0.0429809909599488
41050.0
31.299999
1317.819946
-0.002549394600044501
0.01744875427032779
1278.040039
-0.0440894263287356
-0.030186147296331855
41064.0
32.119999
1325.660034
0.07352937834224593
0.0372601746008366
41071.0
34.900002
1342.839966
0.0865505319598547
0.012959530769108189
41078.0
34.16
1335.02002
-0.021203494486905877
-0.005823438531766244
41085.0
33.240002
1362.160034
-0.026932025761124113
0.020329293638607807
41092.0
33.369999
1354.680054
0.003910860173835219
-0.005491263737958171
41099.0
34.939999
1356.780029
0.04704824833827535
0.0015501630763658427
1362.660034
0.010875815995300974
0.004333793890181134
41113.0
36.52
1385.969971
0.033975084937712424
0.017106201413697578
41120.0
39.669998
1390.98999
0.08625405257393198
0.003622025805059847
1405.869995
0.008318679521990406
0.010697420619108828
1418.160034
0.06925000000000008
0.008741945587934664
41141.0
41.360001
1411.130005
-0.03296700958615867
-0.00495714787573827
1406.579956
0.015473863262237425
-0.0032244010005300287
41156.0
44.259998
1437.920044
0.05380947619047626
0.0222810568758026
1465.77002
0.05580664508841581
0.01936823686143704
1460.150024
0.0019259576289322366
-0.0038341594679361097
41176.0
46.369999
1440.670044
-0.009611298590346012
-0.013341081176464145
1460.930054
-0.00754796220720205
0.014062907800698302
41190.0
43.919998
1428.589966
-0.045632377227292555
-0.022136643647964766
41197.0
44.639999
1433.189941
0.01639346613813606
0.0032199407174053228
1411.939941
0.06406812419507439
-0.014827064712143413
41213.0
46.209999
1414.199951
-0.027157915789473613
0.001600641737211091
1379.849976
0.025968427309422646
-0.02428933403350124
1359.880005
-0.03459185825775139
-0.014472566835048441
1409.150024
0.08848590779986884
0.036231151880198466
41239.0
52.369999
1416.180054
0.051184243275792844
0.004988844253818
1418.069946
-5.7282796587406E-4
0.0013344998008283948
41253.0
53.470001
1413.579956
0.021589625525410775
-0.003166268358387474
1430.150024
-0.024499737712741144
0.011722059250817499
1402.430054
-0.03048312883435576
-0.019382560944529344
41274.0
53.139999
1466.469971
0.050820624876408996
0.04566353724190801
41281.0
50.580002
1472.050049
-0.04817457749669891
0.0038051089421182274
1485.97998
0.08877022187543607
0.009462946595778501
41296.0
56.810001
1502.959961
0.03159616851280188
0.011426789881785589
1513.170044
0.10455903706109775
0.006793316698341467
41309.0
64.019997
1517.930054
0.020238996015936313
0.003145720481894476
41316.0
64.169998
1519.790039
0.0023430335368494807
0.001225343022294525
41324.0
64.110001
1515.599976
-9.3496964110876E-4
-0.0027570012254831008
41330.0
63.900002
1518.199951
-0.003275604378792574
0.0017154757463522722
41337.0
66.029999
1551.180054
0.03333328534168126
0.02172316168122434
41344.0
64.150002
1560.699951
-0.02847186170637384
0.006137196630043909
41351.0
67.550003
1556.890015
0.05300079335928942
-0.0024411713459457315
41358.0
69.970001
1569.189941
0.03582528338303689
0.007900317865421048
41365.0
62.310001
1553.280029
-0.10947548793089194
-0.010138933206429519
41372.0
60.669998
1588.849976
-0.026320060562990525
0.022899893345631857
-0.04664575726539494
-0.021147355954014863
41386.0
61.599998
1582.23999
0.06500688105117558
0.01735411670149496
1614.420044
0.009415617188818746
0.02033828888372359
41400.0
61.380001
1633.699951
-0.012865857188806685
0.011942311464512575
41407.0
65.459999
1667.469971
0.06647112957850874
0.02067088266687469
41414.0
65.470001
1649.599976
1.527956027008199E-4
-0.010716831673606203
41422.0
66.57
1630.73999
0.016801572983021595
-0.011433066364205583
41428.0
65.870003
1643.380005
-0.01051520204296224
0.007751091576530204
41435.0
63.810001
1626.72998
-0.03127374990403443
-0.010131573311919367
1592.430054
-0.07146216781911663
-0.02108519940107094
1606.280029
-0.005738396624472631
0.008697383577514473
41456.0
57.240002
1631.890015
-0.028348294007808517
0.01594366208732832
1680.189941
0.03232001983507979
0.029597537552186165
41470.0
57.490002
1692.089966
-0.027077305804704795
0.007082547460626604
1691.650024
0.026265401764988688
-2.59999177845118E-4
1709.670044
-0.010000000000000057
0.010652333369399067
41491.0
58.919998
1691.420044
0.008731347372025392
-0.0106745743507921
41498.0
56.299999
1655.829956
-0.04446705853588114
-0.021041543244239763
41505.0
58.110001
1663.5
0.032149236805492615
0.004632144727305538
41512.0
57.099998
1632.969971
-0.017380880788489362
-0.01835288788698528
41520.0
57.419998
1655.170044
0.005604203348658616
0.01359490584288275
41526.0
57.130001
1687.98999
-0.0050504529798137505
0.019828745764806793
1709.910034
0.014003132959861136
0.012985885064401336
41540.0
58.529999
1691.75
0.010357310547212098
-0.010620461684477136
41547.0
59.169998
1690.5
0.010934546573288052
-7.388798581350672E-4
1703.199951
0.012844381032427956
0.007512541259982287
0.05923577507091602
0.024248502928708657
41568.0
63.400002
1759.77002
-0.0012602079395084473
0.00875323588420747
41575.0
64.129997
1761.640015
0.011514116356021604
0.0010626360142219136
41582.0
65.360001
1770.609985
0.01917985431996814
0.005091829161248987
41589.0
67.099998
1798.180054
0.026621740718761656
0.015570944043896756
41596.0
68.480003
1804.76001
0.020566394055630183
0.0036592308903455554
41603.0
69.610001
1805.810059
0.016501138295802947
5.818219564827041E-4
41610.0
71.239998
1805.089966
0.023416132403158606
-3.9876453030651004E-4
41617.0
71.599998
1775.319946
0.005053340961632248
-0.0164922638542881
41624.0
74.029999
1818.319946
0.03393856240051856
0.02422098624920198
1841.400024
0.009725800482585395
0.012693078603010582
41638.0
76.290001
1831.369995
0.020602020066889683
-0.005446958221610196
1842.369995
0.022414457695445516
0.00600643235939879
41652.0
76.019997
1838.699951
-0.0253846538461538
-0.0019920233231978802
41660.0
74.440002
1790.290039
-0.020783939257456124
-0.026328337026207967
41666.0
73.089996
1782.589966
-0.018135491183893404
-0.004301019852794911
41673.0
74.279999
1797.02002
0.016281338967373927
0.008094993394571776
41680.0
75.93
1838.630005
0.022213260934481206
0.023154992452449168
41688.0
74.949997
1836.25
-0.0129066640326618
-0.0012944447732973785
41694.0
74.860001
1859.449951
-0.0012007472128384381
0.012634418515997307
41701.0
78.080002
1878.040039
0.043013638217824716
0.009997627518827433
41708.0
78.690002
1841.130005
0.007812499799884914
-0.019653486205572848
41715.0
77.949997
1866.52002
-0.00940405364330796
0.013790452021882045
41722.0
76.650002
1857.619995
-0.016677293778471804
-0.004768245132457735
41729.0
79.57
1865.089966
0.03809521100860496
0.004021258933531229
1815.689941
-0.035440492647982824
-0.02648667136735854
41743.0
80.279999
1864.849976
0.04599347231270363
0.027075126589578807
41750.0
82.589996
1863.400024
0.028774252974268166
-7.775167003567794E-4
41757.0
83.529999
1881.140015
0.011381560062068587
0.009520226881783016
41764.0
81.910004
1878.47998
-0.019394169991550015
-0.0014140547640202528
41771.0
81.860001
1877.859985
-6.104626731553303E-4
-3.300514280700597E-4
41778.0
82.029999
1900.530029
0.0020766918876534922
0.012072275984942487
41786.0
84.790001
1923.569946
0.03364625178161955
0.0121228902718906
41792.0
84.360001
1949.439941
-0.005071352694051823
0.01344894946700317
41799.0
83.489998
1936.160034
-0.010312979963098826
-0.006812165238180115
41806.0
85.940002
1962.869995
0.029344880329258204
0.013795327106726148
41813.0
81.489998
1960.959961
-0.051780357184539126
-9.730822748655832E-4
1985.439941
1.2273898939106693E-4
0.012483671511332846
41827.0
80.290001
1967.569946
-0.014846613496932469
-0.009000521562490324
41834.0
80.860001
1978.219971
0.007099265075360918
0.005412780888247982
41841.0
82.650002
1978.339966
0.02213703905346234
6.0658067231703814E-5
41848.0
80.540001
1925.150024
-0.025529352074304814
-0.02688614844472084
41855.0
83.050003
1931.589966
0.031164663134285283
0.003345163711771054
41862.0
83.790001
1955.060059
0.008910270599267767
0.012150660032989582
41869.0
86.089996
1988.400024
0.02744951632116576
0.017053166651592937
41876.0
87.019997
2003.369995
0.010802660508893558
0.007528651588871629
41884.0
87.510002
2007.709961
0.00563094710288253
0.0021663327347577668
41890.0
83.019997
1985.540039
-0.05130847785833666
-0.011042392791116925
2010.400024
0.03288367981993539
0.012520515583518813
41904.0
82.230003
1982.849976
-0.04104952769679304
-0.013703764261395602
41911.0
77.639999
1967.900024
-0.05581909075207006
-0.007539628404040155
41918.0
76.32
1906.130005
-0.01700153293407448
-0.03138879935294927
41925.0
72.209999
1886.76001
-0.053852214360586965
-0.010161948528794087
41932.0
76.489998
1964.579956
0.059271556007084336
0.04124528058022603
2018.050049
0.02627797166369386
0.027217061253576133
41946.0
74.699997
2031.920044
-0.04840768152866247
0.0068729687882978854
41953.0
71.779999
2039.819946
-0.03908966689784462
0.003887900029987652
41960.0
79.419998
2063.5
0.10643632079181281
0.011608894229334065
41967.0
73.019997
2067.560059
-0.08058425032949514
0.0019675594863096243
41974.0
73.019997
2075.370117
0.0
0.00377742739128819
41981.0
65.68
2002.329956
-0.1005203684136004
-0.0351938000849609
41988.0
71.809998
2070.649902
0.09333127283800222
0.03412022369004605
41995.0
72.650002
2088.77002
0.01169759119057499
0.008750932730104665
42002.0
71.699997
2058.899902
-0.013076462131411977
-0.014300338339785163
Std Dev.
0.2912009561473383
0.11265295119064521
Systematic Risk=
0.023627759483308582
SUMMARY OUTPUT
Unsystematic Risk=
0.061170237377815476
Total Risk=
0.08479799686112406
Regression Statistics
Multiple R
0.527859660424276
Systematic Risk %=
0.2786358211032319
0.2786
R Square
R Square
0.278635821103232
Unsystematic Risk %=
0.7213641788967681
0.7214
Adjusted R Square
0.2734832198253979
1.0
Standard Error
0.034420244391033306
Observations
142.0
ANOVA
df
SS
MS
F
Significance F
Regression
1.0
0.06406757859897141
0.06406757859897141
54.08
1.475E-11
Residual
140.0
0.16586545135138436
0.0011847532239384598
Total
141.0
0.22993302995035578
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Lower 95.0%
Upper 95.0%
Intercept
0.0013956700067627283
0.002941372020613838
0.4744962544627267
0.6358853512888738
-0.004419580487487192
0.007210920501012649
-0.004419580487487192
0.007210920501012649
X Variable 1
1.3644
0.1855510821655389
7.353688097972829
1.475065950091913E-11
0.9976403273049222
1.7313292416684813
0.9976403273049222
1.7313292416684813
Adjusted/Smoothing beta
1.24
Interest bearing Debt (D)
10961.0
Market cap E
40612.0
Captial Structure
Total Debit Ratio
0.5570464290843438
0.5592192457528414
0.5678447361304683
Stable debt ratio beta/(1+D/E) to unlever beta
Unlevered beta (PSX)
97.98
Unlevered beta (VLO)
1.1054
Re-Levered (PSX) Beta
1.0425846835095354
Avgerage/Industry unlevererd Beta
1.3239736994641305
