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.
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 |
Hello I need help with creating the adjustments, adjusted trial balance, income statement, and balance sheet....
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 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 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 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 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 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 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 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 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 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...