Need this assignment done, preferably in Excel. Just so you know, the 2009 amazon financial statement is just for the last set of questions on assignment 4.2

97999_25_AppA_p01-42 11/30/10 8:56 AM Page A-1 Appendix A http://media.corporate-ir.net/media_files/irol/97/97664/2007AR.pdf Courtesy of Amazon.com, Inc. or its affiliates. All rights reserved. Appendix A A-1 97999_25_AppA_p01-42 A-2 11/30/10 Appendix A 8:56 AM Page A-2 97999_25_AppA_p01-42 11/30/10 8:56 AM Page A-3 Appendix A A-3 97999_25_AppA_p01-42 A-4 11/30/10 Appendix A 8:56 AM Page A-4 97999_25_AppA_p01-42 11/30/10 8:56 AM Page A-5 Appendix A A-5 97999_25_AppA_p01-42 A-6 11/30/10 Appendix A 5:31 PM Page A-6 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-7 Appendix A A-7 97999_25_AppA_p01-42 A-8 11/30/10 Appendix A 5:31 PM Page A-8 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-9 Appendix A A-9 97999_25_AppA_p01-42 A-10 11/30/10 Appendix A 5:31 PM Page A-10 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-11 Appendix A A-11 97999_25_AppA_p01-42 A-12 11/30/10 Appendix A 5:31 PM Page A-12 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-13 Appendix A A-13 97999_25_AppA_p01-42 A-14 11/30/10 Appendix A 5:31 PM Page A-14 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-15 Appendix A A-15 97999_25_AppA_p01-42 A-16 11/30/10 Appendix A 5:31 PM Page A-16 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-17 Appendix A A-17 97999_25_AppA_p01-42 A-18 11/30/10 Appendix A 5:31 PM Page A-18 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-19 Appendix A A-19 97999_25_AppA_p01-42 A-20 11/30/10 Appendix A 5:31 PM Page A-20 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-21 Appendix A A-21 97999_25_AppA_p01-42 A-22 11/30/10 Appendix A 5:31 PM Page A-22 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-23 Appendix A A-23 97999_25_AppA_p01-42 A-24 11/30/10 Appendix A 5:31 PM Page A-24 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-25 Appendix A A-25 97999_25_AppA_p01-42 A-26 11/30/10 Appendix A 5:31 PM Page A-26 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-27 Appendix A A-27 97999_25_AppA_p01-42 A-28 11/30/10 Appendix A 5:31 PM Page A-28 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-29 Appendix A A-29 97999_25_AppA_p01-42 A-30 11/30/10 Appendix A 5:31 PM Page A-30 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-31 Appendix A A-31 97999_25_AppA_p01-42 A-32 11/30/10 Appendix A 5:31 PM Page A-32 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-33 Appendix A A-33 97999_25_AppA_p01-42 A-34 11/30/10 Appendix A 5:31 PM Page A-34 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-35 Appendix A A-35 97999_25_AppA_p01-42 A-36 11/30/10 Appendix A 5:31 PM Page A-36 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-37 Appendix A A-37 97999_25_AppA_p01-42 A-38 11/30/10 Appendix A 5:31 PM Page A-38 97999_25_AppA_p01-42 11/30/10 5:31 PM Page A-39 Appendix A A-39 97999_25_AppA_p01-42 A-40 11/30/10 Appendix A 5:31 PM Page A-40 97999_25_AppA_p01-42 11/30/10 5:52 PM Page A-41 Appendix A A-41 97999_25_AppA_p01-42 A-42 11/30/10 Appendix A 5:31 PM Page A-42 Accounting 2 Handouts Assignment 4.1 Handout 1. Financial statements all have a goal. The cash flow statement does as well. Requirements R1. Describe how the Statement of Cash Flows helps investors and creditors perform each of the following functions: a. Predict future cash flows b. Evaluate management decisions c. Predict the ability to make debt payments to lenders and pay dividends to stockholders 2. Cash-flow items must be categorized into one of four categories. Requirements R1. Answer the following questions about the Statement of Cash Flows: a. List the categories of cash flows in order of presentation. b. What is the \"key reconciling figure\" for the Statement of Cash Flows? Where do you get this figure? c. What is the first dollar amount to report for the indirect method? 3. Triumph Corporation is preparing its Statement of Cash Flows by the indirect method. Triumph has the following items for you to consider in preparing the statement: Requirement Identify each item as an Operating activityaddition to net income (O+), or subtraction from net income (O-) Investing activityaddition to cash flow (I+), or subtraction from cash flow (I-) Financing activityaddition to cash flow (F+), or subtraction from cash flow(F-) Activity that is not used to prepare the indirect cash-flow statement (N) Accounting 2 Assignment Handout 2011 Pearson Education Page 1 of1 6 2/29/2016 Accounting 2 Handouts 4. DVR Equipment, Inc., reported the following data for 2011: Requirement Compute DVR's net cash provided by operating activitiesindirect method. 5. Street Cellular accountants have assembled the following data for the year ended June 30, 2012: Requirement Prepare the operating activities section using the indirect method for Street Cellular's Statement of Cash Flows for the year ended June 30, 2012. 6. Use the data in exercise 5 to complete this exercise. Requirement Prepare Street Cellular's Statement of Cash Flows using the indirect method for the year ended June 30, 2012. Stop after determining the net increase (or decrease) in cash. Accounting 2 Assignment Handout 2011 Pearson Education Page 2 of2 6 2/29/2016 Accounting 2 Handouts 7. White Media Corporation had the following Income Statement and Balance Sheet for 2011: Requirements R1. Compute for White Media Corporation during 2011 the a. Acquisition of equipment. The business sold no equipment during the year. b. Payment of a long-term note payable. During the year the business issued a $5,100 note payable. 8. Use the White Media Corporation data in exercise 7 and the results you calculated from the requirements. Requirement Prepare White Media's Statement of Cash Flowsindirect methodfor the year ended December 31, 2011. 9. Brianna's Wedding Shops earned net income of $76,000, which included depreciation of $17,000. Brianna's paid $122,000 for a building and borrowed $63,000 on a long-term note payable. Requirement How much did Brianna's cash balance increase or decrease during the year? 10. Roberta McLeary Company expects the following for 2011: Accounting 2 Assignment Handout 2011 Pearson Education Page 3 of3 6 2/29/2016 Accounting 2 Handouts Requirement How much free cash flow does McLeary expect for 2011? 11. The cash flow statement categorizes like transactions for optimal reporting. Requirement Identify each of the following transactions as an (a) Operating activity (O), Investing activity (I), Financing activity (F), Noncash investing and financing activity (NIF) Transaction that is not reported on the Statement of Cash Flows (N). For each cash flow, indicate whether the item increases (+) or decreases (-) cash.The indirect method is used to report cash flows from operating activities. 12. Consider the following transactions: Accounting 2 Assignment Handout 2011 Pearson Education Page 4 of4 6 2/29/2016 Accounting 2 Handouts Requirement Indicate whether each transaction would result in an operating activity, an investing activity, or a financing activity for an indirect method Statement of Cash Flows and the accompanying schedule of noncash investing and financing activities. 13. The accounting records of CD Sales, Inc., include the following accounts: Requirement Compute CD's net cash provided by (used for) operating activities during March. Use the indirect method. 14. Cole Gymnastics Equipment, Inc., reported the following financial statements for 2011: Accounting 2 Assignment Handout 2011 Pearson Education Page 5 of5 6 2/29/2016 Accounting 2 Handouts Requirement Compute the amount of Cole Gymnastics' acquisition of plant assets. Cole Gymnastics sold no plant assets. Accounting 2 Assignment Handout 2011 Pearson Education Page 6 of6 6 2/29/2016 Accounting 2 Handouts Assignment 4.2 Handout 1. Accountants for Smithson, Inc., have assembled the following data for the year ended December 31, 2011: Requirement Prepare Smithson's Statement of Cash Flows using the indirect method. Include an accompanying schedule of noncash investing and financing activities. Accounting 2 Assignment Handout 2011 Pearson Education Page 1 of1 4 2/29/2016 Accounting 2 Handouts 2. The 2012 comparative Balance Sheet and Income Statement of Cobbs Hill, Inc., follow: Cobbs Hill had no noncash investing and financing transactions during 2012. During the year, there were no sales of land or equipment, no issuances of notes payable, no retirements of stock, and no treasury stock transactions. Requirements R1. Prepare the 2012 Statement of Cash Flows, formatting operating activities by the indirect method. Accounting 2 Assignment Handout 2011 Pearson Education Page 2 of2 4 2/29/2016 Accounting 2 Handouts R2. How will what you learned in this problem help you evaluate an investment? Accounting 2 Assignment Handout 2011 Pearson Education Page 3 of3 4 2/29/2016 Accounting 2 Handouts Decision Case Showcase Cinemas and Theater by Design are asking you to recommend their stock to your clients. Because Showcase and Theater by Design earn about the same net income and have similar financial positions, your decision depends on their cashflow statements, summarized as follows: Requirement Based on their cash flows, which company looks better? Give your reasons. Financial Statement Case Refer to the 2009 Amazon.com Financial Statements handout. Use the Amazon.com Statement of Cash Flows, along with the company's other financial statements to answer the following questions. Requirements R1. Which method does Amazon use to report net cash flows from operating activities? How can you tell? R2. Amazon earned net income during 2009. Did operations provide cash or use cash during 2009? Give the amount. How did operating cash during 2009 compare with 2008? R3. Evaluate 2009 in terms of net income, cash flows, Balance Sheet position, and overall results. Be specific. Accounting 2 Assignment Handout 2011 Pearson Education Page 4 of4 4 2/29/2016