What formulas should I be using on Excel to calculate the following if I have the 10K info? Please state what formula I should be using for the cells, thank you.

Operating taxes

NOPLAT

Increase in working capital

Capital expenditures

Free cash flow

WACC
		Proportion			After-tax	Contribution
	Market value,	of total	Cost of	Marginal	cost of	to weighted
Source of capital	$ million	capital, %	capital, %	tax rate, %	capital, %	average, %
Debt
Equity
Total Capital

Unit: $ million	Year
	1	2	3
Free cash flow (FCF)
Discounted FCF
Continuing value
PV of explicit FCFs
PV of continuing value
PV of operations
Midyear adjustment
PV of nonoperating assets
Total value of the firm