Question
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
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