Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

This is a case that I would like from you to solve. it is about an accounting but I would to follow the instructions precisely by linking the transactions with the balance sheet and the income statement, so any change in one of them will be reflected in the other.

Here are some check figures for the Dow Chemical case

Net Income Available for the Dow Chemical Common Stockholders, $247.

Income before income taxes, $1,070

Retained earnings, $17,040

Total assets, $68,135

Please refer to the 2012 Annual Report (in this case it is a combination of a corporate annual report and 10-k (a 10-k is the formal report filed annually with the Securities and Exchange Commission, which includes a full set of financial statements)) for Dow Chemical.
You will be using the

Consolidated Statements of Income (income statement) on page 69, the retained earnings portion of the Consolidated Statements of Equity (page 73) and the Consolidated Balance Sheets (page 71) for the year ended 2012. On the following worksheets in this workbook I have prepared the income statement, statement of retained earnings, and balance sheet, but have not entered balances. Enter the balances, with excel formulas for all totals and subtotals, and then create transaction columns for each of the transactions below. Create a "Revised" column showing the revised totals after entering the transactions. Sum and copy numbers across the worksheet such that financial statements update appropriately for each transaction recorded. Remember to link net income from the income statement to the statement of retained earnings, and remember to link numbers from the statement of retained earnings to retained earnings on the balance sheet such that any change in retained earnings will update appropriately on the balance sheet. Lastly, format your work properly, no page breaks running through the analyses, use proper number formatting and alignment, etc.

Amounts are in $millions

1 Purchased inventories on account, $1,100.

2 Sales, on account, $3,200, cost of items sold $900, terms 4/10, n/30.

3 Sales were returned to Dow, sales price $300, cost $100. These items were returned to inventory. Cash was refunded.

4 Collections on accounts receivable, $3,900.

5 Purchased properties (buildings, etc.), $43. Paid $8 cash and the rest was financed with long-term debt.

6 Paid wages, $280.

7 Depreciation is recorded on property, $3,650.

8 Interest incomes earned on investments, received in cash, $65.

9 Sold other investments. The cost of the investments was $902; they were sold for $1,100. Cash was received.

10 Paid more dividends to shareholders, $860.

11 Cash was collected for the sales made in #2 above. Cash was collected within the 10 day discount period.

12 Made payments on interest bearing debt. Payments totaled $400, which included interest of $150.

13 Sold additional common stock to shareholders, $900.

14 Made payments on accounts payable, $1,800 cash.

15 Sales for cash, $1,900, cost of items sold was $650.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M91411549
  • Price:- $40

Priced at Now at $40, Verified Solution

Have any Question?


Related Questions in Accounting Basics

Question suppose that france and germany both have 100

Question: Suppose that France and Germany both have 100 units each of capital and labor, and that they share the same CRS technology with which they produce wine and cheese. However, tastes differ in the two countries: c ...

Question - the following data pertain to last years

Question - The following data pertain to last year's operations at Tredder Corporation, a company that produces a single product: Units in beginning inventory 0 Units produced 20,000 Units sold 19,000 Selling price per u ...

Question - pharoah company purchased equipment for 11160 on

Question - Pharoah Company purchased equipment for $11160 on January 1, 2017. The company expects to use the equipment for 3 years. It has no salvage value. Calculate the Monthly depreciation expense on the asset?

Auditing assignment -assessment taskthe aim of the group

Auditing Assignment - Assessment Task: The aim of the group assignment is to test students' ability to integrate skills learnt in Auditing and Assurance Services to analyse a real company from the auditor's perspective a ...

Question - the calculated variable cost per unit of 18 high

Question - The calculated variable cost per unit of $1.8. High Level of activity is: 1,691 units and $7,147cost. If the low level of activity was 530 units, calculate the fixed cost at the low level of activity?

Question - the allowance for doubtful debts account had a

Question - The allowance for doubtful debts account had a balance of $2200 before bad debts of $1400 were written off and the allowance was adjusted to 10% of the accounts receivable balance of $20 000. Compute the new a ...

Question refer to the hat rack cash flow statement 2002 in

Question: Refer to the Hat Rack Cash Flow Statement, 2002 in the text on page 17. Answer the following questions and submit to me via Canvas by the due date. 1. Cash flow from operations? 2. Cash flow from investing? 3. ...

Question - last year garrison manufacturing sold 500 000

Question - Last year, Garrison Manufacturing sold 500 000 units at $4 each. Both sales volume and sales price are expected to increase by 15 per cent in the upcoming year. Calculate the expected sales revenue for the upc ...

Question - c d rom has just given an insurance company

Question - C. D. Rom has just given an insurance company $35,500. In return, he will receive an annuity of $4,400 for 20 years. At what rate of return must the insurance company invest this $35,500 in order to make the a ...

Question please discuss the validation or failure of the

Question: Please discuss the validation or failure of the theory of efficient markets and behavioral finance given the "Credit Crunch" or global financial crisis of 2007-2009. Your initial post must be in your own words, ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As