Company: Target Corporation
The final written paper requires you to prepare a well-written titled “Would You Advise a Friend to Invest in This Company(Company name mentioned above)?” based upon your research and analysis of this company’s financial information(attached documents for reference of the company’s financial information). You should identify at least 5-7 significant points that justify your conclusion. Support your points with a comprehensive explanation incorporating sound reasoning. The significant points you identified should be consistent with what you said in the report
Your final written paper should be 7 pages long. The report should be well written with cover page, introduction, the body of the paper (with appropriate subheadings), conclusion, and reference page. References must be appropriately cited. Format: Double-spaced, one-inch margins, using a 12-point Times New Roman font.
TARGET CORPORATION 2
1) computed the following ratios for two years
|1)||The debt ratio can be calculated as follows|
|Total Debt ratio||72.34%||72.64%|
|2)||Gross Profit margin|
|Gross Profit margin||$23,248||$22,057|
|Gross Profit margin||29.76%||29.27%|
|3)||Free Cash Flow|
|Cash Flow from operations||$7,117||$5,973|
|Free Cash Flow||$4,173||$2,557|
|4)||Time Interest Earned ratio|
|Time Interest Earned Ratio||9.95299145||9.47004608|
|Receivables Turnover||Not defined||Not defined|
|Since receivables are zero, therefore the receivable turnover is not defined|
|Cost of goods sold||$54,864||$53,299|
2) DuPont Analysis of ROE for two years
To perform DuPont analysis for the return on assets, we first compute the return on sales and the asset turnover. The formula for return on sales is net income divided by revenues. Meanwhile, asset turnover is calculated as revenues divided by total assets. Suppose the return on sales and asset turnover is multiplied by each other. In that case, the result will be equal to the return on assets, calculated as net income divided by total assets.
To perform DuPont analysis for the return on equity, we first compute the return on sales, total asset turnover, and financial leverage (equity multiplier). As said earlier, the return on sales is equal to net income divided by revenues. Total asset turnover is equal to revenues divided by total assets. Financial leverage (equity multiplier) is computed as total assets divided by total equity. If you multiply the return on sales by the total asset turnover and by the financial leverage, we can calculate the return on equity, which can alternatively be computed as net income divided by total equity
|DuPont Analysis of ROE for two years||2020||2019|
|Return on Sales||4.20%||3.90%|
|Return on Assets (Return on Sales * Asset Turnover)||7.67%||7.11%|
|Financial Leverage (Equity Multiplier)||3.62||3.65|
|Return on Equity (Net Income / Total Equity)||27.73%||26.00%|
Evaluation of Ratio Trends
Target is an American based merchandise retail corporation. It owns a store in all of the 50 states of the United States. Target’s tagline is “expect more, pay less, ” which shows how their focus is on providing the best quality products at a limited price range. It also works on corporate social responsibility, as 5% of its profits go back into the communities. Moreover, its total revenue was $75.4 billion in 2018. The purpose of the target is to help the families discover the joy of every day’s life
Analysis of Ratio Trends:
The part A of the paper covered the ratios of the company for the year 2019 and 2020. In this part, the ratio trends are discussed and analyzed. The ratio trend analysis examines a financial ratio compared to the same ratio of the previous year/years. It helps analyze the company’s financial position, showing whether the company is doing good, threatening, or average. It also helps in figuring out whether the company’s growth is slow or quick, if the financial statements are stronger or weaker, and helps in evaluating the risk level that the company currently has. It also shows how the company has been performing over time and identifying what measures a company can take to improve its current financial performance. Although the trend analysis is usually shown in percentages, seeing the exact amount is comparatively more helpful in analyzing its performance.
The debt ratio calculated in part A of this assignment shows that the total debt ratio can be calculated with current total liabilities and real assets. The total debt ratio turned out to be 72.64% for 2019 and 72.34% for 2020. This shows that the debt ratio has dropped by 0.3%.
The debt ratios of 0.4 or under that, according to the risk perspective, are considered acceptable. If the debt ratio is higher than 0.6%, it seems to cause companies’ problems, especially when it comes to borrowing money, as a higher debt ratio shows lower creditworthiness. This ratio can be seen as less risky. Moreover, companies carrying small debts are also perceived to be dangerous.
Gross Profit margin:
The gross profit margin of a company indicates good sales and more incredible company wealth. To maintain the right profit margin, a company has to improve its sales and keep reasonable control over its costs to make the best of the lowest investments. According to the worksheet, the gross profit margin of Target Corporation is 29.27% in the year 2019 and 29.76% in 2020. This indicates an increase of 0.49% in the profit margin of Target.
Technically, the right profit margin has to be at least 10%, but looking from a retail store’s perspective, expecting profit improvements to this extent seems somewhat questionable. The company still would be seen as having a weaker and slower gross profit margin.
Free Cash Flow:
The cash produced by a company through its operations, subtracting the expenditure cost on assets, is known as free cash flow. It can also be understood as the cash leftover that a company has after paying off the capital and operating expenses. Although it sounds similar to profit, it is the amount that indicates the net flow of cash in and out of business. The worksheet shows that operations’ cash flow has increased from the previous year, reducing capital expenditures. The overall free cash flow has grown and is often seen as an indicator showing how the company has the cash to spend on new products or operations and is a healthy company.
Time Interest Earned Ratio:
This ratio works as an indicator to show if a company is jumping into a financial crisis. If the percentage is higher, it means that a company is capable of meeting its interest requirements. It also means that a company has a lower risk to creditors and investors when it comes to solvency. From an investor’s perspective, the organization has a ratio greater than 2.5 can be considered an acceptable risk. The Time Interest Earned Ratio of 2019 is 9.47%, whereas, in 2020, it is 9.95%, almost equivalent to 10%. This is a sign that the company is working on reducing its interest levels, and the liquidity of the company can also be considered exceptional
Receivables turnover quantifies the effectiveness of a company in collecting its receivables. It also includes collecting money owed by clients. The ratio indicates how properly a company manages the credit extending to its consumers (Rusdiyanto et al., 2019). If the receivables turnover ratio is low, the company has an imperfect collection process or not so good credit policies. In this case, the company should assess its credit policies again to ensure timeliness while collecting its receivables. According to the worksheet, the turnover rate is not defined; the company needs to look into its matters and even reassess its policies.
Inventory turnover shows the amount of time a company has replaced or sold its inventory in a given period. With this, a company can understand if it has made the right decisions related to manufacturing or purchasing new inventory (Sunjoko & ARILYN, 2016). Since Target is a retail store, it usually has its suppliers and products fixed. However, new products keep coming into the market, and the consumers often desire to change some of them. Due to this, retail stores keep adding new products and removing products that don’t do good while keeping their regulars available. However, a reasonable turnover rate lies between 5 to 10%. As the company has a turnover rate of 6.10 this year, it indicates that the company restocks or sells its inventory every 1 to 2 months, which is a good indicator of its sales.
Return on Equity:
The return on equity ratio calculates the return rate received by the owners of common stock. Equity return shows the company’s performance by looking at the returns generated by it (Kharatyan, 2016). Moreover, an ROE shows the management’s ability to generate income with the available equity. If the ROE is between 15 to 20%, it is considered acceptable. ROE is essential because it discloses the company’s profit concerning the shareholder equity amount. As Target shows a return of 27.73% in 2020, it is an indicator that the company offers impressive performance to generate income.
According to the Ratio Trends Analysis, Target is doing well when it comes to profit and income generation. There are a few areas where the company needs some work, like receivables turnover. The company can improve some of its ratios by reassessing its policies and improving its liquidity. However, the company’s solvency has been enhanced concerning the previous year. Moreover, Target has also been able to retain its position in the market and perform exceptionally well among the retail stores in the US.
Kharatyan, D. (2016). Ratios and indicators that determine the return on equity (Doctoral dissertation).
Rusdiyanto, R., Agustia, D., Soetedjo, S., Septiarini, D. F., Susetyorini, S., Elan, U., … & Rahayu, D. I. (2019). Effects of Sales, Receivables Turnover, and Cash Flow on Liquidity.
Sunjoko, M. I., & ARILYN, E. J. (2016). Effects of inventory turnover, total asset turnover, fixed asset turnover, current ratio, and average collection period on profitability. Jurnal Bisnis dan Akuntansi, 18(1), 79-83.
Company Name: Target Corporation
TARGET CORPORATION 1
Company Name: Target Corporation
Group Project Part 3
1) Target Corporation of Minneapolis, MN 55403 operates primarily in SIC Code 5311 – Department Stores
2) For purposes of this research, Target’s ratios have been compared to other industry averages of the belonging to the same SIC Code.
For further comparison, We have acquired the ratios of Target’s closest competitors, such as:
· Destination XL Group of Canton, MA 02021;
· Colgate-Palmolive Company of New York, NY 10022;
· Urban Outfitters Inc of Philadelphia, PA 19112; and
· Walmart Inc of Bentonville, AR 72716
3) SIC Code 5311 Industry Average vs. Target Corporation:
1) Current ratio – Target’s current ratio indicates its ability to meet short-term debt obligations lesser than that of the industry.
2) Debt ratio – Target’s debt ratio indicates its debts to assets proportion are greater than those of the industry. This may also suggest that Target must be more leveraged than the industry (Bloomenthal, A, 2020).
3) Gross profit margin & Net profit margin- Target’s more significant net profit margin than the industry indicates that it can reinvest more earnings, which might lead to faster expansions than the industry. However, it is noted that Target’s gross profit margin is almost the same as the industry average, which might indicate that it has lesser expenses than the rest (Bloomenthal, A, 2020).
4) Times interest earned – N/A
5) Accounts receivable turnover – N/A
6) Inventory turnover – Target’s inventory turnover is 62, whereas the industry average is 22 days. This indicates that Target still has room to be more aggressive towards sales.
7) Return on Sales – N/A
8) Asset Turnover – Target’s asset turnover is 196 days compared to the industry average of 60 days. This indicates that Target can still maximize its assets to generate more sales.
9) Return on Assets – Target’s return on assets less than the industry average. This indicates that it has to revisit its pricing model or its asset utilization.
10) Financial Leverage – N/A
11) Return on Equity – Target’s return on equity is less than the industry average. This indicates that they can still maximize shareholder investments.
Target is a merchandise retail store having around 50 stores throughout the United States. It is so close to people’s homes that 75% of the U.S. population lives in a radius of 10 miles of a Target store. Target’s main motto is to provide the best quality products at the lowest price range. To work on this, the company has to pay a lot of attention to its financial affairs. Moreover, Target also owns DermStore, Shipt, Roundel, etc. Its hometown is Minneapolis, Minnesota (Bloomenthal, A, 2020).
Ratio Trends Analysis:
The first part of this paper emphasized the different years 2019 and 2020, where gross profit margin, debt ratio, interest expense, turnovers, and other essential ratios were computed. The analysis of those ratios will be conducted, and the conclusion will be driven. According to Investopedia, Ratio analysis is a technique in which insights of a company are gained. These insights include liquidity, profitability, and efficiency of operations. The senses are driven by the financial statements of the company (Bloomenthal, 2020). In simpler terms, ratio trend analysis helps understand the company’s current position, performance, and whether it would make profits or not in the long run in the future. Alongside that, it also assists in determining the speed at which the company is growing. Through ratio trend analysis, a company gets an idea of what decisions to make that would lead to better financial performance. These trends are represented both in percentages and figures (Bloomenthal, A, 2020).
Given below is the debt ratio of Target for the year 2019 and 2020:
|Total Debt Ratio||72.34%||72.64%|
Total liabilities and total assets help in calculating the total debt ratio. The total debt ratio calculated is 72.64% for 2019 and 72.34% for 2020. There is a drop of 0.3% in the debt ratio understood by the above table. Following the risk perspective, a percentage of 0.4% or under is seen as acceptable. If there are fluctuations in it, and the debt ratio rises, it can cause the company to lose potential investors or other financial resources. If the debt ratio is high, the trust automatically goes low. Maintaining a debt ratio of 0.3 would be ideal in this case (Bloomenthal, A, 2020).
Gross Profit Margin:
Given below is Target’s gross profit margin for the year 2019 and 2020.
|Gross Profit Margin||$23,248||$22,057|
|Gross Profit Margin||29.76%||29.27%|
A company’s gross profit margin shows the sales value and wealth of the company. If the profit margin is high, it is understood that the company is doing good and its wealth accumulation is also in good condition. Maintaining the right gross profit margin is more important than having good sales just for a year. To support it, what a company can do is cut down or lower all the unnecessary costs so that they don’t lose a decent amount of money without any reason. The table indicates that the gross profit margin of Target Corporation in the year 2019 is 29.27%, and in 2020, it’s 29.76%. According to this, there is an increase in the profit equivalent to 0.49%. Target is a retail store, and expecting high increases in its profit margin is not a good idea, as retail stores follow specific patterns and work around them. However, the company has slower growth in this area than the profit ratio (Bloomenthal, A, 2020).
Free Cash Flow:
Cash flow can be expressed as the cash produced by the company through its operations. In cash flow, we subtract the expenditure spent on the assets. Cash flows and profit are often confused with each other, but they are different, as cash flow talks about the cash flowing in and out of the company.
|Cash Flow from operation||$7,117||$5,973|
|Free Cash Flow||$4,173||$2,557|
As per the table, the cash flow of Target has increased as compared to the previous year. However, there is a decrease in capital expenditures. Free cash flow overall has shown an improvement compared with last year. If the cash flow is more, it shows that a company is improving its current inventory and other things, which eventually would benefit it, as customer choices keep changing day by day (Bloomenthal, A, 2020).
Time Interest Earned Ratio:
The time interest earned ratio indicates the financial condition of a company. It shows whether a company is performing well in terms of finances or not. The higher the percentage, the more capable the company is of getting interested from its investors. Alongside that, if the company plans on getting solvent, it would be easier for it. From an investor’s perspective, a ratio of more than 2.5 is seen as a safe zone. As per the table, the time Interest Earned Ratio in 2020 is 9.95%, and in 2019, it is 9.47%. A difference of 0.48% indicates that the company has reduced its interest ratio, which is a good sign (Bloomenthal, A, 2020).
This part identifies how effective the company is at collecting receivables. The money usually is collected from its clients. This ratio is used to determine the company’s management of the credit. According to the table, even though the credit sale has dropped, the receivables turnover is labeled as “not defined.” This is due to the turnover is equivalent to zero. In general, a low ratio indicates that the company’s collection process is below average and work needs to be done on it. Credit policies can be improved for the improvement of turnover rate (Bloomenthal, A, 2020).
This ratio is used to recognize the time taken to replace or sell the inventory in a certain period. The inventory turnover formula can calculate the number of days it will take for the stock on hand to get sold. Inventory turnover is beneficial when making decisions related to budgeting, pricing, constructing or manufacturing, and buying new inventory (Hargrave, 2020). Because Target is a retail store, the supplies coming in and going out of the company are almost the same. Companies tend to deal with the suppliers and product manufacturers for putting up their product, due to which the majority of the products are usual. In this situation, retail stores need to keep track of customer’s purchasing patterns as well, because eventually, it’s the customer that helps them run. To tackle this, stores add new or in-demand products and get rid of the old ones. Overall, a reasonable turnover rate lies between 2 and 4%. Lower inventory turnover is an indicator of weaker performance by the sales team. It can also indicate a reduction in product popularity. Technically, if the turnover rate is higher, that shows that the business is meeting the goals. As Target’s turnover rate is 6.10, its performance is good (Bloomenthal, A, 2020).
ROE Analysis and DuPont Analysis:
To perform the DuPont Analysis, first, the return on sales is calculated. It is calculated by dividing income by revenues. First, the return on sales, total assets turnover, and financial leverage is calculated. When the return on sales and total assets turnover is multiplied, the result is called the return on equity. This can be calculated as net income divided by total equity. Apart from the calculation, it is crucial to understand its result, which is taken out with its analysis. However, it is essential to consider all the small elements that make up the ROE analysis because they help identify the company’s profitability better (Bloomenthal, A, 2020).
In this part, the return rate by owners of common stock is calculated. Equity returns indicate the company’s performance as per the return generation. It also shows that the management is capable of generating income by available equity. Target’s return on equity is 27.72% in 2020, which shows that its performance is exceptional. The importance of ROE is immense as it shows the company’s profit as per the shareholder equity amount (Bloomenthal, A, 2020).
Target’s overall performance as per the ratio trends analysis is good, as it is doing well in generating income. All the other areas discussed in the study are exceptional, keeping in mind that Target is recognized as a retail store. Even though most areas covered had a good impact, there is room for improvement around certain areas. The company’s improvement areas are mostly around the receivables turnover, as the table showed zero. As discussed above, specific measures are needed to be taken by the company to improve its turnover, like reassessing its policies. Overall, the company’s liquidity and solvency have gotten enhanced as compared to 2019. Target has managed to retain its position in the market as one of the convenient and most approachable stores of the United States and is keeping in mind its motto and working around it (Bloomenthal, A, 2020).
Bloomenthal, A. (2020). Ratio Analysis. Investopedia. Retrieved 7 November 2020, from https://www.investopedia.com/terms/r/ratioanalysis.asp.
Hargrave, M. (2020). Inventory Turnover. Investopedia. Retrieved 7 November 2020, from https://www.investopedia.com/terms/i/inventoryturnover.asp.
Nicasio, F. (2020). Inventory Turnover 101: What It Is And How to Get It Right – Vend Retail Blog. Vend Retail Blog. Retrieved 7 November 2020, from https://www.vendhq.com/blog/inventory-turnover/.
Group Project Part
Company Name: Target Corporation
Group Project Part 3
Company Name: Target Corporation