User Account

All Pages

Statement of cash flows for fiscal year 2013

Assignment Help Financial Accounting
Reference no: EM131894748

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.

Attachment:- Financial Statement Project.rar

Reference no: EM131894748

Questions Cloud

Compute DiCenta diluted earnings per share : The preferred stock pays an annual dividend of $5 per share. DiCenta' tax rate is 40%. Compute DiCenta' 2010 diluted earnings per share
Department stores and specialty stores : Compare visual merchandising strategies used in department stores and specialty stores. What are some differences? What are some similarities?
Limitations of the process-focus strategy : What can be the limitations of the process-focus strategy? And how to address?
Calculate the values of rttm rtts rttd and rto : Calculate the values of RTTM, RTTS, RTTD, and RTO if the original RTO is 6 seconds. Did the sender miss the retransmission of any segment?
Statement of cash flows for fiscal year 2013 : 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
Calculate commission sales : What is the formula on Excel to calculate commission sales, where commission is 6% on all sales that are at least 20% above cost?
What is a lump-sum purchase : What is a lump-sum purchase? How do we account for the lump-sum purchases of a group of long-term assets
What is the state of the connection after each event : The application sends a "close" message. What is the state of the connection after each event? What is the action after each event?
Define ethical obligation to charge out-of-staters : While traveling on Interstate 10 in the vast, arid land between Phoenix and Los Angeles, a traveler's "worst nightmare" occurs.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Using the effective interest method

On 1/1/2014 the Jackson Co. has a $40,000 debt outstanding which matures on 12/31/16. Interest which is payable on Dec. 31 of each year, was last paid on 12/31/13. Using the effective interest method. how much interest expense is recognized on the de..

  Calculate the synthetic forward rate from the aud

Calculate the synthetic forward rate from the AUD perspective and calculate the AUD arbitrage profits available per GBP 100,000 sold in time 1.

  Design a flowchart of the present system

Design a flowchart of the present system. Identify potential internal control weaknesses in the present procedures. Exclude the data processing departments operation in your review.

  Decision making regarding addition of new facilities for a

decision making regarding addition of new facilities for a business.you are considering adding a new conference room to

  Break-even point and make the business more profitable

For the past ten years, you've worked at a PETCO Salon as a dog groomer. You're thinking of starting your own dog grooming business. You found place you could rent that's right next to a popular shopping center, and two of your friends (who are also ..

  Describe why the fair value of a companys assets

Describe why the fair value of a company's assets is used in the preparation of combined financial statement

  Company sold merchandise

Mullis Company sold merchandise on account to a customer for $1,025, terms n/30. The journal entry to record this sale transaction would be

  Amount of ending inventory at lower-of-cost-or-market

Charapata Company applied FIFO to its inventory and got the following results for its ending inventory. The net realizable value of units purchased at year-end was cameras $78, Blu-ray players $60, and iPods $70. Determine the amount of ending invent..

  Understanding of the task of a marketer

This assessment involves writing about your understanding of the task of a marketer and their role in relation to demonstrating an understanding of how marketers go about changing customer's behaviour in order to get consumers to buy their brand.

  Describe and interpret the ratios that you calculated

Describe and interpret the ratios that you calculated. Discuss potential liquidity issues based on your calculations of the current and quick ratios.

  Short description computation of total cash received from

short description computation of total cash received from the selling of merchandise.first company sold merchandise on

  Question 1 evaluate the cost per unit for each of the 5

question 1 evaluate the cost per unit for each of the 5 products if the company uses glass bottles.2 turn in an excel

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