Sased on the pricading spradsht, prepare a slatument of slackholdes quaty lor Damo Consullng. During the yar indid Auguil 11, 209, S3,400 a aditional common slock wis d. an amount box dos not nequare an intry, lav it Blank. a t ls curred or drvdinds wire pad, entir that amount as a negative number ng a minui sgn Dema Consulting Statement of Stockholders Equity For the Year Ended August 31, 20Y9 Comman Stock Retained tarnings Total Balances, September 1, 20Y8 Issued common stock Nut income Dividends Balances, August 31, 20Y9 Faadhack TCheck My The statement of stockholiders equity shows the beginning balances of common stock and retained earnings. The common stock balance will be increased by any stock issuid during the periad, and retained earmings will be increased by any net income and decreased by any net losses and dividends Based on the preceding spreadshoet, prepare a balance sheet for Demo Consulting. Dema Consualting Balance Shest August 31, 20Y9 Assts Current assets: Cash 10,710 Accounts receivable 25,s00 Supplies 430 Total current ats 36640 Property, plant, and equipment: Land 22,190 Office equipment 20,910 Accumulated dupreciation 4,10 Boak value-office equipmant Total property, plant, and aquipment Tetal assets s gen Crint abiliti Accounts payable Salaries payable Total habilites 7.220 Stocholer Equity Common stock Retained earmings Total stockholders equity Tetal bablites and stockholders equity

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 1M: The general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to...
icon
Related questions
Question
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, 20V9:
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,710
10,710
Accounts Receivable
25,500
25,500
Supplies
2,700
2,270
430
Land
22,190
22,190
Office Equipment
20,910
20,910
Accumulated Depreciation
2,830
1,350
4,180
Accounts Payable
6,890
6,890
Salaries Payable
330
330
Common Stock
8,600
8,600
Retained Earnings
17,410
17,410
Dividends
3,320
3,320
Fees Earned
70,770
70,770
Salary Expense
19,130
330
19,460
Supplies Expense
2,270
2,270
Depreciation Expense
1,350
1,350
Miscellaneous Expense
2,040
2,040
106,500
106,500
3,950
3,950
108,180
108,180
Based on the preceding spreadsheet, prepare an income statement for Demo Consulting.
Demo Consulting
Income Statement
For the Year Ended August 31, 20Y9
Fees earned v
70,770
Expenses:
Salary expense
19,460
Supplies expense
2,270
Depreciation expense
1,350
Miscellaneous expense v
2,040
Total expenses
25,120
Net income
45,650
Transcribed Image Text: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, 20V9: 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,710 10,710 Accounts Receivable 25,500 25,500 Supplies 2,700 2,270 430 Land 22,190 22,190 Office Equipment 20,910 20,910 Accumulated Depreciation 2,830 1,350 4,180 Accounts Payable 6,890 6,890 Salaries Payable 330 330 Common Stock 8,600 8,600 Retained Earnings 17,410 17,410 Dividends 3,320 3,320 Fees Earned 70,770 70,770 Salary Expense 19,130 330 19,460 Supplies Expense 2,270 2,270 Depreciation Expense 1,350 1,350 Miscellaneous Expense 2,040 2,040 106,500 106,500 3,950 3,950 108,180 108,180 Based on the preceding spreadsheet, prepare an income statement for Demo Consulting. Demo Consulting Income Statement For the Year Ended August 31, 20Y9 Fees earned v 70,770 Expenses: Salary expense 19,460 Supplies expense 2,270 Depreciation expense 1,350 Miscellaneous expense v 2,040 Total expenses 25,120 Net income 45,650
Based on the preceding spreadsheet, prepare a statement of stockholders equity for Demo Consulting. During the year ended August 31, 20Y9, s3,400 of additional common stock was issued. Ir an amount box does net require an entry, leave it blank. If a net loss is incurred or dividends wire paid, enter that amount as a negative number using a minus sign.
Demo Consulting
Statement of Stockholders' Equity
For the Year Ended August 31, 20Y9
Common Stock Rutained Earnings
Total
Balances, September 1, 20YBV
Issued common stock
Net income v
Dividends
Balances, August 31, 20Y9
Feadtack
TCheck My War
The statement of stockholders' equity shows Lhe beginning balances of common stock and retained earnings. The common stock balance will be increased by any stock issuid during the period, and retained eanings will be increased by any net income and decreased by any net losses and dividends
Based on the preceding spradshoet, propare a balance sheet for Demo Conulting.
Demo Consulting
Balance Sheet
August 31, 20Y9
Asts
Current assets:
Cash
10,710
Accounts receivable
25.50
Supplies
430
Total current assets
36,640
Property, plare, and equipment
:
Land
22,190
Office equipment
20,910
Accumulated depreciation
4,10
Book value-office equipment
16,730
Total property, plant, and equipment
Total assets
Current liabities:
Accounts payable
Salaries payable
130
Tetal kabilities
7,220
Stockholers Equty
Common stock
Retained earnings
Total stockholders equity
Total habilts and stockholders equity
Transcribed Image Text:Based on the preceding spreadsheet, prepare a statement of stockholders equity for Demo Consulting. During the year ended August 31, 20Y9, s3,400 of additional common stock was issued. Ir an amount box does net require an entry, leave it blank. If a net loss is incurred or dividends wire paid, enter that amount as a negative number using a minus sign. Demo Consulting Statement of Stockholders' Equity For the Year Ended August 31, 20Y9 Common Stock Rutained Earnings Total Balances, September 1, 20YBV Issued common stock Net income v Dividends Balances, August 31, 20Y9 Feadtack TCheck My War The statement of stockholders' equity shows Lhe beginning balances of common stock and retained earnings. The common stock balance will be increased by any stock issuid during the period, and retained eanings will be increased by any net income and decreased by any net losses and dividends Based on the preceding spradshoet, propare a balance sheet for Demo Conulting. Demo Consulting Balance Sheet August 31, 20Y9 Asts Current assets: Cash 10,710 Accounts receivable 25.50 Supplies 430 Total current assets 36,640 Property, plare, and equipment : Land 22,190 Office equipment 20,910 Accumulated depreciation 4,10 Book value-office equipment 16,730 Total property, plant, and equipment Total assets Current liabities: Accounts payable Salaries payable 130 Tetal kabilities 7,220 Stockholers Equty Common stock Retained earnings Total stockholders equity Total habilts and stockholders equity
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
Consolidations
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
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,