Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need Entries only. Journal and adjusted entries both Download the Excel spreadsheet for Computer Depot in the module folder. The spreadsheet includes the following

image text in transcribed

image text in transcribed

I need Entries only. Journal and adjusted entries both

Download the Excel spreadsheet for Computer Depot in the module folder. The spreadsheet includes the following tabs Common stock is issued in exchange for cash in the amount of 8 January 1st 50,000 February SthThe company purchases and pays for 300 units of computer replacement parts at a price of $25 per unit 7,500 10,752 10,512 10 March 1st 11 March 31st 12 April 1st 13 April 10th 14 May 15th 15 May 30th 16 June 1st 17 June 30th 18 19 July 25th 20 The company pays cash for a one-year insurance policy in the amount of Rent on a retail space for 12 months is paid in the amount of Diagnostic tools and testing equipment with a useful life of 2 years is purchased for cash in the amount of. 23,460 PC tuning supplies purchased on account in the amount of The company purchases and pays for another 300 units of computer replacement parts at a price of $38 per 11,400 PC repair services are performed on account in the amount of The company pays for advertisements to be run for the next 12 months in the amount of The company issues a 5-year notes payable with their bank for $100,000 and interest at an annual rate of 8% Interest is due on June 30th each year and the principal will be paid in full at the end of the 5 year period. 1,00,000 Software installation & upgrade services are performed on account in the amount of 120 units of computer replacement parts are sold for $75 per unit with terms 2/10, n/30. The sale is recorded using the gross method in the amount of (see note c for cost flow assumptions) Hardware replacement services are provided on account in the amount of The company receives full payment from the customer for the July 31st sale 4,250 10,538 1,540 10,759 July 31st 21 22 August 2nd 23 August 6th 24 September 15th 25 September 29th 26 October 13th 27 9,000 9,820 8,820 6,295 1,520 Virus removal services are performed on account in the amount of Customer payments are received for services previously provided in the amount of 136 units of computer replacement parts are sold for $75 per unit with terms 2/10, n/30. The sale is recorded using the gross method in the amount of The company receives payment for half of the October 13th sale 10,200 October 29th 28 5,100 29 November 1st Equipment originally purchased on April 1st for $3,000 is sold for $1,500 cash November 15th A bookkeeper is hired to help the company with daily accounting taxes and annual tax preparation The bookkeeper is paid $4,500 for the previous month's services 31 December 15th 32 4,500 Additional information: 34 a. PC tuning supplies on hand at the end of the month are as follows: 2,550 urnal | General Ledger | Trial Balance | IS | SE BS CF | Ratios | REDMI NOTE 5 PRO MI DUAL CAMERA or choose Paste ste Merge & Center Clipboard Font Alignment Num f Option 1 2 the gross method in the amount of (see note c for cost flow assumptions).... 9,000 9,820 8,820 6,295 1,520 August 2nd August 6th September 15th September 29th October 13th Hardware replacement services are provided on account in the amount of The company receives full payment from the customer for the July 31st sale Virus removal services are performed on account in the amount of Custom er payments are received for services previously provided in the amount of 136 units of computer replacement parts are sold for $75 per unit with terms 2/10, n/30. The sale is recorded using the gross method in the amount of The company receives payment for half of the October 13th sale Equipment originally purchased on April 1st for $3,000 is sold for $1,500 cash A bookkeeper is hired to help the company with daily accounting taxes and annual tax preparation The bookkeeper is paid $4,500 for the previous month's services 10,200-13 ctober 29th lovember 5,100 1st ecember 15th 4,500 Additional information: a. PC tuning supplies on hand at the end of the month are as follows: b. The year-end balance reported at the end of the year for the Allowance for Doubtful Accounts 2,550 is estimated as 2.5% of outstanding receivables at the end of the year c. The Company uses a perpetual inventory system and accounts for costs using the Last-In-First-Out cost flow assumption. On December 31st, a count of ending inventory reveals that there are 344 units of computer replacement parts on hand. d. All revenue is recorded in the "Sales Revenue" account and reported net of cash discounts on the income statemer e. The effective interest method is used to amortize bond premiums and discounts f. Adjustments are made at the end of the year for prepaid insurance, rent, advertising, depreciation, and interest expense. g. The bookkeeper is paid a salary of $4,500 on the 15th of every month. h. The company declared dividends of $700 for the year OME NOTE 5 PROs include advertising and supplies expense. All other expenses, other than depreciation MI DUALS CAMERA considered general & administrative. OURED: PART A Download the Excel spreadsheet for Computer Depot in the module folder. The spreadsheet includes the following tabs Common stock is issued in exchange for cash in the amount of 8 January 1st 50,000 February SthThe company purchases and pays for 300 units of computer replacement parts at a price of $25 per unit 7,500 10,752 10,512 10 March 1st 11 March 31st 12 April 1st 13 April 10th 14 May 15th 15 May 30th 16 June 1st 17 June 30th 18 19 July 25th 20 The company pays cash for a one-year insurance policy in the amount of Rent on a retail space for 12 months is paid in the amount of Diagnostic tools and testing equipment with a useful life of 2 years is purchased for cash in the amount of. 23,460 PC tuning supplies purchased on account in the amount of The company purchases and pays for another 300 units of computer replacement parts at a price of $38 per 11,400 PC repair services are performed on account in the amount of The company pays for advertisements to be run for the next 12 months in the amount of The company issues a 5-year notes payable with their bank for $100,000 and interest at an annual rate of 8% Interest is due on June 30th each year and the principal will be paid in full at the end of the 5 year period. 1,00,000 Software installation & upgrade services are performed on account in the amount of 120 units of computer replacement parts are sold for $75 per unit with terms 2/10, n/30. The sale is recorded using the gross method in the amount of (see note c for cost flow assumptions) Hardware replacement services are provided on account in the amount of The company receives full payment from the customer for the July 31st sale 4,250 10,538 1,540 10,759 July 31st 21 22 August 2nd 23 August 6th 24 September 15th 25 September 29th 26 October 13th 27 9,000 9,820 8,820 6,295 1,520 Virus removal services are performed on account in the amount of Customer payments are received for services previously provided in the amount of 136 units of computer replacement parts are sold for $75 per unit with terms 2/10, n/30. The sale is recorded using the gross method in the amount of The company receives payment for half of the October 13th sale 10,200 October 29th 28 5,100 29 November 1st Equipment originally purchased on April 1st for $3,000 is sold for $1,500 cash November 15th A bookkeeper is hired to help the company with daily accounting taxes and annual tax preparation The bookkeeper is paid $4,500 for the previous month's services 31 December 15th 32 4,500 Additional information: 34 a. PC tuning supplies on hand at the end of the month are as follows: 2,550 urnal | General Ledger | Trial Balance | IS | SE BS CF | Ratios | REDMI NOTE 5 PRO MI DUAL CAMERA or choose Paste ste Merge & Center Clipboard Font Alignment Num f Option 1 2 the gross method in the amount of (see note c for cost flow assumptions).... 9,000 9,820 8,820 6,295 1,520 August 2nd August 6th September 15th September 29th October 13th Hardware replacement services are provided on account in the amount of The company receives full payment from the customer for the July 31st sale Virus removal services are performed on account in the amount of Custom er payments are received for services previously provided in the amount of 136 units of computer replacement parts are sold for $75 per unit with terms 2/10, n/30. The sale is recorded using the gross method in the amount of The company receives payment for half of the October 13th sale Equipment originally purchased on April 1st for $3,000 is sold for $1,500 cash A bookkeeper is hired to help the company with daily accounting taxes and annual tax preparation The bookkeeper is paid $4,500 for the previous month's services 10,200-13 ctober 29th lovember 5,100 1st ecember 15th 4,500 Additional information: a. PC tuning supplies on hand at the end of the month are as follows: b. The year-end balance reported at the end of the year for the Allowance for Doubtful Accounts 2,550 is estimated as 2.5% of outstanding receivables at the end of the year c. The Company uses a perpetual inventory system and accounts for costs using the Last-In-First-Out cost flow assumption. On December 31st, a count of ending inventory reveals that there are 344 units of computer replacement parts on hand. d. All revenue is recorded in the "Sales Revenue" account and reported net of cash discounts on the income statemer e. The effective interest method is used to amortize bond premiums and discounts f. Adjustments are made at the end of the year for prepaid insurance, rent, advertising, depreciation, and interest expense. g. The bookkeeper is paid a salary of $4,500 on the 15th of every month. h. The company declared dividends of $700 for the year OME NOTE 5 PROs include advertising and supplies expense. All other expenses, other than depreciation MI DUALS CAMERA considered general & administrative. OURED: PART A

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions