Question

In: Accounting

Complete the following end-of-period spreadsheet for Danilo Enterprises. If an amount box does not require an...

Complete the following end-of-period spreadsheet for Danilo Enterprises. If an amount box does not require an entry, leave it blank or enter "0".

Danilo Enterprises
End-of-Period Spreadsheet
For the Year Ended December 31
Adjusted Trial Balance Income Statement Balance Sheet
Account Title Debit Credit Debit Credit Debit Credit
Cash 14,500
Accounts Receivable 7,500
Supplies 500
Equipment 20,500
Accumulated Depr-Equip 15,000
Accounts Payable 9,500
Wages Payable 3,060
Common Stock 18,240
Dividends 1,000
Fees Earned 34,000
Wages Expense 18,000
Rent Expense 9,300
Depreciation Expense 8,500
Totals 79,800 79,800
Net Loss

Solutions

Expert Solution

Solution:

Danilo Enterprises

End-of-Period Spreadsheet

For the Year Ended December 31

Adjusted Trial Balance

Income Statement

Balance Sheet

Account Title

Debit

Credit

Debit

Credit

Debit

Credit

Cash

14,500

$14,500

Accounts Receivable

7,500

$7,500

Supplies

500

$500

Equipment

20,500

$20,500

Accumulated Depr-Equip

15,000

$15,000

Accounts Payable

9,500

$9,500

Wages Payable

3,060

$3,060

Common Stock

18,240

$16,440

Dividends

1,000

$1,000

Fees Earned

34,000

$34,000

Wages Expense

18,000

$18,000

Rent Expense

9,300

$9,300

Depreciation Expense

8,500

$8,500

Totals

79,800

79,800

$44,000

$44,000

Net Loss

($1,800)

Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you


Related Solutions

Prepare a post-closing trial balance. If an amount box does not require an entry, leave it...
Prepare a post-closing trial balance. If an amount box does not require an entry, leave it blank. Palisade Creek Co. is a merchandising business that uses the perpetual inventory system. The account balances for Palisade Creek Co. as of May 1, 2018, are as follows: Assume all accounts have normal balances. 110 Cash $ 83,600 112 Accounts receivable 233,900 115 Inventory 624,400 116 Estimated returns inventory 28,000 117 Prepaid insurance 16,800 118 Store supplies 11,400 123 Store equipment 569,500 124...
Which of the following accounts would appear in the Income Statement columns of the end-of-period spreadsheet?...
Which of the following accounts would appear in the Income Statement columns of the end-of-period spreadsheet? Select one: a. Unearned Revenue b. Cash c. Prepaid Insurance d. Net Loss
Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete...
Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co. If a box does not require an entry, leave it blank. Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2019 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 250 Accounts Receivable 1,830 Supplies 83 Prepaid Insurance 62 Land 2,080 Equipment 832...
Why do some accountants prepare an end-of-period spreadsheet?
Why do some accountants prepare an end-of-period spreadsheet?
Use the spreadsheet and partially completed Income Summary Account shown. Balloons and Baubbles End-of-Period Spreadsheet For...
Use the spreadsheet and partially completed Income Summary Account shown. Balloons and Baubbles End-of-Period Spreadsheet For the Year Ended December 31, 20-1 1 ACCOUNT TITLE TRIAL BALANCE DEBIT TRIAL BALANCE CREDIT ADJUSTMENTS DEBIT ADJUSTMENTS CREDIT ADJUSTED TRIAL BALANCE DEBIT ADJUSTED TRIAL BALANCE CREDIT 2 Cash 18,000.00 18,000.00 3 Accounts Receivable 12,600.00 12,600.00 4 Merchandise Inventory 67,500.00 (b) 76,500.00 (a) 67,500.00 76,500.00 5 Estimated Returns Inventory 2,880.00 (e) 3,870.00 (d) 2,880.00 3,870.00 6 Supplies 7,200.00 (f) 4,230.00 2,970.00 7 Prepaid Insurance...
Bamboo Consulting is a consulting firm owned and operated by Lisa Gooch. The following end-of-period spreadsheet...
Bamboo Consulting is a consulting firm owned and operated by Lisa Gooch. The following end-of-period spreadsheet was prepared for the year ended July 31, 2019: Bamboo Consulting End-of-Period Spreadsheet For the Year Ended July 31, 2019 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 57,100 57,100 Accounts Receivable 108,200 108,200 Supplies 12,200 (a) 6,300 5,900 Office Equipment 518,000 518,000 Accumulated Depreciation 28,500 (b) 6,900 35,400 Accounts Payable 21,100 21,100 Salaries Payable (c)...
The following accounts were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for...
The following accounts were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for April 30, for Finnegan Co.: Accumulated Depreciation $32,000 Fees Earned 78,000 Depreciation Expense 7,250 Rent Expense 34,000 Prepaid Insurance 6,000 Supplies 400 Supplies Expense 1,800 ​ Prepare an income statement.
The following data were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for...
The following data were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for April 30 for Abigail Company: Accumulated Depreciation $42,400 Prepaid Rent 6,800 Supplies 850 Unearned Fees 7,310 Trucks 49,300 Cash 3,400 Common Stock 2,000 Retained Earnings ? ​ Prepare a classified balance sheet.
Taser Consulting is a consulting firm owned and operated by Annamarie Phipps. The following end-of-period spreadsheet...
Taser Consulting is a consulting firm owned and operated by Annamarie Phipps. The following end-of-period spreadsheet was prepared for the year ended October 31, 2018: Taser Consulting End-of-Period Spreadsheet For the Year Ended October 31, 2018 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 45,000 45,000 Accounts Receivable 119,200 119,200 Supplies 11,900 7,500 4,400 Office Equipment 400,000 400,000 Accumulated Depreciation 56,000 6,000 62,000 Accounts Payable 20,500 20,500 Salaries Payable 9,000 9,000 Common...
Elliptical Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet...
Elliptical Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended June 30, 2016: Elliptical Consulting End-of-Period Spreadsheet For the Year Ended June 30, 2016 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 25,200 25,200 Accounts Receivable 52,000 52,000 Supplies 3,200 (a) 2,300 900 Office Equipment 34,000 34,000 Accumulated Depreciation 5,000 (b) 1,000 6,000 Accounts Payable 3,700 3,700 Salaries Payable (c)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT