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.