1. Using the data from the Income Statement and Balance Sheet, provide the correct calculation of the liquidity ratios and an assessment of the company's ability to maintain liquidity and the management of current assets and current liabilities, include the proper assessment of outcomes as positive or negative trends when all ratio outcomes are factored as a group Liquidity Ratios Current Ratio Quick Rato 2. Using the data from the income Statement and Balance Sheet, provide the correct calculation of the activity ratios and an assessment of the company's ability to maintain liquidity, include the proper assessment of outcomes as positive or negative trends when all four rabo outcomes are factored as a group. Activity Ratios Inventory Turnover Accounts Receivables Tumover Total Asset Turnover Average Collection Period 3. Using the data from the income Statement and Balance Sheet provide the correct calculation of the financing ratios. Include the proper assessment of outcomes as positive or negative trends when all three ratio outcomes are factored as a group. Financing Ratios Financing Ratios Debt Ratio. Debt-to-Equity Ratio Tenes Interest Eamed Ratio 4. Using the data from the price per share data, the income Statement, and the Balance Sheet, provide the correct calculation for the market value ratios below Market Value Ratios Earnings per Share (EPS) Price Camings (PE) 5. Using the data from the Income Stacement and Balance Sheet, provide the comect calculation of these tour profiability radios and an assessment of the company's ability to mainmain if not improve profitabaty based on the amounts of equity, assets, and levels off profits from sales, include the proper assessment of outcomes as positive or negative trends when all four rato outcomes are factored as a group Profitability Ratios Retum on Equity (ROE) Return on Asses (ROA) Net Protic Marg Operating Profit Margin Part 2 In this part of your assignment, you will compose an analyical study reporting your results from Part 1 The CEO of your company is forming a task force to review the financials and present a review for acquisition of ABC Company Based on ABC's previous 3 years of financials, determine if this would be a good acquisition You must firm the task force to complete tak The CEO would most of the departments to participate in the process. Using each departments area of expertise, what information would each of the following department contribute to the final dechion? Provide a minimum one-paragraph response for each department. Finance Department Sales Department . . Marketing Department Human Resources Legal Department Part 3 After your team has provided their input on the effect the acquisition will have on their department, perform an overall analysis to explain your recommendation to the CEO. Your analysis should include the following: Explain how the company is trending based on the year-over-year ratios. . Compare the company to the industry average in Appendix A in the Excel workbook in areas of profitability, management effectiveness, and efficiency. . Based on the above, summarize the pros and cons of ABC Company using both the year-over-year ratio analysis from Part 1 and the industry average comparisons from Part 3. Provide the team's final recommendation as to whether or not the CEO should invest in ABC Company. Your paper should follow this format: Title page with each team member's name that on the team.proiect Minge Period Ending Total Sales Cost of Goods Sold E Gross Profit 7 Selling Generall and Adminstrative 1 Operating Profit N Total Other Income/Expenses Net 10 Earnings before Interest and Taxes Interest Expense 12 Income Before Tax 13 Income Tax Expense 14 15 Discontinued Operations 36 Net Income (Net Profit) 14,000,000 Shares outstanding B C D ABC Company Income Statement Net Income from Continuing Ops 17 18 Market Share price per share 19 20 ABC Company Balance Sheet 21 22 Period Ending 23 Assets 24 Current Assets 25 Cash and Cash Equivalents 28 Net Receivables 27 inventory Income Statement Balance Sheet Cu Append E 31-Dec-15 31-Dec-14 31-Dec-13 $485,651.000 $476.294.000 $475,210,000 365,086,000 358,069,000 350,400,000 120,565.000 118,225,000 93,418,000 91.353.000 26.872,000 27,147,000 113,000 119,000 124,810,000 90,343.000 34,467,000 115.000 34,352,000 2,200.000 2.335,000 24,418,000 32,152.000 7.985,000 16,588,000 8,105,000 9,800,000 16,313,000) 22.352.000 182,000 144,000 285,000 $16,303,000 $16,169,000 $22,170,000 27,034,000 26,753,000 2.461,000 24,573,000 $10.00 F 2015 $9.135.000 6,778,000 45,141,000 G H $9.00 2014 $8.50 2013 $7,281,000 $6.789.000 6.677,000 6.525,000 44.850,000 43,989,000 Current Liabilities Accounts Payable Other current Liabilities Short-term Debt Total Current Liabilities 2015 58.583.000 6,689.000 65,272,000 N 2014 57,174,000 99,000 12,082.000 49.345.000 2013 56,210,000 55.000 14,050,000 10,315,000 28 Other Cum Assets 29 fotal Current Assets 30 Property Plant and Equipment 31 Goodwi 32 Other Assets 33 Total Assets 34 AN 40 41 2002888Sa5c0O 43 44 45 MT217 Unit3 Workbook.xlsx The Et In Formal H QQ Con ABC Company Income Statement 47 BAITA SAMATA DONOVA TINE B that-MTZT A Wo -R RUSA C 4 2.349,000 D 2.224,000 63,278,000 116,655.000 18,102,000 19,510,000 17,900,000 5,671,000 6,149,000 4,500,000 200,706,000 204,751,000 202,202,000 61,185,000 59,502,000 117,907,000 120 300.000 H 2.199,000 Long-term Debt 43,692.000 Deferred Long-teem Liability char 8,805.000 Monority interest 4,543,000 122,312,000 Total Liabilities Miscellaneous Stock Options W Common Stock Retained Earnings 0 of Shares Outstanding Market share price per share 323,000 45.777.000 2,462.000 Captial Surpiun Other Stockholders Equity 7,168,000 Total Stockholders Equity $1.394,000 Total Liabilities & Stockholders 200,706.000 14,000,000 $10.00 M 44,559,000 8.017/000 5.064.000 127,005.000 0 323,000 76,166.000 2,362.000 +1.505.000 77,746,000 204,751,000 14,000,000 $9.00 0 45.324.000 13.553.000 6.875.000 136,067,000 of 323,000 65,790,000 2,262,000 -2,200,000 66,135,000 202,200,000 14,000,000 $8.50 0 the # 7 3 4 5 0 A 7 A Liquidity Ratios Current Ratio Quick Ratio Activity Ratios Inventory Turnover D Accounts Recievables Turnover 10 Total Asset Turnover 11 Average Collection Period. 12 13 Financing Ratios 14 Debt Ratio 15 Debt-to-Equity Ratio 16 Times Interest Eamed Ratio 17 18 Market Ratios 19 Earnings per Share (EPS) 20 Price Earnings (PE) 21 22 Profitability Ratios 23 Return on Equity (ROE) 24 Return on Assets (RCA) 25 Net Profit Margin 26 Operating Profnt Margin 27 29 Income mente Rado Calcolato 2015 A 0 B 2014 2013 Formula Used (Write out formulas) M 4 5 Profitability 1 Appendix A 2 3 Technology 3-Year Average for Industry Averages Gross Margin 7 Operating Profit Margin B Net Profit Margin Earnings per Share 10 21 Management Effectiveness 12 Return on Equity 13 Return on Assets 14 Return on investment 15 Quick Ratio 16 Current Ratio 17 Debt-to-Equity 10 Total Debt to Equity 19 20 Efficiency 8=2022ER Total Asset Turnover 22 Inventory Turnover 23 Accounts Receivable Tum 21 24 25 66.15% 12.04% 6.01% 1.49 26 12.40% 5.61% 14.42 2.87 2.57 61,01% 57.08% C 0.55 44.98 8.21 D E R G M 10 13 K L M N O P. Q H S 1. Using the data from the Income Statement and Balance Sheet, provide the correct calculation of the liquidity ratios and an assessment of the company's ability to maintain liquidity and the management of current assets and current liabilities, include the proper assessment of outcomes as positive or negative trends when all ratio outcomes are factored as a group Liquidity Ratios Current Ratio Quick Rato 2. Using the data from the income Statement and Balance Sheet, provide the correct calculation of the activity ratios and an assessment of the company's ability to maintain liquidity, include the proper assessment of outcomes as positive or negative trends when all four rabo outcomes are factored as a group. Activity Ratios Inventory Turnover Accounts Receivables Tumover Total Asset Turnover Average Collection Period 3. Using the data from the income Statement and Balance Sheet provide the correct calculation of the financing ratios. Include the proper assessment of outcomes as positive or negative trends when all three ratio outcomes are factored as a group. Financing Ratios Financing Ratios Debt Ratio. Debt-to-Equity Ratio Tenes Interest Eamed Ratio 4. Using the data from the price per share data, the income Statement, and the Balance Sheet, provide the correct calculation for the market value ratios below Market Value Ratios Earnings per Share (EPS) Price Camings (PE) 5. Using the data from the Income Stacement and Balance Sheet, provide the comect calculation of these tour profiability radios and an assessment of the company's ability to mainmain if not improve profitabaty based on the amounts of equity, assets, and levels off profits from sales, include the proper assessment of outcomes as positive or negative trends when all four rato outcomes are factored as a group Profitability Ratios Retum on Equity (ROE) Return on Asses (ROA) Net Protic Marg Operating Profit Margin Part 2 In this part of your assignment, you will compose an analyical study reporting your results from Part 1 The CEO of your company is forming a task force to review the financials and present a review for acquisition of ABC Company Based on ABC's previous 3 years of financials, determine if this would be a good acquisition You must firm the task force to complete tak The CEO would most of the departments to participate in the process. Using each departments area of expertise, what information would each of the following department contribute to the final dechion? Provide a minimum one-paragraph response for each department. Finance Department Sales Department . . Marketing Department Human Resources Legal Department Part 3 After your team has provided their input on the effect the acquisition will have on their department, perform an overall analysis to explain your recommendation to the CEO. Your analysis should include the following: Explain how the company is trending based on the year-over-year ratios. . Compare the company to the industry average in Appendix A in the Excel workbook in areas of profitability, management effectiveness, and efficiency. . Based on the above, summarize the pros and cons of ABC Company using both the year-over-year ratio analysis from Part 1 and the industry average comparisons from Part 3. Provide the team's final recommendation as to whether or not the CEO should invest in ABC Company. Your paper should follow this format: Title page with each team member's name that on the team.proiect Minge Period Ending Total Sales Cost of Goods Sold E Gross Profit 7 Selling Generall and Adminstrative 1 Operating Profit N Total Other Income/Expenses Net 10 Earnings before Interest and Taxes Interest Expense 12 Income Before Tax 13 Income Tax Expense 14 15 Discontinued Operations 36 Net Income (Net Profit) 14,000,000 Shares outstanding B C D ABC Company Income Statement Net Income from Continuing Ops 17 18 Market Share price per share 19 20 ABC Company Balance Sheet 21 22 Period Ending 23 Assets 24 Current Assets 25 Cash and Cash Equivalents 28 Net Receivables 27 inventory Income Statement Balance Sheet Cu Append E 31-Dec-15 31-Dec-14 31-Dec-13 $485,651.000 $476.294.000 $475,210,000 365,086,000 358,069,000 350,400,000 120,565.000 118,225,000 93,418,000 91.353.000 26.872,000 27,147,000 113,000 119,000 124,810,000 90,343.000 34,467,000 115.000 34,352,000 2,200.000 2.335,000 24,418,000 32,152.000 7.985,000 16,588,000 8,105,000 9,800,000 16,313,000) 22.352.000 182,000 144,000 285,000 $16,303,000 $16,169,000 $22,170,000 27,034,000 26,753,000 2.461,000 24,573,000 $10.00 F 2015 $9.135.000 6,778,000 45,141,000 G H $9.00 2014 $8.50 2013 $7,281,000 $6.789.000 6.677,000 6.525,000 44.850,000 43,989,000 Current Liabilities Accounts Payable Other current Liabilities Short-term Debt Total Current Liabilities 2015 58.583.000 6,689.000 65,272,000 N 2014 57,174,000 99,000 12,082.000 49.345.000 2013 56,210,000 55.000 14,050,000 10,315,000 28 Other Cum Assets 29 fotal Current Assets 30 Property Plant and Equipment 31 Goodwi 32 Other Assets 33 Total Assets 34 AN 40 41 2002888Sa5c0O 43 44 45 MT217 Unit3 Workbook.xlsx The Et In Formal H QQ Con ABC Company Income Statement 47 BAITA SAMATA DONOVA TINE B that-MTZT A Wo -R RUSA C 4 2.349,000 D 2.224,000 63,278,000 116,655.000 18,102,000 19,510,000 17,900,000 5,671,000 6,149,000 4,500,000 200,706,000 204,751,000 202,202,000 61,185,000 59,502,000 117,907,000 120 300.000 H 2.199,000 Long-term Debt 43,692.000 Deferred Long-teem Liability char 8,805.000 Monority interest 4,543,000 122,312,000 Total Liabilities Miscellaneous Stock Options W Common Stock Retained Earnings 0 of Shares Outstanding Market share price per share 323,000 45.777.000 2,462.000 Captial Surpiun Other Stockholders Equity 7,168,000 Total Stockholders Equity $1.394,000 Total Liabilities & Stockholders 200,706.000 14,000,000 $10.00 M 44,559,000 8.017/000 5.064.000 127,005.000 0 323,000 76,166.000 2,362.000 +1.505.000 77,746,000 204,751,000 14,000,000 $9.00 0 45.324.000 13.553.000 6.875.000 136,067,000 of 323,000 65,790,000 2,262,000 -2,200,000 66,135,000 202,200,000 14,000,000 $8.50 0 the # 7 3 4 5 0 A 7 A Liquidity Ratios Current Ratio Quick Ratio Activity Ratios Inventory Turnover D Accounts Recievables Turnover 10 Total Asset Turnover 11 Average Collection Period. 12 13 Financing Ratios 14 Debt Ratio 15 Debt-to-Equity Ratio 16 Times Interest Eamed Ratio 17 18 Market Ratios 19 Earnings per Share (EPS) 20 Price Earnings (PE) 21 22 Profitability Ratios 23 Return on Equity (ROE) 24 Return on Assets (RCA) 25 Net Profit Margin 26 Operating Profnt Margin 27 29 Income mente Rado Calcolato 2015 A 0 B 2014 2013 Formula Used (Write out formulas) M 4 5 Profitability 1 Appendix A 2 3 Technology 3-Year Average for Industry Averages Gross Margin 7 Operating Profit Margin B Net Profit Margin Earnings per Share 10 21 Management Effectiveness 12 Return on Equity 13 Return on Assets 14 Return on investment 15 Quick Ratio 16 Current Ratio 17 Debt-to-Equity 10 Total Debt to Equity 19 20 Efficiency 8=2022ER Total Asset Turnover 22 Inventory Turnover 23 Accounts Receivable Tum 21 24 25 66.15% 12.04% 6.01% 1.49 26 12.40% 5.61% 14.42 2.87 2.57 61,01% 57.08% C 0.55 44.98 8.21 D E R G M 10 13 K L M N O P. Q H S