Question

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

  1. 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 calculate total dividends and the addition to retained earnings. (Hint: Start with the partial model in the file and report all dollar figures in thousands to reduce clutter.)resource

  2. The partial balance sheets of Cumberland Industries are shown here. Cumberland issued $10,000,000 of new common stock in 2016. Using this information and the results from Part a, fill in the missing values for common stock, retained earnings, total common equity, and total liabilities and equity.

    Cumberland Industries: Balance Sheets as of December 31 (Thousands of Dollars)

    2016 2015 Assets Cash Short-term investments Accounts receivable Inventories Total current assets Net fixed assets Total asse

  3. Construct the statement of cash flows for 2016.

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

ANSWER

Cumberland Industries 455000000 Statement for Income For the period ending 31.12.2016 Sales Less: Operating Expenses Deprecia

__________________________________

If you have any query or any Explanation please ask me in the comment box, i am here to helps you.please give me positive rating.

*****************THANK YOU*************

Add a comment
Know the answer?
Add Answer to:
Begin with the partial model in the file Ch02 P14 Build a Model.xlsx on the textbook’s...
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
  • Spreadsheet Problems 2-18 Start with the partial model in the file Ch 02 Build a Model.xlsx...

    Spreadsheet Problems 2-18 Start with the partial model in the file Ch 02 Build a Model.xlsx at the textbook's website. Build a Model: Cumberland Industries' most recent balance sheets (in thousands of dollars) are shown Financial Statements, below and in the partial model in the file: EVA, and MVA 2015 2014 Cash Short-term investments Accounts receivable Inventories Total current assets Net fixed assets Total assets Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common steck $...

  • 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 P20 Build a Model.xlsx on the textbook's...

    Begin with the partial model in the file Ch02 P20 Build a Model.xlsx on the textbook's Web site a. Britton String Corp. manufactures specialty strings for musical instruments and tennis racquets. Its most recent sales were $880 million; operating costs (excluding depreciation) were equal to 85% of sales; net fixed assets were $300 million; depreciation amounted to 10% of net fixed assets, interest expenses were $22 million; the state-plus-federal corporate tax rate was 25%; and it paid 40% of its...

  • 2-19 Begin with the partial model in the file Ch02 Build a Model.xlsx on the textbook's...

    2-19 Begin with the partial model in the file Ch02 Build a Model.xlsx on the textbook's website. Build a Model: Free a. Using the financial statements shown below for Lan & Chen Technologies, calculate net Cash Flows, EVA, operating working capital, total net operating capital, net operating profit after taxes, and MVA free cash flow, and return on invested capital for 2016. (Hint: Start with the partial model in the file and report all dollar figures in thousands to reduce...

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

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

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

  • 3. Andrea Aerospace's 2018 and 2017 balance sheets (in thousands of dollars) are shown. Andrea Aerospace...

    3. Andrea Aerospace's 2018 and 2017 balance sheets (in thousands of dollars) are shown. Andrea Aerospace December 31 Balance Sheets (in thousands of dollars) 2018 2017 s Assets Cash Accounts receivable Inventories Total current assets Net fixed assets Total assets 102.850 103,365 38.444 244,659 67,165 311.824 s $ 89.725 85.527 34,982 $ 210.234 42,436 $ 252.670 $ Liabilities and equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earings Total common equity Total...

  • 431428470293373958327&eISBN=9781337911009&id=705774549&snapshotid=15798828 mnts, Cash Flow, and Taxes Comprehensive/Spreadsheet Problem 3-19. FINANCIAL STATEMENTS, CASH FLOW, AND TAXES Laiho...

    431428470293373958327&eISBN=9781337911009&id=705774549&snapshotid=15798828 mnts, Cash Flow, and Taxes Comprehensive/Spreadsheet Problem 3-19. FINANCIAL STATEMENTS, CASH FLOW, AND TAXES Laiho Industries's 2018 and 2019 balance sheets (in thousands of dollars) are shown. 2019 2018 Cash Accounts receivable Inventories Total current assets Net fixed assets Total assets $102,850 103,365 38,444 $244,659 67,165 $311 824 $ 89,725 85,527 34,982 $210,234 42,436 $252,670 Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total common equity Total liabilities and equity $...

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