Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fill out dark grey boxes in lower portion with equations on how numbers were gotten Total revenue Revenue growth begin{tabular}{|r|r|r|r|r|r|r|r|} hline$110,954 & $116,502 & $122,327
Fill out dark grey boxes in lower portion with equations on how numbers were gotten
Total revenue Revenue growth \begin{tabular}{|r|r|r|r|r|r|r|r|} \hline$110,954 & $116,502 & $122,327 & $128,443 & $134,865 & $138,911 & $141,689 & $144,523 \\ \hline 5% & 5% & 5% & 5% & 3% & 2% & 2% \\ \hline \end{tabular} Operating expenses Operating expense growth \begin{tabular}{|r|r|r|r|r|r|r|r|} \hline$87,411 & $90,033 & $92,734 & $95,516 & $98,382 & $100,349 & $102,356 & $104,404 \\ \hline 3% & 3% & 3% & 3% & 2% & 2% & 2% \\ \hline \end{tabular} EBT $19,543$2,54113%$22,639$2,94313%$25,646$3,33413%$28,858$3,75213%$32,286$4,19713%$34,284$4,45713%$34,999$4,55013%$35,729$4,64513% \begin{tabular}{llllllll} \hline$17,002 & $19,696 & $22,312 & $25,106 & $28,089 & $29,827 & $30,449 & $31,084 \end{tabular} Forecast Period \begin{tabular}{|l|r|r|r|r|r|r|r|} \hline \multirow{2}{*}{ For the year ended } & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Year 7 \\ \hline & & & & & & \\ \hline Net income & $19,696 & $22,312 & $25,106 & $28,089 & $29,827 & $30,449 & $31,084 \\ \hline + Depreciation \&Amortization (non-cash) & $2,330 & $2,447 & $2,569 & $2,697 & $2,778 & $2,834 & $2,890 \\ \hline \end{tabular} Changes in Net Working Capital - increase in accounts receivable + increase in accounts payable Cash flow from operations Capital expenditures Capex % of revenue \begin{tabular}{|l|l|l|l|l|l|l|} \hline 7% & 7% & 7% & 7% & 7% & 7% & 7% \\ \hline \end{tabular} Cash flow from investment Debt paydown Debt borrowings \begin{tabular}{|r|r|r|r|r|r|r|} \hline$0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline$0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Cash flow from Financing Beginning Cash Balance $14,268 Net Cash Flow Ending Cash Balance first year of AR is 12500 first year of AP is 8500 that's all thats givenStep 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