Please help me with part 4 of the International Financial Reporting Standards and the Recommendations Section! I uploaded the ratios. The main company is Home Depot and the competitor is Lowes.
a. c. 1. Compute the following ratios for the most recent year and include them in an Appendix to this report. [The calculations for each of these ratios can be found in your textbook. The numbers you use for these ratios should agree with the numbers in financial statements. Show all of your supporting work). Return on Equity (Return on Owners' Investment) b. Return on Assets (Return on Total Investment) Earnings per Share d. Net Profit Margin Current Ratio f. Quick Ratio Accounts Receivable Turnover h. Inventory Turnover Times interest earned j. Debt to Equity ratio k. Price/Earnings (P/E) ratio (Use the market price as of the balance sheet date). e. g. i. 2. Identify a company that you believe is the closest competitor ("competitor") to your company. Compute the ratios in (1) above for the competitor and include them in the Appendix Based on your computations in (1) and (2) above, address the following: Profitability: 1. What is your assessment of the profitability of your firm in the most recent year? How does your firm's profitability compare with that of the competitor? 2. Compare the cash flows from operating activities for your firm with the net income for the most recent year. What factors have contributed to the difference between these two numbers? Liquidity and Capital Structure: 1. Will the company be able to meet its obligations as they become due? How does your firm's liquidity compare with that of the competitor? 2. What is the capital structure of your company (1.e., what percentage of the total assets of the company are financed through liabilities and what percentage through stockholders' equity)? 3. Is the capital structure of the competitor significantly different from that of your company? Briefly explain your answer. International Financial Reporting Standards (IFRS) 1. What is the purpose of IFRS? 2. What is the IASB? 3. What are some of the overall differences between US GAAP and IFRS? 4. If your company adopted IFRS: (a) Would its reporting for inventory differ? Briefly explain. (b) Identify other areas that would be impacted if your company adopted IFRS. Recommendations 1. Based on your analysis and company research would you, as a bank-lending officer, approve a 5-year loan for this company? If so, how much would you approve the loan for and for what purpose? Would you require security or collateral? Explain your reasoning. 2. Provide a recommendation as to whether an investor should buy, sell, or hold the stock of your company compared to the selected competitor. Your recommendation should be supported by an adequate explanation and reference to supporting analysis and ratios. Note that the quality of the arguments you provide in support of your position for (1) and (2) are more important than your final recommendation. The Home Depot Ratios Calculations Ratio Return on Equity $11,242 - $3,116 3.608 $11,242 - $51.236 .219 Return on Assets Earnings per Share Net Profit Margin $11,242 - 1,077 $10.44 (11.242 - 110.225)*100 10.2 Current Ratio 19.810 - 18.375 1.078 Quick Ratio (19.810-14,531) - (18.375) 287 Accounts Receivable Turnover 11,242 - 2,021 5.562 Inventory Turnover 72.653 -14.531 4.9 (15.843 +1.989) - 1,128 15.809 Times Interest Earned Debt to Equity Ratio 28.670 - 3,116 9.201 Price Earnings Ratio 27.33-10.44 2.618 Lowes Ratios Calculations Ratio 4,955 - 1,972 2.513 4.281 = 39,471 .108 Return on Equity Return on Assets Earnings per Share Net Profit Margin 4,955 + 777 6.377 (4.281 - 72.148)*100 5.93 Current Ratio 15,319 + 15.182 1.009 Quick Ratio (15,319-13,179) = 15,182 .141 N/A Accounts Receivable Turnover Inventory Turnover 49,205 - 13,179 3.733 Times Interest Earned (6,314+1,262) -691 10.964 Debt to Equity Ratio 16.768 - 1,972 8.503 Price Earnings Ratio 86.01 - 6.377 13.488 a. c. 1. Compute the following ratios for the most recent year and include them in an Appendix to this report. [The calculations for each of these ratios can be found in your textbook. The numbers you use for these ratios should agree with the numbers in financial statements. Show all of your supporting work). Return on Equity (Return on Owners' Investment) b. Return on Assets (Return on Total Investment) Earnings per Share d. Net Profit Margin Current Ratio f. Quick Ratio Accounts Receivable Turnover h. Inventory Turnover Times interest earned j. Debt to Equity ratio k. Price/Earnings (P/E) ratio (Use the market price as of the balance sheet date). e. g. i. 2. Identify a company that you believe is the closest competitor ("competitor") to your company. Compute the ratios in (1) above for the competitor and include them in the Appendix Based on your computations in (1) and (2) above, address the following: Profitability: 1. What is your assessment of the profitability of your firm in the most recent year? How does your firm's profitability compare with that of the competitor? 2. Compare the cash flows from operating activities for your firm with the net income for the most recent year. What factors have contributed to the difference between these two numbers? Liquidity and Capital Structure: 1. Will the company be able to meet its obligations as they become due? How does your firm's liquidity compare with that of the competitor? 2. What is the capital structure of your company (1.e., what percentage of the total assets of the company are financed through liabilities and what percentage through stockholders' equity)? 3. Is the capital structure of the competitor significantly different from that of your company? Briefly explain your answer. International Financial Reporting Standards (IFRS) 1. What is the purpose of IFRS? 2. What is the IASB? 3. What are some of the overall differences between US GAAP and IFRS? 4. If your company adopted IFRS: (a) Would its reporting for inventory differ? Briefly explain. (b) Identify other areas that would be impacted if your company adopted IFRS. Recommendations 1. Based on your analysis and company research would you, as a bank-lending officer, approve a 5-year loan for this company? If so, how much would you approve the loan for and for what purpose? Would you require security or collateral? Explain your reasoning. 2. Provide a recommendation as to whether an investor should buy, sell, or hold the stock of your company compared to the selected competitor. Your recommendation should be supported by an adequate explanation and reference to supporting analysis and ratios. Note that the quality of the arguments you provide in support of your position for (1) and (2) are more important than your final recommendation. The Home Depot Ratios Calculations Ratio Return on Equity $11,242 - $3,116 3.608 $11,242 - $51.236 .219 Return on Assets Earnings per Share Net Profit Margin $11,242 - 1,077 $10.44 (11.242 - 110.225)*100 10.2 Current Ratio 19.810 - 18.375 1.078 Quick Ratio (19.810-14,531) - (18.375) 287 Accounts Receivable Turnover 11,242 - 2,021 5.562 Inventory Turnover 72.653 -14.531 4.9 (15.843 +1.989) - 1,128 15.809 Times Interest Earned Debt to Equity Ratio 28.670 - 3,116 9.201 Price Earnings Ratio 27.33-10.44 2.618 Lowes Ratios Calculations Ratio 4,955 - 1,972 2.513 4.281 = 39,471 .108 Return on Equity Return on Assets Earnings per Share Net Profit Margin 4,955 + 777 6.377 (4.281 - 72.148)*100 5.93 Current Ratio 15,319 + 15.182 1.009 Quick Ratio (15,319-13,179) = 15,182 .141 N/A Accounts Receivable Turnover Inventory Turnover 49,205 - 13,179 3.733 Times Interest Earned (6,314+1,262) -691 10.964 Debt to Equity Ratio 16.768 - 1,972 8.503 Price Earnings Ratio 86.01 - 6.377 13.488
