Discuss the data provided in the sheet labeled cash flows

Assignment Help Accounting Basics
Reference no: EM131752677

I need a cash flow statement prepared for the following problem?

Using the data provided in the sheet labeled "Cash Flows" prepare:

Statement of Cash Flows for fiscal year 2016 in proper format.

Use a separate sheet, appropriately named, for the Statement of Cash Flows.

Cash and Cash Equivalents, January 1, 2016 66,200
Cash and Cash Equivalents, December 31, 2016 57,870
increase in accrued expenses 500
decrease in prepaid expenses 960
increase in inventories 21,350
decrease in income taxes payable 3,500
increase in accounts payable 6,840
gain on sale of investment 11,000
increase in accounts receivable 19,380
gain on sale of land 20,500
dividend payments 32,840
depreciation expense 39,990
payments for purchase of investments 40,500
payments for purchase of equipment 56,200
payments for ppuchase of land 62,500
proceeds from sale of land 80,750
proceeds from the issuance of stock 81,000
proceeds from sale of investments 100,500
net income 111,400
payments made to retire bonds payable 150,000
proceeds from the issueance of a mortgage 175,000
payments for purchase of building

187,500

Let me know if you can complete this and how long it will take.  also how much?

Reference no: EM131752677

Questions Cloud

Write and implement a cpp class which represents a book : Design and implement a C++ class which represents a Book, and use this class in a main program which reads in information for multiple books from a data file an
Enter the transaction letter as the description : Enter the transaction letter as the description when entering the transactions in the journal
Overall change in the city net position on the gwfs : What was the correct overall change in the city's net position on the government-wide financial statements?
Provide a critical analysis of your selected topic : Create a clearly stated thesis, and focus the entire paper around it. Provide specific examples to support this thesis.
Discuss the data provided in the sheet labeled cash flows : Using the data provided in the sheet labeled "Cash Flows" prepare
Prepare a consolidation workpaper at the date of acquisition : Alpha acquired 100% of Beta's common stock for $400,000. Prepare a consolidation workpaper at the date of acquisition based upon the following book values
Innovation and change are centripetal force in organizations : Innovation and change are centripetal forces in organizations. In the global marketplace if an organization is not innovative it frequently ceases to exist.
Write a javascript program that calculates the sales tax : Write a JavaScript program that calculates the sales tax and total price of an item. Assume a sales tax rate of 8%, which means you will multiply the cost of th
What characteristics do they have in common : Do you think the portrayal of scientists in the various forms of media influences how society views people in this profession? Why, or why not?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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