Question

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

0 0
Add a comment Improve this question Transcribed image text
Answer #1
2015 2016
Assets
----Current Assets
Cash 89,725 273313
Accounts Receivable 85,527 103365
Inventories 34,982 38444
Net Fixed Assets 42,436 67165
------Total Assets 252,670 482,287
Liabilities and Equity
-------Current Liabilities
Accounts Payable 23,109 30761
Accruals (wages, utilities etc.) 22,656 30477
Notes Payable 14,217 16717
Long-term Debt 63,914 76264
Shareholder's Equity
Common Stock 90,000 100000
Retained Earnings 38,774 228068
Total Liabilities and Equity 252,670 482,287
Add a comment
Know the answer?
Add Answer to:
Please create a balance sheet based on the following income and cash flow statements: PLEASE FILL...
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: 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.)...

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

  • Fill the missing value for common stock, retainer earnings, total common equity, and total liabilities and...

    Fill the missing value for common stock, retainer earnings, total common equity, and total liabilities and equity. show steps and how to get the answer. 35 b. Cumberland Industries' partial balance sheets are shown below. Cumberland issued $10,000,000 of new common stock in the most recent year. Using this information and the results from part a, fill in the missing values for 37 common stock, retained earnings, total common equity, and total liabilities and equity. 40 Dollar value of common...

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

  • lookign to have a b c completed F92 6 Balance Sheets 7 (in thousands of dollars)...

    lookign to have a b c completed F92 6 Balance Sheets 7 (in thousands of dollars) 2013 2012 9 Assets S91,450 $11,400 103,365 $38,444 $244,659 $67,165 311,824 $74,625 15,100 $85,527 34,982 $210,234 $42,436 $252,670 Cash and cash equivalents 11 Short-term investments 2 Accounts Receivable 4 Total current assets 15 Net fixed assets 16 Total assets 17 18 Liabilities and equity 19 Accounts payable 20 Accruals 21 Notes payable 22 Total current liabilities 23 Long-term debt 4 Total liabilities 25 Common...

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

  • The balance sheet and income statement shown below are for Pettijohn Inc. Note that the firm...

    The balance sheet and income statement shown below are for Pettijohn Inc. Note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over. Balance Sheet (Millions of $) Assets 2016 Cash and securities $ 1,554.0 Accounts receivable 9,660.0 Inventories 13,440.0 Total current assets $24,654.0 Net plant and equipment 17,346.0 Total assets $42,000.0 Liabilities and Equity Accounts payable...

  • FINANCIAL STATEMENTS The Davidson Corporation's balance sheet and income statement are provided here. Davidson Corporation: Balance...

    FINANCIAL STATEMENTS The Davidson Corporation's balance sheet and income statement are provided here. Davidson Corporation: Balance Sheet as of December 31, 2016 (Millions of Dollars) Assets Liabilities and Equity Cash and equivalents $10    Accounts payable $130 Accounts receivable 545    Accruals 210 Inventories 890    Notes payable 230   Total current assets $1,445      Total current liabilities $570 Net plant and equipment 2,495    Long-term bonds 1,520      Total liabilities $2,090    Common stock (100 million shares) 250    Retained...

  • FINANCIAL STATEMENTS The Davidson Corporation's balance sheet and income statement are provided here. Davidson Corporation: Balance...

    FINANCIAL STATEMENTS The Davidson Corporation's balance sheet and income statement are provided here. Davidson Corporation: Balance Sheet as of December 31, 2016 (Millions of Dollars) Assets Liabilities and Equity Cash and equivalents $15    Accounts payable $110 Accounts receivable 495    Accruals 230 Inventories 870    Notes payable 220   Total current assets $1,380      Total current liabilities $560 Net plant and equipment 2,440    Long-term bonds 1,490      Total liabilities $2,050    Common stock (100 million shares) 270    Retained...

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
ADVERTISEMENT