Use the info in the spreadsheet. Fill out the yellow cells.

Year: Year 2 Year 3 150.00 180.00 225.00 150.00 180.00 225.00 Checks CI: NI Dividends Change in RE- C2: Net cash flow. Osange in cash - 0 04. Directos. Indirectos - Inputs Income statement Salary expense as of sales Balance sheet Days in a year Days of receivables Days of salary payable Cash flows contributions from shareholders Distributions) to shareholders Dividends) Income statement Sales Salary expense Operating income rax expense Ending balance sheet 1000.00 1200.00 500.00 80.00% 80.00% 80.00% 25.00% 25.00% 25.00% 360.000 360.000 360.000 36.000 36.000 36.000 72.000 72.000 72.000 300.00 30.00 0.00 0.00 0.00 -45.00 0.00-12.00-19.00 Year 1 Year 2 Year 3 1000.00 1200.00 500.00 800.00 960.00 1200.00 200.00 240.00 300.00 50.00 50.00 75.00 150.00 180.00 225.00 Cash-flow statement et income 150.00 180.00 225.00 - Operating ash flow - Investing ash flow 150.00 180.00 225.00 0.00 Direct Operating CFS Year: Year 2 Year 3 150.00 180.00 225.00 150.00 180.00 225.00 Checks CI: NI Dividends Change in RE- C2: Net cash flow. Osange in cash - 0 04. Directos. Indirectos - Inputs Income statement Salary expense as of sales Balance sheet Days in a year Days of receivables Days of salary payable Cash flows contributions from shareholders Distributions) to shareholders Dividends) Income statement Sales Salary expense Operating income rax expense Ending balance sheet 1000.00 1200.00 500.00 80.00% 80.00% 80.00% 25.00% 25.00% 25.00% 360.000 360.000 360.000 36.000 36.000 36.000 72.000 72.000 72.000 300.00 30.00 0.00 0.00 0.00 -45.00 0.00-12.00-19.00 Year 1 Year 2 Year 3 1000.00 1200.00 500.00 800.00 960.00 1200.00 200.00 240.00 300.00 50.00 50.00 75.00 150.00 180.00 225.00 Cash-flow statement et income 150.00 180.00 225.00 - Operating ash flow - Investing ash flow 150.00 180.00 225.00 0.00 Direct Operating CFS