Email: patrickjun321 @ google mail. com

If finished work please send to my email Thanks :)

Part 3: Complete using MS Excel (You can create in Google Sheets and then save as an Excel sheet to submit) In ARP part #2, you prepared horizontal and vertical analysis. In this part, you will prepare ratio analysis. Refer to Chapter 13 of the text for a summary of the ratios. You should also refer to the chapters where the ratios were originally covered in the text. For the past two years, calculate the following using Excel. If you are not familiar with Excel or you need a refresher, go to http://www.usd.edu/trio/tut/excel for a tutorial. Be sure to use Excel formulas in the cells where you are making computations. Typing computational results in the cells is not acceptable and will result in zero points. Failure to do so will be an automatic deduction of ten points. Failure to have your name and company name typed in the left-hand comer or added as a header on every page will result in point deductions. This part is worth twenty points. Liquidity and Efficiency - ALL RATIOS are in Chapter 13 in your textbook or e-book a. Current ratio 6. Acid-test ratio C. Accounts receivable turnover d Inventory turnover e. Days' sales uncollected f. Days' sales in inventory g. Total asset tumover Solvency a. Debt ratio 6. Equity ratio c. Debt-to-equity ratio d Times interest earned Profitability a. Profit margin ratio b. Gross margin ratio c. Return on total assets d. Return on common stockholders' equity e. Book value per common share f. Basic earnings per share Market Prospects a. Price-earnings ratio b. Dividend yield Part 3: Complete using MS Excel (You can create in Google Sheets and then save as an Excel sheet to submit) In ARP part #2, you prepared horizontal and vertical analysis. In this part, you will prepare ratio analysis. Refer to Chapter 13 of the text for a summary of the ratios. You should also refer to the chapters where the ratios were originally covered in the text. For the past two years, calculate the following using Excel. If you are not familiar with Excel or you need a refresher, go to http://www.usd.edu/trio/tut/excel for a tutorial. Be sure to use Excel formulas in the cells where you are making computations. Typing computational results in the cells is not acceptable and will result in zero points. Failure to do so will be an automatic deduction of ten points. Failure to have your name and company name typed in the left-hand comer or added as a header on every page will result in point deductions. This part is worth twenty points. Liquidity and Efficiency - ALL RATIOS are in Chapter 13 in your textbook or e-book a. Current ratio 6. Acid-test ratio C. Accounts receivable turnover d Inventory turnover e. Days' sales uncollected f. Days' sales in inventory g. Total asset tumover Solvency a. Debt ratio 6. Equity ratio c. Debt-to-equity ratio d Times interest earned Profitability a. Profit margin ratio b. Gross margin ratio c. Return on total assets d. Return on common stockholders' equity e. Book value per common share f. Basic earnings per share Market Prospects a. Price-earnings ratio b. Dividend yield