Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, this is an adjusted trial balance exercise, I need to fill out the excel document attached and the instructions are in the word document.

Hello, this is an adjusted trial balance exercise, I need to fill out the excel document attached and the instructions are in the word document. Thank you.

image text in transcribed Use the Adjusted Trial Balance WorksheetProject, Part 1 (tab 1). The unadjusted balances have been inserted for your convenience. Enter the adjusting entries. (Specific information relating to these entries can be found below.) Calculate the Adjusted Trial Balance. Input from the Adjusted Trial Balance, the Balance Sheet, and the Income Statement. Adjusted Trial Balance Barb has found the following adjusting entries that need to be made to the Unadjusted Trial Balance. Prepare the Adjusting Journal Entries, and enter them onto the Adjusting Entries column of the Adjusted Trial Balance worksheet. Denote the entry number of each adjustment in the entry # column. Note: Some items won't require an adjusting entry. Read each item carefully. 1. Business insurance was purchased in November for $12,000, which covers a 12-month period. An entry needs to be made between prepaid and insurance expense. This entry has been done for you and should be used as an example of how the rest of the entries should be completed. 2. Depreciation needs to be calculated for all of the fixed-asset accounts. Computer equipment, computer software, and furniture and fixtures will be depreciated using the straight-line method over 60 months. Machinery will be depreciated over 84 months using the straight-line method of accounting. 3. An entry was made incorrectly recording the Note Payable interest and principal payments to the Other Accrued Liability account. The entry should have been made to Interest Expense and the Notes Payable accounts. The loan has a monthly payment of $1001.61. The shop has paid $2,439 in interest and $5,565 in principal over the past eight months. A. The note was used to purchase a customer list. The asset will have a life of 10 years, and it should be amortized evenly over the 10-year period. You'll need to record the amortization. B. The loan has a monthly payment of $1,001.61. The short-term portion of the loan (the next 12 months of payments) needs to be reclassed from account 400-Note Payable to account 335-ShortTerm Portion of Notes Payable. C. As stated above, the original interest expense of $2,439 was incorrectly recorded in the Other Accrued Liabilities account number 320 for the eight-month period. You'll need to make an adjusting journal entry to correct this. You'll need to reclassify the error to the interest expense account. D. The principal amount of $5,565 was also incorrectly recorded in Other Accrued Liabilities account number 320. You'll need to make an adjusting entry, moving this from Accrued Other and reducing the Long-Term Note Payable account. 4. Several late payables were received but not recorded. These payables were for clothing and accessories discounted after the season and will be sold next year. The total late payable amount is $6,998. 5. Inventory is valued correctly at the lower of cost or market. 6. Since it's the shop's first year, it could be hard to estimate what the balance in the allowance for doubtful accounts should be. But based on the Bernard's New York store and the similarities of both, Mrs. Bernard estimated the allowance should be 5 percent of Accounts Receivable. 7. Mr. and Mrs. Bernard collect their salary throughout the year. They're paid one week in arrears. Their gross payroll for a week is $3,942, and the employer portion of tax associated with the accrual is 15 percent. You'll need to make an adjusting entry to record the one week of salary and tax expense. 8. Rent is $3,000 per month and is prepaid on the first day of the month. 9. Utilities this time of year are low and run $275 a month. Services are billed for the previous month at the beginning of the next month. For example, June's utility invoice would be sent at the beginning of July. You'll need to adjust for this. 10. The shop's CPA has advised the Bernards that their estimated tax liability for the year will be $51,924. They've made payments through the end of May of $45,434. The remaining amount will need to be accrued. Total the adjusting entries to be sure they zero out. Your next step will be to combine the Unadjusted Trial Balances and the Adjusting Entries to calculate the Adjusted Trial Balance. Next, divide the accounts into either Net Income or Balance Sheet accounts and enter into the appropriate columns. Hint: The net balance of both the Income and Balance Sheets accounts will be $158,977. Mile High Ski and Snowboard Shop Pennsylvania Entity Adjusted Trial Balance For the Eight Month Period Ending 6/30/XX Final Project (Part 1) EXCEL Account Number 010 020 030 040 050 060 100 110 120 130 150 160 170 180 210 255 300 310 315 320 330 335 340 400 Unadjusted Trail Balance Current Assets Cash Accounts receivable Bad debt reserve Marketable Securities Inventory Prepaid Assets Computer Equipment Computer Software Furniture and Fixtures Machinery Accumulated Depreciation - Computer Equipment Accumulated Depreciation - Computer Software Accumulated Depreciation - Furniture and Fixtures Accumulated Depreciation - Machinery Customer List Customer List Amortization Accounts payable Accrued Payroll & Payroll Tax Liability Income Tax Payable Other accrued liabilities Other short term liabilities Short-tem Portion of Note Payable Unremitted sales tax Note Payable (120 payments) 1 of 6 $ 134,195 12,500 (600) 25,000 34,600 600 27,500 5,000 10,000 12,500 Adjusting Entries 4,000 Entry # 1 100,000 (12,500) (3,942) (45,433) (17,157) (100,000) Adjusted TB (PS# Part 1) Mile High Ski and Snowboard Shop Pennsylvania Entity Adjusted Trial Balance For the Eight Month Period Ending 6/30/XX Final Project (Part 1) EXCEL Account Number 500 510 600 610 620 630 640 650 700 710 720 730 740 800 805 810 812 814 815 820 822 825 830 835 Unadjusted Trail Balance Current Assets Capital Retained earnings Clothing and accessory sales Rentals Services Ski equipment sales Snow board equipment sales Other revenues Adjusting Entries Entry # (176,800) (128,500) (76,300) (225,320) (193,400) (32,500) 70,720 32,125 34,335 90,128 87,030 5,230 3,500 Clothing and Accessory - Cost of Sales Rentals - Cost of Sales Services - Cost of Sales Ski Equipment - Cost of Sales Snow Board Equipment - Cost of Sales Advertising Bank fees Depreciation Expense Amortization Expense Bad Debt Expense Dues and Subscriptions Employee benefits Income Tax Payable Insurance Expense Interest Expense Legal and accounting fees 500 45,433 12,000 3,000 2 of 6 (4,000) 1 Adjusted TB (PS# Part 1) Mile High Ski and Snowboard Shop Pennsylvania Entity Adjusted Trial Balance For the Eight Month Period Ending 6/30/XX Final Project (Part 1) EXCEL Account Number 840 845 850 855 860 865 870 875 Unadjusted Trail Balance Current Assets Payroll Tax Expense Postage Rent Salaries and Wages Telephone Travel and Entertainment Utilities Vehicle Expense Adjusting Entries Entry # 29,446 1,200 24,000 196,306 3,200 4,200 4,525 3,679 $ - - 3 of 6 Adjusted TB (PS# Part 1) Adjusted Trial Balance $ Balance Sheet Income Statement 134,195 12,500 (600) 25,000 34,600 4,600 27,500 5,000 10,000 12,500 100,000 (12,500) (3,942) (45,433) (17,157) (100,000) 4 of 6 Adjusted TB (PS# Part 1) Adjusted Trial Balance Balance Sheet Income Statement (176,800) (128,500) (76,300) (225,320) (193,400) (32,500) 70,720 32,125 34,335 90,128 87,030 5,230 3,500 500 45,433 8,000 3,000 5 of 6 Adjusted TB (PS# Part 1) Adjusted Trial Balance Balance Sheet Income Statement 29,446 1,200 24,000 196,306 3,200 4,200 4,525 3,679 $ - $ - $ - 6 of 6 Adjusted TB (PS# Part 1)

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

Recommended Textbook for

Accounting

Authors: Carl S. Warren, Christine Jonick, Jennifer Schneider

28th Edition

1337902683, 978-1337902687

More Books

Students also viewed these Accounting questions