Spacely's Sprockets Spacely's Sprockets 2016 2017 2016 2017 2016 2017 Sales $38.000 $ 53.200 Assets Liabilities and Equity Cost of Goods Sold 15,200 Cash $ 6,500 Accounts Payable $ 1.200 Gross Profit 22,800 Accounts Receivable 1.600 Notes Payable 900 SGA 14,500 Inventory 1,800 Total Current Liablitos 2.100 Depreciation 3.500 6.000 Total Current Assets 9,900 Long-Term Debt 22,500 Operating Income (EBIT) 47300 Total 24000 Interest Expense 1.200 Fixed Assets Gross 45,000 Earrings Before and S7600 Loss Accumulated Depreciation 17.500 Common Stock 3.200 Income Tax Fixed Assets, Nel 27500 Retained Earnings 9.600 Net Income S060 Total Common Equity 12800 Total Assets $ 37,400 Total Labies and Equilly 700 Dividends Paid $ 1.2005 3,407 Change in Retained Earringe 3 10 if Spacely Sprockets is looking to expand by bulding a new $25,000 manufacturing facility How much will their new change in retained Gaming bo? What is the company's totalset tumover? How much new funds wil they require? What is the companys quick ratio? What will their new total liabilities and equity be? (Sales will increase by 40%,grossfixed assets will increase by $25,000. All other figures wil behave nomaly) 540 Mar Apr May Jun 1,000 100 1,100 550 1,350 1,200 Spacely's Sprockets Cash Inflows Nov Dec Jan Feb Cash Collections In month of sales $ 900 $ 925 $ Month after sales $ 50 $ 75 $ Total cash collections 950 $ 1,000 $ Cash Outflows Payments of materials purchases In month of purchase 450 $ 500 $ Month following purchase 1,250 $ 1,300 $ Other cash payments SGA (monthly) 1,200 1,200 Interest payments 750 Total cash outflows 800 1,450 Net cash gain / (loss) $ 150 $ (450) $ Cash Flow Summary Cash balance at start of month $ 1,200 Net cash gain / (loss) during month Cash balance at end of month before financing Minimum cash balance desired 1,000 1.000 Surplus/ (deficit) cash External Financing Summary External financing at start of month 25 New financing required Financing repayments External financing at end of month Cash balance at end of month after financing 850 250 1,000