Please help with the formulas too!

B C D E F G H I J 1 PROBLEM 3-1: Clayton Manufacturing Company 2 3 Given $ EBITDA (Year 1) Growth Rate in EBITDA Initial investment Depreciation (Straight line) over Estimated salvage value Tax rate Cost of capital 200,000 5% 800,000 5 years $ Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output $ 35% 12% Solution Years 3 0 2 5 200.000 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 a. EBITDA Less: Depreciation Expense EBIT Less: Taxes NOPAT Plus: Depreciation Expense Less: CAPEX Less: Change in Working Capital Project FCF b. NPV c. Using "Goal Seek" to solve for the EBITDA in year 1 (C5) that yields a NPV of O (C28). Breakeven Year 1 EBITDA