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 750 Office Equipment 32,000 32,000 Accumulated Depreciation 4,500 900 5,400 Accounts Payable 3,350 3,350 Salaries Payable 2,000 2,000 Common Stock 20,000 20,000 Retained Earnings 52,200 52,200 Dividends 10,000 10,000 Fees Earned 279,000 279,000 Salary Expense 240,000 2,000 242,000 Supplies Expense 1,650 1,650 Depreciation Expense 900 900 Miscellaneous Expense 2,000 2,000 359,050 359,050 4,550 4,550 361,950 361,950

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 10M
icon
Related questions
icon
Concept explainers
Question
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 vwas 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
750
Office Equipment
32,000
32,000
Accumulated Depreciation
4,500
900
5,400
Accounts Payable
3,350
3,350
Salaries Payable
2,000
2,000
Common Stock
20,000
20,000
Retained Earnings
52,200
52,200
Dividends
10,000
10,000
Fees Earned
279,000
279,000
Salary Expense
240,000
2,000
242,000
Supplies Expense
1,650
1,650
Depreciation Expense
900
900
Miscellaneous Expense
2,000
2,000
359,050
359,050
4,550
4,550
361,950
361,950
Transcribed Image Text: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 vwas 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 750 Office Equipment 32,000 32,000 Accumulated Depreciation 4,500 900 5,400 Accounts Payable 3,350 3,350 Salaries Payable 2,000 2,000 Common Stock 20,000 20,000 Retained Earnings 52,200 52,200 Dividends 10,000 10,000 Fees Earned 279,000 279,000 Salary Expense 240,000 2,000 242,000 Supplies Expense 1,650 1,650 Depreciation Expense 900 900 Miscellaneous Expense 2,000 2,000 359,050 359,050 4,550 4,550 361,950 361,950
Based on the preceding spreadsheet, prepare statement of stockholders' equity for Triton Consulting. If no entry is required, leave the amount box blank or "0". 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
Balances, May 1, 20Y2 V
Issued common stock v
Net income v
Dividends v
Balances, April 30, 20Y3 V
Transcribed Image Text:Based on the preceding spreadsheet, prepare statement of stockholders' equity for Triton Consulting. If no entry is required, leave the amount box blank or "0". 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 Balances, May 1, 20Y2 V Issued common stock v Net income v Dividends v Balances, April 30, 20Y3 V
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,