Prepared an end-of-period spreadsheet

Assignment Help Financial Accounting
Reference no: EM131258851

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 Services End-of-Period Spreadsheet For the Year Ended November 30, 2018 ~ Adjusted Trial Balance Account Title ~ Dr. Cr. ~ Cash ~ 27,500 Accounts Receivable ~ 71,800 Supplies ~ 3,550 Prepaid Insurance ~ 750 Building ~ 330,500 Accumulated Depreciation-Building ~ 184,100 Accounts Payable ~ 16,100 Salaries Payable ~ 6,600 Unearned Rent ~ 1,500 Common Stock ~ 40,000 Retained Earnings ~ 70,300 Dividends ~ 30,000 Service Fees ~ 675,500 Rent Revenue ~ 9,000 Salaries Expense ~ 435,000 Rent Expense ~ 55,000 Supplies Expense ~ 11,850 Depreciation Expense-Building ~ 10,000 Utilities Expense ~ 8,800 Repairs Expense ~ 4,250 Insurance Expense ~ 3,000 Miscellaneous Expense ~ 11,100 ~ 1,003,100 1,003,100 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. 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 $46,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 Foxy Investigative Services General Ledger ASSETS 11 Cash 12 Accounts Receivable 13 Supplies 14 Prepaid Insurance 17 Building 18 Accumulated Depreciation-Building LIABILITIES 21 Accounts Payable 22 Salaries Payable 23 Unearned Rent EQUITY 31 Common Stock 32 Retained Earnings 33 Dividends 34 Income Summary REVENUE 41 Service Fees 42 Rent Revenue EXPENSES 51 Salaries Expense 52 Rent Expense 53 Supplies Expense 54 Depreciation Expense-Building 55 Utilities Expense 56 Repairs Expense 57 Insurance Expense 59 Miscellaneous Expense 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 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 (Label) 1 (Label) 2 3 4 5 (Label) 6 7 8 9 10 11 12 13 14 15 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. 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 (Label) 1 2 3 4 5 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 (Label) 1 Assets 2 (Label) 3 4 5 6 7 8 (Label) 9 10 11 12 13 Liabilities 14 (Label) 15 16 17 18 19 Stockholders’ Equity 20 21 22 23 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 JOURNALACCOUNTING EQUATION DATE DESCRIPTION POST. REF. DEBIT CREDIT ASSETS LIABILITIES EQUITY 1 Closing Entries 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 3. If Retained Earnings had instead decreased $46,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. $

Reference no: EM131258851

Questions Cloud

Consider the various uses for network devices : Consider the various uses for network devices like routers, switches, hubs, repeaters, etc. and how one or more of them would aid situations where network performance is degraded.
Was domestic financial sector a surplus or deficit sector : Was the domestic financial sector a surplus or deficit sector? Which sectors purchased the bulk of Treasury securities? What percentages of Treasury Securities did individuals and institutions in other countries purchase?
Financial statement case : How much was Amazon’s long-term debt at December 31, 2009? Of this amount, how much was due within one year? How much was payable beyond one year in the future? Journalize in a single entry Amazon’s interest expense for 2009. Amazon paid cash of $32 ..
Possible operation performed by this sequence : Which one of the following is a possible operation performed by this sequence?
Prepared an end-of-period spreadsheet : 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 par..
Maintaining executive support for programs : Acquisition strategy statements are important documents for gaining and maintaining executive support for programs and projects. What in your view are the one or two biggest challenges in developing an acquisition strategy?
Provide background information about the agency and goals : Provide background information about the agency, mission, goals, objectives, departments, and strategic plan. (Title this section Introduction.)
One user-defined function : Please note that zero is a valid number of days for the crud togrow in which case it would remain at its initial value.You should make good use of functions to make your code easy to read. Please use at least one user-defined function (except of t..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd