the answers of part b, please explain it as clearly as possible. I will apreciate it very much.
APPLE Part A Calculation Name of Ratio Current Ratio Table A Formula Current Assets/Current Liabilities Net Income / Net Sales (or Operating Revenues) 1.133 Net Profit Margin 0.224 Earnings Per Share 0.01294 Net / Avg. number of shares of common stock outstanding Net Sales (or Operating Revenues) / Avg. Total Asset 0.754 Total Asset Turnover Ratio Return on Assets 0.169 Net Income / Avg. Total Assets Net Sales/ Avg. Trade Acc. Receivable 11.52 Receivables Turnover COGS / Avg. Inventory Inventory Turnover 40.62 Net Sales (or Operating Revenues) Avg. Net Fixed Assets Sheet1 poly(1) (.docx ^ D Monopoly(1) (.docx - Monopoly (1) (1).docx - Monopoly(1).docx COGS / Avg. Inventory Inventory Turnover 40.62 Net Sales (or Operating Revenues) Avg. Net Fixed Assets Fixed Asset Turnover Account Payable Turnover Net Sales/ Avg. Acc. Payable 1.295 5.021 Answer straightline FIFO Table B Question Method of depreciation Method to value Inventory Percentage of Current Assets Percentage of Non-Current Assets Percentage of Current Liabilities Percentage of Non-Current Liabilities Capital structure Accounting Firm 48.10% 51.90% 42.62% 57.38% 106.85 Emst and Young heet1 ....docx - Monopoly (1) (....docx^ Monopoly (1) (1).docx ^ Monopoly(1).docx J Aldi ructure 106.85 Capital structure Accounting Firm Emst and Young Table C 2018 Value(in millions) Year Key account balance Net Sales COGS Gross Profit Total operating expenses IBIT Net Income Total Current Assets Total Current Liabilities 260174 163756 101839 30941 72903 59531 131339 115929 Sheet1 annallti (1) docx a Mono A = 100% - Normal text , Arial - 12 - BI U A L- 11 12 13 1 4516 MULUUTTUITY IT PART B The objective here is for you to analyze the company in terms of its profitability, solvency, and liquidity, and to provide your investment and credit recommendations. Using the information you calculated on your MS Excel worksheet, address each of the following questions. Use the results of your ratio and other analyses to support your answers: You are to discuss the following ratio categories for your company: Profitability Turnover (activity) Liquidity Solvency (iii) (iv) Look up what each of these terms mean, and which ratios support the analysis of each. You can state what each ratio 'tells' us in general (do not report how the ratio is calculated - this is given in the excel file). Considering what the ratio is 'telling' us, analyze how your company is performing, and compare to your competitor. After presenting each of the individual ratios under their respective categories Finally, summarize how your company is performing in each of the five categories (profitability, turnover, liquidity, solvency, and others). The below recommendations will be based on these conclusions. Recommendations To conclude your report, provide recommendations for whether: a. Creditors should loan money to this company in the short-term b. Creditors should loan money to this company in the long-term Investors should buy, hold, or sell the stock (use the competitor as a baseline, and be sure to consider the current price of the stock) ----./41 141 dary Monopoly(1).doc APPLE Part A Calculation Name of Ratio Current Ratio Table A Formula Current Assets/Current Liabilities Net Income / Net Sales (or Operating Revenues) 1.133 Net Profit Margin 0.224 Earnings Per Share 0.01294 Net / Avg. number of shares of common stock outstanding Net Sales (or Operating Revenues) / Avg. Total Asset 0.754 Total Asset Turnover Ratio Return on Assets 0.169 Net Income / Avg. Total Assets Net Sales/ Avg. Trade Acc. Receivable 11.52 Receivables Turnover COGS / Avg. Inventory Inventory Turnover 40.62 Net Sales (or Operating Revenues) Avg. Net Fixed Assets Sheet1 poly(1) (.docx ^ D Monopoly(1) (.docx - Monopoly (1) (1).docx - Monopoly(1).docx COGS / Avg. Inventory Inventory Turnover 40.62 Net Sales (or Operating Revenues) Avg. Net Fixed Assets Fixed Asset Turnover Account Payable Turnover Net Sales/ Avg. Acc. Payable 1.295 5.021 Answer straightline FIFO Table B Question Method of depreciation Method to value Inventory Percentage of Current Assets Percentage of Non-Current Assets Percentage of Current Liabilities Percentage of Non-Current Liabilities Capital structure Accounting Firm 48.10% 51.90% 42.62% 57.38% 106.85 Emst and Young heet1 ....docx - Monopoly (1) (....docx^ Monopoly (1) (1).docx ^ Monopoly(1).docx J Aldi ructure 106.85 Capital structure Accounting Firm Emst and Young Table C 2018 Value(in millions) Year Key account balance Net Sales COGS Gross Profit Total operating expenses IBIT Net Income Total Current Assets Total Current Liabilities 260174 163756 101839 30941 72903 59531 131339 115929 Sheet1 annallti (1) docx a Mono A = 100% - Normal text , Arial - 12 - BI U A L- 11 12 13 1 4516 MULUUTTUITY IT PART B The objective here is for you to analyze the company in terms of its profitability, solvency, and liquidity, and to provide your investment and credit recommendations. Using the information you calculated on your MS Excel worksheet, address each of the following questions. Use the results of your ratio and other analyses to support your answers: You are to discuss the following ratio categories for your company: Profitability Turnover (activity) Liquidity Solvency (iii) (iv) Look up what each of these terms mean, and which ratios support the analysis of each. You can state what each ratio 'tells' us in general (do not report how the ratio is calculated - this is given in the excel file). Considering what the ratio is 'telling' us, analyze how your company is performing, and compare to your competitor. After presenting each of the individual ratios under their respective categories Finally, summarize how your company is performing in each of the five categories (profitability, turnover, liquidity, solvency, and others). The below recommendations will be based on these conclusions. Recommendations To conclude your report, provide recommendations for whether: a. Creditors should loan money to this company in the short-term b. Creditors should loan money to this company in the long-term Investors should buy, hold, or sell the stock (use the competitor as a baseline, and be sure to consider the current price of the stock) ----./41 141 dary Monopoly(1).doc
