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

  What is the profitability index for the project

Assuming the company's cost of capital is 12 percent, what is the profitability index for the project? (Round to one decimal place.)

  What does the scanlon plan mean need examples

What does the scanlon plan mean? need examples to explain it.

  Problem regarding the capital structure theory

1. Capital Structure Theory in general assumes that: 2. Which of the following financial ratios is the best measure of the operating effectiveness of a firm's management?

  A promissory note has outstanding payments of 650 at the

a promissory note has outstanding payments of 650 at the end of each of the next 5 years. what market price would be

  Calculate any passive investment income tax penalty

If this will be the third consecutive year the company may be subject to the penalty tax on excessive passive investment income, what could Sweet water do before the end of year to avoid the tax?

  Purchase commitments

(Purchase Commitments) At December 31, 2014, Indigo Girls Company has outstanding noncancelable purchase commitments for 36,000 gallons, at $3.00 per gallon, of raw material to be used in its manufacturing process. The company prices its raw material..

  Two skill sets-what are the ethical issues

An accounting professional requires at least two skill sets. The first is to be technically competent. Knowing how to capture, manage, and report information is a necessary skill. Second, the ability to assess manager and employee actions and biases ..

  Identification of key qualitative factorsrelevant costs

identification of key qualitative factors.relevant costs special sales order-idle versus full capacity hull motors inc.

  Question 1for an upcoming trip pat wants to buy euros at

question 1for an upcoming trip pat wants to buy euros at the local bank when the current exchange rate quoted in the

  Capital structure and ratio analysis

Investigate how the concepts of dividend policy, cost of capital, and other aspects of corporate financial management theory learned in this course affect the financial profile of the firm your group has selected.

  Section on honeywell history and the turnaround

After reviewing the background section on Honeywell's history and the turnaround led by Dave Cote from 2002-2008, what do you think went wrong with the way the management team handled the 2001 recession?

  Received information that a potential unethical

The fraud detection committee has received information that a potential unethical or illegal action has taken place at our retail facility in New York. This potential issue was flagged by a current employee of this entity, although little direct, det..

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