Find the statement of cash flows using the indirect method

Assignment Help Financial Accounting
Reference no: EM131106746

Excel Assessment: In this assignment, you will demonstrate your knowledge and competencies to use Excel to solve an accounting problem. Approximately 50% of your grade will be based on correct use of Excel and the remaining 50% will be based on your ability to create a Statement of Cash Flows using both the direct & indirect methods.

Instructions:

1) Use the Comparative Balance Sheets & the Income Statement along with the additional information included in the tabs below to prepare a Statement of Cash Flows using the Direct Method. Place your answer on the Direct Method tab of this spreadsheet.

2) Use the Comparative Balance Sheets & the Income Statement along with the additional information below to prepare a Statement of Cash Flows using the Indirect Method. Place your answer on the Indirect Method tab of this spreadsheet.

3) Use the Excel formula function for all computations.

4) Do not copy and paste figures from the Balance Sheets or Income Statement when preparing the Statement of Cash Flows. Instead, reference data from one sheet to another using Excel formulas..

Attachment:- excelassessment.xlsx

Reference no: EM131106746

Questions Cloud

Calculate portfolio new beta : The portfolio's beta is 1.20. Suppose you sell one of the stocks with a beta of .8 for $5,000 and use the proceeds to buy another stock whose beta is 1.6. Calculate your portfolio's new beta.
Rederive this algorithm for a discounted problem : In Section 12.3, we derived the dynamic-programming algorithm for a finite-horizon problem. In this problem, we rederive this algorithm for a discounted problem for which the cost-to-go function is defined by
What influence might previous child sexual abuse - placement : What influence might previous child sexual abuse and/or placement in foster care have on teenagers who become parents? What do you think about the idea that in some families, teens are encouraged to have babies so the family can get government assis..
What would the dollar price of the automobile : Has the price, in dollars, of the automobile increased or decreased during the 25-year period because of changes in the exchange rate? What would the dollar price of the automobile be in May 2008, again assuming that the car's price changes only with..
Find the statement of cash flows using the indirect method : Use the Comparative Balance Sheets & the Income Statement along with the additional information included in the tabs below to prepare a Statement of Cash Flows using the Direct Method.
Question regarding the available analysis on the brexit : What we would like is a 3 page report on all available analysis on the Brexit, and based on your analysis which sectors will be see large negative or positive impacts. Also we would like coverage on 2-3 companies which will see a large impact as w..
Teller corporations post closing trial balance : Teller Corporation's post-closing trial balance at December 31, 2010, was as follows. At December 31, 2010, Teller had the following number of common and preferred shares.
Do you think that more single fathers would be willing : Search in your community (Vancouver, Washington) to find resources available to young fathers. Using the Journal, list the resources you found. If there were more services to address the needs of single fathers, do you think that more single fathe..

Reviews

Write a Review

 

Financial Accounting Questions & Answers

  Contribution deduction and carryover

Calculate Calvin's charitable contribution deduction and carryover (if any) under the following circumstances

  Effective-interest method for discount-premium amortization

Prepare a bond amortization schedule using the effective-interest method for discount and premium amortization. Amortize premium or discount on interest dates and at year-end. Prepare all of the relevant journal entries from the time of sale until th..

  Questionbetter food company currently acquired an olive oil

questionbetter food company currently acquired an olive oil processing company that has an annual capacity of 2000000

  Evaluate the equivalent units of product

Evaluate the equivalent units of product for (1) materials and (2) conversion cost for each month and calculate the physical units for January and May.

  Why harrys profits were different from the amount

Construct Harry's cash budget for the 3 months April, May, and June and the total for the 2nd quarter. Fixed overhead expenses requiring the use of cash may be grouped together as a single line item called "fixed overhead".

  Explain the purposes of the statement of cash flows

(Learning Objective 1: Explain the purposes of the statement of cash flows) Bryant, Inc., has experienced an unbroken string of nine years of growth in net income. Nevertheless, the company is facing bankruptcy.

  Used in making personal financial decisions

Cost-volume-profit analysis can also be used in making personal financial decisions. For example, the purchase of a new car is one of your biggest personal expenditures. What is the variable gasoline cost of going one mile in the hybrid car? What is ..

  Locate and summarise online news articles

Students who study accounting are expected to be aware of current events that impact upon the profession and be able to interpret financial and other information that companies prepare and present to the public.

  Evaluate the amount of sedato company inventory

Sedato Company follows the practice of pricing its inventory at the lower-of-cost-or-market, on an individual-item basis - determine the amount of Sedato Company inventory.

  Revenue recognition for companies selling bundled contracts

Give an overview of how this method affects revenue recognition for companies selling bundled contracts. How does this principle help a company report how it’s truly performing financially?

  Statement of cash flows using the indirect method

Prepare cash flows from operating activities section of statement of cash flows, using the indirect method.

  Illustrate what business risks does jetblue face

Illustrate what business risks does JetBlue face that may threaten the company’s ability to satisfy stockholder expectations? What are some examples of control activities that the company could use to reduce these risks?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd