Question
Please create a balance sheet based on the following income and cash flow statements: PLEASE FILL IN blank columm in balance sheet below for 2016
Please create a balance sheet based on the following income and cash flow statements:
PLEASE FILL IN blank columm in balance sheet below for 2016
Income Statement | 2016 | |
Sales | 655,150 | |
Expenses excluding depreciation and amortization | 386,878 | |
EBITDA | 268,272 | |
Depreciation and amortization | 7,388 | |
EBIT | 260,884 | |
Interest expense | 8,574 | |
EBT | 252,310 | |
Taxes (20%) | 20% | 50,462 |
Net income | 201,848 | |
Common dividends | 12,554 | |
Addition to retained earnings | 189,294 | |
Cash flow Statement | 2016 | |
Operating Activities | 203,409 | |
Net Income | 201,848 | |
Depreciation and amortization | 7,388 | |
Increase in accounts payable | 7,652 | |
Increase in accruals (wages, utilities etc.) | 7,821 | |
Increase in accounts receivable | -17,838 | |
Increase in inventories | -3,462 | |
Net cash provided by operating activities | ||
Investing Activities | -32,117 | |
Addition to property, plant, and equipment | -32,117 | |
Financing activities | 12,296 | |
Increase in notes payable | 2,500 | |
Increase in long-term debt | 12,350 | |
Increase in common stock | 10,000 | |
Payment of common dividends | -12,554 | |
Net change in cash | 183,588 |
Balance sheet for 2015 is below- Please give all numbers below but for year 2016- Balance sheet for 2016
Assets
----Current Assets 210,234 Cash 89,725 Accounts Receivable 85,527 Inventories 34,982 Net Fixed Assets 42,436 ------Total Assets 252,670 Liabilities and Equity
----Current Liabilities 59,982 Accounts Payable 23,109 Accruals (wages, utilities etc.) 22,656 Notes Payable 14,217 Long-term Debt 63,914 Shareholder's Equity
Common Stock 90,000 Retained Earnings 38,774
Total Liabilities and Equity 252,670
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