could you do both 10% and 20%

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% 2.5% 8% 12% SUBMISSION: Wed Sept 16, 2020 BRIGHTSPACE DROP BOX DISCOUNTED CASH FLOW ("DCF") 1 2 3 4 5 in qilions $'s ACTUAL 2020 Revenues 10% or $100.00 REVENUE GROWTH Expenses 20% Taxes A) EBIT(1.) or NOPAT Depreciation Capital Expenditures & NCWC B) FREE CASH FLOW TO FIRM ("FCFF") Discount Rate (WACCI PY OF FCFF (per year) 2021 2022 2023 $115.00 12.25 $152.09 15.00% 15.OON 15.00 369 000 -$12.00 $1300 $1500 $34.00 $40 25 $46 09 -$2300 $26.00 $30 00 $11.00 $14.25 $16.09 1296 59 82 $11.36 $11 45 2024 2025 $174.90 $2011 15.00% 15.00N US $1200 -$1700-$2000 $52 90 $60 14 $35.00 $40.00 $17.90 $20.14 $11.38 $11.43 $55.43 TV 5230 44 TV - (FCFF. * 103Y 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 bang Cash & marketable securities D) Value of Equity Number of common shares outstanding E) Value per share $130.76 $186.19 $100.00 $20.00 $106.19 1000 $10.62 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% 2.5% 8% 12% SUBMISSION: Wed Sept 16, 2020 BRIGHTSPACE DROP BOX DISCOUNTED CASH FLOW ("DCF") 1 2 3 4 5 in qilions $'s ACTUAL 2020 Revenues 10% or $100.00 REVENUE GROWTH Expenses 20% Taxes A) EBIT(1.) or NOPAT Depreciation Capital Expenditures & NCWC B) FREE CASH FLOW TO FIRM ("FCFF") Discount Rate (WACCI PY OF FCFF (per year) 2021 2022 2023 $115.00 12.25 $152.09 15.00% 15.OON 15.00 369 000 -$12.00 $1300 $1500 $34.00 $40 25 $46 09 -$2300 $26.00 $30 00 $11.00 $14.25 $16.09 1296 59 82 $11.36 $11 45 2024 2025 $174.90 $2011 15.00% 15.00N US $1200 -$1700-$2000 $52 90 $60 14 $35.00 $40.00 $17.90 $20.14 $11.38 $11.43 $55.43 TV 5230 44 TV - (FCFF. * 103Y 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 bang Cash & marketable securities D) Value of Equity Number of common shares outstanding E) Value per share $130.76 $186.19 $100.00 $20.00 $106.19 1000 $10.62