Log in
Accounting
1
answer
0
watching
49
views

Using the data provided,please prepare a trial balance, an income statement, a statement ofchanges in owner's equity and a balance sheet. First, set up yourtrial balance by putting the accounts in the proper order, nextenter the amounts in the proper column and then input a formula tototal the columns.
Begin by creating a trialbalance in the correct order. Then create the income statement, astatement of changes in owners equity and a balance sheet usingcell reference for the amounts. In the cell that you want theamount to appear, be sure to put the cell reference from the amounton the trial balance. Therefore, EVERY data entry (amount) into thefinancial statements will be a cell reference or a formula. (35points)
Accounts payable 45
Accounts receivable 57
Accumulated depreciation 50
Cash 10
Depreciationexpense 5
Drawing 7
Equipment 100
Insuranceexpense 1
PrepaidInsurance 5
Repairexpense 2
Owners Equity(beginning) 50
Salariesexpense 10
Salaries payable 30
Service revenue 25
Utilitiesexpense 3

Watch
1
answer
0
watching
49
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Hubert Koch
Hubert KochLv2
28 Sep 2019

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share

Related questions

QUESTION 21 A journal entry for a $75 payment for Rent expensewas posted as a debit to Salary expense and a credit to Cash. Thiserror will cause which of the following conditions on the trialbalance? A. The sum of the credits will equal the sum of thedebits. B. The sum of the debits will exceed the sum of the creditsby $75. C. The sum of the credits will exceed the sum of the debitsby $150. D. The sum of the debits will exceed the sum of thecredits by $150.

QUESTION 22 The business receives cash from a customer that isowed to the company "on account," based on services rendered to thecustomer previously. How does the collection of the cash affect theaccounting equation? A. Assets increase; owner's equity increases.B. Assets increase; liabilities increase. C. Assets decrease;owner's equity decreases. D. One asset increases; one assetdecreases

QUESTION 23 A business completes service to a client and sendsout a sales invoice. The amount will be collected from the customerat a later time. Which of the following would be TRUE at the timewhen the invoice is sent out? A. Total assets will decrease. B. Netincome will increase. C. Owner's equity will decrease. D. Totalliabilities will increase.

QUESTION 24 Which of the following accounts increases with adebit? A. Cash B. Interest Payable C. Accounts Payable D. Smith,Capital

QUESTION 25 The Accounts Receivable account of Nuptials Inc. isshown below. Accounts Receivable Dr Cr 26,000 3,500 5,000 Calculatethe ending balance of the account. A. $33,500 debit B. $31,000,debit C. $3,500, credit D. $27,500, debit

QUESTION 26 The following transactions for the month of Marchhave been journalized and posted to the proper accounts. Mar. 1Martinez invested $9,000 cash in his new design services business.Mar. 2 Paid the first month's rent of $800. Mar. 3 Purchasedequipment by paying $3,000 cash and executing a note payable for$5,000. Mar. 4 Purchased office supplies for $750 cash. Mar. 5Billed a client for $10,000 of design services completed. Mar. 6Received $8,000 on account for the services previously recorded.What is the balance in Cash? A. $13,250 B. $12,450 C. $15,450 D.$14,000

QUESTION 27 Which of the following sequences states the order inwhich a trial balance lists accounts? A. Equity → Assets →Liabilities B. Liabilities → Assets → Equity C. Assets → Equity →Liabilities D. Assets → Liabilities → Equity

QUESTION 28 Which of the following statements is FALSE? A. Atrial balance shows total amounts for assets, liabilities, andequity. B. A trial balance is created before the balance sheet isprepared. C. A trial balance presents data in debit and creditformat, but a balance sheet does not. D. A trial balance showstotal debits and total credits.

QUESTION 29 A promise received from a business's customers topay for goods and services that they received from the business iscalled a(n): A. revenue. B. account receivable. C. account payable.D. expense.

QUESTION 30 You can evaluate the economic resources, debt, andoverall financial position of a company in which of the followingfinancial statements? A. Income statement B. Balance sheet C.Statement of owner's equity D. Statement of cash flows

QUESTION 31 A book holding all of the accounts is called the: A.income statement. B. journal. C. ledger. D. balance sheet.

QUESTION 32 Which of the following groups of accounts BOTHnormally have a debit balance? A. Assets and Liabilities B.Liabilities and Owner's equity C. Revenues and Expenses D. Assetsand Expenses

QUESTION 33 A business buys $500 of supplies on account. Whichaccount is debited? A. Supplies B. Cash C. Service revenue D.Accounts payable

QUESTION 5 Which of the following statements BEST definesfinancial statements? A. Financial statements are plans andforecasts for future time periods. B. Financial statements are theverbal statements made to business news organizations by chieffinancial officers. C. Financial statements are documents thatreport on a business in monetary terms, providing information tohelp people make informed business decisions. D. Financialstatements are the information systems that record and measurebusiness transactions.

QUESTION 6 Which of the following statements is true of a trialbalance? A. A trial balance has the same format as a balance sheet.B. A trial balance presents data in debit and credit format. C. Atrial balance shows total amounts of assets, liabilities, but notequity. D. A trial balance is prepared after the balance sheet.

QUESTION 7 There are relatively few types of revenue. Which ofthe following in NOT a type of revenue? A. Sales B. Service C.Interest D. Unearned Revenue

QUESTION 8 The financial statements should be prepared in whatorder? A. Income statement, statement of owner's equity, balancesheet, statement of cash flows B. Balance sheet, statement ofowner's equity, income statement, statement of cash flows C.Statement of owner's equity, balance sheet, income statement,statement of cash flows D. Balance sheet, income statement,statement of owner's equity, statement of cash flows

QUESTION 9 Which of the following journal entries would berecorded if a business makes a cash payment to a supplier of $600"on account" (the business had purchased supplies on account in theprevious month)? A. Accounts payable 600 Cash 600 B. Accountspayable 600 Supplies 600 C. Cash 600 Supplies 600 D. Cash 600Accounts payable 600

QUESTION 10 Which of the following statements about revenue isCORRECT? A. Revenues increase owner's equity, so a revenueaccount's normal balance is a credit balance. B. Revenues decreaseowner's equity, so a revenue account's normal balance is a debitbalance. C. Revenues increase owner's equity, so a revenueaccount's normal balance is a debit balance. D. Revenues decreaseowner's equity, so a revenue account's normal balance is a creditbalance.

QUESTION 11 From a legal perspective, a proprietorship is: A.not a distinct entity from its proprietor. B. authorized understate charter. C. an entity separate from its proprietor. D.subject to regulation by the SEC.

QUESTION 12 Sharon Samson starts a plumbing service namedReliable Waterworks. Selected transactions are described asfollows: A) Sharon deposits $7,000 into a new checking account forthe business, recording the capital contribution. B) Reliable pays$4,000 cash for equipment to be used for plumbing repairs. C)Reliable borrows $15,000 from a local bank and deposits the moneyin the checking account. D) Reliable pays $600 rent for the firstmonth. E) Reliable pays $400 cash for plumbing supplies to be usedon various jobs in the future. F) Reliable completes a plumbingrepair project for a local lawyer and receives $1,300 cash. G)Sharon takes a cash withdrawal of $2,500. After all of thetransactions, what is the amount of total assets? A. $25,700 B.$20,200 C. $24,200 D. $5,200

QUESTION 13 The Accounts Payable account is a(n) ________account and carries a ________ normal balance. A. liability; debitB. asset; debit C. liability; credit D. asset; credit

QUESTION 14 The following are the ending month's balances forToys Galore. Accounts payable $6,790 Revenue $8,680 Cash $4,500Expenses $1,050 Furniture $8,370 Accounts receivable $ 7,710Capital $930 Notes payable $5,230 What is the total amount ofcredits for the trial balance? A. $30,310 B. $16,400 C. $21,630 D.$20,580

QUESTION 15 The Sarbanes-Oxley Act ("SOX") made it a criminaloffense to: A. steal shareholders' money. B. default on loans fromcreditors. C. declare bankruptcy. D. falsify financialinformation.

QUESTION 16 Which of the following is the order of steps tojournalize an entry? A. Record the transaction, identify eachaccount affected, determine increase or decrease in each account.B. Identify each account affected, determine increase or decreasein each account, record the transaction. C. Identify each accountaffected, record the transaction, determine increase or decrease ineach account. D. Determine increase or decrease in each account,identify each account affected, record the transaction

QUESTION 17 Mitchell Florists had the following total assets,liabilities, and equity as of December 31. Assets $450,000Liabilities 135,000 Equity 315,000 What is Mitchell's debt ratio asof December 31? A. 30% B. 70% C. 100% D. 43%

QUESTION 18 Which of the following financial statements reportsrevenues? A. Statement of cash flows B. Income statement C.Statement of owner's equity D. Balance sheet

QUESTION 19 Following is a list of account balances (except forowner's capital) of Wilson Mowing Service as of December 31 of thefirst year of operation: Accounts receivable $2,500 Accountspayable $3,500 Salary expense $4,500 Repairs expense $800 Truck$8,500 Equipment $6,300 Notes payable $8,200 Cash $6,800 Suppliesexpense $1,600 Service revenue $31,900 Gasoline expense $3,800Salary payable $200 The proprietor, J.D. Wilson, contributed $3,000at the beginning of the year; during the year, the proprietor took$12,000 in drawings. At the end of the year, what is net income? A.$11,900 B. $21,200 C. $24,100 D. $12,200

QUESTION 20 Which of the following is an asset account? A.Salaries Expense B. Accounts Payable C. Service Revenue D. PrepaidExpense

QUESTION 21 A journal entry for a $75 payment for Rent expensewas posted as a debit to Salary expense and a credit to Cash. Thiserror will cause which of the following conditions on the trialbalance? A. The sum of the credits will equal the sum of thedebits. B. The sum of the debits will exceed the sum of the creditsby $75. C. The sum of the credits will exceed the sum of the debitsby $150. D. The sum of the debits will exceed the sum of thecredits by $150.

QUESTION 22 The business receives cash from a customer that isowed to the company "on account," based on services rendered to thecustomer previously. How does the collection of the cash affect theaccounting equation? A. Assets increase; owner's equity increases.B. Assets increase; liabilities increase. C. Assets decrease;owner's equity decreases. D. One asset increases; one assetdecreases

QUESTION 23 A business completes service to a client and sendsout a sales invoice. The amount will be collected from the customerat a later time. Which of the following would be TRUE at the timewhen the invoice is sent out? A. Total assets will decrease. B. Netincome will increase. C. Owner's equity will decrease. D. Totalliabilities will increase.

QUESTION 24 Which of the following accounts increases with adebit? A. Cash B. Interest Payable C. Accounts Payable D. Smith,Capital

QUESTION 25 The Accounts Receivable account of Nuptials Inc. isshown below. Accounts Receivable Dr Cr 26,000 3,500 5,000 Calculatethe ending balance of the account. A. $33,500 debit B. $31,000,debit C. $3,500, credit D. $27,500, debit

QUESTION 26 The following transactions for the month of Marchhave been journalized and posted to the proper accounts. Mar. 1Martinez invested $9,000 cash in his new design services business.Mar. 2 Paid the first month's rent of $800. Mar. 3 Purchasedequipment by paying $3,000 cash and executing a note payable for$5,000. Mar. 4 Purchased office supplies for $750 cash. Mar. 5Billed a client for $10,000 of design services completed. Mar. 6Received $8,000 on account for the services previously recorded.What is the balance in Cash? A. $13,250 B. $12,450 C. $15,450 D.$14,000

QUESTION 27 Which of the following sequences states the order inwhich a trial balance lists accounts? A. Equity → Assets →Liabilities B. Liabilities → Assets → Equity C. Assets → Equity →Liabilities D. Assets → Liabilities → Equity

QUESTION 28 Which of the following statements is FALSE? A. Atrial balance shows total amounts for assets, liabilities, andequity. B. A trial balance is created before the balance sheet isprepared. C. A trial balance presents data in debit and creditformat, but a balance sheet does not. D. A trial balance showstotal debits and total credits.

QUESTION 29 A promise received from a business's customers topay for goods and services that they received from the business iscalled a(n): A. revenue. B. account receivable. C. account payable.D. expense.

QUESTION 30 You can evaluate the economic resources, debt, andoverall financial position of a company in which of the followingfinancial statements? A. Income statement B. Balance sheet C.Statement of owner's equity D. Statement of cash flows

QUESTION 31 A book holding all of the accounts is called the: A.income statement. B. journal. C. ledger. D. balance sheet.

QUESTION 32 Which of the following groups of accounts BOTHnormally have a debit balance? A. Assets and Liabilities B.Liabilities and Owner's equity C. Revenues and Expenses D. Assetsand Expenses

QUESTION 33 A business buys $500 of supplies on account. Whichaccount is debited? A. Supplies B. Cash C. Service revenue D.Accounts payable

You have been hired as an accountantfor B&G Co., a corporation performing diverse consultingservices in Detroit, Michigan. B&G Co. prepares financialstatements on monthly bases.

ProjectScope: You are to record the transactions forDecember, prepare the monthly adjustments, and prepare thefinancial statements using the Excel workbook provided. Then youwill close the fiscal year and prepare the books for next year.

Directions: The assignment encompasses twofiles: Directions and Transactions (this Word document)and Forms (a separate Excel workbook). Your solutionshould be worked in Excel and the completed Excel workbooksubmitted for grading.

You should use Excel formula whereappropriate and cell references to carry forward values and numbersbetween worksheets within the workbook. Simply typing values inExcel will result in a reduced score, even if the correctsolution is provided. You should use formula whereverpossible.

Analyze the narrative to prepare and record the transactions forDecember to the General Journal.

Post the journal entries to ledger accounts using T-accounts(Don’t forget the opening balances from the information given onthe post-closing trial balance on Nov. 30th.)

Prepare Income Statement and the Retained Earnings Statement forthe month ended December 31, 2016 and Balance Sheet as of December31, 2016 in good forms. Use the multi-step format for the IncomeStatement.

Close the temporary accounts, posting any net income or loss toretained earnings.

Due Date: Dec.8th.

Transactionsin December 2016:

Dec.

1

The equipment was completely destroyed by the regional earthquake. “Loss by earthquake” was recognized.

1

Lent cash to another company and received a 2 year, $20,000zero-interest-bearing note. The market rate of interest for a noteof similar risk is 9 percent.

1

Purchased new equipment that costs $12,000 and issued 1,000shares of common stock (no-par stock) to the equipment seller.

3

Cash payment on accounts payable amounted to $6,000.

4

Sold land for $13,000 cash.

10

Collected $15,000 as payment for amounts previously billed(suppose the payment was made within the discount period).

13

One of the customers went bankrupt. B&G wrote off $2,000account receivable.

15

Paid monthly salaries of $20,000 to employees

16

Issued 1,000 shares of preferred stock at $10 per share

17

Purchased 500 shares of ABC corporation’s common stock at $15(per share) and classify the securities as available-for-salessecurities

20

Found that the company incorrectly overstated its Novemberaccount receivable and sales revenue by $1,000 and made a journalentry to correct the error.

29

Performed services for a customer for $30,000 cash

30

Performed $30,000 services on account with the following terms:2/15, n/30. B&G records credit sales using the net method

31

Dividends of $5,000 were declared and paid. $ 1,025 is paid topreferred stockholders and the rest is paid to the common stockholders.

31

ABC corporation declared $ 5 dividend per share (to common stockholders). It will be paid in 2017.

* Additional information

1. Ignoretax effect.

2. Salariesexpenses incurred but not paid prior to Dec. 31sttotaled $10,500.

3. Thecompany received the bill for utility services (electricity) thatthe firm used during December in the amount of $6,000. The companywill pay the bill in Jan. 2016.

4. $3,000 ofsupplies remained at the end of December.

5. Thecompany use the “Allowance” method for possible accounts receivablewrite-offs in the future and estimated that 5% of the outstandingaccount receivable will not be collected.

6. The equipmentpurchased on Dec. 1st depreciates $200 per month.

7. Thecommon stock price of ABC Corporation on December 31st is still $15 per share.

Weekly leaderboard

Home
Homework Help 3,900,000
Accounting 580,000
Start filling in the gaps now
Log in