Please go step by step in detail, thank you in advance!
The maximum price per share Schultz should pay for Arras is $ 47.74 / share.
Working notes ÷
Share price = value of equity /no. of shares
Value of equity = Value of company - value of debt
Value of firm = present value of future cash flows
The cash flows each year will be:
Year 1: $7,100,000(1 + .07) = $7,597,000
Year 2: $7,597,000(1 + .07) = $8,128,790
Year 3: $8,128,790(1 + .07) = $8,697,805
Year 4: $8,697,805(1 + .07) = $9,306,651
Year 5: $9,306,651(1 + .07) = $9,958,117
Year 6: $9,958,117(1 + .04) = $10,356,442
Since the cash flows begin a perpetual growth rate, we can calculate the terminal value in year 5
We are valuing Arras, we need to use the cost of capital for that company i.e. 9%
. So, the terminal value is:
TV5= CF6/ (WACC– g)
TV5= $10,356,442/(0.09 – 0.04)
TV5= $207,128,840
Now we can discount the cash flows for the first 5 years and the terminal value ÷
Value of firm
= $[7,597,000 /(1.09)1 + 8,128,790/(1.09)2 + 8,697,805/(1.09)3 + 9,306,651/(1.09)4 + (9,958,117+ 207,128,840)/(1.09)5]
= $[7,597,000 × 0.917 + 8,128,790 × 0.842 + 8,697,805 × 0.772 + 9,306,651 × 0.708 + 217,086,957 × 0.650
= $168,221,227
The value of the equity = $(168,221,227 – 25,000,000 ) =$143,221,227
Share price = $143,221,227/3,000,000
Share price = $ 47.74 / share
The maximum price per share Schultz should pay for Arras is $ 47.74 / share.
NOTE÷
1. As nothing said in the question for rounding off ,the figures for annuity factor are rounded to 3 decimals. So there may be a little bit difference in the value of company. And the final answer is rounded to 2 decimals
1. If calculation is made with financial calculator then the value of company is $ 168,212,559.75
value of equity =$(168,212,559.75 - 25,000,000)
=$143,212,559.75
Share price = 143,212,559.75/ 3,000,000
=$ 47.738
= $ 47.74 / share
The final answer i.e. price per share is same =
$ 47.74/share in both the calculations.
Please go step by step in detail, thank you in advance! Schultz Industries is considering the...
Schultz Industries is considering the purchase of Arras Manufacturing. Arras is currently a supplier for Schultz, and the acquisition would allow Schultz to better control its material supply. The current cash flow from assets for Arras is $6.5 million. The cash flows are expected to grow at 8 percent for the next five years before leveling off to 5 percent for the indefinite future. The cost of capital for Schultz and Arras is 12 percent and 10 percent, respectively. Arras...
Problem 13-20 Firm Valuation Schultz Industries is considering the purchase of Arras Manufacturing. Arras is currently a supplier for Schultz and the acquisition would allow Schultz to better control its material supply. The current cash flow from assets for Arras is $8.3 million. The cash flows are expected to grow at 7 percent for the next five years before leveling off to 4 percent for the indefinite future. The costs of capital for Schultz and Arras are 11 percent and...
Saved Help Save & Exit Submit Check my work 15 Schultz Industries is considering the purchase of Arras Manufacturing. Arras is currently a supplier for Schultz, and the acquisition would allow Schultz to better control its material supply. The current cash flow from assets for Arras is $7.4 million. The cash flows are expected to grow at 9 percent for the next five years before leveling off to 6 percent for the indefinite future. The cost of capital for Schultz...
McDonalds is considering the purchase of Yukon Commercial Bakeries. Yukon bakes hamburger buns and bagels used by several fast food restaurant chains, including McDonalds. McDonalds sees the purchase as a way to maintain a consistent supply of bakery products to its Canadian operators and franchisees. The current free cash flow for Yukon is $28.9 million. The cash flows are expected to grow at 7 percent for the next five years before leveling off to 4 percent for the indefinite future....
Hello, can I get a step by step solution using excel. Thank you
Titan Mining Corporation has 9.5 million shares of common stock outstanding and 390,000 4.9 percent semiannual bonds outstanding, par value $1,000 each. The common stock currently sells for $43 per share and has a beta of 1.15; the bonds have 15 years to maturity and sell for 114 percent of par. The market risk premium is 8.3 percent, T-bills are yielding 4 percent, and the company's tax...
The Hollings Corporation is considering a two-step buyout of the Norton Corporation. The latter firm has 2.5 million shares outstanding and its stock price is currently $40 per share. In the two-step buyout, Hollings will offer to buy 51 percent of Norton’s shares outstanding for $62 per share in cash and the balance in a second offer of 840,000 convertible preferred stock shares. Each share of preferred stock would be valued at 40 percent over the current value of Norton’s...
Hello, can I please get a step by step solution using excel?
Thank you!
National Business Machine Co. (NBM) has $4.4 million of extra cash after taxes have been paid. NBM has two choices to make use of this cash. One alternative is to invest the cash in financial assets. The resulting investment income will be paid out as a special dividend at the end of three years. In this case, the firm can invest in either Treasury bills yielding...
can you please show calculations.
eBook Problem 8-10 You are building a free cash flow to the firm model. You expect sales to grow from $1.8 billion for the year that just ended to $3.6 billion five years from now. Assume that the company will not become any more or less efficient in the future. Use the following information to calculate the value of the equity on a per-share basis a. Assume that the company currently has $648 million of...
Could you please solve it with the formula in Excel for each
step? Thank you
17-12. (Preparing a cash budget) Harrison Printing has projected its sales for the first eight months of 2017 as follows: January $100,000 May $275,000 February 120.000 June 200,000 March 150,000 July 200,000 April 300.000 August 180.000 Harrison collects 20 percent of its sales in the month of the sale, 50 percent in the month following the sale, and the remaining 30 percent two months following...
Thank you so much! Please help me solve the problem b, c,
d.
Sora Industries has 67 million outstanding shares, $127 million in debt, $47 million in cash, and the following projected free cash flow for the next four years : a. Suppose Sora's revenue and free cash flow are expected to grow at a 4.9% rate beyond year 4. If Sora's weighted average cost of capital is 120%, what is the value of Sora's stock based on this information?...