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
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
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 |
|
(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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Business/Professional Ethics Directors/Executives…
Accounting
ISBN:
9781337485913
Author:
BROOKS
Publisher:
Cengage
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Business/Professional Ethics Directors/Executives…
Accounting
ISBN:
9781337485913
Author:
BROOKS
Publisher:
Cengage
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
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…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning