Indirect cash flows reconciliation

Assignment Help Accounting Basics
Reference no: EM13969229

In this project, you are given complete 2014 and selected 2015 information about a company, and are asked to prepare the following in good form (Note: Because much of the information relates to summary transactions for the entire year, use June 30, 2015 as the date for the original entries unless a specific date is provided.)

1. Original entry to record the transactions

2. Adjusting entries made at year end (see Note 1)

3. Trial balance worksheet through the ending or closing balance column, including closing entries

4. Bounce's 2015 multiple step Income Statement

5. 2015 Classified Balance Sheet

6. 2015 Statement of Stockholders' Equity

7. 2015 Direct method Statement of Cash Flows

8. Disclosures, complete with Indirect Cash Flows reconciliation

Round all calculations, except earnings per share, to the nearest dollar.  Be sure to use dollar signs where appropriate.

All work must be done in an Excel spreadsheet.

All transactions must be linked to the General Journal. All totals must be calculated on the spreadsheet either by adding and subtracting cells or using the sum function.  Closing entries must be completed by reference to the adjusted balances.  All totals and subtotals on the financial statements must also be calculated either by adding and subtracting cells or using the sum function.

Notes:

1. For purposes of the Bounce Company, certain transactional entries that affect the cash balance must be computed.  You may date these as either transactional entries or adjusting entries for purposes of the Bounce Company journal entries.

2. Several accounts and account balances are missing from the 2015 information provided.  You will need to determine this missing information by reference to the transaction and adjusting entries above.

General Information about the Bounce Company:

The Bounce Company makes basketballs for the NBA and NCAA. Manufacturing occurs at the plant in Zanesville, Ohio. Bounce Company also owns a warehouse in South Dakota.  Bounce Company also rents a sales office in New Orleans.

The Bounce Company is in the 30% tax bracket.  Note that 70% of 2015 taxes have been paid, and the remaining 30% will be paid in 2016.

All purchases of property, plant and equipment assets are made with cash.

500,000 shares of $1 par value common stock have been authorized.  As of 12/31/14, 100,000 shares of stock were issued and outstanding.   

Additional information concerning 2015:

On January 2, 2015 Bounce Company sold an additional 2,000 shares of stock for $10 per share.

During 2015, 10,000 shares of Bounce's stock were actively traded on the NYSE among investors (this excludes the 2,000 shares from the 2015 offering).  The December 31, 2015 year-end price for Bounce's stock was $15 per share.

The following transactions (a partial list) took place:

  • $15,000 of supplies was purchased on account during 2015.
  • 2015 rent payments totaled $45,000.
  • 2015 utility payments totaled $15,000.
  • Gross sales revenue for 2015 was $1,600,000.
  • Transportation-in for inventory items bought on account for 2015 totaled $9,000.
  • Purchase returns for inventory items bought on account for 2015 totaled $1,100.
  • 2015 inventory purchases, all on account, totaled $500,000.
  • 2015 wage payments to employees totaled $200,000.
  • Sales returns for goods purchased on account totaled $1,300 in 2015.  The cost of the merchandise was $390.
  • Payments were made to suppliers for general operating expenses in the amount of $8,000.

During 2015, Bounce changed its estimate of bad debts from 2% of net credit sales to 2.5% of total credit sales.  All sales are credit sales on terms of net 30 days.

During 2015, Bounce Company sold a building that had an original cost of $100,000 and accumulated depreciation at the time of sale of $50,000.  Bounce sold the building for $55,000 cash.

During 2015, Bounce Company disposed of $100,000 of equipment at the city dump.  At the time of disposal the equipment had accumulated depreciation of $80,000.

Bounce Company rents part of the South Dakota warehouse to another company, and received $30,000 in cash for the rental during 2015.

The warehouse in South Dakota received extensive water damage from rain due to a freako hurricane.  It cost $100,000 to repair the damages, for which the Bounce Company paid.  Later, the Bounce Company received $50,000 from its property and casualty insurer to cover part of the cost of the damages.

On December 31, 2015, Bounce received $100,000 cash from the issuance of a 10% bank note due in ten annual installments of $16,275.  The $10,000 of the first annual payment, due 12/31/16, will be the payment of interest.

Cash dividends of $66,400 were declared and paid in 2015.

Check figures:

Net Income                                         $367,710       

Total assets                                          $976,487

Cash used by investing activities        $595,000

Hints and other helpful information:

The selected account balances that are reported are all correct as of 12/31/14.

Go through the information on the attached pages and determine the missing information (i.e., accounts and account balances) that must be added to the partial information that has been provided. 

 

The Bounce Company (All accounts have normal balances)

Account

Selected Balances12/31/15

Final Balances  12/31/14

Accumulated Depreciation -Buildings

$240,000

$200,000

Accumulated Depreciation - Equipment

280,000

250,000

Gross Accounts Receivable

130,000

47,500

Allowance for Uncollectible Accounts

42,500

2,500

Cash

112,987

29,500

Prepaid Rent

3,000

5,000

Prepaid Utilities

6,000

4,000

Unearned Rent

8,500

7,000

Wages Payable

3,000

5,000

Accounts Payable

29,900

0

Land

45,000

45,000

Buildings

500,000

300,000

Equipment

650,000

400,000

Supplies

12,000

10,000

Inventory

80,000

90,000

Capital Stock

 

100,000

Additional Paid in Capital

 

190,000

Retained Earnings

 

176,500

 

 

 

Reference no: EM13969229

Questions Cloud

Gearing up to plan the spend for the upcoming season : What metric(s) would you look at to come up with the optimal decision? What optimization model that you have seen or used for a different type of application could apply here? Why do think the problem is similar? State all assumptions.
Informs ethical practices and conduct in accounting : You are to prepare a 5-page report on a philosopher/thinker of your choice and show clearly how his/her body of thought applies to, and informs ethical practices and conduct in accounting and business in general.
A large volume of research related to leadership : A large volume of research related to leadership has been published over the last fifty years. This large volume of research stresses on the importance of leadership within the context of organizational productivity and performance. While leadership ..
Computer crimes-acts-intent and defenses : Assume that you work in a large accounting firm that handles hundreds of client accounts containing confidential information, financial data, and social security numbers.
Indirect cash flows reconciliation : In this project, you are given complete 2014 and selected 2015 information about a company, and are asked to prepare the following in good form (Note: Because much of the information relates to summary transactions for the entire year, use June 30,..
Advantages of having multiple revenue sources for services : What do you believe are the primary advantages and disadvantages of having multiple revenue sources for health care services offered by an organization for planning and reporting purposes
What are benefits and challenges to having a hybrid record : Discuss one of the emerging technology issues and discuss whether it should be included in the definition of the legal health record. What is a hybrid record? What are some benefits and challenges to having a hybrid record?
Analyze data from a revision of the survey fielded : Complete this project assignment in which you analyze data from a revision of the survey fielded in June 2012. The survey once again was given to a random sample of Vancouver Symphony Orchestra concertgoers attending a free concert, since the free co..
How effective was your training and orientation : How effective was your training and orientation? How did this person handle performance evaluation and reviews? How did this person coach and mentor his or her staff? What lessons did you learn from this experience?

Reviews

Write a Review

Accounting Basics Questions & Answers

  Sky king company sold 9 million of four- year 8

sky king company sold 9 million of four- year 8 debentureson july 1 2007. the bonds sold to yield a real rate of

  Shurshot sports inc manufactures basketballs for the

shurshot sports inc. manufactures basketballs for the national basketball association nba. for the first 6 months of

  Used 1900 hours of direct labor time at a total cost of

the odle company makes and sells a single product called a kitt. odle uses a standard costing system. each kitt has a

  Disbursements on the cash budget

The excess or deficiency of cash available over disbursements on the cash budget is calculated as follows:

  A buffer that contains 0347 m of a base b and 0483 m of

a buffer that contains 0.347 m of a base b and 0.483 m of its conjugate acid bh has a ph of 8.08. what is the ph after

  Abc company had the following account balance after

abc company had the following account balance after adjusting journal entries 12-31-09 cash 120000 accounts receivable

  Objectives for the conference decision case

Define the Objectives for the Conference Decision Case. Objectives should be separated into fundamental and means objectives.

  Prepare cheng entry to record the exchange

Cheng Company traded a used truck for a new truck. The used truck cost $30,000 and has accumulated depreciation of $27,000. The new truck is worth $37,000.

  How control weaknesses can lead to fraud

In your Discussion, you will be faced with a potentially fraudulent situation. This is something that you might face in your auditing career as well. How would you handle these types of difficult situations?

  Record treasury stock transactions using cost method

Record treasury stock transactions using cost method for: a) bought 300 shares of common stock as treasury shares@ 62 b) sold 80 shares of treasury stock at 60 c) sold 40 treasury shares at 68.

  Preparation and subsequent use of budget

Submit your budget to the store manager with no more than a 700-word write-up for the budget. The write-up must include risks associated with sales forecasts and an analysis of ethical considerations in the preparation and subsequent use of the bu..

  August 5th a small ofice building is purchased for 320000

august 5th. a small ofice building is purchased for 320000 by paying 3200 down and taking out a fifteen-year 4 288000

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