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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started