Question

In: Finance

Use the following financial information below to find the cash flow form assets (CFFA) for 2017:...

Use the following financial information below to find the cash flow form assets (CFFA) for 2017: (10 pts)
2016. 2017
sales $5,918. $7,000
COGS. 3,899. 4,460
Interest. 333. 277
Depreciation. 1,204. 1,196
Cash. 875. 418
Accounts
receivables. 601. 578
Current
liabilities. 414. 463
Inventory. 1,215. 1,598
Long-term
debt. 4,780. 4,103
Net fixed
assets. 7,700. 7,330
Shareholder’s
equity. 4,994. 5,358
Taxes. 198. 320


please show full work with formulas

Solutions

Expert Solution

EBIT = Sales - Costs - Depreciation
EBIT = $7,000 - $4,460 - $1,196
EBIT = $1,344

Operating Cash Flow = EBIT + Depreciation - Taxes
Operating Cash Flow = $1,344 + $1,196 - $320
Operating Cash Flow = $2,220

Current Assets, 2017 = Cash + Accounts Receivables + Inventory
Current Assets, 2017 = $418 + $578 + $1,598
Current Assets, 2017 = $2,594

Current Assets, 2016 = Cash + Accounts Receivables + Inventory
Current Assets, 2016 = $875 + $601 + $1,215
Current Assets, 2016 = $2,691

Change in Net Working Capital = Net Working Capital, 2017 - Net Working Capital, 2016
Change in Net Working Capital = (Current Assets, 2017 - Current Liabilities, 2017) - (Current Assets, 2016 - Current Liabilities, 2016)
Change in Net Working Capital = ($2,594 - $463) - ($2,691 - $414)
Change in Net Working Capital = -$146

Net Capital Spending = Net Fixed Assets, 2017 + Depreciation - Net Fixed Assets, 2016
Net Capital Spending = $7,330 + $1,196 - $7,700
Net Capital Spending = $826

Cash Flow from Assets = Operating Cash Flow - Net Capital Spending - Change in Net Working Capital
Cash Flow from Assets = $2,220 - $826 - (-$146)
Cash Flow from Assets = $1,540


Related Solutions

Cash flow from assets. Use the data from the following financial statements in the popup​ window,...
Cash flow from assets. Use the data from the following financial statements in the popup​ window, LOADING... . The company paid interest expense of $ 17 comma 500$17,500 for 20172017 and had an overall tax rate of 40 %40% for 20172017. Find the cash flow from assets for 20172017​, and break it into its three​ parts: operating cash​ flow, capital​ spending, and change in net working capital. The operating cash flow is ​$nothing. Partial Income Statement Year Ending 2017 Sales...
Cash flow from assets. Use the data from the following financial statements in the popup​ window,...
Cash flow from assets. Use the data from the following financial statements in the popup​ window, LOADING.... The company paid interest expense of $ 17 comma 300 for 2017 and had an overall tax rate of 40 % for 2017. Find the cash flow from assets for 2017​, and break it into its three​ parts: operating cash​ flow, capital​ spending, and change in net working capital. Partial Income Statement Year Ending 2017 Sales revenue $350,100 Cost of goods sold $142,000...
What is the firm’s free cash flow (i.e., cash flow from assets) for 2017? Cash                             &
What is the firm’s free cash flow (i.e., cash flow from assets) for 2017? Cash                                                                      $423 Accounts Receivable                                            15% of Total Revenue Accounts Payable                                                 20% of Cost of Goods Sold Notes Payable                                                       $800 Inventory                                                              $2,900 Net Fixed Assets                                                   $14,800 Long-term Debt                                                    $3,500 Common Stock                                                     $10,000 Total Revenue                                                      $7,200 Cost of Goods Sold                                               50% of Total Revenue Depreciation Expense                                           $1,200 Selling, General, & Administrative Expense       $1,000 Interest Expense                                                   10% of Long-term Debt Income Taxes                                                       35% of Taxable Income
Calculate free cash flow for 2017 for Monarch Textiles, Inc., based on the financial information that...
Calculate free cash flow for 2017 for Monarch Textiles, Inc., based on the financial information that follows. Assume that all current liabilities are non-interest-bearing liabilities and that no fixed assets were sold or disposed of during 2017. (Enter your answer in 1000s.) income statement 2017 sales 1640 cost of sales 880 operating expenses 190 depreciation 86 interest expense 50 earnings befor taxes 434 tax 173.6 net income 260.4 selected balance sheet items 2016 2017 current assets 40 670 net fixed...
Calculate free cash flow for 2017 for Monarch Textiles, Inc., based on the financial information that...
Calculate free cash flow for 2017 for Monarch Textiles, Inc., based on the financial information that follows. Assume that all current liabilities are non-interest-bearing liabilities and that no fixed assets were sold or disposed of during 2017. (Enter your answer in 1000s.) Monarch Textiles, Inc. ($ thousands) Income statement Selected balance sheet items 2017 2016 2017 Sales 1,610 Current assets 470 655 Cost of sales 870 Net fixed assets 168 336 Operating expenses 185 Current liabilities 285 365 Depreciation 84...
Capital Budgeting Analysis - Use the information below to prepare for cash flow analysis in a...
Capital Budgeting Analysis - Use the information below to prepare for cash flow analysis in a table for both scenarios Please create your table from Colume L and keep this statement here as it is. You must show the analysis and results from both scenarios based on your cash flow analysis table and make your decision Decision without data support will be given 0 points. Micro-Technologies is a Bio Tech research firm that is conducting research on a cure for...
Select financial information follows. Calculate Cash Flow from Assets.  Hint: In the process, you will need to...
Select financial information follows. Calculate Cash Flow from Assets.  Hint: In the process, you will need to calculate the amount of taxes that would appear on the income statement based on the information available to you. Round your answer to 2 decimal places (example: if your answer is 546.345 you should enter 546.35). Note: If your final answer is negative, be sure to enter a negative sign with your response. from Balance Sheet 12/31/2031 from Balance Sheet 12/31/2032 from Income Statement,...
Use the following set of cash flows for the questions below: Table A Year Cash Flow...
Use the following set of cash flows for the questions below: Table A Year Cash Flow 1 $5,973 2 $18,662 3 $61,839 4 $66,528 5 $68,052 6 $73,559             2. Using the cash flows in Table A, determine the present value of the cash flow stream at the following discount rates: 3%, 8%, 12%, 18%, and 22%. (Use a data table to complete these calculations. (please show how to do in excel, having a hard time figuring out how to...
Use the financial statements of Heifer Sports Inc. to find the information below for Heifer. (Use...
Use the financial statements of Heifer Sports Inc. to find the information below for Heifer. (Use 365 days a year. Round all answers to 2 decimal places except $ amounts.) Income Statement 2017 Sales $ 5,670,000 Cost of goods sold 2,967,000 Depreciation 293,200 Selling & admin. expenses 1,570,000 EBIT $ 839,800 Interest expense 151,000 Taxable income $ 688,800 Taxes 310,500 Net income $ 378,300 Balance Sheet, Year-End 2017 2016 Assets Cash $ 46,200 $ 67,000 Accounts receivable 632,000 1,159,200 Inventory...
Below is taken from Ametek’s reportable segment financial information note to their 2017 Form 10-K: In...
Below is taken from Ametek’s reportable segment financial information note to their 2017 Form 10-K: In thousands                                                                     2017                                        2016 Net Sales:     Electronic Instruments                                            $2,690,554                                  Electromechanical                                                   1,609,616                              Operating Income:     Electronic Instruments                                                677,489                                          Electromechanical                                                      310,875                                    Operating Assets:     Electronic Instruments                                            4,803,575                                 4,104,972     Electromechanical                                                  2,535,503                                 2,446,180 Calculate for 2017 (Please show your work):                                                             ROI                             Margin                        Turnover Electronic Instruments                 ____________               ___________                 ___________ Electromechanical                       ____________               ___________                 ___________ Compare the relative profitability of Ametek’s Electronic Instruments and Electromechanical segments.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT