Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed
image text in transcribed
image text in transcribed
Please add assumptions and outputs
Growth Rate: 4%
Discount Rate: 12%
Number of Shares: 87million
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions