Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please Complete Assignment 1-6. Accounting Cycle Project (Group) ACCT3303 Spring 2020 Assignments Required: 1) Making journal entries for each transaction in chronological order. 2) Posting
Please Complete Assignment 1-6.
Accounting Cycle Project (Group) ACCT3303 Spring 2020 Assignments Required: 1) Making journal entries for each transaction in chronological order. 2) Posting to the general ledger and prepare trial balance before adjustment 3) Making adjusting entries and prepare adjusted trial balance. 4) Prepare Income Statement, Retained Earnings Statement, and Balance Sheet 5) Making closing entries. 6) Put all your work on excel spreadsheet. Each group should submit one completed copy to Assignment tab. The 2019 Balance Sheet of the Victoria Co. is as follows: Victoria Co. Balance Sheet As of December 31, 2019 Cash Notes Receivable Accounts Receivable Less: Allowance for Doubtful A/Cs Inventories Office Supplies Prepaid Insurance Prepaid Rent Total Current Assets Long-term Investments Investments in securities Land for future development Property, Plant and Equipment Land Buildings Less: Accu. Depreciation Intangible Assets Capitalized Development Costs Goodwill Other Intangible Assets Total Non-Current Assets Total Assets 85,000 Notes Payable 34,590 Accounts Payable 35,000 Unearned Revenue (2,930) Property Tax Payable 65,000 Interest Payable O Income Tax Payable 540 Salary and Wages Payable 4,800 Utilities Payable 222,000 Total Current Liabilities Provisions Related to Pensions 180,000 Bonds Payable 60,000 Total Non-Current Liab. Total Liabilities 145,000 Common Stock 800,000 Paid-in-capital - Common Stock (240,000) Preferred Stock Paid-in-capital - Preferred Stock 15,000 Retained Earnings 120.000 Accu. Other Comp. Income 48,000 Less: Treasury Stock 1,128,000 Total Shareholders' Equity 1,350,000 Total Liab. and Total Equity 150,000 125,000 1,000 0 3.500 13,000 6,500 12,000 311,000 93 100 300,000 393,100 704,100 240,000 96.000 97,000 7,400 210,500 5.000 (10,000) 645.900 1,350,000 During 2020, the following events occurred in the company. Additional information available at the end of 2020 is as follows: 1) On January 8, received checks, $20,000 from Kent and $15,000 from Montana, for sales on account made in December 2019 after discount period has lapsed. 2) On January 15, paid cash $125,000 to Hermann for merchandise purchased last year after discount period has lapsed. 3) On January 18, received checks, $34,590 for outstanding note receivable and associated interest of $410 4) On January 25, paid off the utilities bill of $12,000 and income tax of 13,000, and wages payable of 6,500 5) On January 26, purchased merchandise on account from Charles $90,000 and Georgia 120,000. Terms 3/10, 1/30, F.O.B. destination. 6) On February 4, send checks to Charles for 90,000 less 2% cash discount, and to Georgia for $120,000 less 3% cash discount. 7) On February 13, sold merchandise on account to Franklin $110,000 and Thompson $150,000. Terms 2/10, n/30, F.O.B. shipping point. 8) On February 15, issued credit of $6,000 to Franklin for the merchandise returned. 9) On February 20, received payment in full from Franklin and Thompson before discount period has lapsed. 10) On February 28, the prepaid rent balance was expired. 11) On March 1, paid off notes payable $150,000 (issued in 2019) and associated interest of $7,500 (including $3,500 interest payable on the balance sheet). 12) On March 1, paid rent of $30,000 for one-year term starting from March 1, 2020 13) On April 15, paid $8,000 cash for office supplies. The company expenses all of the supplies purchased during the year. 14) On June 5, declared cash dividends totaling $30,000 15) On June 30, paid cash dividends totaling $30,000 to stockholders. 16) On July 1, issued a note of $250,000 to bank (one year, annual interest rate 5%) for cash. 17) On July 15, the company CEO paid $80,000 from her savings bank account to purchase a car for personal use. 18) On August 1, issued common stock 3,000 shares, $10 par, in exchange of a land with a fair market value of $80,000. 19) On September 8, paid utilities expense, $12,000 20) On October 7. sold merchandise to Utah on account $220,000, term 1/10 n/30, FOB shipping point. 21) On October 16, Utah paid off its balance 22) On November 9, purchased merchandise from Pensacola $60,000 terms 3/10, 1/30 23) On November 12, returned $3,000 of merchandise to Pensacola and received credit 24) On November 18, paid off the balance to Pensacola. 25) On December 27, 2020, the company paid the 2020 federal income tax of $12,500 and 2020 property tax of $6,600 26) On December 28, sold merchandise to Kent on account $90,000, term 1/10, n/30, FOB shipping point. 27) On December 29, purchased merchandise from Hermann $160,000, terms 3/10,n/30. 2a) Over the year, daily cash sales were $1,000 on average per day. 29) Over the year, sales and office employees earned $120,000 in salaries and wages, of which $15,000 remained as payable at the end of year. 30) Depreciation expense for the year was $80,000 31) The utilities bill of $18,000 as of December 31, 2020 is due in January 2021. 32) The balance of uneamed revenues was increased by $12,000 during 2020 33) Based on its historical data, the bad debts are about 2% of net credit sales (credit sales minus sales discounts and sales returns in the year of 2020) Additional information available at the end of 2020 is as follows: 1) No insurance policy was effective during the year. 2) After physical counting, the company decided that the ending inventory was $60,000. 3) Charles, Georgia, Pensacola, Franklin, Thompson, and Utah had zero balance on account as of Jan 1, 2020 4) The company uses the gross method to record its purchases and sales on credit 5) The company adopts the periodic inventory system. In order to report the purchase activities the firm used the purchases, purchases discounts, and purchase returns & allowances accounts. Accounting Cycle Project (Group) ACCT3303 Spring 2020 Assignments Required: 1) Making journal entries for each transaction in chronological order. 2) Posting to the general ledger and prepare trial balance before adjustment 3) Making adjusting entries and prepare adjusted trial balance. 4) Prepare Income Statement, Retained Earnings Statement, and Balance Sheet 5) Making closing entries. 6) Put all your work on excel spreadsheet. Each group should submit one completed copy to Assignment tab. The 2019 Balance Sheet of the Victoria Co. is as follows: Victoria Co. Balance Sheet As of December 31, 2019 Cash Notes Receivable Accounts Receivable Less: Allowance for Doubtful A/Cs Inventories Office Supplies Prepaid Insurance Prepaid Rent Total Current Assets Long-term Investments Investments in securities Land for future development Property, Plant and Equipment Land Buildings Less: Accu. Depreciation Intangible Assets Capitalized Development Costs Goodwill Other Intangible Assets Total Non-Current Assets Total Assets 85,000 Notes Payable 34,590 Accounts Payable 35,000 Unearned Revenue (2,930) Property Tax Payable 65,000 Interest Payable O Income Tax Payable 540 Salary and Wages Payable 4,800 Utilities Payable 222,000 Total Current Liabilities Provisions Related to Pensions 180,000 Bonds Payable 60,000 Total Non-Current Liab. Total Liabilities 145,000 Common Stock 800,000 Paid-in-capital - Common Stock (240,000) Preferred Stock Paid-in-capital - Preferred Stock 15,000 Retained Earnings 120.000 Accu. Other Comp. Income 48,000 Less: Treasury Stock 1,128,000 Total Shareholders' Equity 1,350,000 Total Liab. and Total Equity 150,000 125,000 1,000 0 3.500 13,000 6,500 12,000 311,000 93 100 300,000 393,100 704,100 240,000 96.000 97,000 7,400 210,500 5.000 (10,000) 645.900 1,350,000 During 2020, the following events occurred in the company. Additional information available at the end of 2020 is as follows: 1) On January 8, received checks, $20,000 from Kent and $15,000 from Montana, for sales on account made in December 2019 after discount period has lapsed. 2) On January 15, paid cash $125,000 to Hermann for merchandise purchased last year after discount period has lapsed. 3) On January 18, received checks, $34,590 for outstanding note receivable and associated interest of $410 4) On January 25, paid off the utilities bill of $12,000 and income tax of 13,000, and wages payable of 6,500 5) On January 26, purchased merchandise on account from Charles $90,000 and Georgia 120,000. Terms 3/10, 1/30, F.O.B. destination. 6) On February 4, send checks to Charles for 90,000 less 2% cash discount, and to Georgia for $120,000 less 3% cash discount. 7) On February 13, sold merchandise on account to Franklin $110,000 and Thompson $150,000. Terms 2/10, n/30, F.O.B. shipping point. 8) On February 15, issued credit of $6,000 to Franklin for the merchandise returned. 9) On February 20, received payment in full from Franklin and Thompson before discount period has lapsed. 10) On February 28, the prepaid rent balance was expired. 11) On March 1, paid off notes payable $150,000 (issued in 2019) and associated interest of $7,500 (including $3,500 interest payable on the balance sheet). 12) On March 1, paid rent of $30,000 for one-year term starting from March 1, 2020 13) On April 15, paid $8,000 cash for office supplies. The company expenses all of the supplies purchased during the year. 14) On June 5, declared cash dividends totaling $30,000 15) On June 30, paid cash dividends totaling $30,000 to stockholders. 16) On July 1, issued a note of $250,000 to bank (one year, annual interest rate 5%) for cash. 17) On July 15, the company CEO paid $80,000 from her savings bank account to purchase a car for personal use. 18) On August 1, issued common stock 3,000 shares, $10 par, in exchange of a land with a fair market value of $80,000. 19) On September 8, paid utilities expense, $12,000 20) On October 7. sold merchandise to Utah on account $220,000, term 1/10 n/30, FOB shipping point. 21) On October 16, Utah paid off its balance 22) On November 9, purchased merchandise from Pensacola $60,000 terms 3/10, 1/30 23) On November 12, returned $3,000 of merchandise to Pensacola and received credit 24) On November 18, paid off the balance to Pensacola. 25) On December 27, 2020, the company paid the 2020 federal income tax of $12,500 and 2020 property tax of $6,600 26) On December 28, sold merchandise to Kent on account $90,000, term 1/10, n/30, FOB shipping point. 27) On December 29, purchased merchandise from Hermann $160,000, terms 3/10,n/30. 2a) Over the year, daily cash sales were $1,000 on average per day. 29) Over the year, sales and office employees earned $120,000 in salaries and wages, of which $15,000 remained as payable at the end of year. 30) Depreciation expense for the year was $80,000 31) The utilities bill of $18,000 as of December 31, 2020 is due in January 2021. 32) The balance of uneamed revenues was increased by $12,000 during 2020 33) Based on its historical data, the bad debts are about 2% of net credit sales (credit sales minus sales discounts and sales returns in the year of 2020) Additional information available at the end of 2020 is as follows: 1) No insurance policy was effective during the year. 2) After physical counting, the company decided that the ending inventory was $60,000. 3) Charles, Georgia, Pensacola, Franklin, Thompson, and Utah had zero balance on account as of Jan 1, 2020 4) The company uses the gross method to record its purchases and sales on credit 5) The company adopts the periodic inventory system. In order to report the purchase activities the firm used the purchases, purchases discounts, and purchase returns & allowances accountsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started