| 2017 | 2018E | |
| Sales | 560.0 | 588.0 |
| Less : Operating expense | 336.0 | 323.4 |
| EBITDA | 224.0 | 264.6 |
| Less : Depreciation | 76.5 | 85.0 |
| Less : Amortization | 5.0 | 3.0 |
| EBIT | 142.5 | 179.6 |
| Less : Interest expense | 52.0 | 54.6 |
| Add: Interest income | 10.0 | 15.0 |
| Earnings before taxes | 100.5 | 140.0 |
| Taxes @23% | 23.12 | 32.20 |
| Earnings after taxes | 77.39 | 107.80 |
| a. | ||
| NOPLAT = EBIT * (1 - tax rate) | ||
| NOPLAT = 179.6*(1-23%) | ||
| NOPLAT = 138.29 | ||
| b. | ||
| a. EBITA = EBIT + Amortization | ||
| 179.6+3 = 182.6 | ||
| b. Cash tax | ||
| 125+32.2-145 = 12.2 | ||
| c. FCF | ||
| FCF = NOPLAT + D&A - Capex - Change in working capital | ||
| FCF =138.29 + 85 + 3 -125 - (-2.5) | ||
| FCF = 103.79 | ||
| Change in working capital = (80+102.5-145)-(75+95-130) | ||
| Change in working capital = -2.5 | ||
| d. Net income = 107.80 |
Question 1 (50 points) FCF items from income and cash flow statements(millions NOK) 2017 2018E 560.0...
The focus on traditional financial statements is -Select-marketaccountingreplacementItem 1 data rather than cash flow. However, cash flow is important to investors, managers, and stock analysts. Therefore, corporate decision makers and security analysts need to modify accounting data provided to them. An important modification is the concept of free cash flow (FCF). Many analysts regard FCF as being the single and most important number that can be developed from the accounting statements, even more important than net income. The equation for free...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales 2875.0 2500.0 Operating costs excluding 2372.0 2125.0 depreciation Depreciation and amortization 69.0 55.0 Earnings before interest and taxes 434.0 320.0 Less: Interest 62.0. 54.0 Pre-tax income 372.0 266.0 Taxes (40%). 148.8 106.4 Net Income available to common 223.2 159.6 stockholders Common dividends 201.0. 128.0 Rhodes Corporation Balance Sheet as of December 31 (Millions of Dollars) Assets Cash 40.0 35.0 Short-Term investments 15.0. 13.0 Accounts Receivable...
Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $2,310.0 $2,100.0 Operating costs excluding depreciation and amortization 1785.0 1,733.0 $ 577.0 $ 315.0 EBITDA Depreciation and amortization 53.0 46.0 $ 269.0 Earnings before interest and taxes (EBIT) 524.0 Interest 51.0 46.0 Earnings before taxes (EBT) 473.0 223.0 Taxes (40%) 189.2 89.2. Net income $ 283.8 $ 133.8 Common dividends $255.0 $107.0 Powell Panther Corporation: Balance Sheets as of December 31 (Millions of Dollars)...
FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents $ 13,000 $ 11,000 Accounts receivable 25,000 20,000 Inventories 24,910 19,000 Total current assets $ 62,910 $ 50,000 Net plant and equipment 49,000 47,000 Total assets $111,910 $97,000 Liabilities and Equity Accounts payable $ 10,200 $ 8,000 Accruals 7,900 7,000 Notes payable 7,000 5,250 Total current liabilities $ 25,100 $ 20,250 Long-term bonds 20,000 20,000...
FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents $ 14,000 $ 11,000 Accounts receivable 35,000 30,000 Inventories 31,975 28,000 Total current assets $ 80,975 $ 69,000 Net plant and equipment 50,000 45,000 Total assets $130,975 $114,000 Liabilities and Equity Accounts payable $ 10,500 $ 9,500 Accruals 7,800 7,000 Notes payable 6,700 5,250 Total current liabilities $ 25,000 $ 21,750 Long-term bonds 10,000 10,000...
(In millions) Year Ended December 31, 2018 2017 Cash flows from operating activities Net income $ 22,112 $ 15,934 Adjustments to reconcile net income to net cash provided by operating activities: Depreciation and amortization 4,315 3,025 Share-based compensation 4,152 3,723 Deferred income taxes 286 (377) Other (64) 24 Changes in assets and liabilities: Accounts receivable (1,892) (1,609) Prepaid expenses and other current assets (690) (192) Other assets (159) 154 Accounts payable 221 43 Partners payable 157 95 Accrued expenses and...
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...
QUESTION 1 Given the following income statement and balance sheet data, select which items would be included in presenting the cash flow from operating activities section of the statement of cash flows using the indirect method: 2019 $50,000 33,400 16,600 13,600 920 Income Statement ($ millions) Sales Less: Cost of goods sold Gross profits Less: Cash operating expenses Less: Depreciation expense Less: Amortization of intangible assets Operating profits (EBIT) Less: Interest expense Equity in earnings (loss) of affiliate Gain (loss)...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2017 Sales Operating costs excluding depreciation Depreciation and amortization Earnings before interest and taxes Less Interest Pre-tax income Taxes (40%) Net income available to common stockholders Common dividends 2018 $11,050.0 8,564.0 275.0 $2,211.0 238.0 $1,973.0 789.2 $1,183.8 $1,065.0 $8,500.0 7,225.0 230.0 $1,045.0 183.0 $862.0 344.8 $517.2 $414.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 2017 $112.0 56.0 1,169.0 2,656.0 $3,993.0 2,754.0 $6,747.0 $102.0...
164.0 Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $9,350.0 $8,500.0 Operating costs excluding depreciation 7,013.0 7,225.0 Depreciation and amortization 196.0 179.0 Earnings before interest and taxes $2,141.0 $1,096.0 Less Interest 201.0 183.0 Pre-tax income $1,940.0 $913.0 Taxes (40%) 776.0 365.2 Net income available to common stockholders $1,164.0 $547.8 Common dividends $1,048.0 $438.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $113.0 $94.0...