ANSWER
a) | Sources and Uses Statement: | |
Sources of cash | ||
Reduction in inventories | $ 12,500 | |
Increase in accumulated depreciation | 1,400 | |
Increase in taxes payable | 10,700 | |
Increase in long-term debt | 33,900 | |
Increase in common stock | 52,000 | |
Increase in retained earnings | 47,200 | |
Total sources of cash | $ 157,700 | |
Uses of cash | ||
Increase in cash | $ 29,200 | |
Increase in accounts receivable | 43,100 | |
Increase in buildings | 61,000 | |
Increase in equipment | 2,300 | |
Reduction in accounts payable | 22,100 | |
Total uses of cash | $ 157,700 |
Cash Flow Statement:
Cash flow statement: | |
Operating activities | 2017 |
Net income | $ 69,200 |
Add back depreciation | 1,400 |
(Increase) decrease in Receivables | (43,100) |
(Increase) decrease in inventories | 12,500 |
(Increase) decrease other current assets | |
Increase (decrease) in accounts payable | (22,100) |
Increase (decrease) in income taxes | 10,700 |
Cash flow from operations | $ 28,600 |
Investing activities | |
(Increase) decrease in building | (61,000) |
(Increase) decrease in equipment | (2,300) |
Cash flow from investing | $ (63,300) |
Financing activities | |
Increase (decrease) in long-term debt | 33,900 |
Increase (decrease) in common stock | 52,000 |
Dividends paid | (22,000) |
Cash flow from financing | $ 63,900 |
Net change in cash | 29,200 |
Beginning cash balance 2016 | 47,500 |
Ending cash balance 2017 | $76,700 |
__________________________________
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*************
a. Prepare a sources and uses statement for Whistler Corp. for fiscal year 2017. b. Prepare...
Below are the financial statements for Whistler Corporation: Whistler Corporation Financial Statements Balance Sheet: 2013 2014 Current Assets Cash $47,500 $76,700 Accounts Receivable $0 $43,100 Inventories $49,000 $36,500 Total current assets $96,500 $156,300 Noncurrent Assets Land $15,800 $15,800 Buildings $103,600 $164,600 Equipment $63,200 $65,500 Patent $5,200 $5,200 Accumulated depreciation -$10,800 -$12,200 Total noncurrent assets $177,000 $238,900 Total Assets $273,500 $395,200 Current Liabilities Accounts payable $48,000 $25,900 Income taxes payable ...
Please use Excel for the answers!!!!! 1 Chapter 1 Problem 14 2 a. Prepare a sources and uses statement for Whistler Corp. for fiscal year 2014 3 b. Prepare a cash flow statement for Whistler Corp. for fiscal year 2014 4 2013 2014 Balance Sheet: Current Assets Cash Accounts Receivable Inventories Total current assets Noncurrent Assets Land Buildings Equipment Patent Accumulated depreciation Total noncurrent assets Total Assets $47,500 $76,700 SO $43,100 $49,000 $36,500 6,500 $156,300 10 12 13 14 15...
This is the third time I'm posting this problem, I had two different responses and I am just confused now, please use EXCEL!!!! Thank you! 1 Chapter 1 Problem 14 2 a. Prepare a sources and uses statement for Whistler Corp. for fiscal year 2014 3 b. Prepare a cash flow statement for Whistler Corp. for fiscal year 2014 4 2013 2014 Balance Sheet: Current Assets Cash Accounts Receivable Inventories Total current assets Noncurrent Assets Land Buildings Equipment Patent Accumulated...
Balance Sheet Assets Fiscal year is January-December. All values USD millions. 2017 Cash & Short Term Investments 18.3B Total Accounts Receivable 13.49B Inventories 8.77B Other Current Assets 2.54B Total Current Assets 43.09B 2017 Net Property, Plant & Equipment 17.01B Total Investments and Advances 751M Long-Term Note Receivable - Intangible Assets 85.13B Other Assets 4.22B Total Assets 157.3B Liabilities & Shareholders' Equity 2017 ST Debt & Current Portion LT Debt 3.91B Accounts Payable 7.31B Income Tax Payable 1.85B Other Current Liabilities...
Prepare a forecasted statement of cash flows for 2017 using the indirect method. Assume the following: • Operating expenses for 2017 (such as general and administrative) include depreciation and amortization expense of $522 million. • The company did not dispose of or write-down any long-term assets during the year. • The company paid dividends of $159 million in 2017 P11-47. Statement of Cash Flows (Indirect Method) Following are the income statement and balance sheet for Whole Foods Market Inc., for...
The 2017 and 2016 balance sheets of Wallace Corporation follow. The 2017 income statement is also provided. WallaceWallace had no noncash investing and financing transactions during 2017. During the year, the company sold equipment for $15,300, which had originally cost $13,600 and had a book value of $11,400. The company did not issue any notes payable during the year but did issue common stock for $35,000. The company purchased plant assets and long-term investments with cash. Wallace Corporation Income Statement...
partial data shown below For its fiscal year ending October 31, 2017, Bramble Corp. reports the following Income before income taxes Income tax expense (17%x $467,000) 79,390 Income from continuing operations $643,000 563,610 128,300 Net income The loss o discontinued operations was comprised of a $59,900 loss from operations and a $68,400 loss from disposal. The income tax rate Prepare a cocrect statement of comprehensive income beginning with income before income taxes 17% on all terms BRAMBLE CORP Statement of...
Oriole Supply Company Income Statement for the Fiscal Year Ended June 30, 2017($ thousands) Net sales Cost of goods sold Selling and administrative expenses Nonrecurring expenses Earnings before interest, taxes, depreciation, and amortization (EBITDA) Depreciation Earnings before interest and taxes (EBIT) Interest expense Earnings before taxes (EBT) Taxes (35%) Net income $2,110,000 1,460,000 317,000 27,000 $306,000 113,000 193,000 118,000 $75,000 26,250 $48,750 Oriole Supply Company Balance Sheet as of June 30, 2017($ thousands) Assets: Liabilities and Equity: Cash and marketable...
The balance sheet and income statement for Cullumber Supply Company for the fiscal year ended June 30, 2017 is as follows Cullumber Supply Company Income Statement for the Fiscal Year Ended June 30, 2017($ thousands) Net sales Cost of goods sold Selling and administrative expenses Nonrecurring expenses Earnings before interest, taxes, depreciation, and amortization (EBITDA) Depreciation Earnings before interest and taxes (EBIT) Interest expense Earnings before taxes (EBT) Taxes (35%) Net income $2,133,900 1,459,400 313,000 27,600 $333,900 112,150 221,750 117,650...
For its fiscal year ending October 31, 2017, Blue Spruce Corp. reports the following partial data shown below. Income before income taxes $573,000 Income tax expense (25% × $557,000) 139,250 Income from continuing operations 433,750 Loss on discontinued operations 118,200 Net income $315,550 Prepare a correct statement of comprehensive income, beginning with income before income taxes.