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

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

ekkarill92 answered 2 years ago

Prepare general journal entries for the following transactions. If an amount box does not require an...

Prepare general journal entries for the following transactions. If an amount box does not require an entry, leave it blank. When required, enter amounts to the nearest cent. Assume 360 days in a year. June 15 Purchased $6,000 worth of equipment from a supplier on account. July 15 Issued a $6,000, 30-day, 7% note in payment of the account payable. Aug. 14 Paid $300 cash plus interest to the supplier, extending the note for 30 days from August 14. Sept....

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

Why do some accountants prepare an end-of-period spreadsheet?

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...

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...

Question