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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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