Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bynum and Crumpton Inc. (B&C), a small jewelry manufacturer, has been successful and has enjoyed a positive growth trend. Now B&C is planning to go

Bynum and Crumpton Inc. (B&C), a small jewelry manufacturer, has been successful and has enjoyed a positive growth trend. Now B&C is planning to go public with an issue of common stock, and it faces the problem of setting an appropriate price for the stock. The company and its investment banks believe that the proper procedure is to conduct a valuation and select several similar firms with publicly traded common stock and to make relevant comparisons.
Several jewelry manufacturers are reasonably similar to B&C with respect to product mix, asset composition, and debt/equity proportions. Of these companies, Abercrombe Jewelers and Gunter Fashions are most similar. When analyzing the following data, assume that the most recent year has been reasonably "normal" in the sense that it was neither especially good nor especially bad in terms of sales, earnings, and free cash flows. Abercrombe is listed on the AMEX and Gunter on the NYSE, while B&C will be traded in the Nasdaq market.
Company data Abercrombe Gunter B&C
Shares outstanding 5 million 11 million 500,000
Price per share $39.00 $53.00 NA
Earnings per share $2.20 $3.13 $2.60
Free cash flow per share $1.63 $2.54 $2.00
Book value per share $14.00 $23.00 $19.00
Total assets $105 million $303 million $10.5 million
Total debt $35 million $50 million $2 million
The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Open spreadsheet
B&C is a closely held corporation with only 500,000 shares outstanding. Free cash flows have been low and in some years negative due to B&C's recent high sales growth rates, but as its expansion phase comes to an end B&C's free cash flows should increase. B&C anticipates the following free cash flows over the next 5 years:
Year 1 2 3 4 5
FCF 1,000,000 1,050,000 1,208,000 1,329,000 1,462,000
After Year 5, free cash flow growth will be stable at 7% per year. Currently, B&C has no non-operating assets, and its WACC is 12%. Using the free cash flow valuation model, estimate B&C's intrinsic value of equity and intrinsic per share price. Do not round intermediate calculations. Round your answer for the value of equity to the nearest dollar. Round your answer for the value of equity per share to the nearest cent.
Value of equity $ fill in the blank 2
Per share value of equity $ fill in the blank 3
Calculate debt to total assets, P/E, market to book, P/FCF, and ROE for Abercrombe, Gunter, and B&C. For calculations that require a price for B&C, use the per share price you obtained with the corporate valuation model in part a. Do not round intermediate calculations. Round your answers to two decimal places.
Abercrombe Gunter B&C
D/A fill in the blank 4 % fill in the blank 5 % fill in the blank 6 %
P/E fill in the blank 7 fill in the blank 8 fill in the blank 9
Market/Book fill in the blank 10 fill in the blank 11 fill in the blank 12
ROE fill in the blank 13 % fill in the blank 14 % fill in the blank 15 %
P/FCF fill in the blank 16 fill in the blank 17 fill in the blank 18
Using Abercrombe's and Gunter's P/E, Market/Book, and Price/FCF ratios, calculate the range of prices for B&C's stock that would be consistent with these ratios. For example, if you multiply B&C's earnings per share by Abercrombe's P/E ratio you get a price. What range of prices do you get? Do not round intermediate calculations. Round your answers to the nearest cent.
The range of prices:
from $ fill in the blank 19 to $ fill in the blank 20
image text in transcribed
image text in transcribed
B A Company data Shares outstanding Price per share Earnings per share Free cash flow per share Book value per share Total assets (in Millions) Total debt (In millions) Abercrombo 5,000,000 $39.00 $2.20 $1.63 $14.00 $105.00 $35.00 Gunter 11,000,000 $53.00 $3.13 $2.54 $23.00 $303.00 $50.00 B&C 500,000 NA $2.60 $2.00 $19.00 $11.50 $2.00 Free Cash Flow Valuation Model: Constant growth rate after years WACC Non-operating assets 7.00% 12.00% $0 Formula Year 1 $1,000,000 Year 2 $1,050,000 Year 3 $1,208,000 Year 4 Year 5 $1,329,000 $1,462,000 #N/A B&C's expected free cash flows (FCFS) Horizon value FCFS $1,000,000 $1,050,000 $1,208,000 $1,329,000 $1,462,000 Formulas WNIA ANIA INIA WNIA 3 Value of operations Non-operating assets 5 Debt 6 Intrinsic value of equity 37 18 Intrinsic price pet sharo 29 30. Ratio Calculations: 31 DebuAssets (DIA) 32 Price/Earnings (P/E) 33 MarketBook (MB) 34 Retum on Equity. ROE Sheet1 Abercrombe Gunter 5&C Abercrombe UNIA F WNIA WNIA AN/A Formulas Gunter WNIA ANIA ANIA N/A B&C ANIA #N/A ANIA WNIA F17 Year 5 D E INA Abercrombe Gunter B&C 27 28 Intrinske price per share 29 30 Rato Calculations 31 DebtAssets (DIA) 32 Pro/Eamings (PE) 33 MarkeBook (MB) 34 Return on Equity (ROE) 35 Price/Free Cash Flow (P/FCF) 36 37 Abercrombe WNIA INJA ANIA #N/A MINIA Formulas Gunter #N/A UNIA #NIA WN/A #N/A B&C ANIA #N/A WNIA #NIA WNIA Range of Bac Prices Based on 38 Abercrombe and Gunter Ratios: 39 Abercrombe P/E 40 Gunter P/E 41 Abercrombe MB 42 Gunter MB 43 Abercrombe P/FCF 44 Gunter P/FCF 45 46 Stock price range Formulas Ratio 0.00 0.00 0.00 0.00 0.00 0.00 Formulas Implied Implied B&C B&C Price B&C Measure Price Per Share B&C Measure Per Share #N/A WNIA $0.00 #N/A #N/A N/A $0.00 ANIA #N/A #N/A $0.00 #N/A to WNIA #N/A B A Company data Shares outstanding Price per share Earnings per share Free cash flow per share Book value per share Total assets (in Millions) Total debt (In millions) Abercrombo 5,000,000 $39.00 $2.20 $1.63 $14.00 $105.00 $35.00 Gunter 11,000,000 $53.00 $3.13 $2.54 $23.00 $303.00 $50.00 B&C 500,000 NA $2.60 $2.00 $19.00 $11.50 $2.00 Free Cash Flow Valuation Model: Constant growth rate after years WACC Non-operating assets 7.00% 12.00% $0 Formula Year 1 $1,000,000 Year 2 $1,050,000 Year 3 $1,208,000 Year 4 Year 5 $1,329,000 $1,462,000 #N/A B&C's expected free cash flows (FCFS) Horizon value FCFS $1,000,000 $1,050,000 $1,208,000 $1,329,000 $1,462,000 Formulas WNIA ANIA INIA WNIA 3 Value of operations Non-operating assets 5 Debt 6 Intrinsic value of equity 37 18 Intrinsic price pet sharo 29 30. Ratio Calculations: 31 DebuAssets (DIA) 32 Price/Earnings (P/E) 33 MarketBook (MB) 34 Retum on Equity. ROE Sheet1 Abercrombe Gunter 5&C Abercrombe UNIA F WNIA WNIA AN/A Formulas Gunter WNIA ANIA ANIA N/A B&C ANIA #N/A ANIA WNIA F17 Year 5 D E INA Abercrombe Gunter B&C 27 28 Intrinske price per share 29 30 Rato Calculations 31 DebtAssets (DIA) 32 Pro/Eamings (PE) 33 MarkeBook (MB) 34 Return on Equity (ROE) 35 Price/Free Cash Flow (P/FCF) 36 37 Abercrombe WNIA INJA ANIA #N/A MINIA Formulas Gunter #N/A UNIA #NIA WN/A #N/A B&C ANIA #N/A WNIA #NIA WNIA Range of Bac Prices Based on 38 Abercrombe and Gunter Ratios: 39 Abercrombe P/E 40 Gunter P/E 41 Abercrombe MB 42 Gunter MB 43 Abercrombe P/FCF 44 Gunter P/FCF 45 46 Stock price range Formulas Ratio 0.00 0.00 0.00 0.00 0.00 0.00 Formulas Implied Implied B&C B&C Price B&C Measure Price Per Share B&C Measure Per Share #N/A WNIA $0.00 #N/A #N/A N/A $0.00 ANIA #N/A #N/A $0.00 #N/A to WNIA #N/A

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

Concise 10th Edition

1337902578, 978-1337902571

More Books

Students also viewed these Finance questions

Question

What is the typical class size?

Answered: 1 week ago

Question

Do you favor a civil service system? Why or why not?

Answered: 1 week ago