Reference no: EM131012985

Question

XYZ, Inc. - Review of the Basics

Three financial statements: the balance sheet, income statement, and statement of retained earnings for XYZ, Inc., an accounting and consulting firm, are included below.

                                         XYZ, Inc,

                                     Balance Sheet

                              As of December 31, 2015

Assets: Cash	$ 12,000	Liabilities & Shareholders' Equity: Accounting Payable	$ 2.000
Accounts receivable	22,000	Salaries payable	6.000
Supplies	7,000	Uthies payable	1,000
Land	18,000	Notes payable	25.000
Equipment (net)	30,000	Common stock	42,000
		Retained earnings	13,000
Total assets	$89,000	Total liabities & Shareholders' equity	$ 89,000

XYZ, Inc.
Income Statement
For Period ended December 31.2015 

Consulting   revenue	$                      150,000
Salaries expense Markedly expense	(90,C00) (24,000) (22000)
Administrative expense Net income
	14.000

XYZ. Inc.

Statement o f Retained earnings

For Period ended December 31.2015

Begining balance	$
Add: Net Income Less: Dividends	14,000 (24,000) (22000)
Ending balance
	13,0000

During January 2016, XYZ engaged in the following transactions:

1) Paid in full with cash the December 31 balance of accounts payable

2) Furnished professional services and billed $25,000. It collected $13,000 of the December 31 balance of accounts receivables and none of the January billings.

3) Paid all marketing expenses with cash as they arose, $4,500.

4) Incurred supplies expenses of $5,100. The unused supplies (i.e. Supplies inventory) balance on January 31 was $4,000. All of the January inventory purchases were on credit.

5) Paid the bank $5,000 to reduce the principal of the long-term note payable ($5,000 payment due each January), and additionally paid one month's interest in cash at a 12% per year rate on the month's beginning balance. You need to record a principal reduction of $5,000 as well as the appropriate amount of cash paid for interest as a separate item or amount from the $5,000 principal reduction.

6) Sold the land for $25,000

7) Paid utilities payable outstanding as of December 31, 2015. The $1,200 bill for January's utility consumption will be paid in February.

8) On January 31, purchased computer equipment for $1,000 cash and a $5,000 installment note payable at 10% interest due in six months (i.e. no cash was exchanged for the note). Use an "equipment" account for this transaction.

9) Declared (obligated itself to pay) a dividend of $3,000. It will be paid in February.

10) Additional information: Equipment originally cost $40,000 has an estimated salvage value of $4,000 and is being depreciated straight-line over six years. Please record the adjustment for accumulated depreciation in the "Equipment (net)" account.

11) Paid salaries payable outstanding as of December 31, 2015. Incurred and paid with cash salaries expense of $7,500 in January (none outstanding at the end of January).

Required:

Using the financial effects template and beginning with the 12/31/2015 balances in the balance sheet accounts, analyze these transactions in a worksheet. At the end, you should have balances for the 1/31/2016 balance sheet and income statement. Set up a separate column for each balance sheet and income statement account affected.

Prepare the income statement, statement of retained earnings, and statement of cash flows for the month of January. Classify each cash flow as (1) operating, (2) investing, or (3) financing.

Prepare a "Classified" balance sheet as of January 31, 2016. As appropriate, a "Classified" balance sheet separates assets into (1) Current assets, (2) Investments, (3) Property, Plant, & Equipment, (4) Intangible assets, and (5) Other assets, and separates liabilities into (1) Current liabilities and (2) Long-term liabilities.

Note: work should be done in excel

Additional information -

The problem relates to Accounting and it discuss about preparation and analysis of financial statements of a company.