Question

In: Accounting

Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by...

  1. 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 10,880
    Salaries Payable 520 520
    Common Stock 13,000 13,000
    Retained Earnings 28,120 28,120
    Dividends 5,240 5,240
    Fees Earned 75,980 75,980
    Salary Expense 29,830 520 30,350
    Supplies Expense 3,590 3,590
    Depreciation Expense 2,140 2,140
    Miscellaneous Expense 3,220 3,220
    132,450 132,450 6,250 6,250 135,110 135,110

    Based on the preceding spreadsheet, prepare an income statement for Triton Consulting.

    Triton Consulting
    Income Statement
    For the Year Ended April 30, 20Y3
    $
    Expenses:
    $
    Total expenses
    $

    Based on the preceding spreadsheet, prepare a statement of stockholders’ equity for Triton Consulting. During the year ended April 30, 20Y3, common stock of $5,000 was issued. If an amount box does not require an entry, leave it blank. If a net loss is incurred or dividends were paid, enter that amount as a negative number using a minus sign.

    Triton Consulting
    Statement of Stockholders’ Equity
    For the Year Ended April 30, 20Y3
    Common Stock Retained Earnings Total
    $ $ $
    $ $ $

    Based on the preceding spreadsheet, prepare a balance sheet for Triton Consulting.

    Triton Consulting
    Balance Sheet
    April 30, 20Y3
    Assets
    Current assets:
    $
    Total current assets $
    Property, plant, and equipment:
    $
    Total property, plant, and equipment
    Total assets $
    Liabilities
    Current liabilities:
    $
    Total liabilities $
    Stockholders' Equity
    Total stockholders' equity
    Total liabilities and stockholders' equity

Solutions

Expert Solution

Income Statement
Revenue
Fees Earned $           75,980
Total Revenue $           75,980
Expenses
Salary expense $           30,350
Supplies Expense $             3,590
Depreciation Expense $             2,140
Misc Expense $             3,220
Total Expenses $           39,300
Net Income $           36,680
Statement of Stockholder's Equity
Common Stock Retained Earnings Total
Beginning Balance $           13,000 $           28,120 $          41,120
Add Net Income $           36,680 $          36,680
$           13,000 $           64,800 $          77,800
Less Dividends $            (5,240) $          (5,240)
Ending Balance $           13,000 $           59,560 $         72,560
Balance Sheet
Assets
Current Assets
Cash $           16,930
Accounts Receivable $           40,310
Supplies $                 680
Total Current Assets $           57,920
Property, Plant and Equipment
Office Equipment $           32,650
   Less : Accumulated Depreciation $            (6,610)
Total Property, Plant and Equipment $           26,040
Total Assets $           83,960
Liabilities & Stockholder's Equity
Current Liabilities
Accounts Payable $           10,880
Salaries Payable $                 520
Total Current Liabilities $           11,400
Stockholder's Equity
Common Stock $           13,000
Retained Earnings $           59,560
Total Stockholder's Equity $           72,560
Total Liabilities & Stockholder's Equity $           83,960

Related Solutions

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 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 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...
Financial Statements from the End-of-Period Spreadsheet Bamboo Consulting is a consulting firm owned and operated by...
Financial Statements from the 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 Adjusted Trial Balance Adjustments Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 9,560 9,560 Accounts Receivable 22,770 22,770 Supplies 2,410 (a) 2,030 380 Office Equipment 18,220 18,220 Accumulated Depreciation 2,530 (b) 1,210 3,740 Accounts...
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)...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT