Question

Please create a balance sheet based on the following income and cash flow statements: for 2016...

Please create a balance sheet based on the following income and cash flow statements: 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 create balance sheet for 2016 based on above income statement and cash flow statement.

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

0 0
Add a comment Improve this question Transcribed image text
Answer #1

BALANCE SHEET FOR 2016 ASSETS AMOUNT LIABILITIES AMOUNT CURRENT ASSETS Cash 89,725.00 CURRENT LIABILITIES Accounts Payable In

Add a comment
Know the answer?
Add Answer to:
Please create a balance sheet based on the following income and cash flow statements: for 2016...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please create a balance sheet based on the following income and cash flow statements: PLEASE FILL...

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

  • (30 points) Financial Statements: Laiho Industries's 2014 and 2015 balance sheets in thousands of dollars) are...

    (30 points) Financial Statements: Laiho Industries's 2014 and 2015 balance sheets in thousands of dollars) are shown. Laiho Indus tries December 31 Balance Sheets (in thousands of dollars) 2015 2014 Assets Cas h Accounts receivable Inventories Total current assets Net fixed assets Total assets S 102,850 S 89,725 85,527 34,982 S 244,659 S 210,234 42,436 S 311,824 S 252,670 103,365 38,444 67,165 Liabilities and equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained...

  • 8) The latest balance sheet and income statement for Coleco Corporation are below: 2016 2017 Assets...

    8) The latest balance sheet and income statement for Coleco Corporation are below: 2016 2017 Assets Cash and equivalents 57,600 7.282 Accounts receivable 351,200 632,160 Inventories 715,200 1.287,360 Total current assets 1,124,000 1,926,802 Net fixed assets 344.800 939,790 Total Assets 1,467.800 2.866.592 - Liabilities and Equity Accounts payable Accruals Notes Payable Total current liabilities Long-term bonds Common Equity: Common stock (100,000 shares) Retained earnings Total common equity Total liabilities & equity 145,600 136,000 200.000 481,600 323,432 524,160 489,600 636,808 1,650,568...

  • Problem 1: Below are financial statements of FIN300.01 Inc: Balance Sheet: 12/31/17 Assets Cash and Marketable...

    Problem 1: Below are financial statements of FIN300.01 Inc: Balance Sheet: 12/31/17 Assets Cash and Marketable Securitics Accounts Reccivable Inventorics Total Current Asscts Net plant and equipment TOTAL ASSETS 2017 10 375 61.5 1,000 2016 80 31. 41.5 810 Liabilities and Equity Accounts Payable Notes Payable Accruals Total Current Liabilities Long Term Bonds TOTAL DEBT Preferred Stock Common Stock Retained carnings TOTAL COMMON EQUITY TOTAL LIABILITIES AND EQUITY 2017 140 110 310 2016 40 G0 130 230 1,064 40 130...

  • What was the free cash flow in 2017 for FIN 300 Inc.? Please show work. Balance...

    What was the free cash flow in 2017 for FIN 300 Inc.? Please show work. Balance Sheet: 12/31/17 Assets Cash and Marketable Securities Accounts Receivable Inventories Total Current Assets Net plant and equipment TOTAL ASSETS 2017 130 4875 7995 13000 13000 26000 2016 1040 4095 5395 10530 11310 21840 Liabilities and Equity Accounts Payable Notes Payable Accruals Total Current Liabilities Long Term Bonds TOTAL DEBT Preferred Stock Common Stock Retained earnings TOTAL COMMON EQUITY TOTAL LIABILITIES AND EQUITY 2017 780...

  • Begin with the partial model in the file Ch02 P14 Build a Model.xlsx on the textbook’s...

    Begin with the partial model in the file Ch02 P14 Build a Model.xlsx on the textbook’s Web site. The 2016 sales of Cumberland Industries were $455,000,000; operating costs (excluding depreciation) were equal to 85% of sales; net fixed assets were $67,000,000; depreciation amounted to 10% of net fixed assets; interest expenses were $8,550,000; the state-plus-federal corporate tax rate was 40%; and Cumberland paid 25% of its net income out in dividends. Given this information, construct Cumberland’s 2016 income statement. Also...

  • what was the free cash flow in 2017 for FIN300.01 Inc? 2016 10 Problem 1: Below...

    what was the free cash flow in 2017 for FIN300.01 Inc? 2016 10 Problem 1: Below are financial statements of FIN300.01 Inc.. Balance Sheet: 12/31/17 Assets 2017 Cash and Marketable Securities Accounts Receivable 375 Inventories 615 Total Current Assets 1,000 Net plant and equipment 1,000 TOTAL ASSETS 2,000 315 415 810 870 1,680 2017 60 140 110 310 754 1,064 2016 40 60 130 Liabilities and Equity Accounts Payable Notes Payable Accruals Total Current Liabilities Long Term Bonds TOTAL DEBT...

  • What was the free cash flow in 2017 for FIN300.01 Inc.? 2016 80 Problem 1: Below...

    What was the free cash flow in 2017 for FIN300.01 Inc.? 2016 80 Problem 1: Below are financial statements of FIN300.01 Inc.: Balance Sheet: 12/31/17 Assets 2017 Cash and Marketable Securities 10 Accounts Receivable 375 Inventories 615 Total Current Assets 1,000 Net plant and equipment 1.000 TOTAL ASSETS 2,000 315 415 810 870 1,680 2017 2016 40 60 60 580 Liabilities and Equity Accounts Payable Notes Payable Accruals Total Current Liabilities Long Term Bonds TOTAL DEBT Preferred Stock Common Stock...

  • The comparative balance sheet of Tru-Built Construction Inc. for December 31, 2016 and 2015, is as...

    The comparative balance sheet of Tru-Built Construction Inc. for December 31, 2016 and 2015, is as follows: Dec. 31, 2016 Dec. 31, 2015 Assets Cash $110 $35 Accounts receivable (net) 63 44 Inventories 39 24 Land 90 99 Equipment 50 38 Accumulated depreciation-equipment (14) (7) Total Assets $338 $233 Liabilities and Stockholders' Equity Accounts payable (merchandise creditors) $43 $35 Dividends payable 7 - Common stock, $10 par 22 11 Paid-in capital: Excess of issue price over par—common stock 55 27...

  • Statement of Cash Flows-Indirect Method The comparative balance sheet of Harris Industries Inc. at December 31,...

    Statement of Cash Flows-Indirect Method The comparative balance sheet of Harris Industries Inc. at December 31, 2014 and 2043, is as follows: Dec. 31, Dec. 31, 2014 2013 Assets Cash Accounts receivable (net) Inventories Prepaid expenses $443,240 665,280 887,880 $360,920 592,200 1,022,560 31,640 25,200 Land 302,400 302,400 Buildings 1,713,600 (466,200) 1,134,000 (414,540) Accumulated depreciation-buildings Machinery and equipment Accumulated depreciation-machinery and equipment 781,200 (214,200) 106,960 $4,251,800 781,200 (191,520) 112,000 $3,724,420 Patents Total assets $837,480 32,760 Liabilities and Stockholders' Equity Accounts payable...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT