Based on the attached balancesheet / incomestatement, kindly provide the required financial ratios.It's on EXCEL SHEET, it will be easy to use formula.Appreciate your help.

Period Ending:

12/31/2016Liquidity RatiosCurrent Ratio

Quick Ratio

Cash Ratio

Profitability RatiosGross Margin

Net Profit Margin

Return on Investment

Return on Equity

Financial Leverage Ratios

Debt-to-Equity

Debt-to-Total-Asset

Total Capitalization

Coverage Ratio

Interest Coverage

Receivable Turnover

Average Collection Period

Payable Turnover

Inventory Turnover

Total Asset Turnover

Income Statement Annual Income Statement (values in 000's) Period Ending: Total Revenue Cost of Revenue Gross Profit Operating Expenses Research and Development Sales, General and Admin. Non-Recurring Items Other Operating Items Operating Income Add'l income/expense items Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax Minority Interest Trend 12/31/2016 $4,825,335 $2,584,724 $2,240,611 $0 $1,823,140 $0 $0 $417,471 -$2,755 $414,716 $26,434 $388,282 $131,303 $0 Equity Earnings/Loss Unconsolidated Subsidiary Net Income-Cont. Operations $0 $256,979 Net Income $256,979 Net Income Applicable to Common Shareholders $197,979 FINANCIAL RATIOS Period Ending: Liquidity Ratios Current Ratio Quick Ratio Cash Ratio Profitability Ratios Gross Margin Net Profit Margin Return on Investment Return on Equity Financial Leverage Ratios 12/31/2016 Debt-to-Equity Debt-to-Total-Asset Total Capitalization Coverage Ratio Interest Coverage Receivable Turnover Average Collection Period Payable Turnover Inventory Turnover Total Asset Turnover Read more: htp://www.nasdaq.com/symbol/ua/fnancials?query=income-statement#ixzz4hW6UTKR3 Balance Sheet Annual Income Statement (values in 000's) Period Ending: Current Assets Cash and Cash Equivalents Short-Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long-Term Assets Long-Term Investments Fixed Assets Goodwill Intangible Assets Other Assets Deferred Asset Charges Total Assets Current Liabilities Accounts Payable Short-Term Debt / Current Portion of Long-Term Debt Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Deferred Liability Charges Misc. Stocks Minority Interest Total Liabilities Stock Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity Total Liabilities & Equity Trend 12/31/2016 $250,470 $0 $622,685 $917,491 $174,507 $1,965,153 $0 $804,211 $563,591 $64,310 $110,204 $136,862 $3,644,331 $618,429 $27,000 $40,387 $685,816 $790,388 $137,227 $0 $0 $0 $1,613,431 $145 $823,484 $1,259,414 $0 -$52,143 $2,030,900 $3,644,331 ixzz4hW6UTKR3