Question

Prepare Statements of Cash Flow for W&B for (1) 2017 forecast and (2) actual 2017 results (You can use the format provided and discussed in class. Pay attention to the footnotes.) Next to each item provide an explanation for deviation between actual and forecast. 1.
Exhibit 1: Balance Sheets as of December 31 Forecast 2017 $40,000 228,000 300,000 $568,000 Actual 2017 $42,700 278,200 ASSETS Cash Receivables, net Inventory* Actual 2016 $83,700 198,100 265 300 $547,100 Current Assets 825,500 148,500 17,000 131,500 12.300 $969,300 Fixed assets 117,500** 16,500)9 $101,000 12,000 $681,000 72,500 Less: Reserve for depreciation31500 Net fixed assets Deferred charges TOTAL ASSETS $41,000 10.000 $598,100 $34,000 5,000 47,000 Accounts payable Miscellaneous accruals Accrued income tax due Bank loan, current $34,600 7,100 32,400 $213,500 11,900 49,200**s Current Liabilities $74,100 $86,000 314,600 Bank Loan Capital stock (par $50) Retained earnings 180,000 344.000 $598,100 180,000 387000 $653,000 80,000 180,000 394.700 $969,300 TOTAL LIABILITIES &EQUITY Funds needed $28,000 $120,000 *Inventory accounted for on a FIFO basis. **After planned write-off of fully depreciated equipment and fixtures originally costing $20,000. ** Payable in March, 2018.
Exhibit 2: Income Statements for Years Ended December 31 Net sales Cost of sales Gross margin Actual 2016 $1,555,800 (1.012.500) 543,300 Forecast 2017 $1,873,000 (1183.000) 690,000 Actual 2017 $2,540,600 (1.685.200) 855,400 (434800) 108,500 (522.000) 168,000 (670,400) 185,000 st Operating profit Federal income tax Net profit after tax (52.000) 56,500 (89,300) 95,700 88,000 (45,000) S 43,000 (45,000) $ 50,700 Dividends paid (30,000) Eamings retained S 26,500 2016 were $1,052,000; they were estimated at $1,217,000 for 2017 and w * Includes depreciation of $2,600 in 2016, $5,000 estimated for 2017, S5,500 for actual 2017 *Purchases $1,924,500 for 2017. Credit terms were net 10
Statement of Cash Flow 2017 Forecast 2017 Actual Net Income Depreciation Working capital Receivables Inventory Accounts payable Accruals Prov Income Tax Cash Flow from Operationa 3 Fixed Assets 4 Deferred Charges 5 Cash Flow from Investments 6 7 Bank Loan 8 Dividend 9 Cash Flow from Financing 0 1 Total Cash Flow 2 3 Beginning Cash 4 Ending cash 5 Change in Cash 26 27 CF Operationa + Investments Financing in
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer is

Cashflows of W&B
Particulars 2017 2017
Forecast Actuals
Net income 88000 95700
Depreciation 5000 5500
Working capital
Receivables -29900 -80100
Inventory -34700 -239300
Accounts payable -600 178900
Accruals -2100 4800
Prov income tax 14600 16800
Cash flow from operations 40300 -17700
Fixed Assets -65000 -96000
Deferred charges -2000 -2300
Cash flow from investments -67000 -98300
Bank loan 28000 120000
Dividend -45000 -45000
Cash flow from financing -17000 75000
Total Cash Flow -43700 -41000
Beginning Cash 83700 83700
Closing cash 40000 42700
Add a comment
Know the answer?
Add Answer to:
Prepare Statements of Cash Flow for W&B for (1) 2017 forecast and (2) actual 2017 results...
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
  • Finance 313 - Handout #28 Cash Flow Statement #2 Prepare the 2017 Statement of Cash Flows for Sampson Company. No di...

    Finance 313 - Handout #28 Cash Flow Statement #2 Prepare the 2017 Statement of Cash Flows for Sampson Company. No dividends were paid in 2018. Balance Sheet Years Ending December 31, 2018 and 2017 12/31/18 S 35,000 72,185 98,000 12/31/32 $ 60,000 65,000 85,000 Cash Net Receivables Inventory Gross Plant & Equipment Less Accum. Deprec. Net Fixed Assets Total Assets 195,000 45,000 180,000 35,000 150,000 $355,185 145,000 $355.000 $ 80,000 61,000 Accounts Payable Accruals Mortgage Payable Common Stock Retained Earnings...

  • Problem 12-09 Financing Deficit Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December 31, 2016 Cash $   180,000 Accounts payable $   360,000...

    Problem 12-09 Financing Deficit Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December 31, 2016 Cash $   180,000 Accounts payable $   360,000 Receivables 360,000 Notes payable 156,000 Inventories 720,000 Line of credit 0 Total current assets $1,260,000 Accruals 180,000 Fixed assets 1,440,000 Total current liabilities $   696,000 Common stock 1,800,000 Retained earnings 204,000 Total assets $2,700,000 Total liabilities and equity $2,700,000 Income Statement for December 31, 2016 Sales $3,600,000 Operating costs 3,279,720 EBIT $  320,280...

  • Problem 12-09 Financing Deficit Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as...

    Problem 12-09 Financing Deficit Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December 31, 2016 $360,000 156,000 180,000 Cash $ 180,000 Accounts payable Receivables 360,000 Notes payable Inventories 720,000 Line of credit Total current assets $1,260,000 Accruals Fixed assets 1,440,000 Total current liabilities Common stock Retained earnings Total assets $2,700,000 Total liabilities and equity Income Statement for December 31, 2016 $ 696,000 1,800,000 204,000 $2,700,000 Sales Operating costs $3,600,000 3,279,720 $ 320,280 18,280 EBIT Interest...

  • Help with #8 please? quarter ending December 31, 2017. B. Prepare monthly pro forma balance sheets...

    Help with #8 please? quarter ending December 31, 2017. B. Prepare monthly pro forma balance sheets at the end of October, November, and December 2017. C. Prepare both a monthly cash budget and pro forma statements of cash flows for October, Novem ber, and December 2017. D. Describe your findings and indicate the maximum amount of bank borrowing that is needed & Cash Conversion Cycle Two years of financial statement data for the Munich Export Corpor shown below. A. Calculate...

  • Prepare a forecast, showing any calculations BALANCE SHEETS 2016 2,860 0 Use the following financial statements...

    Prepare a forecast, showing any calculations BALANCE SHEETS 2016 2,860 0 Use the following financial statements to answer questions (Dollars are stated in $millions) INCOME STATEMENT 2015 2016 2015 2016 Net Sales 8,360 9,610 Cash 310 405 Cost of goods sol 5,247 6,310 Accounts rec. 2,640 3,055 Depreciation 1,340 1,370 Inventory 3,275 3,850 EBIT 1,773 1,930 Current assets 6,225 7,310 Interest 620 630 Net fixed assets 10,960 10,670 Taxable income 1,153 1,300 Taxes 403 455 Total assets 17,185 17,980 Net...

  • Question 1 (50 points) FCF items from income and cash flow statements(millions NOK) 2017 2018E 560.0...

    Question 1 (50 points) FCF items from income and cash flow statements(millions NOK) 2017 2018E 560.0 588.0 Sales Operating expenses (excl. depr. and amort.) Depreciation 323.4 85.0 3.0 Amortization 336.0 76.5 5.0 52.0 10.0 10.0 Interest expenses 54.6 15.0 Interest income 15.0 Dividends One time Capex on new plant construction Capital expenditure (Capex) 400.0 0.0 116.5 125.0 Consolidated Balance Sheet (millions NOK) Cash and marketable securities 4.0 Accounts receivable 15.0 75.0 95.0 80.0 102.5 Inventory Goodwill and intangible assets Cumulative...

  • What is the cash flow to the creditors for 2017? Exelon, Inc. 2017 Income Statement Net...

    What is the cash flow to the creditors for 2017? Exelon, Inc. 2017 Income Statement Net sales 13,000 Cost of goods sold 7,050 Selling, general, and administrative expenses 2,419 Depreciation 1,650 Earnings before interest and taxes 1,881 Interest 215 Pretax income 1,666 Taxes 54 Net income 1,612 Exelon, Inc. 2016 and 2017 Balance Sheets 2016 2017 2016 2017 Cash 298 306 Accounts payable 6,219 6,184 Accounts receivable 3,206 3,422 Accrued expenses 1,880 1,825 Inventory 5,210 5,950    Total 8,099 8,009    Total...

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

  • Question 1 Calculate the missing information (indicated by shaded areas) from the following cash flow statements:...

    Question 1 Calculate the missing information (indicated by shaded areas) from the following cash flow statements: Cash from (used by) Company 1 Company 2 Company 3 Company 4 Company 5 Operations $30,000 ($36,000) $48,000 Investing activities (13,500) 1,500 (30,000) (15,000) Financing activities 45,000 (30,000) (18,000) 6,000 Net increase (decrease) in cash 3,000 (15,000) 18,000 (24,000) Question 2 You are provided the following information about Lebron Sneakers Ltd. (Lebron) for fiscal 2017: Net income Accounts receivable on July 1, 2016 Accounts...

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