Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Build a Discounted Cash Flow (DCF) model in Microsoft Excel for Delphi Technologies PLC from 2018 up to 2023. Please add assumptions and outputs Growth
Build a Discounted Cash Flow (DCF) model in Microsoft Excel for "Delphi Technologies PLC" from 2018 up to 2023.
Please add assumptions and outputs
Growth Rate: 4%
Six Months Ended June 30, 2019 2018 (in millions) Cash flows from operating activities 195 S 50 Net income Adjustments to reconcile net income to net cash provided by operating activities: 100 112 Depreciation and amortization (17) (11) Restructuring expense, net of cash paid 3 (2) Deferred income taxes 22 18 Pension and other postretirement benefit expenses (1) (6) Income from equity method investments, net of dividends received 8 10 Other, net Changes in operating assets and liabilities (6) 64 Accounts receivable, net (32) (22) Inventories Accounts payable (13) (72) Other, net (6) (15) Pension contributions (26) (23) Net cash provided by operating activities 91 239 Cash flows from investing activities Capital expenditures (234) (123) Proceeds from sale of property 1 Proceeds from insurance settlement claims 1 Cost of technology investments (7) Settlement of undesignated derivatives (1) (10) Net cash used in investing activities 230) (138) Cash flows from financing activities: Net repayments under other short-term debt agreements (2) Repayments under long-term debt agreements (19) (9) Dividend payments of consolidated affiliates to minority shareholders (8) (10) un Repurchase of ordinary shares (29) Distribution of cash dividends (30) Taxes withheld and paid on employees' restricted share awards (2) (5) Net cash used in financing activities (58) (56) Effect of exchange rate fluctuations on cash, cash equivalents and restricted cash (12) Decrease in cash, cash equivalents and restricted cash (197) 33 Cash, cash equivalents and restricted cash at beginning of period 360 339 Cash, cash equivalents and restricted cash at end of period $ 163 $ 372 I Six Months Ended June 30, 2019 2018 (in millions) Cash flows from operating activities 195 S 50 Net income Adjustments to reconcile net income to net cash provided by operating activities: 100 112 Depreciation and amortization (17) (11) Restructuring expense, net of cash paid 3 (2) Deferred income taxes 22 18 Pension and other postretirement benefit expenses (1) (6) Income from equity method investments, net of dividends received 8 10 Other, net Changes in operating assets and liabilities (6) 64 Accounts receivable, net (32) (22) Inventories Accounts payable (13) (72) Other, net (6) (15) Pension contributions (26) (23) Net cash provided by operating activities 91 239 Cash flows from investing activities Capital expenditures (234) (123) Proceeds from sale of property 1 Proceeds from insurance settlement claims 1 Cost of technology investments (7) Settlement of undesignated derivatives (1) (10) Net cash used in investing activities 230) (138) Cash flows from financing activities: Net repayments under other short-term debt agreements (2) Repayments under long-term debt agreements (19) (9) Dividend payments of consolidated affiliates to minority shareholders (8) (10) un Repurchase of ordinary shares (29) Distribution of cash dividends (30) Taxes withheld and paid on employees' restricted share awards (2) (5) Net cash used in financing activities (58) (56) Effect of exchange rate fluctuations on cash, cash equivalents and restricted cash (12) Decrease in cash, cash equivalents and restricted cash (197) 33 Cash, cash equivalents and restricted cash at beginning of period 360 339 Cash, cash equivalents and restricted cash at end of period $ 163 $ 372 Discount Rate: 12%
Number of Shares: 87million
Step 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