Question

Hello I need help with creating the adjustments, adjusted trial balance, income statement, and balance sheet....

Hello I need help with creating the adjustments, adjusted trial balance, income statement, and balance sheet.

Trial Balance December 31, 2019

Debit

Credit

Cash

29,000

Notes Receivable

10,000

Interest Receivable

Accounts Receivable

7,600

Allowance for Doubtful Accounts

200

Inventory

18,000

Prepaid Insurance

Prepaid Advertising

21,000

Land

55,000

Buildings

148,000

Accumulated Depreciation-Buildings

9,750

Equipment

89,000

Accumulated Depreciation-Equipment

18,000

Short Term Note Payable

18,000

Accounts Payable

12,000

Salaries Payable

Interest Payable

Unearned Wedding Revenue

12,000

Unearned Funeral Revenue

2,000

Mortgage Payable

133,000

Capital Stock

20,000

Retained Earnings

87,950

Dividends Declared

15,000

Wedding Revenue

123,000

Funeral Revenue

54,000

Cash Sales of garden plants

178,000

Cost of Goods Sold

71,000

Salaries Expense

130,000

Insurance Expense

9,300

Advertising Expense

Depreciation Expense-Building

Depreciation Expense-Equipment

Bad Debt Expense

Other Expenses

53,000

Interest Revenue

Interest Expense

12,000

Total

667,900

667,900

a. The 8% Note was received from a customer on December 13th. The note matures in 60 days.

b. Each mortgage payment is due on the 20th of the month. The last payment was made in December

      15th. Here is the mortgage amortization schedule. Assume each month has 30 days

Date

Cash

Interest

Principal

Balance

20-Dec-19

950

447

503

133,000

20-Jan-20

950

443

507

132,493

c. All advertising was taken to the Prepaid Advertising Account. Of that 16,800 has been used during period

d. All insurance premium payments were taken to Insurance Expense. $1,000 should remain in prepaid at the end of the period

e. $9,000 of the Unearned Wedding Revenue had been earned by the end of the year.

f. A funeral prepayment on Dec 31 of $1,200 was inadvertently taken to Funeral Revenue. Funeral is scheduled for early January.

g. Salaries of $2500 had been earned but not yet paid at December 31

h. The building has a 30 year life and a $46,000 salvage value. The equipment as a 10

      year life and a $20,000 salvage value. The company uses the straight-line method.

i. The company took out a short-term 9% note on November 11. The note is due in February.

     j. The company estimates that 1/2% of wedding and floral revenue after adjustments will prove uncollectible.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
ADJUSTED TRIAL BALANCE, INCOME STATEMENT & BALANCE SHEET:
Unadjusted T/B Adjustments Adjusted T/B Income Statement Balance Sheet
Acc title Debit $ Credit $ Debit $ Credit $ Debit $ Credit $ Debit $ Credit $ Debit $ Credit $
Cash 29000 29000 29000
Note Rec 10000 10000 10000
Inter Rec. 42 42 42
Accounts Rec. 7600 7600 7600
Allow for D/A 200 634 834 834
Inventory 18000 18000 18000
Prep. Insu. 1000 1000 1000
Prep. Advert. 21000 16800 4200 4200
Land 55000 55000 55000
Buildings 148000 148000 148000
Acc Dep - build 9750 3400 13150 13150
Equipment 89000 89000 89000
Acc Dep - Eq. 18000 6900 24900 24900
ST Note paya. 18000 18000 18000
Accounts Pay. 12000 12000 12000
Salaries Pay. 2500 2500 2500
Interest Pay. 383 383 383
Unearned Wedding Rev. 12000 9000 3000 3000
Unearned Funeral Rev. 2000 1200 3200 3200
Mortgage Payable 133000 133000 133000
Capital stock 20000 20000 20000
Reta. Earnings 87950 15000 72950 72950
Dividends decl. 15000 15000 0 0
Wedding Rev. 123000 9000 132000 132000
Funeral Rev. 54000 1200 52800 52800
Cash sales of garden plants 178000 178000 178000
Interest rev. 42 42 42
COGS 71000 71000 71000
Salaries exp. 130000 2500 132500 132500
Insurance exp. 9300 1000 8300 8300
Advertising exp. 16800 16800 16800
Dep. Exp - building 3400 3400 3400
Dep. Exp.- Equip 6900 6900 6900
Bad Debt exp. 634 634 634
Other exp. 53000 53000 53000
Interest Exp. 12000                    383                                                               12383                   
Total 667900 667900 56859 56859 654376 666759 304917 362842
Net Income 57925                    57925
Balance Sheet Total 361842 361842
NOTES:
interest receivable = 10000*8%*19/365 = $42
interest payable = 443*11/31=157
Dep-building = (148000-46000)/30 = 3400
Dep - equip = (89000-20000)/10 = 6900
Interest payable on ST Note= 18000*9%*51/365 = 226
Bad Debt = [ (114000 + 52800)* 0.5%] - 200 = 834 - 200 = 634
Add a comment
Know the answer?
Add Answer to:
Hello I need help with creating the adjustments, adjusted trial balance, income statement, and balance sheet....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Iris Floral Several years ago Iris began a floral business to have something to do in...

    Iris Floral Several years ago Iris began a floral business to have something to do in her spare time. The shop has done well and now employs several people. The trial balance at December 31, 2019 is shown below along with some additional information. Iris has asked that you use this information to prepare financial statements for her for the year ended December 31st. I suggest you begin with a worksheet. All amounts should be to the nearest dollar.            ...

  • Requirement: Using this adjusted trial balance, complete an income statement, a statement of retained earnings, and...

    Requirement: Using this adjusted trial balance, complete an income statement, a statement of retained earnings, and a balance sheet. Make sure all three are in good form. Bertrand Irrigation System Adjusted Trial Balance December 31, 2018    Balance    Account Title Debit Credit    Cash $12,000    Accounts Receivable 46,200    Office Supplies 17,700    Prepaid Insurance 4,600    Building 58,000    Accumulated Depreciation—Building $24,300    Equipment 26,000    Accumulated Depreciation—Equipment 7,600    Accounts Payable 27,100    Interest Payable 1,800...

  • please prepare a balance sheet. Unadjusted Adjusted Trial Balance Adjustments Trial Balance Income Statement Balance Sheet...

    please prepare a balance sheet. Unadjusted Adjusted Trial Balance Adjustments Trial Balance Income Statement Balance Sheet Cash 270.788 270,788 270.78 Accounts receivable 1,070,384 1.070,384 1.070,384 Allowance for doubtful accounts 18.313.6 74,567.14 93,080.74 93.081 Interest receivable 8,530.525 8,531 8531 Note receivable 359,180 359.180 359.180 Merchandise inventory 782.572 782.572 782.572 Prepaid insurance 28,728 19,1529,576 9.576 Prepaid rent 47,880 6.390 41,490 41.490 Supplies 121.296 116,622 4.674 4.674 Equipment 1.118.264 1.118,264 1.118.264 Accumulated depreciation Equipment 118,104 110,626.4 228.730.4 228.730 Accounts payable 111.826.4 111.826.4 111.826...

  • list of accounts Sandhill Company had the following adjusted trial balance. $3,840 Sandhill Company Adjusted Trial...

    list of accounts Sandhill Company had the following adjusted trial balance. $3,840 Sandhill Company Adjusted Trial Balance For the Month Ended June 30, 2020 Adjusted Trial Balance Account Titles Debit Credit Cash Accounts Receivable 4,070 Supplies 400 Accounts Payable $1,700 Unearned Service Revenue 190 Owner's Capital 3,900 Owner's Drawings Service Revenue 5,920 Salaries and Wages Expense 1,300 Miscellaneous Expense 200 Supplies Expense 1,930 Salaries and Wages Payable 540 $12,250 $12,250 510 Prepare closing entries at June 30, 2020. (Credit account...

  • prepare an income statement and a statement of retained earnings. 4.674 Unadjusted Adjusted Trial Balance Adjustments...

    prepare an income statement and a statement of retained earnings. 4.674 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Income Statement Balance Sheet Cash 270,788 270,788 270,78% Accounts receivable 1,070,384 1.070,384 1.070,384 Allowance for doubtful accounts 18.313.6 74,567.14 93,080.74 93,081 Interest receivable $_3530525 8.531 8,531 Note receivable 359.180 359.180 359.180 Merchandise inventory 782.572 782.572 782572 Prepaid insurance 28,728 19,152 9.576 9.576 Prepaid rent 47,880 6,390 41,490 41.490 Supplies 121.296 116.622 Equipment 1,118,264 1.118,264 1.118,264 Accumulated depreciation Equipment 118,104 110.626.4 228.730.4 228.730...

  • The adjusted trial balance of Ryan Company appears below. Using the information from the adjusted trial...

    The adjusted trial balance of Ryan Company appears below. Using the information from the adjusted trial balance, you are to prepare for the month ending December 31:                 1.            an income statement.                 2.            a retained earnings statement.                 3.            a balance sheet. (You need to calculate the amount of cash) Trial Balance Debit 285,000 $ 45,000 16,500 178,500 Cash Accounts Receivable Allowance for Doubtful Accounts Supplies Prepaid Insurance Equipment Accumulated Depreciation - Equipment Notes Payable Accounts Payable Interest Payable...

  • Fill in the balance sheet above. Problem 4-03A The Cullumber Hotel opened for business on May...

    Fill in the balance sheet above. Problem 4-03A The Cullumber Hotel opened for business on May 1, 2022. Here is its trial balance before adjustment on May 31. CULLUMBER HOTEL Trial Balance May 31, 2022 Credit Debit $ 2,343 2,600 1,800 14,843 67,600 16,800 Cash Supplies Prepaid Insurance Land Buildings Equipment Accounts Payable Unearned Rent Revenue Mortgage Payable Common Stock Rent Revenue Salaries and Wages Expense Utilities Expense Advertising Expense $ 4,543 3,300 33,600 59,843 9,000 3,000 800 500 $110,286...

  • The Moto Hotel opened for business on May 1, 2017. Here is its trial balance before...

    The Moto Hotel opened for business on May 1, 2017. Here is its trial balance before adjustment on May 31. MOTO HOTEL Trial Balance May 31, 2017 Debit Credit Cash $ 2,333 Supplies 2,600 Prepaid Insurance 1,800 Land 14,833 Buildings 67,600 Equipment 16,800 Accounts Payable $ 4,533 Unearned Rent Revenue 3,300 Mortgage Payable 33,600 Common Stock 59,833 Rent Revenue 9,000 Salaries and Wages Expense 3,000 Utilities Expense 800 Advertising Expense 500 $110,266 $110,266 Other data: 1. Insurance expires at the...

  • BIG CONSTRUCTION COMPANY Unadjusted Trial Balance December 31, 2020 ADIUSTED T.B. INCOME STATEMENT ADJUSTMENTS CREDIT UNADJUSTED...

    BIG CONSTRUCTION COMPANY Unadjusted Trial Balance December 31, 2020 ADIUSTED T.B. INCOME STATEMENT ADJUSTMENTS CREDIT UNADJUSTED T.B CREDIT CREDIT DEBIT DEBIT DEBIT DEBIT CREDIT ACCOUNT TITLE Cash Notes Receivable Accounts Receivable 220,000 24,000 23,000 Inventory 12/31/2020 Prepaid Insurance 47,000 4,300 Prepaid Rent 8,400 Supplies Land 2,900 28.000 Equipment Accum Deprec-Equipment Accounts Payable 90,000 18,000 28.000 12,500 75.000 Unearned Rent Revenue Mortgage Payable (Due 2022) Owner's Capital Owner's Drawings 124,000 4,700 279,000 Sales Revenue 2,100 Sales Returns and Allowances 1,900 Sales...

  • I need help solving the adjusting entries. I have provided the unadjusted trial balance. Thank you...

    I need help solving the adjusting entries. I have provided the unadjusted trial balance. Thank you so much! Debit Credit 15,000 55,000 2,000 7,000 12,000 1,000 4,000 40,000 330,000 120,000 39,000 150,000 70,000 22,000 30,000 Cash Accounts Receivable Allowance for Doubtful Accounts Prepaid Insurance Prepaid rent Supplies Prepaid Advertising Note Receivable Interest Receivable Land Buildings Accumulated Depreciation-Buildings Equipment Accumulated Depreciation-Equipment Accounts Payable Notes Payable Interest Payable Salary & Wage Payable Unearned revenue Unearned rent revenue Common Stock Retained Earnings Sales...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT