Balance sheet Cash Accounts receivables Inventories Prepaid advertising Beginning Ending Changes 440.00 562.00 100.00 120.00 123.00 191.00 82.00 98.00 Net PP&E 700.00 779.00 = Total assets 1445.00 1750.00 Accounts payable to suppliers of inventories 65.00 105.00 Salary payable to salespeople 51.00 81.00 Advance received [Unearned revenue] 78.00 85.00 Interest payable 12.00 22.00 Debt: Principal Taxes payable = Total liabilities Paid-in capital Retained earnings = Total equity |= Total liabilities + Total equity Income statement Sales revenue Cost of merchandize sold Advertising expense Salary expense Depreciation expense Operating income Interest expense = Earnings before taxes Tax expense = Net income 300.00 350.00 15.00 19.00 521.00 662.00 500.00 545.00 424.00 543.00 924.00 1088.00 1445.00 1750.00 For the year 1500.00 450.00 225.00 340.00 132.00 353.00 78.00 275.00 110.00 165.00

Business/Professional Ethics Directors/Executives/Acct
8th Edition
ISBN:9781337485913
Author:BROOKS
Publisher:BROOKS
Chapter8: Subprime Lending Fiasco-ethics Issues
Section: Chapter Questions
Problem 3.7EC
icon
Related questions
Question
Cash received from customers
 
Cash of goods(purchased): Put minus sign in front of outflows
 
Cash (paid) to suppliers: Put minus sign in front of outflows
 
Cash (paid) for advertising: Put minus sign in front of outflows
 
Cash (paid) for salaries: Put minus sign in front of outflows
 
Cash (paid) for interest: Put minus sign in front of outflows
 
Cash (paid) for taxes: Put minus sign in front of outflows
 
US GAAP Operating cash flow
 
(Capital expenditures): Put minus sign in front of outflows
 
Net proceeds from debt
 
Net capital contributions
 
(Dividends): Put minus sign in front of outflows

please help me find these using the data in the excel. I need help

Balance sheet
Cash
Accounts receivables
Inventories
Prepaid advertising
Beginning
Ending Changes
440.00
562.00
100.00
120.00
123.00
191.00
82.00
98.00
Net PP&E
700.00
779.00
= Total assets
1445.00
1750.00
Accounts payable to suppliers of inventories
65.00
105.00
Salary payable to salespeople
51.00
81.00
Advance received [Unearned revenue]
78.00
85.00
Interest payable
12.00
22.00
Debt: Principal
Taxes payable
= Total liabilities
Paid-in capital
Retained earnings
= Total equity
|= Total liabilities + Total equity
Income statement
Sales revenue
Cost of merchandize sold
Advertising expense
Salary expense
Depreciation expense
Operating income
Interest expense
= Earnings before taxes
Tax expense
= Net income
300.00
350.00
15.00
19.00
521.00
662.00
500.00
545.00
424.00
543.00
924.00
1088.00
1445.00
1750.00
For the year
1500.00
450.00
225.00
340.00
132.00
353.00
78.00
275.00
110.00
165.00
Transcribed Image Text:Balance sheet Cash Accounts receivables Inventories Prepaid advertising Beginning Ending Changes 440.00 562.00 100.00 120.00 123.00 191.00 82.00 98.00 Net PP&E 700.00 779.00 = Total assets 1445.00 1750.00 Accounts payable to suppliers of inventories 65.00 105.00 Salary payable to salespeople 51.00 81.00 Advance received [Unearned revenue] 78.00 85.00 Interest payable 12.00 22.00 Debt: Principal Taxes payable = Total liabilities Paid-in capital Retained earnings = Total equity |= Total liabilities + Total equity Income statement Sales revenue Cost of merchandize sold Advertising expense Salary expense Depreciation expense Operating income Interest expense = Earnings before taxes Tax expense = Net income 300.00 350.00 15.00 19.00 521.00 662.00 500.00 545.00 424.00 543.00 924.00 1088.00 1445.00 1750.00 For the year 1500.00 450.00 225.00 340.00 132.00 353.00 78.00 275.00 110.00 165.00
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Business/Professional Ethics Directors/Executives…
Business/Professional Ethics Directors/Executives…
Accounting
ISBN:
9781337485913
Author:
BROOKS
Publisher:
Cengage
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage