Forecast Cashflow \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & \multicolumn{7}{|c|}{ Forecast Period } \\ \hline For the year ended & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Year 7 \\ \hline \multicolumn{8}{|l|}{ Net income } \\ \hline + Depreciation \&Amortization (non-cash) & $2,367 & $2,485 & $2,610 & $2,740 & $2,822 & $2,879 & $2,936 \\ \hline \multicolumn{8}{|l|}{ Changes in Net Working Capital } \\ \hline \multicolumn{8}{|l|}{ - increase in accounts receivable } \\ \hline \multicolumn{8}{|l|}{+ increase in accounts payable } \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{ Cash flow from operations }} \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline \multicolumn{8}{|l|}{ Capital expenditures } \\ \hline Capex \% of revenue & 7% & 7% & 7% & 7% & 7% & 7% & 7% \\ \hline \multicolumn{8}{|l|}{ Cash flow from investment } \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline Debt paydown & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline Debt borrowings & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \multicolumn{8}{|l|}{ Cash flow from Financing } \\ \hline & & & & & & & \\ \hline Beginning Cash Balance & $13,350 & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{ Net Cash Flow }} \\ \hline & & & & & & & \\ \hline \end{tabular} AutoSave off Search chris janos File Ho Insert Draw Page Layout Formulas Data Review View Automate Help cor General 1 + (1) Delete Format Formatting Table Styles 2 Number Styles Cells AutoSum Fill AV Clear Sort \& Find \& Editing J32 Font Alignment fx A E F G K L M N O P Q Net income $13,937 $16,536 $19,089 $21,820 $24,739 $26,428 $26,983 $27,548 Forecast Cashflow For the year ended Year 1 Forecast Period Share R Net income + Depreciation \&Amortization (non-cash) $2,367 $2,485 $2,610 $2,740 $2,822 $2,879 $2,936 Changes in Net Working Capital - increase in accounts receivable + increase in accounts payable \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Cash flow from opera & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline Capital expenditures & & & & & & & \\ \hline Capex \% of revenue & 7% & 7% & 7% & 7% & 7% & 7% & 7% \\ \hline Cash flow from inves & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline Debt paydown & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline Debt borrowings & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Cash flow from Financing Beginning Cash Balance $13,350 Ending Cash Balance 58 IS Cash Flow Bal Sheet DCF : Ready ix Accessibility: Investigate Search 10 + + 102% Forecast Cashflow \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & \multicolumn{7}{|c|}{ Forecast Period } \\ \hline For the year ended & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Year 7 \\ \hline \multicolumn{8}{|l|}{ Net income } \\ \hline + Depreciation \&Amortization (non-cash) & $2,367 & $2,485 & $2,610 & $2,740 & $2,822 & $2,879 & $2,936 \\ \hline \multicolumn{8}{|l|}{ Changes in Net Working Capital } \\ \hline \multicolumn{8}{|l|}{ - increase in accounts receivable } \\ \hline \multicolumn{8}{|l|}{+ increase in accounts payable } \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{ Cash flow from operations }} \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline \multicolumn{8}{|l|}{ Capital expenditures } \\ \hline Capex \% of revenue & 7% & 7% & 7% & 7% & 7% & 7% & 7% \\ \hline \multicolumn{8}{|l|}{ Cash flow from investment } \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline Debt paydown & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline Debt borrowings & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \multicolumn{8}{|l|}{ Cash flow from Financing } \\ \hline & & & & & & & \\ \hline Beginning Cash Balance & $13,350 & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{ Net Cash Flow }} \\ \hline & & & & & & & \\ \hline \end{tabular} AutoSave off Search chris janos File Ho Insert Draw Page Layout Formulas Data Review View Automate Help cor General 1 + (1) Delete Format Formatting Table Styles 2 Number Styles Cells AutoSum Fill AV Clear Sort \& Find \& Editing J32 Font Alignment fx A E F G K L M N O P Q Net income $13,937 $16,536 $19,089 $21,820 $24,739 $26,428 $26,983 $27,548 Forecast Cashflow For the year ended Year 1 Forecast Period Share R Net income + Depreciation \&Amortization (non-cash) $2,367 $2,485 $2,610 $2,740 $2,822 $2,879 $2,936 Changes in Net Working Capital - increase in accounts receivable + increase in accounts payable \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Cash flow from opera & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline Capital expenditures & & & & & & & \\ \hline Capex \% of revenue & 7% & 7% & 7% & 7% & 7% & 7% & 7% \\ \hline Cash flow from inves & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline Debt paydown & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline Debt borrowings & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Cash flow from Financing Beginning Cash Balance $13,350 Ending Cash Balance 58 IS Cash Flow Bal Sheet DCF : Ready ix Accessibility: Investigate Search 10 + + 102%