Question

In: Accounting

Windswept Woodworks, Inc. Input Data (millions of dollars) Year 2 Year 1 Accounts payable 436 384...

Windswept Woodworks, Inc.
Input Data
(millions of dollars)
Year 2 Year 1
Accounts payable 436 384
Accounts receivable 1,280 830
Accumulated depreciation 6,746 6,632
Cash & equivalents 224 128
Common stock 1,184 1,120
Cost of goods sold 1,500 n.a.
Depreciation expense ? n.a.
Common stock dividends paid ? n.a.
Interest expense 140 n.a.
Inventory 1,014 1,026
Addition to retained earnings 602 n.a.
Long-term debt 812 736
Notes payable 230 380
Gross plant & equipment 10,260 10,000
Retained earnings 3,062 2,476
Sales 3,018 n.a.
Other current liabilities 116 96
Tax rate 34 % n.a.
Market price per share – year end $ 19.80 $ 17.50
Number of shares outstanding 500.00 million 500.00 million
Cash flows from investment activities
Increase in gross plant and equipment $
Total cash flow from investments $
Cash flows from financing activities
Increase in long-term debt $
Increase in common stock
Cash dividends paid to common stockholders
Total cash flow from financing $
Net change in cash balance $
Cash balance on December 31, year 2 $


Solutions

Expert Solution

Statement of cash flow
Cash flows from operating activities
Net Income 602.00
Adjustments to reconcile net income to net cash provided by operating activities
Depreciation expenses   (6746-6632) 114
Increase in Accounts receivable -450
decrease in mercandise Inventory 12
Increase in Accounts Payable 52
Increase in other Current Liabilities 20
-252
Net cash from operating activities 350
Cash flows from investing activities
Increase in Gross Plant & equipment -260
Net cash used investing activities          (260.00)
Cash flows from financing activities
Increase in long-term debt (812-736) 76
Increase in common stock (1184-1120)             64.00
Decrease in Notes payable          (150.00)
Cash dividends paid to common stockholders -16.00
3062-(2476+602)
Net cash used financing activitie           (26.00)
Net Increase in cash and cash equivalents            64.00
Cash and cash equivalents at beginning of period          128.00
Ending Balance                214.00

Related Solutions

Windswept Woodworks, Inc. Input Data (millions of dollars) Year 2 Year 1 Accounts payable 484 424...
Windswept Woodworks, Inc. Input Data (millions of dollars) Year 2 Year 1 Accounts payable 484 424 Accounts receivable 1,328 870 Accumulated depreciation 6,794 6,672 Cash & equivalents 272 168 Common stock 1,232 1,160 Cost of goods sold 1,500 n.a. Depreciation expense ? n.a. Common stock dividends paid ? n.a. Interest expense 140 n.a. Inventory 1,062 1,066 Addition to retained earnings 602 n.a. Long-term debt 860 776 Notes payable 230 380 Gross plant & equipment 10,260 10,000 Retained earnings 3,110 2,516...
Please! Take your time! No rush really! :) ! Windswept Woodworks, Inc. Input Data (millions of...
Please! Take your time! No rush really! :) ! Windswept Woodworks, Inc. Input Data (millions of dollars) Year 2 Year 1 Accounts payable 520 454 Accounts receivable 1,364 900 Accumulated depreciation 6,830 6,702 Cash & equivalents 308 198 Common stock 1,268 1,190 Cost of goods sold 1,500 n.a. Depreciation expense ? n.a. Common stock dividends paid ? n.a. Interest expense 140 n.a. Inventory 1,098 1,096 Addition to retained earnings 602 n.a. Long-term debt 896 806 Notes payable 230 380 Gross...
Consider the following data for X. Enterprise’s Accounts Payable: Year 1 2 3 Accounts Payable 78...
Consider the following data for X. Enterprise’s Accounts Payable: Year 1 2 3 Accounts Payable 78 85 92 Holding all else is constant, how should you adjust X’s year 2 earnings to obtain Cash Flows? Note: Use a positive number for any additions and a negative number for any subtractions Accounts receivables: Year 1 2 3 Accounts receivables 79 57 69 Holding all else is constant, how should you adjust X’s year 2 earnings to obtain Cash Flows? Note: Use...
Geo Inc. had the following account balances on January 1, Year 2: Accounts Payable $ 710...
Geo Inc. had the following account balances on January 1, Year 2: Accounts Payable $ 710 Accounts Receivable 1,700 Cash 1,700 Common Stock 15,000 Equipment 1,900 Note Payable 3,200 Retained Earnings 3,786 Salaries and Wages Expense 4,200 Supplies 940 Required: Prepare journal entries for each of the following January activities, and post results to the relevant T-accounts. Compute the ending balance of each T-account. Beginning balances have been entered. (If no entry is required for a transaction/event, select "No Journal...
Geo Inc. had the following account balances on January 1, Year 2: Accounts Payable $ 725...
Geo Inc. had the following account balances on January 1, Year 2: Accounts Payable $ 725 Accounts Receivable 2,200 Cash 2,200 Common Stock 20,000 Equipment 2,900 Note Payable 4,200 Retained Earnings 4,411 Salaries and Wages Expense 4,700 Supplies 1,540 Required: Prepare journal entries for each of the following January activities, and post results to the relevant T-accounts. Compute the ending balance of each T-account. Beginning balances have been entered. (If no entry is required for a transaction/event, select "No Journal...
Windswept, Inc. 2017 Income Statement ($ in millions) Net sales $ 8,700 Cost of goods sold...
Windswept, Inc. 2017 Income Statement ($ in millions) Net sales $ 8,700 Cost of goods sold 7,340 Depreciation 405 Earnings before interest and taxes $ 955 Interest paid 82 Taxable income $ 873 Taxes 306 Net income $ 567    Windswept, Inc. 2016 and 2017 Balance Sheets ($ in millions) 2016 2017 2016 2017 Cash $ 150 $ 185 Accounts payable $ 1,180 $ 1,260 Accounts rec. 920 730 Long-term debt 1,000 1,265 Inventory 1,520 1,550 Common stock 3,210 2,900...
Apex Roofing Inc. has the following balance sheet (in millions of dollars): Current assets $3.0 Accounts...
Apex Roofing Inc. has the following balance sheet (in millions of dollars): Current assets $3.0 Accounts payable $1.2 Net fixed assets 4.0 Notes payable 0.8 Accrued wages and taxes 0.3 Total current liabilities $2.3 Long-term debt 1.2 Common equity 1.5 Retained earnings 2.0 Total assets $7.0 Total liabilities and equity $7.0 Last year's sales were $10 million, and Apex estimates it will need to raise $2 million in new debt and equity next year. You have identified the following facts:...
Trend Analysis - The following data pertain to Company A: (in millions) Year 2 Year 1...
Trend Analysis - The following data pertain to Company A: (in millions) Year 2 Year 1 Revenue $39,474 $35,137 Net income 5,658 5,642 Accounts receivable 4,389 3,725 Inventory 2,290 1,926 Total current assets 10,151 9,130 Total assets 34,628 29,930 Total current liabilities 7,753 6,860 Total long-term liabilities 9,641 7,702 Total stockholder equity 20,000 18,000 Common-Size Income Statements - Company A reported the following income statements: COMPANY A INCOME STATEMENT FOR THE YEARS ENDED DECEMBER YEAR 2 AND YEAR 1 (in...
1.Assume you collected a quarterly sales data (in millions of dollars) over a four-year period from...
1.Assume you collected a quarterly sales data (in millions of dollars) over a four-year period from the first quarter 2016 to the fourth quarter 2019, and computed the seasonal index for each quarter. If the values of the actual sales and deseasonalised sales were 162 and 158.68, respectively, in the second quarter of 2016, what is the (normalised) seasonal index for the second quarter? Round your answer to two decimal places. 2. Assume you collected data representing the number of...
6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014...
6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014 2015 2016 2018 2019 Revenue: 30 32 34 35 39 39 45 Let the year 2010 be the base year with x=0. a) Model the data with a linear function using the points in years 2010 and 2019. Round computed values to 2 decimal places. Also, using your model predict the revenue in the year 2021 accurate to 3 decimal places. b) Set up...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT