Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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,990 10,990
Accounts Receivable 26,160 26,160
Supplies 2,770 2,330 440
Land 22,240 22,240
Office Equipment 20,930 20,930
Accumulated Depreciation 2,900 1,390 4,290
Accounts Payable 7,060 7,060
Salaries Payable 340 340
Common Stock 8,800 8,800
Retained Earnings 17,880 17,880
Dividends 3,400 3,400
Fees Earned 71,300 71,300
Salary Expense 19,360 340 19,700
Supplies Expense 2,330 2,330
Depreciation Expense 1,390 1,390
Miscellaneous Expense 2,090 2,090
107,940 107,940 4,060 4,060 109,670 109,670

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

Demo Consulting
Income Statement
For the Year Ended August 31, 20Y9
Cash $fill in the blank 5541d9f97f90fec_2
Expenses:
$fill in the blank 5541d9f97f90fec_4
fill in the blank 5541d9f97f90fec_6
fill in the blank 5541d9f97f90fec_8
fill in the blank 5541d9f97f90fec_10
Total expenses fill in the blank 5541d9f97f90fec_11
$fill in the blank 5541d9f97f90fec_13

Based on the preceding spreadsheet, prepare a statement of stockholders equity for Demo Consulting. During the year ended August 31, 20Y9, $3,500 of additional common stock 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.

Demo Consulting
Statement of Stockholders Equity
For the Year Ended August 31, 20Y9
Common Stock Retained Earnings Total
$fill in the blank a40923096069074_2 $fill in the blank a40923096069074_3 $fill in the blank a40923096069074_4
fill in the blank a40923096069074_6 fill in the blank a40923096069074_7 fill in the blank a40923096069074_8
fill in the blank a40923096069074_10 fill in the blank a40923096069074_11 fill in the blank a40923096069074_12
fill in the blank a40923096069074_14 fill in the blank a40923096069074_15 fill in the blank a40923096069074_16
$fill in the blank a40923096069074_18 $fill in the blank a40923096069074_19 $fill in the blank a40923096069074_20

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

Demo Consulting
Balance Sheet
August 31, 20Y9
Assets
Current assets:
$fill in the blank 180344fc905906f_2
fill in the blank 180344fc905906f_4
fill in the blank 180344fc905906f_6
Total current assets $fill in the blank 180344fc905906f_7
Property, plant, and equipment:
$fill in the blank 180344fc905906f_9
$fill in the blank 180344fc905906f_11
fill in the blank 180344fc905906f_13
fill in the blank 180344fc905906f_15
Total property, plant, and equipment fill in the blank 180344fc905906f_16
Total assets $fill in the blank 180344fc905906f_17
Liabilities
Current liabilities:
$fill in the blank 180344fc905906f_19
fill in the blank 180344fc905906f_21
Total liabilities $fill in the blank 180344fc905906f_22
Stockholders' Equity
$fill in the blank 180344fc905906f_24
fill in the blank 180344fc905906f_26
Total stockholders' equity fill in the blank 180344fc905906f_27
Total liabilities and stockholders' equity $fill in the blank 180344fc905906f_28

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Accounting

Authors: Fred Phillips, Robert Libby, Patricia Libby

5th edition

78025915, 978-1259115400, 1259115402, 978-0078025914

Students also viewed these Accounting questions