show all work in excel, please!

Assignment: Create a Data Table that shows sensitivity of Enterprise Value to two input parameters of your choice from: Gross margin, Revenue Growth in years 1-5, steady growth after year 5 or discount rate.

Do conditional formatting for data tables

Create a Data Table that shows sensitivity of Enterprise Value to two input parameters of your choice from: Gross margin, Revenue Growth in years 1-5, steady growth after year 5 or discount rate. Do conditional formatting for data tables Gross Margin Fixed Costs Revenue Growth Rate for Years 1 - 5 FCF Steady Growth Discount Rate Year 1 Revenue Tax Rate Terminal Year 40% $2,000 10% 3% 12% $5,000 21% 5 Revenues Gross profits Fixed Costs Net Operating Income Taxes Free Cash Flow 1 2 3 5 $5,000 $5,500 $6,050 $6,655 $7,321 2,000 2,200 2,420 2,662 2,928 (2,000) (2,000) (2.000) (2,000) (2,000) S - $ 200 S 420 S 662 S 928 s 's (42)'s (88)'s (139)'s (195) S - $ 158 S 332 S 523 S 733 NPV for Years 1-5 Cash Flows Terminal Value (as of Year 5) PV of Terminal Value Enterprise Value $1,111