Please answer forecasting worksheet and show the formulas and a brief description how you came up with the numbers.I need assistance on how to solve this worksheet

Balance Sheet Actual 2015 Cash Shrot-term investments 10.0 0.0 Forecast Basis Income Statement First Pass 2016 AFN 2nd Pass 2016 Actual 2015 Sales 3,000.0 Costs except depreciation 2,617.0 Accounts receivable 375.0 Depreciation Inventories 615.0 Total operating costs Total current assets 1,000.0 EBIT Net PP&E 1,000.0 Less interest Total assets 2,000.0 Earnings before taxes 60.0 100.0 2,717.0 283.0 Taxes Accounts payable Forecast First Pass 2nd Pass Basis 2016 Feedback 2016 88.0 195.0 78.0 NI before preferred dividends 117.0 Accruals 140.0 Dividends to preferred Notes payable 110.0 NI available to common Total current liabilities 310.0 Dividends to common 57.0 Long-term bonds 754.0 Addition to retained earnings 56.0 Total debt 40.0 Common stock 130.0 Notes Payable Retained earnings 766.0 Long-term Bonds Total common equity 896.0 2,000.0 AFN Cumulative AFN 113.0 1,064.0 Preferred stock Total liabilities and equity 4.0 AFN Financial Mix Interest or dividend rate 6.11% 9.00% 41.89% 10.36% Preferred Stock 2.22% 10.00% Common Equity 2016 Sales Growth 49.78% Common dividend growth rate Common dividend in 2015 10% Tax Rate 40% 8% # of shares outstanding in 2015 1.14 Stock price in 2015 50 23