5. Fill in the spreadsheet below with the appropriate cell formulas to compute the operating cash flow, for example the formula is provided for the fixed costs in cell B12. (Do not put in the numerical answers, just the Excel cell formulas)

	B	C	D	E
1
2	Assumptions
3	Price	$10
4	Quantity	100,000
5	Fixed Costs	25,000
6	VC Percent	65%
7	Tax Rate	30%
8	Depreciation	10,000
9
10	Sales Revenue	(a)
11	Variable Costs	(b)
12	Fixed Costs	=c5
13	Depreciation	(c)
14	Operating Profit	(d)
15	Taxes	(e)
16	Net Profit	(f)
17	Operating CF	(g)