Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You need to complete a DCF Valuation Analysis for company XYZ. You are specifically interested in assessing the effect that the net working capital of

You need to complete a DCF Valuation Analysis for company XYZ. You are specifically interested in assessing the effect that the net working capital of your company will have on the Free Cash Flow. Calculate the effect of Net Working Capital on the free cash flow generated by the company between the end of June 2016 and the end of June 2017. Express your answer as a negative number if you think that the effect on the cash flow is negative (reduction in cash flow) and express your number as a positive number if you think that the effect on the cash flow is positive. Express your answer in millions of dollars with zero decimal points and without the dollar sign.

Annual

Item 06/14 06/15 06/16 06/17
CA - Cash 1,142 3,800 1,982 2,427
CA - Receivables 6,242 5,616 7,707 17,753
CA - Prepaid Expenses 223 436 205 226
CA - Inventories 18,817 21,113 21,440 22,237
CA - Other 7 8 7 3
Total Current Assets 26,431 30,973 31,341 42,646
NCA - Receivables 2,027 1,955 2,779 2,904
NCA - Inventories 0 0 0 2,309
NCA - Investments 0 0 0 0
NCA - PP&E 22,992 20,820 20,260 18,171
NCA - Intangibles(ExGW) 0 0 0 0
NCA - Goodwill 4,334 4,334 4,334 4,334
NCA - Future Tax Benefit 5,866 4,970 4,918 4,013
NCA - Other 0 0 0 0
Total Non Current Assets 35,219 32,079 32,291 31,731
Total Assets 61,650 63,052 63,632 74,377
CL - Account Payable 5,408 6,249 6,328 6,865
CL - Short-Term Debt 12,364 3,535 1,798 12,527
CL - Provisions 876 849 713 741
CL - Other 1,573 1,447 1,217 1,557
Total Current Liabilities 20,221 12,080 10,056 21,690
NCL - Account Payable 0 0 0 0
NCL - Long-Term Debt 4,284 12,412 11,889 3,493
NCL - Provisions 2,658 2,897 3,887 4,171
NCL - Other 931 562 114 270
Total Non Current Liabilties 7,873 15,871 15,890 7,934
Total Liabilities 28,094 27,951 25,946 29,624
Share Capital 30,367 31,778 33,896 40,657
Reserves 13,956 13,956 13,956 14,262
Retained Earnings -10,767 -10,633 -10,166 -10,166
Total Equity 33,556 35,101 37,686 44,753

Interim

Item 12/14 12/15 12/16 12/17
CA - Cash 1,421 2,001 759 3,085
CA - Receivables 6,980 8,151 9,973 13,017
CA - Prepaid Expenses 0 0 0 0
CA - Inventories 20,641 20,322 23,718 24,189
CA - Other 316 304 748 529
Total Current Assets 29,358 30,778 35,198 40,820
NCA - Receivables 2,027 2,641 2,132 2,902
NCA - Inventories 0 0 0 2,544
NCA - Investments 0 0 0 0
NCA - PP&E 23,291 20,516 19,382 18,865
NCA - Intangibles(ExGW) 4,334 4,334 4,334 4,334
NCA - Goodwill 0 0 0 0
NCA - Future Tax Benefit 5,803 4,734 4,111 2,700
NCA - Other 0 0 0 0
Total Non Current Assets 35,455 32,225 29,959 31,345
Total Assets 64,813 63,003 65,157 72,165
CL - Account Payable 4,781 5,230 4,706 3,086
CL - Short-Term Debt 3,911 1,966 13,065 1,695
CL - Provisions 921 816 702 638
CL - Other 2,312 1,567 1,659 2,018
Total Current Liabilities 11,925 9,579 20,132 7,437
NCL - Account Payable 0 0 0 0
NCL - Long-Term Debt 15,223 12,893 279 14,454
NCL - Provisions 2,660 3,437 3,628 3,447
NCL - Other 1,036 237 172 767
Total Non Current Liabilties 18,919 16,567 4,079 18,668
Total Liabilities 30,844 26,146 24,211 26,105
Share Capital 30,367 31,778 35,875 40,657
Reserves 13,956 13,956 15,237 15,569
Retained Earnings -10,354 -8,877 -10,166 -10,166
Total Equity 33,969 36,857 40,946 46,060

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

The Bank Credit Analysis Handbook

Authors: Jonathan Golin, Philippe Delhaise

2nd Edition

ISBN: 0470821574, 978-0470821572

More Books

Students also viewed these Finance questions