Question: 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

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 income

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!