Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help on ebitda line and below. Thank you! Forecast Income Statement begin{tabular}{|c|c|c|c|c|c|c|c|c|} hline For the year ended & Year 0 & Year 1 &
Please help on ebitda line and below. Thank you!
Forecast Income Statement \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline For the year ended & Year 0 & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Year 7 \\ \hline Total revenue & $104,832 & $110,074 & $115,577 & $121,356 & $127,424 & $131,247 & $133,872 & $136,549 \\ \hline Revenue growth & & 5% & 5% & 5% & 5% & 3% & 2% & 2% \\ \hline Operating expenses & $91,692 & $94,443 & $97,276 & $100,194 & $103,200 & $105,264 & $107,369 & $109,517 \\ \hline Operating expense growth & & 3% & 3% & 3% & 3% & 2% & 2% & 2% \\ \hline \multicolumn{9}{|l|}{ EBITDA } \\ \hline \multicolumn{9}{|l|}{ EBITDA margin } \\ \hline & & & & & & & & \\ \hline Depreciation \& Amortization & $2,500 & & & & & & & \\ \hlineD&A% of revenue & 2% & 2% & 2% & 2% & 2% & 2% & 2% & 2% \\ \hline \multicolumn{9}{|l|}{ EBIT } \\ \hline \multicolumn{9}{|l|}{ EBIT margin } \\ \hline Interest Expense & $1,500 & $1,500 & $1,500 & $1,500 & $1,500 & $1,500 & $1,500 & $1,500 \\ \hline Interest rate & 5% & 5% & 5% & 5% & 5% & 5% & 5% & 5% \\ \hline \multicolumn{9}{|l|}{ EBT } \\ \hline & & & & & & & & \\ \hline \multicolumn{9}{|l|}{ Tax } \\ \hline Tax rate & 13% & 13% & 13% & 13% & 13% & 13% & 13% & 13% \\ \hline 2= & & & & & & & & \\ \hline \end{tabular} Net incomeStep 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