Accounting

The following balance sheet is presented for XYZ Co. as of December 31, 2019.

XYZ Co. Balance Sheet - 12/31/19

Assets

Liabilities

Cash

$245,000

Accounts Payable

220,000

Accounts Rec.

188,000

Wages Payable

73,000

Inventory

200,000

Total Current Liabilities

293,000

Prepaid Insurance

74,000

Supplies

40,000

Mortgage Payable

800,000

Total Current Assets

747,000

Total Liabilities

1,093,000

Long Term Investments

160,000

Equity

Mach. & Equipment

1,430,000

Common Stock

500,000

Accumulated Depreciation

(429,000)

Retained Earnings

315,000

Total Equity

815,000

Total Assets

1,908,000

Total Liabs. and Stockholders Equity

1,908,000

During 2020, XYZ entered into the following transactions.

1. Made credit sales of $1,350,000 and cash sales of $350,000. The cost of the inventory sold was $700,000.

2. Purchased $820,000 of inventory on account.

3. Made cash payments of $400,000 to employees for salaries. This amount includes the wages due employees as of December 31, 2019.

4. Purchased $110,000 of supplies by issuing a six month note that matures on March 1, 2021.

5. Collected $850,000 from customers in payment of open accounts receivable.

6. Paid suppliers $870,000 for payment of open accounts payable.

7. Sold a long term investment for $37,000. The investment had been purchased for $30,000.

8. Paid $60,000 cash for the current years advertising, $36,000 cash for rent, and $52,000 for maintenance.

9. Issued additional common stock for $120,000 cash.

10. The company declared and paid a $50,000 cash dividend.

11. The company purchased Microsoft stock as a long term investment for $50,000.

The following information is also available.

(a) 40 percent of the prepaid insurance on January 1 was still in effect as of December 31, 2020.

(b) A physical count of the supplies inventory indicated that the company had $40,000 on hand as of December 31, 2020.

(c) A review of the companys advertising campaign indicates that of the expenditures made during 2020 for advertising, $25,000 applies to promotions to be undertaken during 2021.

(d) The company is charged at a rate of $3,500 per month for its rental contracts. Note that $36,000 rent was paid in cash during the year.

(e) The company owes employees $43,000 for wages as of December 31, 2020.

(f) Machinery & equipment has an estimated useful life of ten years with no salvage value. The company uses the straight-line method to depreciate and amortize all property, plant, and equipment,

(g) The note issued by the company (see 4 above) pays interest at a rate of 15 percent and was issued on September 1, 2020.

(h) The interest rate on the mortgage payable is 12 percent. Interest is payable each January 1, beginning January 1, 2021. The mortgage was issued on December 31, 2019.

Instructions:

Prepare an income statement for 2020 and a balance sheet as of December 31, 2020. You should submit an Excel spreadsheet that contains a financial statement effects template, a balance sheet, and an income statement