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 12,470           12,470   Accounts Receivable 29,690           29,690   Supplies 3,150         2,640 510   Land 25,240           25,240   Office Equipment 23,750           23,750   Accumulated Depreciation   3,300       1,570   4,870 Accounts Payable   8,020           8,020 Salaries Payable           390   390 Common Stock   10,000           10,000 Retained Earnings   20,280           20,280 Dividends 3,860           3,860   Fees Earned   80,610           80,610 Salary Expense 21,670     390     22,060   Supplies Expense       2,640     2,640   Depreciation Expense       1,570     1,570   Miscellaneous Expense 2,380           2,380     122,210 122,210

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question
100%

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 12,470           12,470  
Accounts Receivable 29,690           29,690  
Supplies 3,150         2,640 510  
Land 25,240           25,240  
Office Equipment 23,750           23,750  
Accumulated Depreciation   3,300       1,570   4,870
Accounts Payable   8,020           8,020
Salaries Payable           390   390
Common Stock   10,000           10,000
Retained Earnings   20,280           20,280
Dividends 3,860           3,860  
Fees Earned   80,610           80,610
Salary Expense 21,670     390     22,060  
Supplies Expense       2,640     2,640  
Depreciation Expense       1,570     1,570  
Miscellaneous Expense 2,380           2,380  
  122,210 122,210   4,600   4,600 124,170 124,170
Office equipment
Accumulated depreciation
Book value-office equipment
Total property, plant, and equipment
Total assets
Current liabilities:
Accounts payable
Salaries payable
Total liabilities
Common stock
Retained earnings
Total stockholders' equity
Total liabilities and stockholders' equity
Feedback
20,910 X
-4,180 X
Liabilities
Stockholders' Equity
16,730 X
6,890 X
330 X
12,000 X
59,740 X
$
38,920 X
78,960 X
7,220 X
71,740 X
78,960 X
✓ Check My Work
Assets (including contra-assets like Accumulated Depreciation), liabilities, and the Retained Earnings Account flow into the balance sheet.
Transcribed Image Text:Office equipment Accumulated depreciation Book value-office equipment Total property, plant, and equipment Total assets Current liabilities: Accounts payable Salaries payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity Feedback 20,910 X -4,180 X Liabilities Stockholders' Equity 16,730 X 6,890 X 330 X 12,000 X 59,740 X $ 38,920 X 78,960 X 7,220 X 71,740 X 78,960 X ✓ Check My Work Assets (including contra-assets like Accumulated Depreciation), liabilities, and the Retained Earnings Account flow into the balance sheet.
Based on the preceding spreadsheet, prepare a balance sheet for Demo Consulting.
Demo Consulting
Balance Sheet
August 31, 20Y9
Current assets:
Cash
Accounts receivable
Supplies
✓
Total current assets
Property, plant, and equipment:
Land
Office equipment
Accumulated depreciation
Book value-office equipment
✓
Total assets
Total property, plant, and equipment
Current liabilities:
Accounts payable
Salaries payable
✓
Assets
20,910 X
-4,180 X
Liabilities
14,110 X
25,500 X
430 X
22,190 X
16,730 X
6,890 X
330 X
40,040 X
38,920 X
78,960 X
Transcribed Image Text:Based on the preceding spreadsheet, prepare a balance sheet for Demo Consulting. Demo Consulting Balance Sheet August 31, 20Y9 Current assets: Cash Accounts receivable Supplies ✓ Total current assets Property, plant, and equipment: Land Office equipment Accumulated depreciation Book value-office equipment ✓ Total assets Total property, plant, and equipment Current liabilities: Accounts payable Salaries payable ✓ Assets 20,910 X -4,180 X Liabilities 14,110 X 25,500 X 430 X 22,190 X 16,730 X 6,890 X 330 X 40,040 X 38,920 X 78,960 X
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Financial Statements
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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education