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 Dave CPA Your Own Question

Dave CPA
Dave CPA, Accountant
Category: Single Problem
Satisfied Customers: 840
Experience:  Sound knowledge base in accounting and finance.
15068660
Type Your Single Problem Question Here...
Dave CPA is online now
A new question is answered every 9 seconds

Using the Statement of Cash Flow for Xcel Energy, Xcel Energy

Resolved Question:

Using the Statement of Cash Flow for Xcel Energy, Xcel Energy Inc. (XEL) -NYSE report the cash flow ratios. Please report and discuss 3 years of ratios for the three ratios related to debt and dividends but only the current year’s cash flows per share. Show numerators and denominators for all ratios and then discuss their economic meaning. It is possible that your firm does not pay dividends (you will see dividends in the financing section of the Cash Flow Statement).

The cash flow per share ratio is particularly challenging since most of the numbers in the statements are in thousands or millions (look at the top of the statement for a note) while the # XXXXX shares outstanding only for the current year (in Yahoo.Finance, under your firm’s page, look in “Key Statistics” and you will find the # XXXXX shares in the right column down about halfway on the page). You only have to report ONE YEAR on the cash flow per share.
Submitted: 10 months ago.
Category: Single Problem
Expert:  Angela--Mod replied 10 months ago.

Hello, I'm a moderator for this topic. I've been working hard to find a professional to assist you right away, but sometimes finding the right professional can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. Please let me know and I will assist further. Thank you!

 

Best,

Angela
Customer: replied 10 months ago.
I actually thought I sent the question to Dave, CPA he helped me on a similar question.
Expert:  Dave CPA replied 10 months ago.

Hello,

 

I have been away for a bit. Thanks for requesting me. Can you clarify the actual ratios you need to show? It's not very clear in the question.

 

Regards Dave

Customer: replied 10 months ago.

Dave,


 


I'm looking for something similar to this, but for Xcel Energy.


 


The analysis of the Statement of Cash Flow for Starbucks Corporation:


Operating cash flows/current liabilities


 


2012: 1,750/2,210 = .79


2011: 1,612/2,076 = .78


2010: 1,705/1,779 = .96


 


The operating cash flows/current liabilities for Starbucks dropped in 2011, but increased slightly in 2012. The liquidity is worse than it was in 2010, but is showing improvement from 2011 to 2012. The ability to meet current maturities of debt is lower than it was in 2010, meaning that it would be more difficult to cover current liabilities with current cash flows today, than it would have been in 2010. The fact that it did increase from 2011 to 2012 shows that they are working to improve this position.


 


Operating cash flow/total debt


2012: 1,750/3,110 = .56


2011: 1,612/2,976 = .54


2010: 1,705/2,711 = .63


 


The operating cash flow/total debt showed a decrease from 2012 to 2011, but increased in 2012. This increase shows that Starbucks is in a better position to carry total debt than they were in 2011.


Operating cash flow per share


 


2012: 1,750,300,000/751,400,000 = $2.33


 


This number shows that the company is making good capital expenditure decisions and is able to pay out dividends.


Operating cash flow/cash dividends


 


2012: 1,750/513 = 3.41


2011: 1,612/390 = 4.13


2010: 1,705/171 = 9.97


 


The operating cash flow/cash dividends ratio has decreased over the last three years. Starbucks is paying out an increasing number of dividends, but is not increasing cash flow from operating activities at a similar pace. The biggest change in the operating activities occurred in the Changes in Inventory section. Starbucks has purchased an increasingly larger amount of inventory, which is directly affecting the Total Cash Flows from Operating Activities, which in turn is affecting this ratio negatively.


Starbucks Corporation. Balance statement for September 30, 2012, October 2, 2011 and October 3, 2010. Retrieved from http://finance.yahoo.com/q/bs?s=SBUX+Balance+Sheet&annual

Expert:  Dave CPA replied 10 months ago.
Thanks for the clarification. I will have something tomorrow. Regards Dave
Expert:  Dave CPA replied 10 months ago.

Hello,

 

It was a pleasure helping you. Let me know if you have any questions before you rate my answer. Regards Dave

 

 

https://app.box.com/s/4qte1sue5y2ef1fcrbtq

 

Dave CPA, Accountant
Category: Single Problem
Satisfied Customers: 840
Experience: Sound knowledge base in accounting and finance.
Dave CPA and other Single Problem 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:

 
 
 
  • 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
< Last | Next >
  • 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
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • linda_us

    Master's Degree

    Satisfied Customers:

    769
    Business Analyst and Solution Consultant with over 9 years of experience.
< Last | Next >
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg linda_us's Avatar

    linda_us

    Master's Degree

    Satisfied Customers:

    769
    Business Analyst and Solution Consultant with over 9 years of experience.
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Bachelor's Degree

    Satisfied Customers:

    350
    Finished my BA degree with a GPA of 4.0.
  • http://ww2.justanswer.com/uploads/ED/educatortech/2012-6-7_1256_williams4.64x64.jpg Mr. Gregory White's Avatar

    Mr. Gregory White

    Master's Degree

    Satisfied Customers:

    265
    M.A., M.S. Education / Educational Administration
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    CPA

    Satisfied Customers:

    251
    BA degree and Certified Public Accountant
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    B.Com

    Satisfied Customers:

    172
    Have completed B.Com and CA Finalist
  • http://ww2.justanswer.com/uploads/YO/youngda2/2011-12-23_135741_2011012417.37.18.64x64.jpg Dave CPA's Avatar

    Dave CPA

    Accountant

    Satisfied Customers:

    98
    Sound knowledge base in accounting and finance.
  • http://ww2.justanswer.com/uploads/MY/MyVirtualCPA/2012-7-5_44024_cookmegan1.64x64.jpg MyVirtualCPA's Avatar

    MyVirtualCPA

    Master's Degree

    Satisfied Customers:

    89
    Master's Degree in Accounting with excellent math and reasoning skills
 
 
 

Related Single Problem Questions