How is each individual item highlighted in blue calculated?

FREE-CASH-FLOW VALUATION OF EQUITY enter data In blue-colored cells Assumptions: PERIOD 10 0 1 2 3 YEAR 1 3 4 2 4 Profit from operations (EBIT) 0.0 0.0 0.0 0.0 0.0 Income tax rate 0.0 0.0 0.0 0.0 0.0 Depreciation & amortization expense 0.0 0.0 0.0 0.0 0.0 Net working capital from balance sheet forecast 0.0 0.0 0.0 D.0 0.0 0.0 Capital expenditures 0.0 0.0 0.0 0.0 0.0 Long-term growth rate 0.0% Wt-Avg. C of C (K-wacc) 0.0% Market Value of Debt 0.0 Number of Shares 0.0 Redundant Assets 0.0 PERIOD 1 2 3 5 YEAR 1 2 3 4 4 5 EBIT after tax (EBIAT) 0.0 0.0 D.0 0.0 0.0 + Depreciation 0.0 0.0 0.0 0.0 0.0 -Cash Flow from Operations (CFFO) 0.0 0.0 0.0 0.0 0.0 +/- Change in Net Working Capital 0.0 0.0 0.0 0.0 0.0 +/- Capital Expenditures 0.0 0.0 0.0 0.0 0.0 =Free Cash Flow (FCF) 0.0 0.0 0.0 0.0 0.0 +Terminal Value (TV) #DIV/O! =Sum of FCF + TV 0.0 0.0 0.0 0.0 #DIV/O! Present Value #DIV/O! - Market Value of Debt 0.0 Valuation of Equity #DIV/O! Redundant assets 0.0 =Adjusted Value of Equity #DIV/O! / Number of Shares 0.0 Value of Equity per Share #DIV/OI MARKET MULTIPLES (COMPARABLES) VALUATION OF EQUITY Average Market Multiples of Peers Peer A Peer B Peer C Peer D Poor E Mkt Mult Price /revenue market multiple of peer company D.C D.O 0.0 U.L 0.0 REFER TO PEER DATA TAB Price/EBITDA market multiple of peer company 0.0 0.0 0.0 0.0 0.0 0.0 Price /Earnings market multiple of peer company 0.0 0.0 0.0 0.0 0.0 0.0 Mkt Val of Eq/Book Val mkt mult of Equity of peer co 0.0 0.0 0.0 0.0 0.0 0.0 Target company data Target company revenue 0.0 adjust function Target company EBITDA D.0 If less than 5 Target company earnings (net income) 0.0 peers Target company book value of equity 0.0 Target company number of shares 0.0