Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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 Balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Complete Guide To Property Finance

Authors: Richard W J Brown

1st Edition

1739832027, 978-1739832025

More Books

Students also viewed these Finance questions