In this exercise, you will create an income statement, statement of owner’s equity, and balance sheet in Excel for Dragon, Inc. With the exception of the William Moss, Capital account (the balance for which is from 8/1/2016), the company had the following account balances as of 8/31/2016:
Supplies Expense |
$1,800 |
Cash |
$65,300 |
William Moss, Capital – 8/1/2016 |
$73,200 |
Sales Revenue |
$33,000 |
Land |
$20,000 |
Accounts Payable |
$3,000 |
Accounts Receivable |
$1,600 |
Equipment |
$12,000 |
Utilities Expense |
$1,900 |
Telephone Expense |
$2,000 |
Office Expense |
$2,100 |
Auto Expense |
$4,400 |
Service Revenue |
$6,100 |
William Moss, Drawing |
$4,200 |
In this exercise, you will create an income statement, statement of owner’s equity, and balance sheet...
In this exercise, you will create an income statement, statement of owner’s equity, and balance sheet in Excel for Ampersand Co. With the exception of the Robert Benjamin, Capital account (the balance for which is from 2/1/2016), the company had the following account balances as of 2/29/2016: Notes Payable $1,200 Service Revenue $26,600 Robert Benjamin, Drawing $1,500 Furniture $4,800 Building $18,000 Robert Benjamin, Capital – 2/1/2016 $16,300 Telephone Expense $3,000 Accounts Receivable $7,200 Office Expense $3,400 Utilities Expense $2,200 Interest...
Part 1: (See photo) prepare finacial statements: income statement, statement of owners equity, and balance sheet. Then: perform ratio analysis a. current ratio b. quick ratio c. debt ratio d. equity ratio e. debt to equity ratio f. profit margin for each reporting period part 2: summarize the firms finacial position based on information in part 1 Extend Your Skills 63 Extend Your Skills EA2-E1 Create Financial Statements for Frozen Fractals Corp. In this exercise, you will create an income...
Extend You Extend Your Skills EA2-E1 Create Financial Statements for Frozen Fractals Corp. In this exercise, you will create an income statement, statement of owner's equity, and balance sheet in Excel for Frozen Fractals Corp. With the exception of the Jacqueline Elise, Capital account (the balance for which is from 12/1/2016), the company had the following account balances as of 12/31/2016. Accounts Payable Accounts Receivable Auto Expense Cash Furniture $27,000 $4,000 $8,500 $41,000 Land $6,000 $4,100 Office Expense S9,400 Rent...
1. The balance sheet should be prepared a.after the income statement and the statement of owner’s equity b.before the income statement and after the statement of owner’s equity c.before the income statement and the statement of owner’s equity d.after the income statement and before the statement of owner’s equity 2. Which of the following accounts will not be closed to the capital account at the end of the year? a.Fees Earned b.Insurance Expense c.Prepaid Insurance d.Utilities Expense
Income statement, Statement of Owner’s Equity, and Balance sheet 1. Prepare a Multiple-step income statement 2. Prepare a statement of owners equity 3. Prepare a balance sheet Paulsons pet store completed the work sheet below for the year ended dec. 31, 20–. Owners equity as of January 1,20–, was $22,696. The current portion of mortgage payable is $536. Paulson's Pet Store Work Sheet For Year Ended December 31, 20 - TRIAL BALANCE DEBIT CREDIT DEBIT CREDITDEBIT 15,872 ADJUSTMENTSADJUSTED TRIAL BALANCE...
Complete the Income Statement, Statement of Owner's Equity and Balance Sheet for Help Today company. Fill in the templates... Exercise 2-16 HELP TODAY Income Statement For Month Ended August 31 Revenues Consulting fees earned $ Expenses Rent expense $ Salaries expense Telephone expense Miscellaneous expenses ______ Total expenses ______ Net income $ Exercise 2-17 HELP TODAY Statement of Owner’s Equity For Month Ended August 31 C. Camry, Capital, July 31 $ 0 Add: Investment by owner 102,000 Net income (from...
Using the Adjusted Trial Balance, complete the Income Statement, Statement of Owner's Equity, and Balance Sheet. Enter any decreases with a minus sign or parentheses SMART TOUCH LEARNING Adjusted Trial Balance December 31, 2016 Balance Account Title Debit Credit Cash 19,200 Accounts Receivable 10,600 Office Supplies 200 Expenses: Prepaid Rent 12,800 Furniture 22,500 7.700 Accounts Payable Salaries Payable Interest Payable 2,500 600 300 Total Expenses Unearned Revenue 6,400 9,000 25,400 Net Income Notes Payable Bright, Capital Bright, Withdrawals 32,700 Service...
Income Statement Balance Sheet Journal Entries OUTSIDE, INC. Balance Sheet December 31 $ $ Assets Cash Accounts Receivable Supplies Prepaid Insurance Office Equipment Less: Accum. Depreciation (enter as a negative) 5,400 19,000 4,200 930 Liabilities Accounts Payable Unearned Subscription Revenue Salaries Payable Total Liabilities 17,000 10,000 3,500 30,500 70,000 (13,000) 57,000 Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity 86,530 Total Liabilities and Stockholders' Equity $ 21,000 17,620 X 38,620 X 69,120 X Total Assets $ Check Outside, Inc....
Prepare the Income Statement, the Statement of Stockholders Equity, the Classified Balance Sheet, and the Closing Entries using the adjusted trial balance for Stockton Company. Paragraph Styles Problem Two Prepare the Income Statement, the Statement of Stockholders' Equity, the Classified Balance Sheet, and the Closing Entries using the adjusted trial balance for Stockton Company. Stockton Company Adjusted Trial Balance For the Year ended December 31, 2018 $ 5,030 2,100 700 10,000 13,700 Cash Accounts Receivable Prepaid Expenses Land Equipment Accumulated...
Requirement: Using this adjusted trial balance, complete an income statement, a statement of retained earnings, and a balance sheet. Make sure all three are in good form. Bertrand Irrigation System Adjusted Trial Balance December 31, 2018 Balance Account Title Debit Credit Cash $12,000 Accounts Receivable 46,200 Office Supplies 17,700 Prepaid Insurance 4,600 Building 58,000 Accumulated Depreciation—Building $24,300 Equipment 26,000 Accumulated Depreciation—Equipment 7,600 Accounts Payable 27,100 Interest Payable 1,800...