Prepare consolidating worksheets for the income statement

Assignment Help Accounting Basics
Reference no: EM132578111

Question - How do you get a question/problem answered? The problem has previously been asked but was not answered. The problem deals with Java the Hut, a regional coffee chain. Below is what I'm looking for help with. The question is on your site but I can't find an answer to it.

You recently accepted the controller position for Java the Hut, a regional coffee chain.

The owner informs you that a complete financial statement package will be required for a new bank loan package.

Prior to your arrival, the company had one accountant and relied heavily on the auditors in the preparation of financial statements. With the new controller position, the expectation is that you will assume the preparation of financial statements.

On your first day of work on April 1, 2012, the Java the Hut accountant informs you that there were a number of transactions in the first quarter of 2012 that she was unsure of the appropriate accounting. Consequently, she recorded the cash activity in Other Assets - Holding account as a temporary holding account. The good news is that the Java the Hut accountant maintained excellent detail of the various transactions and has a series of supporting schedules for you.

Project Requirements -

1. Prepare the appropriate journal entries to recognize the first quarter transactions, currently reported in Other Assets - Holding in the balance sheet.

2. Prepare consolidating worksheets for the income statement for the first quarter of 2012, the retained earnings for the first quarter of 2012, for the balance sheet as of March 31, 2012, and the cash flow statement for the first quarter of 2012.

Adjusting entries from 1 above should be reflected in the appropriate company general ledger.

All inter-company transactions and balances should be eliminated.

Consolidating worksheets should utilize Excel.

Calculations supporting eliminations should be included.

3. Prepare consolidated financial statements for the bank reporting, including:

Income Statement for the first quarter of 2012 (Multi-Step Format)

Balance Sheet as of March 31, 2012 (Classified Format)

Statement of Retained Earnings as of March 31, 2012.

Statement of Cash Flows for the first quarter of 2012.

Financial Statements should utilize Excel.

Reference no: EM132578111

Questions Cloud

Strongest moral consideration in favor of capitalism : What do you see as the strongest moral consideration in favor of capitalism? Why? What do you see as the strongest objection to it? Why?
What is standard deviation of monthly returns : A stock has the following prices in 5 consecutive months, starting from the earliest to the latest: $64, $61, $70, $67, and $65
Describe trait leadership and functional leadership : Describe trait leadership, functional leadership, and Path-Goal Situational Leadership. Apply each of those theories to the manager.
Compute Sugarlands net income : Sugarland Industries reported a net income of $710,750 on December 31, 2018. Compute Sugarland's net income that would produce a basic EPS of $1.80
Prepare consolidating worksheets for the income statement : Prepare consolidating worksheets for the income statement for the first quarter of 2012, the retained earnings for the first quarter of 2012
Variance of the returns on the common stock : The rate of return on the common stock of a company is expected to be 12.00% in a boom economy, 7.00% in a normal economy
What is the weighted average cost of capital : The YTM of the new debt is 8.30% and the tax rate is 21%. What is the weighted average cost of capital after the restructuring?
What is the expected return on portfolio : Suppose the risk-free rate is 5.30% and the market portfolio has an expected return of 14.25%. A portfolio is invested equally
Discuss the law of one price : Discuss the 'Law of One Price' and why it can be an effective tool for discerning investment opportunities.

Reviews

Write a Review

Accounting Basics Questions & Answers

  What is the estimated cost for the tonys house

Mrs. Tony and her husband, Allan, are planning their dream house. What is estimated cost for the Tonys house if they use contractors to complete all of house

  Calculate any passive investment income penalty tax

In 2011, the excess net passive income of Cut-N-Shooters, Inc., an S corporation in Cut-N-Shoot, Calculate any passive investment income penalty tax

  Pear corporation is issuing 600000 of 8 5-year bonds when

pear corporation is issuing 600000 of 8 5-year bonds when potential bond investors want a return of 10. interest is

  Prepare the sales revenues section of the income statement

Prepare the sales revenues section of the income statement based on this information.

  A company is evaluating a project requiring capital

a company is evaluating a project requiring capital expenditure of 620000. estimated life of project is four years and

  Prepare the stockholders equity section of the balance sheet

On January 1, 2020, Wildhorse Corporation had the following stockholders' equity accounts. Prepare the stockholders equity section of the balance sheet

  Journalize the march transactions for snyder company

Mar. 1 Snyder Company sold merchandise on account to Brooks Co., $12,750, terms FOB destination, 2/15, n/eom. The cost of the merchandise sold was $6,000.

  Prepare t-accounts for manufacturing overhead

Dillon Products manufactures various machined parts to customer specifications. The company uses a job-order costing system and applies overhead costs to jobs.

  It sold land haveing a fair market value of 900000 in

on july 1 2010 rentoul inc made two sales1. it sold land haveing a fair market value of 900000 in exchange for a 4-year

  Prepare T-accounts to show the flow of costs

Prepare T-accounts to show flow of costs during the period from Materials Inventory through Cost of Goods Sold. Prepare journal entries to record transactions

  Prepare the adjusting journal entry on december

At December 31, the unadjusted trial balance of H&R Tacks reports Supplies of $8,700 and Supplies Expense of $0. Prepare the adjusting journal entry on December

  Jobs and research the organizations

1. List at least three jobs and research the organizations' recruiting practices. The jobs could be positions you have held or of those you want to hold. In your post, address the following questions:

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