Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Growth Stage Stage 1 - Near-term Growth 2020E 2021E 2022E Revenue Growth 20.0% 25.0% 23.5% Gross Margin 81.9% 81.9% 81.9% R&D Percent 19.0% 18.8% 18.8%
Growth Stage Stage 1 - Near-term Growth 2020E 2021E 2022E Revenue Growth 20.0% 25.0% 23.5% Gross Margin 81.9% 81.9% 81.9% R&D Percent 19.0% 18.8% 18.8% SG&A Percent 27.5% 27.0% 26.7% Tax Rate 15.0% 19.0% 20.0% What is your forecast for each year? 2020E 2021E 2022E EBITDA ($MM) 40,023 GAAP EPS* 9.06 *Full Diluted Earnings Per Share (EPS) row 58 in SFAM
pls give me the excel formula not steps
\begin{tabular}{|l|r|r|r|} & & \multicolumn{3}{c|}{ Growth Stage } \\ \cline { 2 - 4 } & & \multicolumn{3}{|c|}{ Stage 1 - Near-term Growth } \\ \hline Revenue Growth & 2020E & 2021E & 2022E \\ \hline Gross Margin & 20.0% & 25.0% & 23.5% \\ \hline R\&D Percent & 81.9% & 81.9% & 81.9% \\ \hline SG\&A Percent & 19.0% & 18.8% & 18.8% \\ \hline Tax Rate & 27.5% & 27.0% & 26.7% \\ \hline \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started