Need help filling int he blanks to this excel spreadsheet

Example - Enterprise Valuation & Terminal Value Given (You may use your numbers instead!) Gross Margin 40% Fixed Costs $ 2,000 Revenue Growth Rate for Years 1 - 5 10% FCF Steady Growth 3% Discount Rate 12% Year 1 Revenue $ 5,000 Tax Rate 35% Terminal Year 5 Solution Legend Value given in problem Formula/Calculation/Analysis required Crystal Ball Input Crystal Ball Output 1 2 Revenues Gross profits Fixed Costs Net Operating Income Taxes Free Cash Flow NPV for Years 1-5 Cash Flows Terminal Value (as of Year 5) PV of Terminal Value Enterprise Value Terminal Value / Enterprise Value Author: Using Crystal Ball is not required 3 4 5