User Account

All Pages

Statement of cash flows

Assignment Help Financial Accounting
Reference no: EM131117872

Financial Statements Project

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

USE EXCEL EFFICIENTLY AND EFFECTIVELY TO COMPLETE THIS PROJECT (cell references, formulas, etc.).

(1) Using the data for Spring, Inc. provided in the sheet labeled "Trial Balance" prepare:

Balance Sheet - comparative, classified in proper format for fiscal years 2012 and 2013.

Income Statement - multiple-step for fiscal years 2012 and 2013. Include earnings per share data.

Statement of Retained Earnings for 2013.

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 Midnight, Inc. provided in the sheet labeled "Cash Flows" prepare:

Statement of Cash Flows for fiscal year 2013 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.

FILENAME:
Name your file FSlastname. For example, my file would be named: FSCasello_Bouges

(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.

111787284_1Financial Statement Project Summer 2016.xls

Reference no: EM131117872

Questions Cloud

What is your available cash balance : Your book balance for cash is $811. You have an outstanding deposit of $210 and three outstanding checks totaling $316. What is your available cash balance?
How can the sports exports company use currency futures : How can the Sports Exports Company use currency futures contracts to hedge against exchange rate risk? Are there any limitations of using currency futures contracts that would prevent the Sports Exports Company from locking in a specific exchange rat..
What should sheryl conan do : Lower-of-Cost-or-Market The market value of Lake Corporation's inventory has declined below its cost.
Problem regarding the western and central europe : Germany and Italy controlled almost all of western and central Europe, leaving Britain to face the seemingly invincible German army and air force alone. Britain's new prime minister, ______________________, was already turning to Roosevelt for aid..
Statement of cash flows : Create and on all sheets to be printed out - Statement of Cash Flows for fiscal year 2013 in proper format.
What is the purpose of the lower of cost or market method : Do you apply the lower-of-cost-or-market method to each individual item, to a category, or to the total of the inventory? Explain.
Question regarding the search for immortality : Name first Emperor of China whose insane search for Immortality is what killed him?
Question regarding the protestant reformation : Describe how Catholics responded to the Protestant Reformation. Include the reforms that Catholics were already undertaking as well as the reforms they carried out in the wake of Luther. Furthermore, describe how Catholic kings attempted to suppre..
Prepare a schedule showing the computation of the cost : Prepare a schedule showing the computation of the cost of inventory on hand at December 31, 2009, based on the conventional retail method.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Illustrate what is the material purchase price variance

Direct material 9 feet at $5.00 per foot. Actual information for July: 2,000 units were produced; 20,000 feet of direct material were purchased at a cost of $92,000 and 19,000 feet of material were used. Illustrate what is the material purchase pr..

  Project will provide unlevered cash flows

Stackhouse Industries has a new project available that requires an initial investment of $4.5 million. The project will provide unlevered cash flows of $675,000 per year for the next 20 years. The company will finance the project with a debt-to-value..

  How many shares are held as treasury stock by coca-cola

What percentage of authorized shares was issued by Coca-Cola at December 31, 2010, and by PepsiCo at December 29, 2010? How many shares are held as treasury stock by Coca-Cola at December 31, 2010, and by PepsiCo at December 29, 2010?

  Illustrate what is the best estimate for the firm value

Illustrate what is the best estimate for the firm's value of equity, in millions

  Opportunity cost of going to the game is

Your best friend offered you $130 for the ticket now that the team is doing well. The opportunity cost of going to the game is?

  Discount and allowance

Apr. 18   Purchased merchandise from FAU Corp. under the following terms: $8,500 price, invoice dated April 18, credit terms of 2/10, n/30, and FOB destination. Apr. 21   After negotiations, received from FAU a $1,100 allowance on the April 18 purcha..

  Prepare journal entry included income tax expense

Prepare journal entry for 2012 through 2015? (Included: income tax expense, income tax payable, deferred tax liability.

  Prepare a statement of cash flows for the year ended

Complete the December 31, 2011, balance sheet and prepare a statement of cash flows for the year ended December 31, 2011, using the indirect method.

  Affecting client business risk and acceptable audit risk

What are the major factors affecting client business risk and acceptable audit risk for this audit? What is the most appropriate document(s) to use for sampling procedures? What are some attributes that you would list on your work paper when doing yo..

  Bond issue proceeds increase shareholders equity

On March 1, 2013, E Corp. issued $1,400,000 of 8% nonconvertible bonds at 103, due on February 28, 2023. Each $1,000 bond was issued with 30 detachable stock warrants, each of which entitled the holder to purchase, for $75, one share of Evan's $25 pa..

  What is the principal source of legislative guidance

1.  What is the principal source of legislative guidance that provides "Special Rules for Long-Term Contracts"? 2.  ­What are the three terms that the IRS uses to define "long-term contract" and what do they mean?  3.  What two categories does Sectio..

  Nbspfrom the data prepare journal ledger trial balance

nbspfrom the data prepare journal ledger trial balance financial statements.for the past several years dawn lytle has

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