Question: The unadjusted trial balance of Data Solution
The unadjusted trial balance of Data Solution at November 30, 2018, follows:
Additional information at November 30, 2018:
a. Accrued Service Revenue, $800.
b. Depreciation, $350.
c. Accrued Salaries Expense, $650.
d. Prepaid Rent expired, $700.
e. Office Supplies used, $550.
Requirements:
1. Complete Data Solution’s worksheet for the month ended November 30, 2018.
2. How much was net income for November?
Transcribed Image Text:
DATA SOLUTION Unadjusted Trial Balance November 30, 2018 Balance Account Title Debit Credit Cash $ 4,400 Accounts Receivable 3,100 Prepaid Rent 1,800 Office Supplies 3,100 Equipment 30,200 Accumulated Depreciation-Equipment $ 1,500 Accounts Payable 5,100 Salaries Payable Common Stock 32,900 Dividends 2,900 Service Revenue 8,800 Depreciation Expense-Equipment Salaries Expense 2,100 Rent Expense Utilities Expense 700 Supplies Expense Total S 48,300 S 48,300
> For each account listed, identify the category in which it would appear on a classified balance sheet. a. Office Supplies b. Interest Payable c. Retained Earnings d. Copyrights e. Land f. Accumulated Depreciation—Furniture g. Land (held for long-term in
> Refer to the data in Short Exercise S4-1. Prepare Dalton’s statement of retained earnings for the year ended December 31, 2018. Short Exercise 4-1: Dalton Hair Stylists’s adjusted trial balance follows. Prepare Dalton’s income sta
> Dalton Hair Stylists’s adjusted trial balance follows. Prepare Dalton’s income statement for the year ended December 31, 2018.
> Indicate the effects of the following business transactions on the accounting equation for Sam’s Snack Foods, a supplier of snack foods. Transaction (a) is answered as a guide. a. Sam’s Snack Foods received cash from issuance of common stock to stockhold
> List the steps of the accounting cycle.
> What are the steps in the closing process?
> How is the Income Summary account used? Is it a temporary or permanent account?
> What is the closing process?
> Why are financial statements prepared in a specific order? What is that order?
> What are reversing entries? Are they required by GAAP?
> What is the current ratio, and how is it calculated?
> What types of accounts are listed on the post-closing trial balance?
> If a business had a net loss for the year, what would be the closing entry to close Income Summary and transfer the net loss to the Retained Earnings account?
> What are permanent accounts? Are permanent accounts closed in the closing process?
> Indicate the effects of the following business transactions on the accounting equation of Vivian’s Online Video store. Transaction (a) is answered as a guide. a. Received cash of $10,000 from issuance of common stock. b. Earned video rental revenue on ac
> What are temporary accounts? Are temporary accounts closed in the closing process?
> If a business had a net loss for the year, where would the net loss be reported on the worksheet?
> How could a worksheet help in preparing financial statements?
> What does liquidity mean?
> Identify two liability categories on the classified balance sheet, and give examples of each category.
> Identify two asset categories on the classified balance sheet, and give examples of each category.
> What is a classified balance sheet?
> What does the balance sheet report?
> What does the statement of retained earnings show?
> What does the income statement report?
> As the manager of a Papa Sean’s restaurant, you must deal with a variety of business transactions. Give an example of a transaction that has each of the following effects on the accounting equation: a. Increase one asset and decrease another asset. b. De
> What document are financial statements prepared from?
> The unadjusted trial balance and adjustment data of Myla’s Motors at December 31, 2018, follow: Adjustment data at December 31, 2018: a. Depreciation on equipment, $1,700. b. Accrued Wages Expense, $1,300. c. Office Supplies on hand,
> On December 1, Curt Wilson began an auto repair shop, Wilson’s Quality Automotive. The following transactions occurred during December: The business uses the following accounts: Cash; Accounts Receivable; Office Supplies; Prepaid Insu
> The unadjusted trial balance of Watson Anvils at December 31, 2018, and the data for the adjustments follow: Adjustment data: a. Unearned Revenue still unearned at December 31, $3,600. b. Prepaid Rent still in force at December 31, $2,000. c. Office Su
> The unadjusted trial balance of Fleming Investment Advisers at December 31, 2018, follows: Adjustment data at December 31, 2018: a. Unearned Revenue earned during the year, $700. b. Office Supplies on hand, $3,000. c. Depreciation for the year, $3,000.
> The adjusted trial balance of Bradley Irrigation System at December 31, 2018, follows: Requirements: 1. Prepare the company’s income statement for the year ended December 31, 2018. 2. Prepare the company’s statement
> Adjusted trial balance of Rocket Real Estate Appraisal at June 30, 2018, follows: Requirements: 1. Prepare the company’s income statement for the year ended June 30, 2018. 2. Prepare the company’s statement of retain
> The unadjusted trial balance and adjustment data of Martha’s Motors at December 31, 2018, follow: Adjustment data at December 31, 2018: a. Depreciation on equipment, $2,100. b. Accrued Wages Expense, $1,100. c. Office Supplies on hand
> On December 1, Bob Waldo began an auto repair shop, Waldo’s Quality Automotive. The following transactions occurred during December: The business uses the following accounts: Cash; Accounts Receivable; Office Supplies; Prepaid Insuran
> The unadjusted trial balance of Walton Anvils at December 31, 2018, and the data for the adjustments follow: Adjustment data: a. Unearned Revenue still unearned at December 31, $1,800. b. Prepaid Rent still in force at December 31, $2,100. c. Office Su
> The records of Felix Company show the following at December 31, 2018: Requirements: 1. Compute the missing amount for Felix Company. You will need to determine Retained Earnings, December 31, 2018, and total stockholders’ equity, Dece
> The unadjusted trial balance of Farish Investment Advisers at December 31, 2018, follows: Adjustment data at December 31, 2018: a. Unearned Revenue earned during the year, $800. b. Office Supplies on hand, $4,500. c. Depreciation for the year, $4,500.
> The adjusted trial balance of Boston Irrigation System at December 31, 2018, follows: Requirements: 1. Prepare the company’s income statement for the year ended December 31, 2018. 2. Prepare the company’s statement o
> The adjusted trial balance of Erickson Real Estate Appraisal at June 30, 2018, follows: Requirements: 1. Prepare the company’s income statement for the year ended June 30, 2018. 2. Prepare the company’s statement of
> Refer to the Practice Set data provided in Chapters 2 and 3 for Crystal Clear Cleaning. Chapter 2 Consider the following transactional data for the first month of operations for Crystal Clear Cleaning. Chapter 3 This problem continues the Crystal Clea
> This case, based on the balance sheet of Target Corporation, will familiarize you with some of the assets and liabilities of that company. Visit http://www.pearsonhighered.com/Horngren to view a link to Target Corporation’s Fiscal 2015 Annual Report. Use
> Houston Veterinary Hospital completed the following worksheet as of December 31, 2018. Requirements: 1. Complete the worksheet for Houston Veterinary Hospital. 2. Prepare the closing entries. 3. Prepare a post-closing trial balance. H. HOUSTON VETE
> Mark’s Bowling Alley’s adjusted trial balance as of December 31, 2018, is presented below: Requirements: 1. Prepare the closing entries for Mark’s Bowling Alley. 2. Prepare a post-closing trial bala
> Cynthia Elmer, CPA, had the following partial worksheet: Requirements: 1. Complete the worksheet. 2. Prepare the closing entries for Cynthia Elmer, CPA. CYNTHIA ELMER, CPA Worksheet 3. December 31, 2018 Adjustments Credit Unadjusted Trial Balance A
> Selected accounts for Kebby Photography at December 31, 2018, follow: Requirements: 1. Journalize Kebby Photography’s closing entries at December 31, 2018. 2. Determine Kebby Photography’s ending Retained Earnings ba
> The adjusted trial balance of Stone Sign Company follows: Requirements: 1. Assume Stone Sign Company has a January 31 year-end. Journalize Stone’s closing entries at January 31. 2. How much net income or net loss did Stone Sign Compan
> During 2018, Flowing Rivers Spa reported revenue of $30,000. Total expenses for the year were $15,000. Flowing Rivers Spa ended the year with total assets of $43,000, and it owed debts totaling $14,000. At year-end 2017, the business reported total asset
> The unadjusted trial balance of Data Solution at November 30, 2018, follows: Additional information at November 30, 2018: a. Accrued Service Revenue, $800. b. Depreciation, $350. c. Accrued Salaries Expense, $650. d. Prepaid Rent expired, $700. e. Offi
> The adjusted trial balance of Melanie O’Mallie Dance Studio Company follows: Requirements: 1. Prepare the classified balance sheet of Melanie O’Mallie Dance Studio Company at August 31, 2018. Use the report form. You
> For each account listed, identify the category that it would appear on a classified balance sheet. Use the following categories: Current Assets; Long-term Investments; Property, Plant, and Equipment; Intangible Assets; Current Liabilities; Long-term Liab
> The adjusted trial balance for Green Advertising Services is presented below: Requirements: 1. Prepare the income statement for the year ending December 31, 2018. 2. Prepare the statement of retained earnings for the year ending December 31, 2018. 3. P
> Mountain View Services had the following unadjusted balances at December 31, 2018: Salaries Payable, $0; and Salaries Expense, $1,900. The following transactions have taken place at the end of 2018 and beginning of 2019: Requirements: 1. Open T-account
> Lucas Architects recorded the following adjusting entries as of December 31: a. Service Revenue accrued, $2,600. b. Unearned Revenue that has been earned, $1,300. c. Office Supplies on hand, $530. The balance of the Office Supplies account was $880. d.
> McGregor Insurance Agency started the year with a beginning Retained Earnings balance of $27,500. During the year, McGregor Insurance Agency earned $34,000 of Service Revenue and incurred $23,500 of various expenses. Dividends of $12,000 from the busin
> Grant Film Productions wishes to expand and has borrowed $100,000. As a condition for making this loan, the bank requires that the business maintain a current ratio of at least 1.50. Business has been good but not great. Expansion costs have brought the
> This problem continues the Canyon Canoe Company situation from Chapter 3. From Chapter 3: This problem continues the Canyon Canoe Company situation from Chapter 2. You will need to use the unadjusted trial balance and posted T-accounts that you prepare
> Mountain Drycleaners started 2018 with total assets of $19,000 and total liabilities of $14,000. At the end of 2018, Mountain’s total assets stood at $12,000 and total liabilities were $9,000. Requirements: 1. Did the stockholders’ equity of Mountain Dr
> This comprehensive problem is a continuation of Comprehensive Problem 1. Murphy Delivery Service has completed closing entries and the accounting cycle for 2018. The business is now ready to record January 2019 transactions. Requirements: 1. Record eac
> Murphy Delivery Service completed the following transactions during December 2018: 1. Record each transaction in the journal using the following chart of accounts. Explanations are not required. Cash ……â&
> iHeartMedia, Inc. in their annual report for the year ending December 31, 2015, state that the plant assets reported on its balance sheet includes the following: Plant Asset …………………………………………………………………………………………Useful Life Buildings and improvements ………………
> On October 1, 2018, Kitchen Design paid $15,000 for store rent covering the six- month period ending March 31, 2019. Requirements: 1. Journalize the entry on October 1 by using the alternative treatment of deferred expenses. 2. Record the December 31, 2
> Just Right Hair Stylists has begun the preparation of its worksheet as follows: Year-end data include the following: a. Office supplies on hand, $300. b. Depreciation, $700. c. Accrued interest expense, $800. Complete Just Right’s wo
> Seth’s Tax Services had the following accounts and account balances after adjusting entries. Assume all accounts have normal balances. Prepare the adjusted trial balance for Seth’s Tax Services as of December 31, 201
> Birch Park Senior Center has a weekly payroll of $12,500. December 31 falls on Wednesday, and Birch Park Senior Center will pay its employees the following Monday (January 5) for the previous full week. Assume Birch Park Senior Center has a five-day work
> Eastside Magazine collects cash from subscribers in advance and then mails the Magazines to subscribers over a one-year period. Requirements: 1. Record the journal entry to record the original receipt of $180,000 cash. 2. Record the adjusting entry that
> On October 1, Orlando Gold Exchange paid cash of $57,600 for computers that are expected to remain useful for three years. At the end of three years, the value of the computers is expected to be zero. Requirements: 1. Calculate the amount of depreciatio
> On November 1, Carlisle Equipment had a beginning balance in the Office Supplies account of $600. During the month, Carlisle purchased $2,300 of office supplies. At November 30, Carlisle Equipment had $500 of office supplies on hand. Requirements: 1. Op
> Wizco Advertising’s balance sheet data at May 31, 2018, and June 30, 2018, follow: For each of the following situations that occurred in June, 2018 with regard to common stock and dividends of a corporation, compute the amount of net
> On September 1, Big Fan of Toledo prepaid six months of rent, $3,300. Requirements: 1. Record the journal entry for the September 1 payment. 2. Record the adjusting entry required at September 30. 3. Using T-accounts, post the journal entry and adjustin
> Seacoast Magazine sells subscriptions for $36 for 18 issues. The company collects cash in advance and then mails out the magazines to subscribers each month. Apply the revenue recognition principle to determine a. when Seacoast Magazine should record re
> The Pink Peonies Law Firm prepays for advertising in the local newspaper. On January1, the law firm paid $3,000 for 10 months of advertising. How much advertising expense should Pink Peonies Law Firm record for the two months ending February 28 under the
> On September 1, 2018, Salem Landscaping collected $24,000 in advance from Customers for landscaping services. The service revenue will be earned monthly over the 12-month period ending August 31, 2019. Requirements: 1. Journalize the entry on September
> In recording adjusting entries, Reagan Financial Advisors failed to record the adjusting entries for the following situations: a. Office supplies on hand, $100. b. Accrued revenues, $5,000. c. Accrued interest expense, $250. d. Depreciation, $800. e. Un
> At the end of June, Gerber Dental had performed $9,000 of dental services but has not yet billed customers. Record the adjusting entry for accrued revenue.
> Resort Travel borrowed $33,000 on September 1, 2018, by signing a one-year note payable to State One Bank. Resort’s interest expense on the note payable for the remainder of the fiscal year (September through November) is $355. Requirements: 1. Record t
> A select list of transactions for Anuradha’s Goals follows: For each transaction, identify what type of adjusting entry would be needed. Select from the following four types of adjusting entries: deferred expense, deferred revenue, ac
> Suppose on January 1, Andrew’s Tavern prepaid rent of $16,800 for the full year. At November 30, how much rent expense should be recorded for the period January 1 through November 30?
> Protection Home provides house-sitting for people while they are away on vacation. Some of its customers pay immediately after the job is finished. Some customers ask that the business send them a bill. As of the end of the year, Protection Home has coll
> Compute the missing amount in the accounting equation for each entity from the financial information presented: Assets Liabilities Equity Hair Styles $ ? $ 36,000 $ 36,000 Style Cuts 90,000 48,000 Your Basket 101,000 68,000 ?
> The tobacco companies have paid billions because of smoking-related illnesses. In particular, Philip Morris, a leading cigarette manufacturer, paid more than $3,000,000,000 in settlement payments in one year. Requirements: 1. Suppose you are the chief f
> When is an adjusted trial balance prepared, and what is its purpose?
> What are the two basic categories of adjusting entries? Provide two examples of each.
> When are adjusting entries completed, and what is their purpose?
> Under the revenue recognition principle, when is revenue recorded?
> What is a worksheet, and how is it used to help prepare an adjusted trial balance?
> If a payment of a deferred expense was recorded under the alternative treatment, what account would be debited in the adjusting entry?
> If a payment of a deferred expense was recorded under the alternative treatment, what account would be debited at the time of payment?
> If an accrued expense is not recorded at the end of the year, what is the impact on the financial statements?
> What are the two rules to remember about adjusting entries?
> What is an accrued revenue? Provide an example.
> Consider the following accounting terms and definitions, and match each term to the definition: 1. Accounting equation a. An economic resource that is expected to be of benefit in the future 2. Asset b. Debts that are owed to creditors 3. Balance sh
> What is an accrued expense? Provide an example.
> What is a deferred revenue? Provide an example.
> How is book value calculated, and what does it represent?
> What does accumulated depreciation represent?
> In the recording of depreciation expense, which account is credited?
> What is a contra account?
> What is the process of allocating the cost of a plant asset over its useful life called?
> What is a deferred expense? Provide an example.
