Financial Valuations

docx

School

Northeastern University *

*We aren’t endorsed by this school

Course

100

Subject

Finance

Date

Feb 20, 2024

Type

docx

Pages

3

Uploaded by SuperHumanWillpowerHeron34

Report
Liquidity: The current ratio for Target Corp. increased in 2020 but then slightly declined from 2020 to 2021. The exact store growth and e-commerce sales growth were the primary drivers of the increase in current assets in 2020. In addition, Target had to increase its current assets because of a spike in demand for its products during the COVID-19 crisis. This also resulted in a rise in current liabilities to accommodate this demand. So, the demand probably explains the small change between the two years. Still, the ratio seems ideal since it is around 1 for both years. Target has 0.35 in quick assets for each $1 in the current liabilities for 2021. Its quick ratio increased in 2020 but slightly declined from 2020 to 2021 and didn't reach the ratio of 2020. This ratio can indicate that the corporation may struggle to satisfy its short-term obligations. Leverage: The interest coverage ratio for Target Corp. dropped in 2020 but then highly increased from 2020 to 2021, surpassing the 2020 level. So, it wasn't terrible in 2020 as well, but it was solid in 2021, which indicates Target's high capacity to cover its interest expenses from its operational profits. The debt-to-equity ratio of Target Corporation (including operational lease liabilities) grew from 2020 to 2021. It had $3.19 in debt for each $1 in equity. This is not too ideal because it should not be higher than $1 or $2 for every $1 of equity. The debt-to-assets ratio for Target Corporation grew from 2020 to 2021. It was $0.76, which seems ideal as it is below $1. Thus, this indicates that the company is relatively safe in terms of leverage. Efficiency Ratio: Target's ratio indicates that it sold 6.1 times as much inventory as it had on hand throughout the period. So, it seems effective at managing its inventory. Additionally, the inventory turnover ratio at Target Corporation increased between 2020 and 2021. It is probably because Target's COGS increased significantly while its inventory increased slightly between the two years. The growth is driven by its online sales as well as its store sales. Profitability Ratio: Target's ROA increased between 2020 and 2021. The ratios seem ideal, especially 12% ROA in 2021. It shows that Target is using its assets quite effectively. The gross profit margin ratio from 2020 to 2021 remained almost the same. The surge in its gross profit remained because the pandemic's impact increased the demand for Target's goods. Walmart:
Liquidity Based on the calculated current ratio of 0.97, it seems like Walmart has $0.97 in current assets for each $1 in current liabilities. The ideal range for the current ratio is 1.5, and below one may indicate that it can be challenging to pay short-term obligations. However, the current ratio of Walmart Inc. has increased between 2020 and 2021. According to the calculated quick ratio, Walmart has 0.48 in quick assets for each $1 in the current liabilities. This ratio also indicates that the corporation may struggle to satisfy its short-term obligations. However, Walmart Inc.'s quick ratio increased between 2020 and 2021. Overall, the pandemic is probably to blame for the current and quick ratios. Numerous businesses struggled to fulfill their short-term obligations due to the pandemic. Leverage: In 2021, the company's interest coverage ratio was 9.37. A ratio above three can be ideal, so it is stable in terms of covering its interest expenses from its operational profits. The ratio also increased between 2020 and 2021. Hence, for the fiscal year, Walmart has greater EBIT than necessary to pay interest costs. The debt-to-equity ratio for Walmart Inc. was almost the same between 2020 and 2021. It was $1.88 in debt for each $1 in equity. This is a decent ratio that has been remarkably stable over the years. It shows that the company is financing asset purchases with more debt than equity, but its debt management procedures have remained constant for a while, and the company avoided using excessive debt even during economic uncertainty (Depresio, 2022). The debt-to-assets ratio for Walmart Inc. was almost the same between 2020 and 2021 as well. The ratio was $0.65, which seems ideal as it is below $1. So, this indicates that the company is relatively safe in terms of leverage. Generally, due to the pandemic, many businesses increased their debt levels to stay in business. However, looking at Walmart's ratio, it maintained constant debt and has avoided an increase because of the pandemic. Efficiency Ratio: The inventory turnover ratio for the business was 9.4. This indicates that Walmart sold 9.4 times as much inventory as it had on hand throughout the period. So, it is effective at managing its inventory. Also, the inventory turnover ratio for Walmart increased from 2020 to 2021. It's probably high because people were storing up supplies during the pandemic. Profitability Ratio: The return on assets (ROA) for Walmart in 2021 was 5%. The ratio seems ideal, but a bit higher would have been better. Additionally, the ratio increases slightly from 2020 to 2021. The change is because companies had to reduce expenses to survive the pandemic, but this wasn't the case in 2021. Walmart's gross margin percentage was 24 percent. The Gross profit margin ratio for Walmart Inc. increased from 2020 to 2021. It probably higher than 2020 because it had to reduce its prices further in order to compete during the pandemic.
Finally, Walmart's basic financial measures provide assurance that paying debts will not be a problem for the corporation, even though slightly better liquidity and leverage ratios would be nice to see. https://www.macroaxis.com/invest/ratio/TGT/Current-Valuation https://www.stock-analysis-on.net/NYSE/Company/Target-Corp Depresio, G. (2022). Analyzing Walmart's debt Ratios (WMT). Retrieved from https://www.investopedia.com/articles/active-trading/022716/analyzing-walmarts-debt-ratios- 2016-wmt.asp on October 29, 2022. Depresio, G. (2022). Wlmart Financial Anayysis: 5 Key Ratios. Retrieved from https://www.investopedia.com/articles/active-trading/021916/walmarts-5-key-financial-ratios- wmt.asp on October 29, 2022.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help