Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you help me calculate the Net Present Value (NPV), Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), Profitability Index (PI), Payback
Can you help me calculate the Net Present Value (NPV), Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), Profitability Index (PI), Payback Period, and the Discounted Payback Period using the information in the table above. The WACC was calculated to be 10.37%.
Consolidated Cash Flow Statement Dec 31, 2019 3,377 1,341 861 23 183 (143) Dec 31, 2018 5,873 1,356 8 23 252 221 (19) Dec 31, 2017 5,248 1,318 24 22 (1,886) (516) (15) (423) (186) (1,182) (176) 104 1,153 163 62 Dec 31, 2016 1,644 1,168 5 21 612 (815) (10) Dec 31, 2015 4,280 1,078 7 21 529 185 (283) (20) 16 (2,308) (204) (14) 1,941 (245) (830) 132 1,320 (202) (113) (1,546) 268 (273) (163) (1,258) 216 (147) 1,579 111 501 117 2,129 (144) 324 (2,300) (230) (221) 1,431 4,808 (3,873) 1,700 7,573 (2,639) (1,600) 3,648 (1,832) 1,319 2,963 (2,844) 1,433 5,713 (5,764) US$ in millions 12 months ended: Net income Depreciation and amortization Impairments Accretion on discounted liabilities Deferred income taxes Undistributed equity earnings Net gain on dispositions Gain on consolidation of business Other Accounts and notes receivable Inventories Prepaid expenses and other current assets Accounts payable Taxes and other accruals Working capital adjustments Adjustments to reconcile net income to net cash provided by operating activities Net cash provided by operating activities Capital expenditures and investments Proceeds from asset dispositions, includes return of investments in equity affiliates Advances/loans, related parties Collection of advances/loans, related parties Restricted cash received from consolidation of business Other Net cash used in investing activities Issuance of debt Repayment of debt Issuance of common stock Repurchase of common stock Dividends paid on common stock Distributions to noncontrolling interests Net proceeds from issuance of Phillips 66 Partners LP common and preferred units Other Net cash used in financing activities Effect of exchange rate changes on cash, cash equivalents and restricted cash Net change in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash at beginning of Cash, cash equivalents and restricted cash at end of year 157 (98) 95 57 (1) 156 (432) 108 70 (50) 50 31 (3,688) 1,783 (1,307) 32 (1,650) (1,570) (241) 112 (2,471) 2,184 (1,144) 39 (4,645) (1,436) (207) 86 (10) 326 318 (34) (1,146) 3,508 (3,678) 35 (1,590) (1,395) (120) (146) (3,158) 2,090 (833) 34 (1,042) (1,282) (75) (44) (5,738) 1,169 (926) 31 (1,512) (1,172) (46) 173 269 (2,511) 128 (86) (5,167) 1,205 (76) (2,111) 972 (42) (178) 384 (45) (2,117) (14) (1,405) 3,019 1,614 (35) (100) 3,119 3,019 17 408 2,711 3,119 10 (363) 3,074 2,711 9 (2,133) 5,207 3,074 Titili MOTOStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started