Question
First company Home Depot Second company Lowes c. Write Comparisons of the companies and all other analysis (observations and/or interpretations). d. Write Conclusions and recommendation
First company Home Depot
Second company Lowes
c.
Write Comparisons of the companies and all other analysis (observations and/or
interpretations).
d.
Write Conclusions and recommendation for investment. Write conclusive summary on the firms you have studied. Based upon your conclusions, recommend the better performing firm for potential investment. Your conclusions should be based upon, and specifically reference, the analyses prepared in this report.
Executive Summary
The following analysis centers around two popular home improvement stores, Home Depot (HD) and Lowes Home Improvement (LOW). The analysis of the financial statements of these home improvement stores has produced beneficial evidence on the successes and failures spanning the years 2016, 2017, and 2018. Presented is a brief background of both companies, respectively, as their patterns of operation and decision-making impact investors' perspectives. Followed by a report of both company's income statement and balance sheet with common size and comparative analysis calculations, completed to depict the progression of the companies over the course of three-years. Additionally, the financial ratio analysis of each company assisted by its profitability, productivity, solvency, and liquidity computations to better assess the risk speculation field.
Brief Background
When purchasing a new apartment or home, the excitement not only lies within the purchase but the decorating also. Each person has a unique sense of style, and it necessary to have a variety of stores catered to this variety. Stores like Home Depot and Lowe's pride themselves on their ability to fulfill wants for low costs. Lowe has joined the top ranks of worldwide retailers, while Home Depot has expanded to over 2000 stores in three countries.
LOW started as a small hardware store in North Carolina when founder H. Carl Buchan saw its potential to become more. Spanning 70+ years later, they stock over 40,000 items with Canada and Mexico as location as of 2007 and 2010 respectively. In 1982, Lowes celebrated its highest profit of 25 million, and have successfully been increasing ever since.
HD success stores are one of determination, because of the termination of two individuals in 1978. Bernie Marcus and Arthur Blank opened their first store in Atlanta, Ga June of 1979. Forty years later, they are the top tier in providing hardware. With a combined 2200 stores and almost 400,000 associates across the U.S, Mexico, and Canada, HD is one of the world's largest home improvement retailers.
Financial Analysis
Objective
The main objective is to examine, assess, and then distinguish the companies, Home Depot and Lowe's Home Improvement, with the use of financial data accumulated from the vertical and horizontal analysis. The data collected for the span of 3-years, 2016, 2017, and 2018, determines which company is better for investing. The better opponent is regarded as the best for future investments granted that their financial evaluation is the optimum depiction of the company's operations.
Common-size Analysis
The common size analysis, or vertical analysis, is a strategy for assessing budgetary data by communicating everything in a financial report as a level of a base sum for a similar timeframe. By subtracting the current from the previous year data, then dividing that data by the base year (2018) and multiplying by 100, the result is a positive or negative percentage for an income statement. While the balance sheet takes the data of each total listed and divides by the total liabilities. Therefore, both produce percentage calculations about the company from the numerical findings.
Common- Size Income Statement Analysis
First, from the income statement of both, LOW, and HD, the main accounts for analysis are Selling, general and administrative, depreciation and amortization, and Net Income. Over the span of three years, HD has accumulated 18.03 percent and LOW's 23.27 percent in the year of 2018. Compared to 2016, HD decreased by 0.08 percent, while LOW's increased by 1.15 percent. Considering both companies produce the same classification of items,
Secondly, is Depreciation and amortization which are non-money costs on an organization's income statement. Depreciation speaks to the expense of capital resources on the monetary record being utilized after some time, and amortization is the comparable expense of utilizing elusive resources like altruism over the long run. Representing Depreciation and amortization, each company had 1.73 percent and 2.07 percent for HD and LOW's respectively, at the end of the base year 2018. Each company has experience >1% loss over the span of three years.
Lastly, is Net Income which is the company's sum of individual gains after taking away expenses and different findings from net salary. For a business, the overall gain is the measure of income left in the wake of taking away all costs, charges, and expenses. The accumulative net income of HD totals 10.28 percent, a 1.87 percent increase from 2016. While LOW's totals 3.25 percent, a 1.25 percent decrease compared to 2016 percentage.
Financial Ratios
Profitability
In this report four different profitability ratios were used to calculate the profitability of the two companies, which measure the efficiency with which your company turns business activity into profits. Profit margins of these two companies are very close. It shows that these two companies' ability to turn revenue into profits are very similar. Home Depot's return on assets is higher than Lowes, it means that Home Depot has better ability to use assets to produce net income. However, Home Depot's return on equity is negative in 2018, it means its shareholders are losing, rather than gaining. This is usually a very bad sign for investors and managers.
Productivity
Productivity measures the efficiency of a company's production process. There are four different ratios used to calculate these two companies' productivity.
The Inventory turnover is a measure of the number of times inventory is sold or used in a time period such as a year. It is calculated to see if a business has an excessive inventory in comparison to its sales level. Both companies have good turnover rate.
Days inventory outstanding is the average number of days that a company holds its inventory. Home Depot is slightly low than Lowes, and it also has slightly declined over 3 years. It means Home Depot is able to sell inventory at a quicker pace than Lowes is.
PPE turnover is a measure of how efficient you are at generating revenue from fixed assets such as buildings, vehicles, and machinery. Home Depot is a little higher than Lowes, which means that Home Depot is more efficient than Lowes on its capital investments.
Asset turnover is the ratio of total sales or revenue to average assets. Lowes has higher number than Home Depot, it means that Lowes is effective than Home Depot on using their assets to generate sales.
Solvency
Solvency is the ability of a company to meet its long-term debts and financial obligations. There are three ratios used to evaluate these two companies' solvency. Debt-to-equity is calculated by dividing a company's after-tax net operating income by its total debt obligations. Due to Home Depot's 2018 Total stockholders' equity is deficit, so the ratio is negative. It means it has interest rates on its debts that are greater than the return on investment. Negative debt to equity ratio also means Home Depot has a negative net worth.
Times interest earned is the ratio of Operating Income for the most recent year divided by the Total Non-Operating Interest Expense, Net for the same period.Lowes has negative ratio for all 3 years, it is loss-making for all 3 years.
After calculated ROA and ROE, we got the number of Return on Financial leverage. Lowes has good number on ROFL. However, Home Depot has Negative leverage occurs, it assume that Home Depot purchased an investment using borrowed funds, and the borrowed money has a greater cost, or higher interest rate, than the return made on the investment. Home Depot may have problems raising money to cover historical net losses.
Liquidity
The three ratios used in this report to measure both companies' liquidity. The current ratio is a liquidity ratio that measures whether a firm has enough resources to meet its short-term obligations. Lowes has higher current ratio than Home Depot, which a creditor would consider a high current ratio to be better than a low current ratio, because a high current ratio indicates that the company is more likely to pay the creditor back.
The quick ratio another measurement in this report, which is considered a more conservative measure than the current ratio, which includes all current assets as coverage for current liabilities. Home Depot has the higher the ratio result, the better a company's liquidity and financial health; the lower the ratio, the more likely the company will struggle with paying debts.
Working capital that is in line with or higher than the industry average for a company of comparable size is generally considered acceptable. For 2018, Home Depot has negative working capital, because its current liabilities exceed its current assets. This means that the liabilities that need to be paid within one year exceed the current assets that are monetizable over the same period.
Home Depot Balance Sheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started