User Account

All Pages

Prepare statement of cash flows for fiscal year

Assignment Help Financial Accounting
Reference no: EM131684776

Financial Statements Project -

You are required to prepare the following financial statements using Excel.

(1) Using the data for Brady and Co. provided in the sheet labeled "Trial Balance" prepare: Balance Sheet - comparative, classified in proper format for fiscal years 2015 and 2016 Income Statement - multiple-step for fiscal years 2015 and 2016. Include earnings per share data. Statement of Retained Earnings for 2016. Use separate sheets, appropriately named, for each financial statement.

List 5 notes that would be required if you were also preparing the notes to these financial statements. Do not prepare the notes, just briefly list the accounts, etc. for which GAAP would require disclosure based on Spring's financial statements.

(2) Using the data for Gronk, Inc. 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.

(3) Place your name in cell A1 of the first sheet you create and on all sheets to be printed out.

(4) Neatness counts. Make sure the pages break in appropriate places for printing. For instance, make sure the entire balance sheet prints out on one page. Look at the annual report of your favorite company for help with appropriate formatting, subtotalling, underlining, grouping, etc.

Attachment:- Finanical Statement Project.rar

Verified Expert

Cash Flow Statement is prepared for the year ended 31st Dec 2016. Financials has also been prepared with notes to accounts. Some adjustments has been identified and incorporated in the financials. Requirement has been done as per the GAAP requirement.

Reference no: EM131684776

Questions Cloud

How many drop structures will be required in the ridge : how many drop structures will be required in the ridge, types of soil the natural ground in the direction of flow is 0.001 approximately
Determine the capacity of the sprinkler system : If the sprinklers lines are spaced 15m interval. Determine the capacity of the sprinkler system in l/s
Can computer models to mimic creativity be designed : How is design science research related to this discussion and do you agree that DSR is positioned to achieve some of the objectives of the authors?
Explain why it is possible to go forward in time : what you know about time dilation and other information regarding space/time travel, explain why it is possible to go forward in time
Prepare statement of cash flows for fiscal year : Using the data for Gronk, Inc. provided in the sheet labeled "Cash Flows" prepare: Statement of Cash Flows for fiscal year 2016 in proper format
Define depth of an open channel flow to convey : Calculate the rectangular cross-section uniform water depth of an open channel flow to convey Q=10m3/s discharge with a manning coefficient
Discuss the cornucopian-environmentalism continuum : the Cornucopian-environmentalism continuum discussed in the lecture
Discuss injury occurred directly after accidental : A young long distance runner came to her physician with acute we swelling around the lateral aspect of her ankle. This injury occurred directly after accidental
Discuss about the emerging enterprise network applications : Discuss about the Emerging enterprise network applications and Mobile computing and its business implications.

Reviews

inf1684776

1/19/2018 4:13:20 AM

Did the expert make sure everything is correct and the way the professor wanted the material? Thank you so much for providing me a great work, I got good marks in this sem for first time and that is just because of you guys. thanks a lot.

len1684776

10/20/2017 3:55:06 AM

USE EXCEL EFFICIENTLY AND EFFECTIVELY TO COMPLETE THIS PROJECT (cell references, formulas, etc.). Use separate sheets, appropriately named, for each financial statement. This is a project to be completed totally by each student. Do not post questions to the discussion board. Students are to research any questions on their own or ask me through mail in blackboard.

Write a Review

Financial Accounting Questions & Answers

  Prepare the bank reconciliation for the avisa company

Prepare the November Bank Reconciliation for the Avisa Company - Included with the bank statement was a debit memorandum in the amount of $25 for bank service charges. It has not been recorded on the company's books.

  Determine the cost recovery

Jen acquired an apartment building on June 4, 2016, for $1.4 million. The value of land is $200,000. Jen sold the apartment building on November 29, 2022. Determine Jen’s cost recovery for 2016. Determine Jen’s cost recovery for 2022.

  Eliminated if the department is discontinued

A study has been conducted to determine if one of the departments in MSU Company should be discontinued. The contribution margin in the department is $50,000 per year. Fixed expenses charged to the department are $65,000 per year. It is estimated tha..

  In periodic inventory system

In a periodic inventory system, the quantity of ending inventory is determined by_______.

  The family applied to the loan company for maximum loan

A loan company will loan up to 60% of the equity in a home. A family purchased their home 8 years ago for $83,000. The home was financed by paying 20% down and signing a 30-year mortgage at 8.4% for the balance. The market value of the house is now $..

  Calculate the compound growth rate in sales and earnings

Develop some additional financial data which will further illustrate the companys condition - calculate the compound growth rate in sales and earnings for the company.

  Explain the effects of the sarbanes-oxley act

Explain the effects of the Sarbanes-Oxley Act of 2002 on internal controls. Summarize strengths and weaknesses of an internal control system. What recommendations would you suggest to create improvements to internal control systems?

  Operating activities section using the indirect method

Prepare the operating activities section using the indirect method for One Way Cellular's statement of cash flows for the year ended September 30, 2012.

  Compute the break-even in total sales dollars and in units

Compute the break-even in total sales dollars and in units for 2016. Justice has proposed a plan to get the enterprise on a profitable level. He proposes to improve the quality of the product by spending $0.30 more on raw materials. How would James' ..

  Evaluate the eight variances

Evaluate the eight variances and Comment on the variances - During September 2011, the company produced 106,000 cases and recorded the following cost data

  Assuming ace uses a perpetual inventory system

During the month of June, Ace Incorporated purchased goods from two suppliers. Prepare journal entries to record the transactions, assuming Ace uses a perpetual inventory system.

  Huge discounts in order to recover cash flows

Auditors found out that Campbell was delaying expenses to creditors at year end and selling inventories as huge discounts in order to recover cash flows.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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