
Prepare an unlevered free cash flow schedule for The Second Market Value Company as of Year 0 using the information in the previous problem and the financial statements provided in Exhibit P1.1. Note that the company has $500 of depreciation which is part of Cost of Goods Sold and Selling, General and Administrative. The tax rate is 40%. The company holds no excess cash so the change in cash is the change in its required cash?
unlevered free cash flow = earnigs before interest, tax - taxes + depreciation and amortization - capital expenditure - change in working capital
| unlevered cash flow | amount ($) |
| earnings before interest and tax | 1540 |
| less:taxes | -392 |
| add:depreciation and amortization | 500 |
| less:capital expenditure | -190 |
| less:change in working capital | -40 |
| 1418 |
| capital expenidture | amount ($) | |
| year 0 property,plant and equipment | 6220 | |
| year -1 property,plant and equipment | 6030 | |
| capital expenditure | 190 | |
| working capital | current assets - current liabilities | amount ($) |
| year 0 | year-1 | |
| current assets | 1310 | 1240 |
| current liabilities | 320 | 290 |
| working capital | 990 | 950 |
| net change in working capital | 40 |
Prepare an unlevered free cash flow schedule for The Second Market Value Company as of Year...
Free Cash flow question
What is the amount of free cash flow for this company for the
year? Please show formula/equation so i know how to solve for.
Thank you!
Cash Flow Statement Amount Calculations - Chapter 14 End of year Beginning of year Current year Income statement Balance sheet Cash Accounts receivable Inventory Prepaid expenses Total current assets Equipment, at cost Less: Accum. depreciation Net equipment Total assets 86,000 112,000 141,000 18,000 357,000 298,000 (100,000) 198,000 555,000 54,000 126,000...
Problem 13-10 Prepare a Statement of Cash Flows; Free Cash Flow Joyner Company’s income statement for Year 2 follows: Sales $ 709,000 Cost of goods sold 362,000 Gross margin 347,000 Selling and administrative expenses 216,000 Net operating income 131,000 Nonoperating items: Gain on sale of equipment 7,000 Income before taxes 138,000 Income taxes 41,400 Net income $ 96,600 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash and...
Prepare a statement of cash flow using the indirect method for
this year and determine the free cash flow. I have completed this
this but I want to make sure my numbers add up correctly and not
just a coincidence.
Excel Assignment #1 - Statement of Cash Flow Spring Semester Northern Illinois Manufacturing prepared the balance sheet and income statement for this year. Now the company needs to prepare its statement of cash flow. The comparative balance sheets for Northern...
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...
Using the income statement and balance sheets of Niagara Company
below, prepare a statement of cash flows for the year ended
December 31, Year 9, using the direct method.
NIAGRARA COMPANY
Income statement For Year Ended Dec.31,
Year9
Sales
$1000
Cost of goods sold
(650)
Depreciation expense
(100)
Sales and general expense
(100)
Interest expense
(50)
Income tax expense
(40)
Net income
$60
NIAGARA COMPANY Balance Sheets December 31, Year 9 and Year 8 Year 8 Year 9 $ 60...
Problem 14-10 Prepare a Statement of Cash Flows; Free Cash Flow [LO14-1, L014-2 Joyner Company's income statement for Year 2 follows Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating income Nonoperating items: $ 720,08e 362,888 358,688 218,888 148,988 Gain on sale of equipment Income before taxes Incone taxes Net income 1e,800 15e,8e0 45,800 $ 185,8ee Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets...
What is free cash flow for Beta Polaris in Year 5? i Financial Information Click the icon to view financial information for Beta Polaris Inc. Free cash flow is $ in Year 5. (Round to the nearest dollar as needed.) Income Statement & Balance Sheet Beta Polaris Inc. Year 4 Year 5 Sales 1,514,102 1,611,573 Cost of Goods Sold 1,079,192 1,175,679 SG&A 181,994 187,244 Depreciation 44,828 34,047 EBIT 208,088 214,603 Interest Expense 4,579 10.602 Pre-Tax Income 203,509204,001 Income Taxes 89,434...
Help finding the free cash flow to equity and free cash flow to
firm!
Balance Sheet
Income Statement:
Assets Cash Accounts Receivable Inventories Total Current Assets 2008 55,528 $ 632,160 1,287,360 1,975,048 2007 57,600 375,000 727,128 1,159,728 Land, Plant & Equipment Land Buildings Less: Accumulated Depreciation Equipment Less: Accumulated Depreciation Total Land, Plant & Equipment 145,000 280,000 (46,750) 450,000 (137,200) 691,050 65,000 150,000 (36,000) 305,000 (110,200) 373,800 Investments Total Assets 19,000 2,685,098 26,000 1.559,528 $ $ Liabilities & Equity Accounts...
Managerial Accounting:
Prepare a statement of cash flows for this year.
The following information applies to the questions displayed below) Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This $ 10 300 159 བློ་འཆཎ པas an Assets Cash and cash equivalents Accounts receivable Inventory Prepaid expenses Total current assets Property, plant, and equipment Less accumulated depreciation Net property, plant, and equipment Long-term investments Total assets Liabilities and Stockholders' Equity Accounts payable Accrued liabilities...
1. Compute the free cash flow for the year 2014.
2. Explain why cas declined so sharply during the year
2014.
Foxboro Company Income Statement For the Period January 1, 2014 through December 31, 2014 $ 700,000 400,000 300,000 216,000 Sales Cost of Goods Sold Gross Margin Selling and Administrative Expenses Net Operating Income Gain on Sale of Equipment Income Before Taxes Income Taxes Net Income 84,000 6,000 90,000 27,000 63,000 Foxboro Company Comparative Balance Sheets December 31, 2014 December...