Assignment Instructions

Question 1
 
Foxy Investigative Services is an investigative services firm that is owned and operated by Shirley Vickers. On November 30, 2018, the end of the fiscal year, the accountant for Foxy Investigative Services prepared an end-of-period spreadsheet, a part of which follows:
Foxy Investigative ServicesEnd-of-Period SpreadsheetFor the Year Ended November 30, 2018
~Adjusted Trial BalanceAccount Title~Dr.Cr.
~

Cash~23,000
Accounts Receivable~71,800
Supplies~4,500
Prepaid Insurance~2,500
Building~444,000
Accumulated Depreciation-Building~
44,600Accounts Payable~
11,200Salaries Payable~
2,900Unearned Rent~
1,500Common Stock~
80,000Retained Earnings~
293,200Dividends~11,500
Service Fees~
719,450Rent Revenue~
11,500Salaries Expense~525,000
Rent Expense~46,000
Supplies Expense~10,500
Depreciation Expense-Building~7,400
Utilities Expense~7,350
Repairs Expense~2,500
Insurance Expense~2,300
Miscellaneous Expense~6,000

~1,164,3501,164,350

Required:1.A.Prepare an income statement for the year ended November 30, 2018. If a net loss has been incurred, enter that amount as a negative number using a minus sign. Be sure to complete the statement heading. Use the list of Labels and Amount Descriptions for the correct wording of text items other than account names. You will not need to enter colons (:) on the income statement. Refer to the Chart of Accounts for exact wording of account titles.B.Prepare a retained earnings statement for the year ended November 30, 2018. If a net loss is incurred or dividends were paid, enter that amount as a negative number using a minus sign. Be sure to complete the statement heading. Use the list of Labels and Amount Descriptions for the correct wording of text items. Refer to the Chart of Accounts for exact wording of account titles. Refer to the lists of Labels and Amount Descriptions for exact wording of the answer choices for text entries other than account names.C.Prepare a balance sheet as of November 30, 2018. Fixed assets must be entered in order according to account number. Be sure to complete the statement heading. You will not need to enter colons (:) or the word “Less” on the balance sheet; they will automatically insert where necessary. Refer to the Chart of Accounts for exact wording of account titles. Refer to the lists of Labels and Amount Descriptions for exact wording of the answer choices for text entries other than account names. For those boxes in which you must enter subtracted or negative numbers use a minus sign.2.Based upon the end-of-period spreadsheet, journalize the closing entries. Refer to the Chart of Accounts for exact wording of account titles.3.If Retained Earnings had instead decreased $40,000 after the closing entries were posted, and the dividends remained the same, what would have been the amount of net income or net loss? If required, use a minus sign to indicate a net loss.
Chart of Accounts
CHART OF ACCOUNTSFoxy Investigative ServicesGeneral Ledger
ASSETS11Cash12Accounts Receivable13Supplies14Prepaid Insurance17Building18Accumulated Depreciation-Building
LIABILITIES21Accounts Payable22Salaries Payable23Unearned Rent
EQUITY31Common Stock32Retained Earnings33Dividends34Income Summary
REVENUE41Service Fees42Rent Revenue
EXPENSES51Salaries Expense52Rent Expense53Supplies Expense54Depreciation Expense-Building55Utilities Expense56Repairs Expense57Insurance Expense59Miscellaneous Expense
Labels and Amount Descriptions
Labels
Current assets
Current liabilities
Expenses
For the Year Ended November 30, 2018
November 30, 2018
Property, plant, and equipment
Revenues
Amount Descriptions
Change in retained earnings
Dividends
Net income
Net loss
Retained earnings, December 1, 2017
Retained earnings, November 30, 2018
Total assets
Total current assets
Total expenses
Total liabilities
Total liabilities and stockholders’ equity
Total property, plant, and equipment
Total revenues
Total stockholders’ equity

Income Statement
1A. Prepare an income statement for the year ended November 30, 2018. If a net loss has been incurred, enter that amount as a negative number using a minus sign. Be sure to complete the statement heading. Use the list of Labels and Amount Descriptions for the correct wording of text items other than account names. You will not need to enter colons (:) on the income statement. Refer to the Chart of Accounts for exact wording of account titles.
Foxy Investigative Services
Income Statement
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Retained Earnings Statement
1B. Prepare a retained earnings statement for the year ended November 30, 2018. If a net loss is incurred or dividends were paid, enter that amount as a negative number using a minus sign. Be sure to complete the statement heading. Use the list of Labels and Amount Descriptions for the correct wording of text items. Refer to the Chart of Accounts for exact wording of account titles. Refer to the lists of Labels and Amount Descriptions for exact wording of the answer choices for text entries other than account names.
Foxy Investigative Services
Retained Earnings Statement
1
2
3
4
5
Balance Sheet
1C. Prepare a balance sheet as of November 30, 2018. Fixed assets must be entered in order according to account number. Be sure to complete the statement heading. You will not need to enter colons (:) or the word “Less” on the balance sheet; they will automatically insert where necessary. Refer to the Chart of Accounts for exact wording of account titles. Refer to the lists of Labels and Amount Descriptions for exact wording of the answer choices for text entries other than account names. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Foxy Investigative Services
Balance Sheet
1
Assets
2
3
4
5
6
7
8
9
10
11
12
13
Liabilities
14
15
16
17
18
19
Stockholders’ Equity
20
21
22
23
Journal
2. Based upon the end-of-period spreadsheet, journalize the closing entries. Refer to the Chart of Accounts for exact wording of account titles.
PAGE 11
JOURNAL
ACCOUNTING EQUATION
DATEDESCRIPTIONPOST. REF.DEBITCREDITASSETSLIABILITIESEQUITY
1
Closing Entries
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Final Question
3. If Retained Earnings had instead decreased $40,000 after the closing entries were posted, and the dividends remained the same, what would have been the amount of net income or net loss? If required, use a minus sign to indicate a net loss.

Question 2

 
he unadjusted trial balance of Epicenter Laundry at June 30, 2018, the end of the fiscal year, follows:

Epicenter Laundry
UNADJUSTED TRIAL BALANCE
June 30, 2018

ACCOUNT TITLEDEBITCREDIT1Cash11,000.00 2Laundry Supplies21,500.00 3Prepaid Insurance9,600.00 4Laundry Equipment232,600.00 5Accumulated Depreciation 125,400.006Accounts Payable 11,800.007Common Stock 40,000.008Retained Earnings 65,600.009Dividends10,000.00 10Laundry Revenue 232,200.0011Wages Expense125,200.00 12Rent Expense40,000.00 13Utilities Expense19,700.00 14Miscellaneous Expense5,400.00 15Totals475,000.00475,000.00

The data needed to determine year-end adjustments are as follows:
A.Laundry supplies on hand at June 30 are $3,600.B.Insurance premiums expired during the year are $5,700.C.Depreciation of laundry equipment during the year is $6,500.D.Wages accrued but not paid at June 30 are $1,100.

Required:
Note: Download the spreadsheet on the T Accounts panel, saving the Excel file to your computer. Be sure to save your work in Excel. The spreadsheet input will not be included in your grade in CengageNOW on this problem.1. For each account listed in the unadjusted trial balance, enter the balance in a T account. Identify the balance as “Bal.”2. Using the Excel spreadsheet downloaded from the T Accounts panel, click the Work Sheet tab. Enter the unadjusted trial balance on the end-of-period work sheet and complete the work sheet.3. a. Journalize the adjusting entries on page 10 of the journal. Adjusting entries are recorded on June 30. Refer to the Chart of Accounts for exact wording of account titles.3. b. Post the adjusting entries. In the T accounts, identify the adjustments by “Adj.” and the new balances as “Adj. Bal.” (Be sure to add a posting reference to the journal.)4. Prepare an adjusted trial balance.5. a. Prepare an income statement for the year ended June 30, 2018. If a net loss has been incurred, enter that amount as a negative number using a minus sign. Be sure to complete the statement heading. You will not need to enter colons (:) on the income statement. Refer to the Chart of Accounts for exact wording of account titles. Refer to the lists of Labels and Amount Descriptions for exact wording of the answer choices for text entries other than account names.5. b. Prepare a retained earnings statement for the year ended June 30, 2018. If a net loss is incurred or dividends were paid, enter that amount as a negative number using a minus sign. Be sure to complete the statement heading. Refer to the Chart of Accounts for exact wording of account titles. Refer to the lists of Labels and Amount Descriptions for exact wording of the answer choices for text entries other than account names.5. c. Prepare a balance sheet as of June 30, 2018. Fixed assets must be entered in order according to account number. Be sure to complete the statement heading. You will not need to enter colons (:) on the balance sheet; they will automatically insert where necessary. Refer to the Chart of Accounts for exact wording of account titles. Refer to the lists of Labels and Amount Descriptions for exact wording of the answer choices for text entries other than account names. For those boxes in which you must enter subtracted or negative numbers use a minus sign.6. a. Journalize the closing entries on page 11 of the journal. Refer to the Chart of Accounts for exact wording of account titles. (Note: Complete the adjusted trial balance, the income statement, the retained earnings statement, and the balance sheet BEFORE completing part 6. a.)6. b. Post the closing entries. In the T accounts, identify the closing entries by “Clos.” (Be sure to add a posting reference to the journal.)7. Prepare a post-closing trial balance.

Chart of Accounts

CHART OF ACCOUNTSEpicenter LaundryGeneral LedgerASSETS11Cash13Laundry Supplies14Prepaid Insurance17Laundry Equipment18Accumulated Depreciation
LIABILITIES21Accounts Payable22Wages Payable
EQUITY31Common Stock32Retained Earnings33Dividends34Income SummaryREVENUE41Laundry Revenue
EXPENSES51Wages Expense52Rent Expense53Utilities Expense54Laundry Supplies Expense55Depreciation Expense56Insurance Expense59Miscellaneous Expense

Labels and Amount Descriptions

LabelsCurrent assetsCurrent liabilitiesExpensesFor the Year Ended June 30, 2018June 30, 2018Property, plant, and equipmentAmount DescriptionsChange in retained earningsNet incomeNet lossRetained earnings, June 30, 2018Retained earnings, July 1, 2017Total assetsTotal current assetsTotal expensesTotal liabilitiesTotal liabilities and stockholders’ equityTotal property, plant, and equipmentTotal stockholders’ equity

T Accounts

Note:Download the SPREADSHEET, saving the Excel file to your computer. Be sure to save your work in Excel. The spreadsheet input will not be included in your grade in CengageNOW on this problem.1. For each account listed in the unadjusted trial balance, enter the balance in a T account. Identify the balance as “Bal.”3. b. Post the adjusting entries. In the T accounts, identify the adjustments by “Adj.” and the new balances as “Adj. Bal.”6. b. Post the closing entries. In the T accounts, identify the adjustments by “Clos.”

Work Sheet

2. Using the Excel spreadsheet downloaded from the T Accounts panel, click the Work Sheet tab. Enter the unadjusted trial balance on the end-of-period work sheet and complete the work sheet.

Journal

3. a. Journalize the adjusting entries on page 10 of the journal. Adjusting entries are recorded on June 30. Refer to the Chart of Accounts for exact wording of account titles. 6. a. Journalize the closing entries on page 11 of the journal. Refer to the Chart of Accounts for exact wording of account titles. (Note: Complete the adjusted trial balance, the income statement, the retained earnings statement, and the balance sheet BEFORE completing part 6. a.)
PAGE 10PAGE 11

JOURNAL
ACCOUNTING EQUATION

DATEDESCRIPTIONPOST. REF.DEBITCREDITASSETSLIABILITIESEQUITY1 Adjusting Entries      23456789

Adjusted Trial Balance

4. Prepare an adjusted trial balance. If an amount box does not require an entry, leave it blank.

Epicenter Laundry
ADJUSTED TRIAL BALANCE
June 30, 2018

ACCOUNT TITLEDEBITCREDIT1Cash2Laundry Supplies3Prepaid Insurance4Laundry Equipment5Accumulated Depreciation6Accounts Payable7Wages Payable8Common Stock9Retained Earnings10Dividends11Laundry Revenue12Wages Expense13Rent Expense14Utilities Expense15Laundry Supplies Expense16Depreciation Expense17Insurance Expense18Miscellaneous Expense19Totals

Income Statement

5. a. Prepare an income statement for the year ended June 30, 2018. If a net loss has been incurred, enter that amount as a negative number using a minus sign. Be sure to complete the statement heading. You will not need to enter colons (:) on the income statement. Refer to the Chart of Accounts for exact wording of account titles. Refer to the lists of Labels and Amount Descriptions for exact wording of the answer choices for text entries other than account names.

Epicenter LaundryIncome Statement1 2  3 4 5 6 7 8 9 10 11

Retained Earnings Statement

5. b. Prepare a retained earnings statement for the year ended June 30, 2018. If a net loss is incurred or dividends were paid, enter that amount as a negative number using a minus sign. Be sure to complete the statement heading. Refer to the Chart of Accounts for exact wording of account titles. Refer to the lists of Labels and Amount Descriptions for exact wording of the answer choices for text entries other than account names.

Epicenter LaundryRetained Earnings Statement1 2 3 4 5

Balance Sheet

5. c. Prepare a balance sheet as of June 30, 2018. Fixed assets must be entered in order according to account number. Be sure to complete the statement heading. You will not need to enter colons (:) on the balance sheet; they will automatically insert where necessary. Refer to the Chart of Accounts for exact wording of account titles. Refer to the lists of Labels and Amount Descriptions for exact wording of the answer choices for text entries other than account names. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Epicenter LaundryBalance Sheet1Assets  2  3 4 5 6 7  8 9 10 11 12Liabilities  13  14 15 16 17Stockholders’ Equity  18 19 20 21

Post-closing Trial Balance

7. Prepare a post-closing trial balance.

Epicenter Laundry
POST-CLOSING TRIAL BALANCE
June 30, 2018

ACCOUNT TITLEDEBITCREDIT1Cash2Laundry Supplies3Prepaid Insurance4Laundry Equipment5Accumulated Depreciation6Accounts Payable7Wages Payable8Common Stock9Retained Earnings10Totals

 

Calculate Price


Price (USD)
$

This assignment has been solved!

Place your order for a custom solution to this or a similar paper.

Why Choose Us For Your Assignment?

Privacy

We value all our customers' privacy. For that reason, all information stays private and confidential and will never be shared with third parties.

Punctuality

With our service you will never miss a deadline. We use strict follow-ups with our writers to ensure that all papers are submitted on time.

Authenticity

We have no tolerance for plagiarism. All papers go through thorough checking to ensure that no assignments contain plagiarism.

Money Back

You feel unsatisfied with your results? No worries. We offer refunds to our customers if any paper is not written according to the instructions.

Clients Love Us

Client #121678
Client #121678
Read More
This is by far the best I have ever scored in a custom essay. I am surprised the writer handled this assignment so well despite the short notice. I will definitely use your service next time.
Client #21702
Client #21702
Read More
When I was recommended to you by my friends, I wasn't sure you could deliver excellent results for Masters research papers until I submitted my first order. I am all yours now.
Client #20730
Client #20730
Read More
Excellent Services! You are the only assignment helper I can rely on. I have worked with many before and your services are exceptional. I have recommended you to my friends and the results are similar.
Client #20387
Client #20387
Read More
I rarely write reviews online but your services are worth promoting. My paper was so urgent I was sure I was gonna miss the deadline but you turned things around. You are awesome!
Client #20189
Client #20189
Read More
I am a satisfied customer. I know I should have given a 5 star because you deserve it but I will give 4.6 because I almost missed a deadline because of a revision. Luckily it was minor and the writer acted promptly.
Client #20187
Client #20187
Read More
Great paper but there is still some room for improvement. I am impressed by your fast responses and how you tacked my concerns professionally. Thank you for being among the few genuine essay writing service providers.
Client #19783
Client #19783
Read More
I can't thank you enough for being a great part of my college life. I recommended you to two more of my friends. I am sure they will be making their orders soon. I love the fact that you offer free pages for referrals. I will be referring a few more and maybe I won't have to pay for my next two paper, LOL.
Previous
Next