the hidden information hidden is not needed for the question

BASIC DCF MATRIX - HOMEWORK REQUIREMENT: Complete a BASIC DCF EXCEL MATRIX using the following assumption: WACC STUDENT # ENDING IN 1 to 5 TERMINAL GROWTH RATE 1.5% 8% BASIC DCF MATRIX REVENUE % REVENUE GROWTH COSTS % OF REVENUE DEPRECIATION HISTORICAL AVE ASSUMPTION 2017 2018 2019 2020 2021 ACT REV 2016 $ 12,902.00 $15,482.40 $18,578.88 $22,294.66 $26,753.59 $32,104.30 23.48% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% $13,314.86 $15,977.84 $19,173.40 $23,008.08 $27,609.70 83.89% 86.00% 86.00% 86.00% 86.00% 86.00% 86.00% $ 405.64 $ 486.77 $ 584.12 $ 700.94 $ 841.13 2.62% 2.62% 2.62% 2.62% 2.62% 2.62% 2.62% $ 1,761.90 $ 2,114.28 $ 2,537.13 $ 3,044.56 $ 3,653.47 $ 458.09 $ 549.71 $ 659.65 $ 791.59 $ 949.90 30.73% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% $ 1,303.80 $ 1,564.56 $ 1,877.48 $ 2,252.97 $ 2,703.57 $ 405.64 $ 486.77 $ 584.12 $ 700.94 $ 841.13 % OF REVENUE EBIT TAXES % OF EBT A) EBIT (1-TAX)or NOPAT 1) DEPRECIATION 2) CAPEX $ 1,195.24 $ 1,434.29 $ 1,72115 $ 2,065.38 $ 2,478.45 7.72% 7.72% 7.72% 7.72% 7.72% % OF REVENUE 7.72% 7.72% 3) NON-CASH WORKING CAPITAL $ 207.21 $ 248.65 $ 298.18 $ 358.05 $ 429.66 636.59 $ 306.99 $ 1.656.18$ 278.17 $ 2.00% 368.39 $ 302.47 $ 442.27 $ 329.04 $ 530.49 $ 357.63 $ 10.36% 388.87 $ 7,766.98 B) ENTERPRISE CASH FLOW (FCFF) 1) PV OFFCFF Terminal Growth Rate Terminal Value 2) PV of Terminal Value 3) ASSETS NOT REQUIRED TO GENERATE CASH FLOW c) ENTERPRISE VALUE( VALUE OF FIRM) FUNDED DEBT (INTEREST BARING) CASH & MARKTABLE SECURITIES D) VALUE OF EQUITY Number of Shares Outstanding E) PRICE PER SHARE $ 4,744.54 $ 1,000.00 $ 7,400.72 $ 3,000.00 $ 1,000.00 $ 5,400.72 100.000 54.01