Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a mult-step question I have attached a document with the question and sample layouts of what they are looking for: Music-Is-Us, Inc., is

image text in transcribed

This is a mult-step question I have attached a document with the question and sample layouts of what they are looking for:

Music-Is-Us, Inc., is a supplier of musical instruments for professional and amateur musicians. The company?s accountants make adjusting entries monthly, and they make all closing entries annually. The company is growing rapidly and prides itself on having no long-term liabilities.

The company has provided the following trial balance dated December 31, 2015:

MUSIC-IS-US, INC.

TRIAL BALANCE

DECEMBER 31, 2015

Cash

$

45,000

Marketable securities

25,000

Accounts receivable

125,000

Allowance for doubtful accounts

$

5,000

Merchandise inventory

250,000

Office supplies

1,200

Prepaid insurance

6,600

Building and fixtures

1,791,000

Accumulated depreciation

800,000

Land

64,800

Accounts payable

70,000

Unearned customer deposits

8,000

Income taxes payable

75,000

Capital stock

1,000,000

Retained earnings

240,200

Unrealized holding gain on investments

6,000

Sales

1,600,000

Cost of goods sold

958,000

Bank service charges

200

Uncollectible accounts expense

9,000

Salary and wages expense

395,000

Office supplies expense

400

Insurance expense

6,400

Utilities expense

3,600

Depreciation expense

48,000

Income tax expense

75,000

$

3,804,200

$

3,804,200

Other information pertaining to the company?s trial balance is shown below:

1.

The most recent bank statement reports a balance of $46,975. Included with the bank statement was a $2,500 check from Iggy Smarts, a professional musician, charged back to Music-Is-Us as NSF. The bank?s monthly service charge was $25. Three checks written by Music-Is-Us to suppliers of merchandise inventory had not yet cleared the bank for payment as of the statement date. These checks included: no. 508, $5,500; no. 511, $7,500; and no. 521, $8,000. Deposits of $16,500 reached the bank too late for inclusion in the current bank statement. The company prepares a bank reconciliation at the end of each month.

2.

Music-Is-Us has a portfolio of marketable securities that originally cost $19,000. As of December 31, the market value of these securities was $27,500. All short-term investments are classified as ?available for sale.?

3.

During December, $6,400 of accounts receivable were written off as uncollectible. A recent aging of the company?s accounts receivable led management to conclude that an allowance for doubtful accounts of $8,500 is needed at December 31, 2015.

4.

The company uses a perpetual inventory system. A year-end physical count revealed that several guitars reported in the inventory records were missing. The cost of the missing units amounted to $1,350. This amount is not considered significant relative to the total cost of inventory on hand.

5.

At December 31, approximately $900 in office supplies remained on hand.

6.

The company pays for its insurance policies 12 months in advance. Its most recent payment was made on November 1, 2015. The cost of this policy was slightly higher than the cost of coverage for the previous 12 months.

7.

Depreciation expense related to the company?s building and fixtures is $5,000 for the month ending December 31, 2015.

8.

Although Music-Is-Us carries an extensive inventory, it is not uncommon for experienced musicians to order custom guitars made to their exact specifications. Manufacturers do not allow any sales returns of custom-made guitars. The entire sales amount is collected at the time a custom order is placed, and is credited to an account entitled ?Unearned Customer Deposits.? As of December 31, $4,800 of these deposits remained unfilled because the special-order guitars have not been received from the manufacturer. The cost of goods sold and the reduction in inventory associated with all custom orders is recorded when the custom merchandise is delivered to customers. At that time, the adjusting entry requires only a decrease to unearned customer deposits and an increase in sales.

9.

Accrued income taxes payable for the entire year ending December 31, 2015, total $81,000. No income tax payments are due until early in 2016.

Prepare a bank reconciliation and make the journal entries to update the accounting records of Music-Is-Us as of December 31, 2015.

b-i

Prepare the necessary adjusting entries at December 31, 2015. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)

1.?Record the bank service charges for December and the NSF check received from Iggy Bates.

2.?Record to increase reported value of marketable securities.

3.?Record the uncollectible accounts expense for December.

4.?Record the inventory shrinkage of missing guitars.

5.?Record the office supplies used in December.

6.?Record the insurance policies expired during December.

7.?Record the depreciation expense for December.

8.?Record the revenue earned from advance special orders.

9.?Record the account for accrued income taxes in December.

j.

On the basis of the adjustments made to the accounting records in parts a through i above, prepare the company's adjusted trial balance at December 31, 2015. Attached is the correct Table

k-1.

Using the adjusted trial balance prepared in part j above, prepare an annual income statement dated December 31, 2015.

k-2.

Using the adjusted trial balance prepared in part j above, prepare statement of retained earnings dated December 31, 2015.

k-3

Using the adjusted trial balance prepared in part j above, prepare a balance sheet dated December 31, 2015. (Amounts to be deducted should be indicated with minus sign.)

l.

Using the financial statements prepared in part k above, determine approximately how many days on average an account receivable remains outstanding before it is collected. You may assume that the company's ending net accounts receivable balance on December 31 is a close approximation of its net average accounts receivable balance throughout the year. (Use 365 days a year. Round intermediate calculations to 1 decimal place and your final answer to the nearest whole number. )

m.

Using the financial statements prepared in part k, determine approximately how many days on average an item of merchandise remains in stock before it is sold. You may assume that the company's ending merchandise inventory balance on December 31 is a close approximation of its average merchandise inventory balance throughout the year. (Use 365 days a year. Round intermediate calculations to 1 decimal place and your final answer to the nearest whole number. )

n.

Using the financial statements prepared in part k, determine approximately how many days it takes to convert the company's inventory into cash. (Use 365 days a year. Round intermediate calculations to 1 decimal place and your final answer to the nearest whole number. )

image text in transcribed c-Is-Us, Inc., is a supplier of musical instruments for professional and amateur icians. The company's accountants make adjusting entries monthly, and they make all ng entries annually. The company is growing rapidly and prides itself on having no longm liabilities. company has provided the following trial balance dated December 31, 2015: MUSIC-IS-US, INC. TRIAL BALANCE DECEMBER 31, 2015 Cash Marketable securities Accounts receivable $ 45,000 25,000 125,000 Allowance for doubtful accounts 250,000 Merchandise inventory Office supplies Prepaid insurance $ 5,000 1,200 6,600 1,791,00 0 Building and fixtures 800,000 Accumulated depreciation Land Accounts payable Unearned customer deposits Income taxes payable 64,800 70,000 8,000 75,000 1,000,00 0 240,200 Capital stock Retained earnings Unrealized holding gain on investments 6,000 1,600,00 0 Sales 958,000 Cost of goods sold Bank service charges Uncollectible accounts expense 200 9,000 395,000 Salary and wages expense Office supplies expense Insurance expense Utilities expense Depreciation expense Income tax expense 400 6,400 3,600 48,000 75,000 $ 3,804,20 0 $ 3,804,20 0 Other information pertaining to the company's trial balance is shown below: 1 The most recent bank statement reports a balance of $46,975. Included with the bank . statement was a $2,500 check from Iggy Smarts, a professional musician, charged back to Music-Is-Us as NSF. The bank's monthly service charge was $25. Three checks written by MusicIs-Us to suppliers of merchandise inventory had not yet cleared the bank for payment as of the statement date. These checks included: no. 508, $5,500; no. 511, $7,500; and no. 521, $8,000. Deposits of $16,500 reached the bank too late for inclusion in the current bank statement. The company prepares a bank reconciliation at the end of each month. usic-Is-Us has a portfolio of marketable securities that originally cost $19,000. As of December 1, the market value of these securities was $27,500. All short-term investments are classified as available for sale.\" uring December, $6,400 of accounts receivable were written off as uncollectible. A recent aging the company's accounts receivable led management to conclude that an allowance for oubtful accounts of $8,500 is needed at December 31, 2015. he company uses a perpetual inventory system. A year-end physical count revealed that several uitars reported in the inventory records were missing. The cost of the missing units amounted to 1,350. This amount is not considered significant relative to the total cost of inventory on hand. t December 31, approximately $900 in office supplies remained on hand. he company pays for its insurance policies 12 months in advance. Its most recent payment was made on November 1, 2015. The cost of this policy was slightly higher than the cost of coverage r the previous 12 months. epreciation expense related to the company's building and fixtures is $5,000 for the month nding December 31, 2015. though Music-Is-Us carries an extensive inventory, it is not uncommon for experienced musicians to order custom guitars made to their exact specifications. Manufacturers do not allow ny sales returns of custom-made guitars. The entire sales amount is collected at the time a ustom order is placed, and is credited to an account entitled \"Unearned Customer Deposits.\" As December 31, $4,800 of these deposits remained unfilled because the special-order guitars ave not been received from the manufacturer. The cost of goods sold and the reduction in ventory associated with all custom orders is recorded when the custom merchandise is elivered to customers. At that time, the adjusting entry requires only a decrease to unearned ustomer deposits and an increase in sales. ccrued income taxes payable for the entire year ending December 31, 2015, total $81,000. No come tax payments are due until early in 2016. epare a bank reconciliation and make the journal entries to update the accounting records of usic-Is-Us as of December 31, 2015. b- Prepare the necessary adjusting entries at December 31, 2015. (If no entry is required for a i transaction/event, select "No journal entry required" in the first account field.) B B B B B B B B 1.Record the bank service charges for December and the NSF check received from Iggy Bates. 2.Record to increase reported value of marketable securities. 3.Record the uncollectible accounts expense for December. 4.Record the inventory shrinkage of missing guitars. 5.Record the office supplies used in December. 6.Record the insurance policies expired during December. 7.Record the depreciation expense for December. 8.Record the revenue earned from advance special orders. 9.Record the account for accrued income taxes in December. j. On the basis of the adjustments made to the accounting records in parts a through i above, prepar the company's adjusted trial balance at December 31, 2015. Attached is the correct Table Using the adjusted trial balance prepared in part j above, prepare an annual income statement dated December 31, 2015. Using the adjusted trial balance prepared in part j above, prepare statement of retained earnings dated December 31, 2015. 3 Using the adjusted trial balance prepared in part j above, prepare a balance sheet dated December 31, 2015. (Amounts to be deducted should be indicated with minus sign.) Using the financial statements prepared in part k above, determine approximately how many days on average an account receivable remains outstanding before it is collected. You may assume that the company's ending net accounts receivable balance on December 31 is a close approximation of its net average accounts receivable balance throughout the year. (Use 365 days a year. Round intermediate calculations to 1 decimal place and your final answer to the nearest whole number. ) m Using the financial statements prepared in part k, determine approximately how many days on . average an item of merchandise remains in stock before it is sold. You may assume that the company's ending merchandise inventory balance on December 31 is a close approximation of its average merchandise inventory balance throughout the year. (Use 365 days a year. Round intermediate calculations to 1 decimal place and your final answer to the nearest whole number. ) n Using the financial statements prepared in part k, determine approximately how many days it takes to . convert the company's inventory into cash. (Use 365 days a year. Round intermediate calculations to 1 decimal place and your final answer to the nearest whole number. )

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Recommended Textbook for

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

Students also viewed these Accounting questions