How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask PDtax Your Own Question
PDtax
PDtax , CPA, MBA
Category: Finance
Satisfied Customers: 3905
Experience:  Tax professional and business consultant for 35 years.
64119565
Type Your Finance Question Here...
PDtax is online now
A new question is answered every 9 seconds

I have to write a few paragraphs for a paper that Im having

Resolved Question:

I have to write a few paragraphs for a paper that I'm having problems with. I have included a few links that should help. The company I'm writing on is pepsi co. Below is what is expected.

Evaluate Walmart's financial performance over the past two years (2012 and 2013) using financial ratios.

Here are the topics I need to write a paragraph on; calculate the following ratios for each year:
Current
Debt
Return on equity
Days receivable

Be sure to discuss the trend for each ratio and what it tells you about the organization’s financial health. Be sure to properly cite your sources of financial information.

Here are some links that should help.

http://az204679.vo.msecnd.net/media/documents/2013-annual-report_130108806067963477.pdf

http://www.walmartstores.com/sites/annual-report/2012/WalMart_AR.pdf
Submitted: 3 years ago.
Category: Finance
Expert:  PDtax replied 3 years ago.

PDtax :

Hi from Just Answer. I can assist with your assignment.

PDtax :

Please advise when you need the report.

Customer: I need it as soon as possible. By 9am if possible.
Customer: There was no answer provided.
PDtax :

You rated my response as poor. Since all I did was ask when you needed the report, that needs to be revised. We are graded by these scores here at JA.

PDtax :

I can assist, but it's 6:20 am and the first coffee hasn't even started in the pot yet. Please revise my rating while I start a pot of coffee, and I will work on this right now. PDtax.

PDtax :

I see you are online in chat. I am working on your question and will have an answer before 9am EST.

PDtax :

Current debt for Wal-Mart on a consolidated basis increased from $62.3 million at the close of fiscal 2011 (January 31, 2012) to $71.8 million at January 31, 2013. (Wal-Mart 2013 annual report, page 33). This can be an indicator of both current problems and an indicator of growth, depending on comparision with other factors. Current assets were $54.9 million and 59.9 million for the same periods, respectively.


Several factors contribute to Wal-Mart’s use of debt to finance its operations. It is a supplier-driven retail business, and as such negotiates aggressive terms with its suppliers. Suppliers will cooperate, given the huge potential market they can offer their goods in at retail. Wal-Mart uses supplier credit to support more aggressive uses for its cash. Page 36 of the 2013 annual report expands on other uses of cash by the consolidated entity, including being unwilling to repatriate foreign subsidiary cash to Wal-Mart US for domestic use (there is a tax on repatriation).


Perhaps what Wal-Mart does with its cash should be considered as an option to paying down its current liabilities. Other ratios, such as Return on Equity, will reflect management choices that hopefully increase shareholder value while being less concerned with growing values of vendor-provided credit, ostensibly at $0 financing cost. Wal-Mart does not accumulate cash, but instead has entered into a share repurchase buyback program (a tax-free way of boosting share prices by reducing the number of shares outstanding). Such shares are then used in part to compensate employees and management (see page 26 of the(NNN) NNN-NNNNAnnual Report). The company focus on shareholder value is prominent throughout the Annual Report.


Return on Equity is prominently outlined in the Wal-Mart 2013 annual report. The authors clearly believe that good stewardship of the investments made should be used to demonstrate management performance, and the highlights do not disappoint. Page 21 of the 2013 Annual Report shows a return on Investment (which as calculated by Wal-Mart is essentially Return on Equity) of 8.8% for the January 2012 fiscal year, as compared with 18.8% for the year ended January 2013.


Return on Equity can be misleading as well, since it uses historical values of equity to determine returns. An investor buying shares during this two year period should look at their own per-share value, and examine their own returns in comparison. By converting the performance to Return on Investment, Wal-Mart takes out the historical cost of equity and prior year retained earnings, and converts it to more current values of buildings, debt, etc. for its reported return calculations.


Days receivable is accounts receivable times 365 divided by annual sales. This ratio is often used to evaluate a company’s credit policy, where days outstanding is compared to credit terms. The Wal-Mart revenue model is primarily retail, so the receivables (2013 Annual Report, page 36), from third party pharmacy sales, consumer credit cards some consumer financing in foreign operations, and some supplier incentives (slotting allowances and other supplier incentives), are not a significant component of cash flow. A comparison for fiscal 2011 ($5.9 million receivables*365/$446.9 million in revenues) and 2012(($6.7 million receivables*365/$469.1 million in revenues) yields 4.81 days and 5.21 days, respectively. Such ratios are low, but not unexpected when these segments compose so little of the retail giant’s revenue mix. One could evaluate the segment performance if sales for each component of receivables were broken out in the annual Report, but that information was not provided as it was likely considered immaterial.

PDtax :

Thanks for asking at Just Answer. Please review the report, and revise your feedback rating accordingly. I'm PDtax.

Customer:

Can you evaluate Walmarts financial performance for 2012 and 2013 using the current ratio formula?

PDtax :

The current ration for Wal-Mart over these periods does not indicate the traditional strength looked to in this ratio of 2.0, but such a standard does not apply to a retailer like Wal-Mart who chooses to use supplier credit as a source of interest-free cash.

PDtax :

The 2012 current ratio of $54.9 million/$62.3 million (.88) and 2013 current ration of $59.9 million/$71.8 million (.83) are consistent, but reflect a more appropriate use for cash and current assets. Since Wal-Mart generates cash collections each day, retaining cash to pay suppliers is likely unnecessary. Use of their balance sheet assets is aggressive, and retaining cash is contrary to their stewardship of corporate assets and generating returns for shareholders with those assets.

PDtax :

Thanks again from Just Answer.

Customer:

Can you further explain how you got your percentages for return on equity?

PDtax :

The return on equity was calculated with essentially the balance sheet reduced by liabilities. While it comes up with a value for equity, it has a mathematical bias in that it uses more current liability and long term debt values that are denominated in more recent dollars. Return on equity could be a poor measure, since it could be calculated based on historical sales of stock from many years ago, likely for much less per share than today.

PDtax :

The equity section of stock, paid in capital and retained earnings does not really reflect an accurate current value of the investment in the corporation; accounting figures aren't intended to do so. Wal-Mart tries to remove or reduce this bias by using more current values.

PDtax :

Thanks again for asking at Just Answer. Positive feedback closes out your question when we are done. I'm PDtax.

PDtax and other Finance Specialists are ready to help you