Assignments Required:

1) Making journal entries for each transaction in chronological order.

2) Prepare adjusting entries and adjusted trial balance.

3) Prepare Income Statement, Retained Earnings Statement, and Balance Sheet.

4) Making closing entries.

5) Put all your work on excel spreadsheet.

Accounting Cycle Project (Group) ACCT3303 Fall 2016 Due Date: 10/2 (Sun) Assignments Required: 1) 2) 3) 4) 5) Making journal entries for each transaction in chronological order. Prepare adjusting entries and adjusted trial balance. Prepare Income Statement, Retained Earnings Statement, and Balance Sheet. Making closing entries. Put all your work on excel spreadsheet. Each group should submit one completed copy to Assignment tab. The 2015 Balance Sheet of the Katy Co. is as follows: Katy Co. Balance Sheet As of December 31, 2015 Current Assets Cash Notes Receivable Accounts Receivable Less: Allowance for Doubtful Accounts Inventories Prepaid Insurance Prepaid Rent Total Current Assets Non-Current Assets Long-term Investments Investments in held-for-maturity securities Land held for future development Property, Plant, and Equipment Land Buildings Less: Accumulated Depreciation Intangible Assets Capitalized Development Costs Goodwill Other Identifiable Intangible Assets Total Non-Current Assets Total Assets 53,160 16,000 41,800 (3,000) 40,000 540 500 149,000 51,000 45,500 85,000 675,000 (187,500) 8,000 76,000 48,000 801,000 950,000 1 Current Liabilities Notes Payable Accounts Payable Unearned Revenue Property Tax Payable Interest Payable Income Tax Payable Salary and Wages Payable Utilities Payable Total Current Liabilities Non-Current Liabilities Provisions Related to Pensions Bonds Payable Total Non-Current Liabilities Total Liabilities Stockholders' Equity Common Stock Preferred Stock Paid-in-capital - Common Stock Paid-in-capital - Preferred Stock Retained Earnings Accumulated Other Comprehensive Income Less: Treasury Stock Total Stockholders' Equity Total Liabilities and Stockholders' Equity 110,000 33,500 12,000 6,600 1,500 9,440 0 0 173,040 93,100 300,000 393,100 566,140 100,000 100,000 27,500 10,000 154,110 5,000 (12,750) 383,860 950,000 During 2016, the following events occurred in Katy Co.: 1) On January 10, sold merchandise on account to Abby $12,000 and Bob $9,000. Terms 2/10, n/30, F.O.B. shipping point. 2) On January 12, purchased merchandise on account from Charles $4,000 and David 3,500. Terms 1/10, n/30, F.O.B. destination. 3) On January 14, received checks, $4,500 from Esther and $2,500 from Fred, for sales on account after discount period has lapsed. 4) On January 15, send checks to James for 12,000 less 3% cash discount, and to Kimberly for $8,000 less 2% cash discount. 5) On January 16, issued credit of $500 to Bob for merchandise returned. 6) On January 21, paid off the balances to Charles and David for the purchases on January 12. 7) On February 9, received payment in full from Abby and Bob. 8) On March 1, paid rent of $4,800 for a two-year term starting from May 1, 2013. 9) On April 1, the company CEO paid $60,000 from her savings bank account to purchase a car for personal use. 2 10) On April 12, paid $1,200 cash for office supplies. 11) Cash dividends totaling $5,000 were declared on June 13 and paid to stockholders on June 23. 12) Issued a note of $120,000 to bank (one year, annual interest rate 4%) for cash on July 1. 13) On July 5, purchased merchandise from Kimberly $45,000, terms 3/10, n/30. 14) On July 7, issued common stock 1,000 shares, $10 par, in exchange of a land with a fair market value of $60,000. 15) On July 8, returned $500 of merchandise to Kimberly and received credit. 16) On August 1, sold merchandise to Linda on account $120,000, term 1/10, n/30, FOB shipping point. 17) Paid off the balance to Kimberly on August 4. 18) On August 8, paid utilities expense, $12,000. 19) On August 18, Linda paid off its balance. 20) On September 1, paid cash $7,500 to Mary for merchandise purchased last year. 21) On October 1, paid off notes payable $110,000 (issued in 2015) and associated interest $5,500 (including $1,500 interest payable on the balance sheet). 22) Over the year, daily cash sales were $16,000. 23) Over the year, sales and office employees earned $60,000 in salaries and wages, of which $2,500 remained as payable at the end of year. 24) On Dec 31, received a utilities bill of $2,000 (for December 2016) and paid off the bill on January 10, 2016. Additional Information at the end of 2016: 1) Depreciation expense for the year was $14,500. 2) The company estimated that it will pay federal income tax, $6,500. 3) After physically counting, the company decided that the ending inventory was $61,000. 4) Based on its historical data, the bad debts are about 1% of net credit sales. 5) Unearned revenue was decreased by $14,000. 6) The company expenses all of the supplies purchased during the year. 7) No insurance policy was effective during the year. 8) The company uses the gross method to record its purchases and sales on credit. 9) The company adopts the periodic inventory system. 10) Abby, Bob, and Linda had zero balance on account as of Jan 1, 2012. Check Figures Please use the following check figures for the project one: 1) 2) 3) 4) 5) Adjusted Trial Balance: Total $1,289,061 Earnings before income tax: 7,162 Retained Earnings: $154,162 Total assets: $947,452 Total liabilities: 547,540 3