how to find current ratio (excluding cash), Debt to Equity, ROE and Forward internal growth rate

% of Sales Method Growth 28.6% Financial Statements: Sales Expenses Taxes Net Earnings Actual 2017 500,000 350,000 50,000 100,000 100.0% -70.0% - 10.0% 20.0% Forecast 2018 642,857 - 450,000 - 64,286 128,571 Cash Accounts Receivable Inventory Fixed Assets Total 25,000 50,000 25,000 300,000 400,000 5.0% 10.0% 5.0% 60.0% 32,143 64,286 32,143 385,714 514,286 Accounts Payable Long Term Debt Common Stock Retained Earnings (1) Liab & Equity 50,000 125,000 75,000 150,000 400,000 10.0% 35,714 Same 64,286 64,286 160,714 75,000 214,286 514,286 Current Ratio (excluding Cash) Debt to Equity ROE Forward Internal Growth Rate (2) 1.500 0.556 44.496 28.6% 1.500 0.556 44.495 28.6% Notes: 1. Dividends = 50% of Ni or 50% RR 2. (ROEX RR)/(1-ROE XRR) - retained ROE / beginning equity