Calculate and analyze a Cash Flow Statement

Calculate and analyze a Cash Flow Statement

The assignment this week is to calculate and analyze a Cash Flow Statement. The assignment has two parts. Both parts involve using the Cash Flow Statement from Apple. See attachment. Apple+Financials.pdf

Part one.

Using the Apple Cash Flow Statement, perform the following calculations. I suggest you create a table or spreadsheet for your answers. I want to see the formulas you used to make your calculations as well as the results. 1. List the cash provided by operations, investing and financing for 2013, 2012 and 2011 2. Calculate the percentage change in each area for 2012 to 2013 and 2011 to 2012.

Part two

Based on your results, answer the following two questions. What trends do you seed by looking at the Cash Flow Statement itself, the raw numbers? What are they telling you? Look at your percent of and percent change results. What are they telling you? Note: Please use a formal cover page for this assignment. I have been a bit lenient on this the first few weeks and will now make deductions in this area. My expectation is the paper will contain the following: Calculations. Show formulas and results. Grading will be based using the correct formula and correct results. Note: the results of your calculations on this assignment might seem… odd, but trust your math skills. Analysis. Restate the questions and your responses. Grading will be based on your level of insight. As for volume, think about a two paragraphs per answer. Remember to sight your sources if you use them in your write up. Your submission should be in MS Word. If you are using a spreadsheet, embed it in the document.

Answer preview for Calculate and analyze a Cash Flow Statement