For the DDM model in week 4 of FIN 534, where do I find the "TOTAL SALES" and the "BOOK VALUE OF EQUITY" ? I don't see a total sales or book value of equity block for VSEC (the company I am trying to evaluate)...

STOCK VALUATION MODELS - DDM (Dividends & Repurchases) NAME OF COMPANY VSE ENTER DATA IN YELLOW-CODED CELLS OUTPUT IN SUBSEQUENT WORKSHEETS LAST YEAR 2015 Year NUMBER OF SHARES OUTSTANDING (Mil.) 269.00 Millions of Shares MARKET PRICE OF STOCK / SHARE $62.04 Dollars Per Share All Data NET INCOME AFTER TAXES $24,918.00 Millions of Dollars Required TOTAL SALES $162,558.00 Millions of Dollars BOOK VALUE OF EQUITY $27,537.00 Millions of Dollars RISK FREE RATE (Appropriate T- Bill or T-Bond) 4.92% Annual Percentage Rate DIVIDENDS PAID (TOTAL) $2,290.00 Millions of Dollars STOCK REPURCHASES (TOTAL) $371.00 Millions of Dollars REQUIRED INFORMATION FOR CALCULATION OF REQUIRED RATE OF RETURN BETA OF STOCK 1.15 Required MARKET RISK PREMIUM 3.00% Expected Market Risk Premium % Data REQUIRED INFORMATION FOR VARIABLE GROWTH RATE VALUATIONS EXPECTED GROWTH RATE FOR EARNINGS 7.0000% 6.0000% 5.0000% 5.0000% 5.0000% Must be positive EXPECTED GROWTH RATE (DIVIDENDS & STOCK values in each cell 5.0000% 5.0000% 5.0000% 5.0000% 5.0000% REPURCHASES) COMPUTER-GENERATED CALCULATIONS EARNINGS PER SHARE $92.63 LAST CASH DIVIDEND & STOCK $9.89 REPURCHASE PAYMENT PER SHARE EXPECTED ANNUAL GROWTH RATE FOR 5.55% Geometric Mean of Annual Rates EARNINGS EXPECTED ANNUAL GROWTH RATE 5.00% Geometric Mean of Annual Rates (DIVIDENDS & STOCK REPURCHASES) REQUIRED RATE OF RETURN (k) 8.37% CAPM REQUIRED RATE OF RETURN (k) Dividend Discount Model 21.74% REQUIRED RATE OF RETURN (k) Average of CAPM and Dividend Discount Model 15.06% EXPECTED EARNINGS PER SHARE IN 5 $121.62 YEARS SUSTAINABLE RATE OF GROWTH 80.83% (ROE * (1-Payout Ratio)) COMPUTER-GENERATED CALCULATIONS STOCK VALUE - ZERO GROWTH MODEL $65.70 Not applicable for most stocks STOCK VALUE - CONSTANT GROWTH MODEL $103.27 STOCK VALUE - VARIABLE GROWTH MODEL $103.27 EXPECTED RETURN COMMON STOCK INPUTS FORMULA k = ( D1 / P0 ) + g LAST DIVIDEND & STOCK REPURCHASE PER SHARE PRICE OF STOCK EXPECTED GROWTH RATE (DIVIDENDS & STOCK REPURCHASES) OUTPUT ESTIMATED REQUIRED RATE OF RETURN (k) 21.74% $9.89 $62.04 5.00% PRICE OF COMMON STOCK - ZERO GROWTH MODEL INPUTS LAST DIVIDEND & STOCK REPURCHASE PER SHARE REQUIRED RATE OF RETURN (ROR) (Average of CAPM and Dividend Discount Model) OUTPUT PRICE OF STOCK $65.70 FORMULA $9.89 15.06% P0 = D 0 / k PRICE OF COMMON STOCK - CONSTANT GROWTH MODEL INPUTS FORMULA P0 = D1 / ( k - g ) LAST CASH/STOCK REPURCHASE PAYMENT PER SHARE REQUIRED RATE OF RETURN (ROR) EXPECTED ANNUAL GROWTH RATE k must > g (Dividends + Stock Repurchases) OUTPUT PRICE OF STOCK $9.89 15.06% 5.00% $103.27 PRICE OF STOCK - VARIABLE GROWTH MODEL INPUTS LAST YEAR (e.g., 1996) 2015 LAST CASH & STOCK REPURCHASE PAYMENT PER SHARE $9.89 EXPECTED ANNUAL GROWTH RATE (DIVIDENDS + STOCK REPURCHASES) REQUIRED RATE OF RETURN (ROR or k) 2016 2017 2018 2019 2020 5.00% 5.00% 5.00% 5.00% 5.00% 15.06% FORMULA P0 = Present Value of Dividends Plus Present Value of Future Stock Price OUTPUT DIVIDENDS FUTURE PRICE NON-DISCOUNTED CASH FLOWS PRESENT VALUE $103.27 2016 $10.39 2017 $10.91 2018 $11.45 2019 $12.02 $125.53 $10.39 $10.91 $11.45 $137.55 2020 $12.63 PRICE OF STOCK - DIVIDEND AND EARNINGS APPROACH INPUTS PRESENT STOCK PRICE LAST CASH & STOCK REPURCHASE PAYMENT PER SHARE EXPECTED ANNUAL GROWTH RATE (DIVIDENDS & STOCK REPURCHASES) ESTIMATED STOCK PRICE REQUIRED RATE OF RETURN (ROR) $62.04 $9.89 5.00% $0.00 15.06% For 5 Years In 5 Years FORMULA P0 = Present Value of Dividends Plus Present Value of Future Stock Price OUTPUT 2015 $10.39 2016 $10.91 2017 $11.45 2018 $12.02 $9.03 $8.24 $7.52 $6.86 PRICE OF STOCK $37.91 2019 $12.63 $0.00 $6.26 CASH + STOCK REPURCHASE PMT PER SHARE FUTURE VALUE OF STOCK PRESENT VALUES