Calculate the Free Cash Flow of NIKE on www.barrons.com. Show your calculation using the spreadsheet  above.

Add to the spreadsheet at least 6 of the Warren Buffet rules and evaluate NIKE  based on those as well.

have a slide summarizing your analysis and argue whether you still believe NIKE  is a great choice.

Transcribed Image Text:

CFFA1 OCF - NCS-CNWC CFFA2 CFCR + CFSH CFFA1 CFFA = OCF - NCS - CNWC 0 = CFFA2 CFFA = CFCR + CFSH IIA EBIT IIIA Interest Paid Depreciation & Amortization Taxes Operating CF (OCF) IIIB Ending LT Debt 0 Beginning LT Debt Net New Borrowing 0 IIC1 Ending Current Assets Ending Current Liabilities III Cash to Creditors (CFCR) 0 Ending NWC 0 IIC2 Beginning Current Assets IVA Dividends Paid Beginning Current Liabilities Beginning NWC 0 IVB Ending Common Stock IIB Ending Total Assets Beginning Common Stock Net New Equity 0 Ending Current Assets 0 Ending Net Noncurrent Assets IV Cash to Stockholders (CFSH 0 Beginning Total Assets Beginning Current Assets Beginning Net Noncurrent Asse 0 Depreciation & Amortization Net Capx (NCS) 0 IIC Change in NWC (CNWC) 0 CFFA1 OCF - NCS-CNWC CFFA2 CFCR + CFSH CFFA1 CFFA = OCF - NCS - CNWC 0 = CFFA2 CFFA = CFCR + CFSH IIA EBIT IIIA Interest Paid Depreciation & Amortization Taxes Operating CF (OCF) IIIB Ending LT Debt 0 Beginning LT Debt Net New Borrowing 0 IIC1 Ending Current Assets Ending Current Liabilities III Cash to Creditors (CFCR) 0 Ending NWC 0 IIC2 Beginning Current Assets IVA Dividends Paid Beginning Current Liabilities Beginning NWC 0 IVB Ending Common Stock IIB Ending Total Assets Beginning Common Stock Net New Equity 0 Ending Current Assets 0 Ending Net Noncurrent Assets IV Cash to Stockholders (CFSH 0 Beginning Total Assets Beginning Current Assets Beginning Net Noncurrent Asse 0 Depreciation & Amortization Net Capx (NCS) 0 IIC Change in NWC (CNWC) 0