Question

In: Accounting

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 Stock 75,000 75,000
Retained Earnings 180,700 180,700
Dividends 25,000 25,000
Fees Earned 800,000 800,000
Salary Expense 520,000 9,000 529,000
Supplies Expense 7,500 7,500
Depreciation Expense 6,000 6,000
Miscellaneous Expense 11,100 11,100
1,132,200 1,132,200 22,500 22,500 1,147,200 1,147,200

Based on the preceding spreadsheet, prepare an income statement, retained earnings statement, and balance sheet for Taser Consulting. Be sure to read the instructions for each financial statement carefully.

Prepare an income statement for the year ended October 31, 2018 for Taser Consulting. 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.

Taser Consulting

Income Statement

1

2

3

4

5

6

7

8

Solutions

Expert Solution

--requirements asked

Taser Consulting
Income Statement
For the Year Ended October 31, 2018
Fees Earned $800,000
Expenses:
Salary expense $529,000
Supplies expense $7,500
Depreciation expense $6,000
Miscellaneous expense $11,100
Total expenses $553,600
Net Income $246,400

-

Taser Consulting
Retained Earnings Statement
For the Year Ended October 31, 2018
Retained earnings, October 31, 2018 $180,700
Net income $246,400
Dividends ($25,000)
Change in retained earnings $221,400
Retained earnings, October 31, 2018 $402,100


--

Taser Consulting
Balance Sheet
October 31, 2018
Assets
Current assets:
Cash $45,000
Accounts receivables $119,200
Supplies $4,400
Total current assets $168,600
Property, plant, and equipment:
Office equipment $400,000
Accumulated depreciation ($62,000)
Total property, plant, and equipment $338,000
Total assets $506,600
Liabilities
Current liabilities:
Accounts Payable $20,500
Salaries Payable $9,000
Total liabilities $29,500
Stockholders' Equity
Common Stock $75,000
Retained earnings $402,100
Total stockholders' equity $477,100
Total liabilities and stockholders' equity $506,600

Related Solutions

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)...
Elliptical Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet...
Elliptical Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended June 30, 2016: Elliptical Consulting End-of-Period Spreadsheet For the Year Ended June 30, 2016 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 25,200 25,200 Accounts Receivable 52,000 52,000 Supplies 3,200 (a) 2,300 900 Office Equipment 34,000 34,000 Accumulated Depreciation 5,000 (b) 1,000 6,000 Accounts Payable 3,700 3,700 Salaries Payable (c)...
Financial Statements from the End-of-Period Spreadsheet Demo Consulting is a consulting firm owned and operated by...
Financial Statements from the End-of-Period Spreadsheet Demo Consulting is a consulting firm owned and operated by Jesse Flatt. The following end-of-period spreadsheet was prepared for the year ended August 31, 20Y9: Demo Consulting End-of-Period Spreadsheet For the Year Ended August 31, 20Y9 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title   Dr.   Cr.   Dr.   Cr.   Dr.   Cr. Cash 10,230 10,230 Accounts Receivable 24,350 24,350 Supplies 2,580 2,170 410 Land 20,700 20,700 Office Equipment 19,480 19,480 Accumulated Depreciation 2,700 1,290 3,990...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended April 30, 20Y3: During the year ended April 30, 20Y3, common stock of $5,000 was issued. Triton Consulting End-of-Period Spreadsheet For the Year Ended April 30, 20Y3 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr. Cash 21,500 21,500 Accounts Receivable 51,150 51,150 Supplies 2,400 1,650...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended April 30, 20Y3: Triton Consulting End-of-Period Spreadsheet For the Year Ended April 30, 20Y3 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr. Cash 17,460 17,460 Accounts Receivable 41,570 41,570 Supplies 4,410 3,700 710 Office Equipment 33,260 33,260 Accumulated Depreciation 4,610 2,200 6,810 Accounts Payable 11,220...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended April 30, 20Y3: During the year ended April 30, 20Y3, common stock of $5,000 was issued. Triton Consulting End-of-Period Spreadsheet For the Year Ended April 30, 20Y3 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr. Cash 21,500 21,500 Accounts Receivable 51,150 51,150 Supplies 2,400 1,650...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended April 30, 20Y3: Triton Consulting End-of-Period Spreadsheet For the Year Ended April 30, 20Y3 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr. Cash 16,930 16,930 Accounts Receivable 40,310 40,310 Supplies 4,270 3,590 680 Office Equipment 32,650 32,650 Accumulated Depreciation 4,470 2,140 6,610 Accounts Payable 10,880...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended April 30, 2018: Triton Consulting End-of-Period Spreadsheet For the Year Ended April 30, 2018 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr. Cash 14,990 14,990 Accounts Receivable 35,690 35,690 Supplies 3,780 (a) 3,180 600 Office Equipment 28,910 28,910 Accumulated Depreciation 3,960 (b) 1,890 5,850 Accounts...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended April 30, 20Y3: Triton Consulting End-of-Period Spreadsheet For the Year Ended April 30, 20Y3 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr. Cash 16,930 16,930 Accounts Receivable 40,310 40,310 Supplies 4,270 3,590 680 Office Equipment 32,650 32,650 Accumulated Depreciation 4,470 2,140 6,610 Accounts Payable 10,880...
Financial Statements from the End-of-Period Spreadsheet Elliptical Consulting is a consulting firm owned and operated by...
Financial Statements from the End-of-Period Spreadsheet Elliptical Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended June 30, 2019: Elliptical Consulting End-of-Period Spreadsheet For the Year Ended June 30, 2019 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr. Cash 16,870 16,870 Accounts Receivable 40,170 40,170 Supplies 4,260 (a) 3,580 680 Office Equipment 32,940 32,940 Accumulated Depreciation 4,460 (b) 2,130 6,590 Accounts...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT