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: 1977
Experience:  Tax professional and business consultant for 32 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: 1 year ago.
Category: Finance
Expert:  PDtax replied 1 year 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, CPA, MBA
Category: Finance
Satisfied Customers: 1977
Experience: Tax professional and business consultant for 32 years.
PDtax and other Finance Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
< Last | Next >
  • I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
  • I WON!!! I just wanted you to know that your original answer gave me the courage and confidence to go into yesterday's audit ready to fight. Bonnie Chesnee, SC
  • Great service. Answered my complex tax question in detail and provided a lot of additional useful information for my specific situation. John Minneapolis, MN
  • Excellent information, very quick reply. The experts really take the time to address your questions, it is well worth the fee, for the peace of mind they can provide you with. Orville Hesperia, California
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
 
 
 

Meet The Experts:

 
 
 
  • Rakhi Vasavada

    Financial and Legal Consultant

    Satisfied Customers:

    2073
    Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years
< Last | Next >
  • http://ww2.justanswer.com/uploads/RA/rakhi.v/2012-7-3_14374_RakhiVasavadaL.64x64.jpeg Rakhi Vasavada's Avatar

    Rakhi Vasavada

    Financial and Legal Consultant

    Satisfied Customers:

    2073
    Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    1890
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/MY/MyVirtualCPA/2012-7-5_44024_cookmegan1.64x64.jpg Megan C's Avatar

    Megan C

    Certified Public Accountant (CPA)

    Satisfied Customers:

    1755
    Licensed CPA, CFE, CMA who teaches accounting courses at Master's Level
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg JKCPA's Avatar

    JKCPA

    CPA

    Satisfied Customers:

    838
    Bachelors degree and CPA with Accounting experience.
  • http://ww2.justanswer.com/uploads/starside8/2010-2-16_55433_DSCN1175.JPG Eric's Avatar

    Eric

    Financial Manager

    Satisfied Customers:

    558
    Loan servicing, counseling and real estate expert. Foreclosure Expert and Financial Planner.
  • http://ww2.justanswer.com/uploads/FA/fastfile/2011-12-15_23139_Klein2011small.64x64.jpg R. Klein, EA's Avatar

    R. Klein, EA

    Accountant

    Satisfied Customers:

    397
    Intuit Ask a Tax Expert. QuickBooks Certified Pro Advisor (all editions)
  • http://ww2.justanswer.com/uploads/dkaplun/2009-05-17_173121_headshot_1_2.jpg Dimitry K., Esq.'s Avatar

    Dimitry K., Esq.

    Attorney

    Satisfied Customers:

    324
    NASD Licensed Rep, 1997-2001, Business Attorney