# Accounting home work help 5 problems

I Need this done by Wednesday afternoon 2:30pm pst There are 5 excel tabs that contain one problem each.  I need all 5 problems done.

## General Instructions

 Instructions for the Microsoft Excel Templates Detail and information on Excel is contained within the manual. Striking the “F1” key or following the path “Windows>Excel Help” will invoke the Office Assistant and bring up one of several help menus. Type your name into the cell “D5”. This will be copied by formula to the rest of the pages as required. Type the due date of your problem into cell “I5”. This will be copied by formula to the rest of the pages as required. Type the instructor’s name into cell “D6”. This will be copied by formula to the rest of the pages as required. Type the course identifier into cell “I6”. This will be copied by formula to the rest of the pages as required. The problem is identified for you in cell “B7”. In “DATE” cells enter the date in any of several formats and Excel will format it correctly. If more than one page is preformatted into the problem, page breaks are preset and formulas are set to copy the header into the remaining pages. Place the proper account title in the cell where the word “ACCOUNT” appears on the template. Place the amount in the cell where the word “AMOUNT” appears on the template. A formula may be placed in some of these cells. Enter a number like 914 to signify units or gallons where the word “NUMBER” appears. Write a formula into cells where the word “FORMULA” appears. In these cells, an amount calculated outside of Excel can be entered into Excel if desired. Place the explanation for the entry in the cell where the word “EXPLANATION” appears on the template. Insert the account number where “ACCT #” appears on the template during posting. Insert the journal reference where “JOURN #” appears on the template during posting. Insert the title in the cell where “TITLE” appears on the template. The print area is defined to fit onto 8 1/2″ X 11″ sheets in portrait or landscape mode as required. The gray filled cells define the perimeter of the problem and the print area. The problem is formatted for whole dollars with comma separations (no cents) except where required. The display may have “Freeze Pane” invoked so column titles remain visible during data entry. Negative values may be shown as (\$400) vice -\$400. Enter a string like: (\$259,417 X 12 months) + (0.3651 X 5,434,631) where the word TEXT appears.

## Chapter 13 Comp Do It Prob 1&2

, for John Kosinski Manufacturing Company contains the following condensed information.

(Partial)

JOHN KOSINSKI MANUFACTURING COMPANY
December 31,
2011

JOHN KOSINSKI MANUFACTURING COMPANY

For the Year Ended December 31, 2011

Amount

Title Amount
Title Amount
Title Amount

Title Amount

Title Formula

Title Amount
Title Amount
Title Formula

Title Amount

Formula

Amount

Formula

JOHN KOSINSKI MANUFACTURING COMPANY

For the Year Ended December 31, 2011
Cash flows from operating activities

customers

Amount

Title Amount
Title Amount Formula
Title Formula
Cash flows from investing activities
Title Amount
Title Amount
Title Formula
Cash flows from financing activities
Title Amount
Title Formula
Title Amount
Title Formula

Title Amount
Title Amount

Title Formula

Title Amount
Title Amount
Title Amount
Title Amount
Title Formula

Name:
Course:
Date:
Chapter 13 Comprehensive Do It! Problems 1 & 2
Financial Accounting, 7th Edition by Weygandt, Kieso, and Kimmel
Solving Financial Accounting Problems Using Microsoft Excel for Windows by Rex A Schildhouse
Chapter 13 Comprehensive Do It! Problems 1 & 2, The income statement for the year ended

December 31, 2011
JOHN KOSINSKI MANUFACTURING COMPANY
Income Statement
For the Year Ended December 31, 2011
Revenues \$6,583,000
Operating Expenses (excluding depreciation) \$4,9

20,000
Depreciation Expense 880,000 5,800,000
Income Before Income Taxes 783,000
Income Tax Expense 353,000
Net Income \$430,000
Included in operating expenses is a \$24,000 loss resulting from the sale of machinery for \$270,000 cash. Machinery was
purchased at a cost of \$750,000
The following balances are reported on Kosinski’s comparative balance sheets at December 31:
Comparative Balance Sheet (Partial)
2010
Cash \$672,000 \$130,000
Accounts Receivable 775,000 610,000
Inventories 834,000 867,000
Accounts Payable 521,000 501,000
Income tax expense of \$353,000 represents the amount paid in 2011. Dividends declared and paid in 2011 totaled \$200,000
Instructions:
1 – Prepare a statement of cash flows using the indirect method.
Statement of Cash Flows – Indirect Method
Cash flows from operating activities
Net income Amount
Adjustments to reconcile net income to cash provided by operating activities:
Title
Formula
Cash flows from investing activities
Cash flows from financing activities
Net increase in cash
Cash at beginning of period
Cash at end of period
2 – Prepare a statement of cash flows using the direct method.
Statement of Cash Flows – Direct Method
Cash receipts from
Cash payments
Direct Method Computations:
Computation of cash receipts from customers:
Computation of cash payments for operating expenses

&CFileName: &F, Tab: &A, Page &P of &N, &D, &T

## Exercise E13-4 (2)

Name:
Course:
Date:

Financial Accounting, 7th Edition by Weygandt, Kieso, and Kimmel
Solving Financial Accounting Problems Using Microsoft Excel for Windows by Rex A Schildhouse

Instructions:

For the Year Ended December 31, 2011
Cash flows from operating activities
Net income Amount

Amount

Account title Amount

15,000

Account title Amount

Account title Amount 15,000

Formula

 Exercise E13-4, Prepare the operating activities section—indirect method. Exercise E13-4, Villa Company reported net income of \$195,000 for 2011. Villa also reported depreciation expense of \$45,000 and a loss of \$5,000 on the sale of equipment. The comparative balance sheets show a decrease in accounts receivable of \$ 15,000 for the year, an \$17,000 increase in accounts payable, and a, \$4,000 decrease in prepaid expenses. Prepare the operating activities section of the statement of cash flows for 2011. Use the indirect method. VILLA COMPANY Partial Statement of Cash Flows Adjustments to reconcile net income to net cash provided by operating activities Account title Decrease in accounts receivable Net cash provided by operating activities

&CFileName: &F, Tab: &A, Page &P of &N, &D, &T

## Exercise E13-13

Name:
Course:
Date:

Financial Accounting, 7th Edition by Weygandt, Kieso, and Kimmel
Solving Financial Accounting Problems Using Microsoft Excel for Windows by Rex A Schildhouse

\$12,000

Net income

Instructions:

Cash flows from operating activities

Cash receipts from

Title Amount
Title Amount

Formula

Cash payments
Title Amount
Title Amount
Title Amount
Title Amount

Title Amount Formula
Net cash provided by operating activities Formula
 Exercise E13-13, Compute cash flow from operating activities—direct method. Exercise E13-13, The 2011 accounting records of Verlander Transportation reveal the following transactions and events: Payment of interest \$10,000 Collection of accounts receivable \$182,000 Cash sales \$48,000 Payment of salaries and wages \$53,000 Receipt of Dividends Revenues \$18,000 Depreciation expense \$16,000 Payment of income taxes \$12,000 Proceeds from sale of vehicles \$38,000 Purchase of equipment for cash \$22,000 Payment of accounts payable for merchandise \$115,000 Loss on sale of vehicles \$3,000 Payment of dividends \$14,000 Payment for land \$74,000 Payment of operating expenses \$28,000 Prepare the cash flows from operating activities section using the direct method. (Not all of the above items will be used.)

&CFileName: &F, Tab: &A, Page &P of &N, &D, &T

## Problem P13-3B

Name:
Course:
Date:

Financial Accounting, 7th Edition by Weygandt, Kieso, and Kimmel
Solving Financial Accounting Problems Using Microsoft Excel for Windows by Rex A Schildhouse

Income Statement

For the Year Ended December 31, 2011

Depreciation expense

20,000

Net income

during the year.

during the year.

Instructions:

ROSENTHAL COMPANY
Partial Statement of Cash Flows
For the Year Ended December 31, 2011
Cash flows from operating activities
Net income Amount
Adjustments to reconcile net income to net cash provided by operating activities
Title Amount
Title Amount
Title Amount
Title Amount
Title Amount
Title Amount
Title Amount Formula
Net cash provided by operating activities Formula

 Problem P13-3B, Prepare the operating activities section—indirect method. Problem P13-3B, The income statement of Rosenthal Company is presented here: ROSENTHAL COMPANY Sales \$5,400,000 Cost of Goods Sold Beginning inventory \$1,780,000 Purchases 3,430,000 Goods available for sale 5,210,000 Ending inventory 1,900,000 Cost of goods sold 3,310,000 Gross profit \$2,090,000 Operating expenses 105,000 Amortization expense Other expenses 945,000 1,070,000 \$1,020,000 Additional information: 1. Accounts receivable decreased by \$320,000 during the year, and inventory increased \$120,000 2. Prepaid expenses increased \$175,000 during the year. 3. Accounts payable to merchandise suppliers increased \$50,000 4. Accrued expenses payable increased \$155,000 Prepare the operating activities section of the statement of cash flows for the year ended December 31, 2011, for Rosenthal Company, using the indirect method.

&CFileName: &F, Tab: &A, Page &P of &N, &D, &T