In this exercise, you will create an income statement, statement of owner’s equity, and balance sheet...

Question

Question

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 Expense	$1,700	Interest Revenue	$300
Cash	$2,600

business accounting

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Add a comment

Answer 2

Similar Homework Help Questions

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 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...
Extend You Extend Your Skills EA2-E1 Create Financial Statements for Frozen Fractals Corp. In this exercise,...

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...
Part 1: (See photo) prepare finacial statements: income statement, statement of owners equity, and balance sheet....

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...

1. The balance sheet should be prepared a.after the income statement and the statement of owner’s...

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
For the accounts listed below, identify the type of account (asset, liability, owner’s capital, owner’s drawing,...

For the accounts listed below, identify the type of account (asset, liability, owner’s capital, owner’s drawing, revenue, or expense), the normal balance (debit or credit), and which financial statement you would find the account on (income statement, owner’s equity statement, or balance sheet). Type of Account Normal Balance Financial Statement A Cash B Accounts Payable C Rent Expense D Accumulated Depreciation E Interest Revenue F Notes Payable G Advertising Expense H Owner's Drawings I Equipment J Owner's Capital K Sales...
Prepare the Statement of Retained Earnings from the Adjusted Trial Balance and Income Statement. Within each...

Prepare the Statement of Retained Earnings from the Adjusted Trial Balance and Income Statement. Within each section of the statement, use the drop-down menus to enter the accounts in Chart of Accounts order and select the account balances. Prepare the Statement of Retained Earnings from the Adjusted Trial Balance and Income Statement. Within each section of the statement, use the drop-down menus to enter the accounts in Chart of Accounts order and select the account balances. SMART TOUCH LEARNING SMART...

Using the Adjusted Trial Balance, complete the Income Statement, Statement of Owner's Equity, and Balance Sheet....

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, Statement of Owner’s Equity, and Balance sheet 1. Prepare a Multiple-step income statement 2....

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...
trial balance adjusting entries income owners equity cash flows balance sheet solve each page (Part 3)...

trial balance adjusting entries income owners equity cash flows balance sheet solve each page (Part 3) Honors Accounting~Case 7.2 Part 1 JournalEntries 1 Cash 25,000 Briggs, capital Prepaid rent Cash Office supplies Cash Office furniture 25,000 5,400 5,400 900 900 8 4,800 4,800 Accounts payable Advertising expense Cash Accounts receivable Fees earned 10 250 250 12 850 850 15 Cash 350 350 Fees earned Insurance expense Cash 18 300 300 20 Cash 5,000 Unearned fees 5,000 21 Cash 200 200...

Presented below are the 2021 income statement and comparative balance sheet me statement and comparative balance...

Presented below are the 2021 income statement and comparative balance sheet me statement and comparative balance sheets for Santana Industries. P4-11 Statement of cash flows; indirect method • L04-8 $ 17,650 SANTANA INDUSTRIES Income Statement For the Year Ended December 31, 2021 ($ in thousands) Sales revenue $14,250 Service revenue 3,400 Total revenue Operating expenses: Cost of goods sold 7,200 Selling expense 2,400 General and administrative expense 1,500 Total operating expenses Operating income Interest expense Income before income taxes Income...

In this exercise, you will create an income statement, statement of owner’s equity, and balance sheet...

Homework Answers