What is ending cash in year #2

Create pro forma financial statements from the information provided below Income Statement Year 1 Year 1 Revenues Cost of Gross profit SG&A Depreciation Operating Profit Interest expense Income before taxes Taxes (335% Net Income Year 0 | Year 1 | Year 2 | com. size Sales revenues increase 3.0% 17,000 9,200 7800 4,790 1,700 1,310 100.00% Gross margin is 52% sold SG&A increases 1.0% $2200 of PP&E is purchased on January 1 New PP&E is depreciated over 10 years Inventory grows in line with COGS Assume that all other asset accounts grow in line with sales (3.0%) Accounts Payable grow in line with COGS Accrued and deferred income taxes grows in line with taxes Long-term debt declines by $200 Unless otherwise stated, liability accounts grow in line with sales (3.0%) Treasury Stock purchases equal S300 Average interest cost of all interest bearing debt is 1.4% Dividend payout ratio is 24% Tax rate is 35% Funding requirements should be financed with short-term debt 1,155 404 751 Dividends 225 Addition to retained earnings 526 Balance Sheet Assets Year 1 Cash and cash equivalents Marketable securities Accounts Receivables Invento Prepaid expen. & other assets Total Current Assets 640 28 8,200 3,142 Sales revenue decline by 2.0% Gross margin declin esto 50% Inventory grows in line with COGS SG&A declines by 1% $600of PP&E is sold on January 1 for $600 cash. (Gross-$800, Accumulated depreciation = $200) Annual depreciation expense declines by S 80 Assume that all other asset accounts grow in line with sales. (-2.0% Accounts Payable grow in line with COGS Long-term debt declines by $150 Accrued and deferred income taxes grows in line with taxes Unless otherwise stated, liability accounts grow in line with sales (-2.0%) Treasury Stock purchase is S150 Average interest cost of all interest bearing debt is 1.8% | Dividend payout ratio changes to 25% 13,333 and equipment (gross Plant pro Accumulated Depreciation PP&E (net 7,607 3,000 4,607 Total Assets 17,940 100.00% Liabilities & Shareholders' Equit Year 1 Year 0 | Year 1 | Year 2 | com. size Tax rate is 35% 3,148 Accounts payable Loans & notes payable Current matu Accrued income taxes Funding requirements should be financed with short-term debt Excess cash is used to retire short-term debt 100 shares of $1 par value common stock is issued for $400 Do not add significant amounts to cash unless Loans& notes payable is drawn down to zero lu of long-term debt 500 Create pro forma financial statements from the information provided below Income Statement Year 1 Year 1 Revenues Cost of Gross profit SG&A Depreciation Operating Profit Interest expense Income before taxes Taxes (335% Net Income Year 0 | Year 1 | Year 2 | com. size Sales revenues increase 3.0% 17,000 9,200 7800 4,790 1,700 1,310 100.00% Gross margin is 52% sold SG&A increases 1.0% $2200 of PP&E is purchased on January 1 New PP&E is depreciated over 10 years Inventory grows in line with COGS Assume that all other asset accounts grow in line with sales (3.0%) Accounts Payable grow in line with COGS Accrued and deferred income taxes grows in line with taxes Long-term debt declines by $200 Unless otherwise stated, liability accounts grow in line with sales (3.0%) Treasury Stock purchases equal S300 Average interest cost of all interest bearing debt is 1.4% Dividend payout ratio is 24% Tax rate is 35% Funding requirements should be financed with short-term debt 1,155 404 751 Dividends 225 Addition to retained earnings 526 Balance Sheet Assets Year 1 Cash and cash equivalents Marketable securities Accounts Receivables Invento Prepaid expen. & other assets Total Current Assets 640 28 8,200 3,142 Sales revenue decline by 2.0% Gross margin declin esto 50% Inventory grows in line with COGS SG&A declines by 1% $600of PP&E is sold on January 1 for $600 cash. (Gross-$800, Accumulated depreciation = $200) Annual depreciation expense declines by S 80 Assume that all other asset accounts grow in line with sales. (-2.0% Accounts Payable grow in line with COGS Long-term debt declines by $150 Accrued and deferred income taxes grows in line with taxes Unless otherwise stated, liability accounts grow in line with sales (-2.0%) Treasury Stock purchase is S150 Average interest cost of all interest bearing debt is 1.8% | Dividend payout ratio changes to 25% 13,333 and equipment (gross Plant pro Accumulated Depreciation PP&E (net 7,607 3,000 4,607 Total Assets 17,940 100.00% Liabilities & Shareholders' Equit Year 1 Year 0 | Year 1 | Year 2 | com. size Tax rate is 35% 3,148 Accounts payable Loans & notes payable Current matu Accrued income taxes Funding requirements should be financed with short-term debt Excess cash is used to retire short-term debt 100 shares of $1 par value common stock is issued for $400 Do not add significant amounts to cash unless Loans& notes payable is drawn down to zero lu of long-term debt 500