Pro Froma balance sheet 12/31/16. Fill in highlighted cells using formulas

ASSETS Cash Short-Term Investments Cash and Short-Term Investments Receivables - Trade Income Tax Refund Current Receivables - Other Receivables Inventories - Raw Materials Inventories - Work in Process Inventories - Finished Goods Inventories - Other Inventories - Total Prepaid Expense Other Curr Asst, Excl.Ppd.Exp. Current Assets - Other Current Assets - Total P.P.& E.- Total (Gross) Deprec.Depl.& Amort. Invest. & Advances - Eq.Meth. Invest. & Advances - Other Intangibles Prop.Plant & Equip.- Total (Net) Deferred Charges Other Asst., Excl.Def.Chg. LAssets - Other Total Assets LIABILITIES Accounts Payable Income Taxes Payable Debt in Current Liabilities Accrued Expense Other Curr.Liab., Excl.Accr.Exp. Current Liabilities - Other Current Liabilities - Total Debt-Convertible (Total) Debt-Subordinated Convertible Debt - Senior Convertible Debt-Subordinated Debt-Notes Debt-Debentures Long-Term Debt-Other Debt-Cap. Lease Oblig. Long-Term Debt-Total Liabilities - Other Deferred Taxes Investment Tax Credit Noncontrolling Interest - Redeemable Def. Taxes and Invest.Tax Cred. Liabilities - Total SHAREHOLDERS' EQUITY Pref. Stock - Redeemable Pref. Stock - Nonredeemable Preferred Stock-Carrying Value Common Stock Capital Surplus Retained Earnings Less: Treas Stock - Total $ Amt. Noncontrolling Interest - Nonredeemable Common Equity - Total Shareholders Equity - Total Total Liabilities and Shareholders Equity Notes Payable Debt-Due in One Year