I need the following assignment completed by 11am ESTtomorrow 2-22-16.(A)quality work, no plagiarism.Attached are the Ratio Formulas (13 required), Financial Statements for Moserk Company and rubric.

Reviewthe assigned MoserkCompany's financial statements.

Calculatethe financial ratios for the assigned company's financial statements.

Writea minimum 500-word summary of your analysis.

• Explain the possible reasons for any differences between the company's ratios and those of the industry average..
• Compare the calculated financial ratios against the industry averages stating the possible reasons for the differences.

Showallfinancial calculations in a Microsoft Excel spreadsheet.

FINANCIAL RATIO FORMULA REVIEW There are 4 major ratio categories as follows: I. Liquidity Ratios 1. Current ratio 2. Quick ratio II. CurrentAssets CurrentLiabilities CurrentAssets Inventory CurrentLiabilities Leverage Ratios 3. Debt to assets ratio TotalDebts TotalAsset s 4. Debt to equity ratio TotalDebts Owner ' sEquity 5. Time interest earned 6. Fixed charge coverage III. IncomeBeforeTaxes Interest InterestCh arg es IncomeBeforeTaxes & Interest Lease LeaseCh arg es Activity Ratios 7. Inventory turnover Sales Inventory 8. Total asset turnover Sales TotalAsset s 9. Account receivable turnover Sales Account Re ceivable Based on a comparison of sales with the credit granted to generate the sales, it shows the average length of time to collect the credit. IV. Profitability Ratios 10. Gross profit margin Sales CostofGoodsSold Sales 11. Net profit margin NetIncome Sales 12. Return on total assets NetIncome TotalAsset s 13. Return on equity NetIncome Owner ' sEquity Financial Statements for Moserk Company Income Statement for year ending December 31st Year 20XX $119,299 Sales (Revenues) Costs and Expenses: Cost of Goods Sold Operating, selling and admin expenses Interest Costs: Debt Capital leases Total Costs and Expenses 93,438 9,358 555 229 103,580 15,719 Income Before Income Taxes 4,716 Taxes $11,003 Net Income ______________________________________________________________________________ Balance Sheetfor year ending December 31st 20XX Assets Current Assets: Cash and cash equivalents Receivables Inventories Prepaid expenses and other Total Current Assets $1,447 976 16,497 432 19,352 Property, Plant and Equipment, net Property under Capital Lease, net Other Assets and Deferred Charges Total Assets 21,469 2,137 2,426 $45,384 Liabilities and Shareholders' Equity Current Liabilities: Total Current Liabilities $14,460 Long-Term Debt Long-Term Obligations Under Capital Leases Deferred Income Taxes and Other Total Long-term Liabilities Total Liabilities 7,191 2,483 809 $10,483 $24,943 Shareholders' Equity Private Common stock ($.10 par value; 2,241 issued and outstanding) Capital in excess of par value Retained earnings Total Shareholders' Equity Total Liabilities and Shareholders' Equity $224 585 19,632 20,441 $45,384 Industry Average Ratios to be calculated (show work) Current Ratio Quick Ratio Gross Profit Margin Net Profit Margin Debt Ratio (Debt to assets) Debt Ratio (Debt to equity) Times Interest Earned ROA ROE 2.10 0.75 25.00% 10.00% 0.45 1.20 15.00 14.50% 28.75% Rubric Fin 375 Online Week 5 Individual Paper Name Total assignment points 30 1. Does the paper meet the minimum word count? (Max points 1) Papers which do not meet the minimum word count shall receive no points. Papers may exceed the minimum word count. Points Earned Comment 500 word minimum required 2. Does the paper have an introduction and conclusion section? (Max points 1) A good introduction clearly explains to the reader what the purpose of the paper is. A good conclusion summarizes one or two key points that the author wishes the reader to retain. If the paper does not have either an introduction or a conclusion section then no points will be earned. Points Earned Comment 3. Does the paper use headers? (Max points 1) Headers provide the reader with the organizational structure of the paper and make the work more readable. Points Earned Comment 4. Does the paper contain any spelling, grammar or sentence structure errors? (Max points 1) If any spelling, grammar or sentence structure errors are noted then no points will be awarded. Points Earned Comment 5. Does the paper properly provide footnotes and source references? (Max 1 points) Points Earned Comment 6. Does the paper show the correct calculation results for the nine ratios found in the ratio formula review (located under student materials in the assignment ? (Max 18 points) Points Earned Comment 7. Does the paper discuss any possible reasons for the company ratio results compared to the industry averages? (Max 7 points) Points Earned Comment Grade /30