a. Forecast the parts of the income statement and balance sheets necessary to calculate free cash flow. |
||||
Partial Income Statement for the Year Ending December 31 (Millions of Dollars) |
||||
|
Actual |
Projected |
Projected |
|
Income Statement Items |
2018/12/31 |
12/31/19 |
12/31/20 |
|
Net Sales |
$800.0 |
|
|
|
Costs (except depreciation) |
$576.0 |
|
|
|
Depreciation |
$60.0 |
|
|
|
Total operating costs |
$636.0 |
|
|
|
Earning before int. & tax |
$164.0 |
|
|
|
Partial Balance Sheets for December 31 (Millions of Dollars) |
||||
|
Actual |
Projected |
Projected |
|
Operating Assets |
2018/12/31 |
12/31/19 |
12/31/20 |
|
Cash |
$8.0 |
|
|
|
Accounts receivable |
$80.0 |
|
|
|
Inventories |
$160.0 |
|
|
|
Net plant and equipment |
$600.0 |
|
|
|
|
|
|
|
|
Operating Liabilities |
|
|
|
|
Accounts Payable |
$16.0 |
|
|
|
Accruals |
$40.0 |
|
|
|
b. Calculate free cash flow for each projected year. Also calculate the growth rates of free cash flow each year to ensure that there is constant growth (i.e., the same as the constant growth rate in sales) by the end of the forecast period. |
||||
|
Actual |
Projected |
Projected |
|
Calculation of FCF |
2018/12/31 |
12/31/19 |
12/31/20 |
|
Operating current assets |
|
|
|
|
Operating current liabilities |
|
|
|
|
Net operating working capital |
|
|
|
|
Net PPE |
|
|
|
|
Total net operating capital |
|
|
|
|
NOPAT |
|
|
|
|
Investment in total net operating capital |
na |
|
|
|
Free cash flow |
na |
|
|
|
Growth in FCF |
na |
na |
|
|
Growth in sales |
|
|
|
|
|
|
|
|
ANSWER:-
Price per share = $ 99.46
Please see the table below. Please be guided by the second column titled “Linkage” to understand the mathematics. You can also understand the mathematics making use of [+] / [-] sign appearing in the first column. The last row highlighted in yellow is your answer. Figures in parenthesis, if any, mean negative values. All financials are in $ mn except number of shares which is in mn and Price per share which is $ / shares.
Parameter | Linkage | Actual | Projected | Projected | Projected | Projected |
Year | 12/31/2018 | 12/31/2019 | 12/31/2020 | 12/31/2021 | 12/31/2022 | |
Year number, n | 1 | 2 | 3 | 4 | ||
y-o-y growth in sales | gi | 15% | 10% | 6% | 6% | |
Net Sales | A = Ai-1 x (1 + gi) | 800 | 920.00 | 1,012.00 | 1,072.72 | 1,137.08 |
Costs | B = 72% x A | 662.40 | 728.64 | 772.36 | 818.70 | |
Depreciation | C = 10% x I (below) | 69.00 | 75.90 | 80.45 | 85.28 | |
Cash | D = 1% x A | 8.00 | 9.20 | 10.12 | 10.73 | 11.37 |
Acc. Receivables | E = 10% x A | 80.00 | 92.00 | 101.20 | 107.27 | 113.71 |
Inventory | F = 20% x A | 160.00 | 184.00 | 202.40 | 214.54 | 227.42 |
Accounts Payable | G = 2% x A | 16.00 | 18.40 | 20.24 | 21.45 | 22.74 |
Accruals | H = 5% x A | 40.00 | 46.00 | 50.60 | 53.64 | 56.85 |
Net PPE | I = 75% x A | 600.00 | 690.00 | 759.00 | 804.54 | 852.81 |
Working capital | J = (D + E + F) - (G + H) | 192.00 | 220.80 | 242.88 | 257.45 | 272.90 |
Increase in working capital | K = Ji+1 - Ji | 28.80 | 22.08 | 14.57 | 15.45 | |
Capital Expenditure | L = Ii + C - Ii-1 | 159.00 | 144.90 | 125.99 | 133.55 | |
EBIT x (1 - Tax rate) | M = (A - B - C) x (1 - 40%) | 113.16 | 124.48 | 131.94 | 139.86 | |
[+] Depreciation | C | 69.00 | 75.90 | 80.45 | 85.28 | |
[-] Increase in working capital | K | 28.80 | 22.08 | 14.57 | 15.45 | |
[-] Capital expenditure | L | 159.00 | 144.90 | 125.99 | 133.55 | |
FCFF | N = M + C - K - L | (5.64) | 33.40 | 71.83 | 76.14 | |
WACC | R | 10.5% | ||||
Terminal growth rate | g | 6% | ||||
Horizon value | O = N2022 x (1 + g) / (R - g) | 1,793.56 | ||||
PV factor | PVF = (1 + R)-n | 0.90498 | 0.81898 | 0.74116 | 0.67073 | |
PV of FCFF | PV = PVF x FCFF | (5.10) | 27.35 | 53.24 | 51.07 | |
[+] PV of Horizon value | PVHV = O x PVF2022 | 1,203.00 | ||||
Value of operations (V0) | V0 = PV + PVHV | 1,329.56 | ||||
[+] Value of short-term investments | P | 20.00 | ||||
Total value of company | Q = V0 + P | 1,349.56 | ||||
[-] Total value of all debt | R (= Notes payables + long term bonds) | 340.00 | ||||
[-] Value of preferred stock | S | 15.00 | ||||
Value of common equity | T = Q - R - S | 994.56 | ||||
Number of shares outstanding (mn) | U | 10.00 | ||||
Price per share ($ / share) |
a. Forecast the parts of the income statement and balance sheets necessary to calculate free cash...
Calculate the price per share of common equity as of
12/31/2018.
Millions except price per share
Actual
2018/12/31
Value of operations (V0)
+ Value of short-term investments
Total value of company
− Total value of all debt
− Value of preferred stock
Value of common equity
Number of shares outstanding
Price per share
Income Statement for the Year Ending December 31 (Millions of Dollars) 2018 S Net Sales 800.0 Costs (except depreciation) Depreciation S 576.0 S 60.0 Total operating costs...
10. Determine Free Cash Flows from the given income statements and balance sheets. Smith Brothers Corporation Income Statements for Year Ending December 31 (Millions of Dollars) 2016 $300 255 $ 45 2017 Sales $360 Operating costs excluding depreciation 306 EBITDA $ 54 Depreciation EBIT $ 45 Interest EBT S 38 Taxes (40%) _15 Net income S 23 $ 38 $ 32 13 S 19 Smith Brothers Corporation Balance Sheets as of December 31 (Millions of Dollars) Assets 2017 2016 Cash...
The Davidson Corporation's balance sheet and income statement are provided here. Davidson Corporation: Balance Sheet as of December 31, 2018 (Millions of Dollars) Assets Liabilities and Equity Cash and equivalents 15. Accounts payable 120 Accounts receivable 610 Accruals 230 Inventories 900 Notes payable 215 $ 1,525 Total current assets Total current liabilities 565 Net plant and equipment 2,290 Long-term bonds 1,510 Total liabilities $ 2,075 Common stock (100 million shares) 240 Retained earnings $ 1,500 Common equity $1,740 $3,815 Total...
The Davidson Corporation's balance sheet and income statement are provided here. Davidson Corporation: Balance Sheet as of December 31, 2018 (Millions of Dollars) Assets Liabilities and Equity Cash and equivalents 15 Accounts payable Accounts receivable 505 Accruals Inventories 880 Notes payable Total current assets $ 1,400 Total current liabilities Net plant and equipment 2,430 Long-term bonds Total liabilities Common stock (100 million shares) Retained earnings Common equity Total assets $ 3,830 Total liabilities and equity 130 290 240 660 1,490...
Forecast the Statement of Cash Flows Following are the income statements and balance sheets of Best Buy Co., Inc. Income Statement, Fiscal Years Ended ($ millions) 2012 Estimated Feb. 26, 2011 Revenue $53,037 $50,272 Cost of goods sold 39,672 37,611 Restructuring charges - cost of goods sold -- 24 Gross profit 13,365 12,637 Selling, general and administrative expenses 10,873 10,325 Restructuring charges -- 198 Goodwill and tradename impairment -- -- Operating income 2,492 2,114 Other income (expenses) Investment income and...
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. April 26, 2019 $30,557 9,155 2,330 10,418 1,764 Consolidated Statement of Income, 12 Months Ended ($ millions) Net Sales Costs and expenses Cost of products sold Research and development expense Selling, general, and administrative expense Amortization of intangible assets Restructuring charges, net Certain litigation charges Other operating expense, net Operating profit Other nonoperating income, net Interest expense Income before income taxes Income tax...
Arlington Corporation's financial statements (dollars and shares are in millions) a Balance Sheets as of December 31 2018 2017 Assets Cash and equivalents $ 14,000 $ 13,000 Accounts receivable 30,000 20,000 Inventories 25,585 17,000 Total current assets $69,585 $50,000 Net plant and equipment 46,000 45,000 Total assets $115,58 $95,000 Liabilities and Equity Accounts payable $ 10,900 s 8,500 Accruals 7,100 5,000 Notes payable 6,800 5,050 Total current liabilities $ 24,800 s 18,550 Long-term bonds 10,000 10,000 $ 34,800 $ 28,550...
How do I calculate the Investment in Net Profit Operating Capital? I need an example of how to do it. I am stuck on this area of my excel worksheet for Chapter 12 11P. I am working on the following worksheet and I cannot figure out how to get the answer to for the Investment in total net operating capital. Actual Projected Projected Projected Projected Calculation of FCF 12/31/2016 12/31/17 12/31/18 12/31/19 12/31/20 Operating current assets $248.00 $285.20 $313.72 $332.5...
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...
The balance sheet and income statement shown below are for Konki Inc. Note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over Balance Sheet (Millions of 5) Assets Cash and securities Accounts receivable Inventories Total current assets Net plant and equipment Total assets Liabilities and Equity Accounts payable Accruals Notes payable Total current liabilities 2018 $3,000...