Calculate the rest from the information in the first picture

First Year Assignment Assumptions Hist. Prej Proj. Prep ProjProj Year Year 1 Year 2Year 3 Year 4 Years Income statement 15% 0% 14% Sales growth COGS as % of sales Depreciation as % of beginning fixed assets SC&A as % of sales Tax rate as % of profit before tax Dividends as % of profit after tax Weighted average share outstanding 24% 27% 30% 25% 23% 20% 23% De 7000 7200 7200 7300 Assets Operating current assets as % of sales Capex as % of sales 0 % Liabilities Operating liabilities as % of COGS 30% 30% 30% Equity Shares issued in your 0 100 Debr 300 200 000 300 Issuance of long-term debt Repayment of long-term debt 50 100 100 100 100 Interest rates 3% obs31% Interest rate on revolver Interest rate on long-term obt 4% Interest income on cash 19 19 First Year Assignment Hist. Proj. Proj. Proj. Proj. Proj. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Calcs Property, plant and equipment, net (fixed assets) Beginning balance Capital expenditure Depreciation Ending balance Equity Beginning balance Net income Dividends Ending balance OWC Operating current assets Operating current liabilities OWC First Year Assignment Hist. Proj. Proj. Proj. Proj. Proj. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Debt Revolver Balance Interest rate Interest expense Long-term debt Beginning balance Issuance Repayment Ending balance Interest rate Interest expense Interest expense summary Revolver Long-term debt Total interest expense Interest income Cash balance Interest rate Interest income First Year Assignment Hist. Proj. Proj. Proj. Proj. Proj. Year Year Year Year Year 1 2 3 4 5 Inc Stat Year o Sales Cost of goods sold Depreciation Gross profit 64.760.0 57.714.0 2.157.0 4,889.0 SG&A Operating profit Interest income Interest expense Profit before tax 1,884.0 3,005.0 34.1 1,090.0 1,917.8 Tax expense Net Income 433.0 1,484.8 Dividends 656.0 Shareholder information Weighted average shares outstanding Earnings per share 6,989.0 0.2 Dividends per share 0.1 First Year Assignment Hist. Proj. Proj. Proj. Proj. Proj. Year 1 Year 2 Year 3 Year 4 Year 5 BalSheet 0.0 Assets 3,408.0 Cash Operating current assets Total current assets 9.471.0 12,879.0 Property, plant and equipment Total assets 39,423.0 52,302.0 Liabilities & equity Operating current liabilities 17,927.0 Revolver Total current liabilities 17,927.0 0.0 Long-term debt Total liabilities 21,122.0 39,049.0 Equity 13,253.0 Total liabilities & equity 52,3020 Balance check OK First Year Assignment CashFlow Hist. Proj Proj. Proj. Proj. Proj Year Year 1Year 2 Year 3 Year 4 Years Net Income + Depreciation (Inc) dec in Operating Working Capital Operating cash flow - Capital expenditure Investing cash flow Inc (dec) in long-term debt Dividends Financing cash flow NET CASH FLOW Cash analysis Beginning cash Net cash flow Ending cash First Year Assignment Assumptions Hist. Prej Proj. Prep ProjProj Year Year 1 Year 2Year 3 Year 4 Years Income statement 15% 0% 14% Sales growth COGS as % of sales Depreciation as % of beginning fixed assets SC&A as % of sales Tax rate as % of profit before tax Dividends as % of profit after tax Weighted average share outstanding 24% 27% 30% 25% 23% 20% 23% De 7000 7200 7200 7300 Assets Operating current assets as % of sales Capex as % of sales 0 % Liabilities Operating liabilities as % of COGS 30% 30% 30% Equity Shares issued in your 0 100 Debr 300 200 000 300 Issuance of long-term debt Repayment of long-term debt 50 100 100 100 100 Interest rates 3% obs31% Interest rate on revolver Interest rate on long-term obt 4% Interest income on cash 19 19 First Year Assignment Hist. Proj. Proj. Proj. Proj. Proj. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Calcs Property, plant and equipment, net (fixed assets) Beginning balance Capital expenditure Depreciation Ending balance Equity Beginning balance Net income Dividends Ending balance OWC Operating current assets Operating current liabilities OWC First Year Assignment Hist. Proj. Proj. Proj. Proj. Proj. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Debt Revolver Balance Interest rate Interest expense Long-term debt Beginning balance Issuance Repayment Ending balance Interest rate Interest expense Interest expense summary Revolver Long-term debt Total interest expense Interest income Cash balance Interest rate Interest income First Year Assignment Hist. Proj. Proj. Proj. Proj. Proj. Year Year Year Year Year 1 2 3 4 5 Inc Stat Year o Sales Cost of goods sold Depreciation Gross profit 64.760.0 57.714.0 2.157.0 4,889.0 SG&A Operating profit Interest income Interest expense Profit before tax 1,884.0 3,005.0 34.1 1,090.0 1,917.8 Tax expense Net Income 433.0 1,484.8 Dividends 656.0 Shareholder information Weighted average shares outstanding Earnings per share 6,989.0 0.2 Dividends per share 0.1 First Year Assignment Hist. Proj. Proj. Proj. Proj. Proj. Year 1 Year 2 Year 3 Year 4 Year 5 BalSheet 0.0 Assets 3,408.0 Cash Operating current assets Total current assets 9.471.0 12,879.0 Property, plant and equipment Total assets 39,423.0 52,302.0 Liabilities & equity Operating current liabilities 17,927.0 Revolver Total current liabilities 17,927.0 0.0 Long-term debt Total liabilities 21,122.0 39,049.0 Equity 13,253.0 Total liabilities & equity 52,3020 Balance check OK First Year Assignment CashFlow Hist. Proj Proj. Proj. Proj. Proj Year Year 1Year 2 Year 3 Year 4 Years Net Income + Depreciation (Inc) dec in Operating Working Capital Operating cash flow - Capital expenditure Investing cash flow Inc (dec) in long-term debt Dividends Financing cash flow NET CASH FLOW Cash analysis Beginning cash Net cash flow Ending cash