Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help on all parts. 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
Please help on all parts. 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 Forecast Cashflow For the year ended For the year ended Net income + Depreciation \&Amortization (non-cash) Changes in Net Working Capital - increase in accounts receivable + increase in accounts payable Forecast Period Cash flow from operations Capital expenditures Capex \% of revenue Cash flow from investment Debt paydown Debt borrowings \begin{tabular}{|r|r|r|r|r|r|r|} \hline 7% & 7% & 7% & 7% & 7% & 7% & 7% \\ \hline & & & & & & \\ \hline \end{tabular} Cash flow from Financing Beginning Cash Balance $13,350 Net Cash Flow Ending Cash Balance 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 Forecast Cashflow For the year ended For the year ended Net income + Depreciation \&Amortization (non-cash) Changes in Net Working Capital - increase in accounts receivable + increase in accounts payable Forecast Period Cash flow from operations Capital expenditures Capex \% of revenue Cash flow from investment Debt paydown Debt borrowings \begin{tabular}{|r|r|r|r|r|r|r|} \hline 7% & 7% & 7% & 7% & 7% & 7% & 7% \\ \hline & & & & & & \\ \hline \end{tabular} Cash flow from Financing Beginning Cash Balance $13,350 Net Cash Flow Ending Cash BalanceStep 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