please do one for 10% and 20% thank you

ED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay BASIC DCF MATRIX - HOMEWORK REQUIREMENT: Complete a BASIC DCF EXCEL MATRIX using the following assumption: WACC STUDENT # ENDING IN 1 to 5 6 to 0 TERMINAL GROWTH RATE 1.5% 25% 8% 12% I SUBMISSION: Wed Sept 16, 2020 BRIGHTSPACE DROP BOX DISCOUNTED CASH FLOW (OCF) 1 2 3 4 5 2024 2025 15.00 ACTUAL 2020 Revenues 10% or VENUE GROWTH 20% A) EBIT(1) NOPAT Depreciation Carpenditures & WC B) FREE CASH FLOW TO FIRM FCE) Discount (WACO OF FF ya 15.00 2021 2022 2023 15.00 15.00 STO -5120051300 51500 $340050025 $4500 $23.00 $25.00 53000 5110051425 $16.00 12% 3932 511 36 511 45 5170052000 56290 $60 14 $1790 5.2014 1PVY 51133115 2) PV c) Value of Firm S. 34 SI $106.13 SO TV 523040 TVCHI Day 5106.19 DISCOUNTED CASH FLOW ("DCF") 2 6 in millions $'s ACTUAL 2020 Revenues 10% or $100.00 PREVENUE GROWTH Expenses 20% Taxes A) EBIT(1-) or NOPAT Depreciation Capital Expenditures & NCWC B) FREE CASH FLOW TO FIRM ("FCFF") Discount Rate (WACC) PV OF FCFF (per year) 2021 2022 2023 $115.00 $1232125 $152.109 15.00% 15.00 15.0096 369 0097900391 00 -$1200 -$13.00-$15.00 $34.00 $40.25 $46 09 $23.00 $26.00 $30 00 $1100 $14 25 16 09 12% $9 82 $11.36 $11.45 2024 2025 $174.90...2010.14 15.00 15.00% PST05 US100 -$1700-$20.00 $52 90 $60 14 $35 00 $40 00 $17.90 $20.14 $11.38 (1123 TV] $230,44 TV (FCFF -X103M 12.03) 1)PV of cash flows Year 1-5 Terminal Value 2) Add PV of terminal value c) Value of Firm Funded debt interest baring Cash & marketable securities D) Value of Equity Number of common share outstanding E) Value per share $55.43 3% $130.76 $186.19 S100.00 $20.00 $106.19 20 $10.62