Excel Online Structured Activity: New Stock Issue Bynum and Crumpton Inc. (B&C), a small jewelry manufacturer,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excel Online Structured Activity: New Stock Issue 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 Shares outstanding Price per share Earnings per share Free cash flow per share Book value per share Total assets Total debt Abercrombe 6 million $34.00 $2.20 Gunter 11 million $51.00 B&C 500,000 NA 111 $1.63 $14.00 $3.13 $2.60 $2.00 $2.54 $22.00 $19.00 $119 million $292 million $13.5 million $35 million $50 million $4 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 a. 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 FCF 1 2 3 4 5 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 Per share value of equity $ $ b. 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. D/A P/E Market/Book ROE P/FCF Abercrombe Gunter B&C % % % % % % c. 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 $ to $ Check My Work Reset Problem Excel Online Structured Activity: New Stock Issue 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 Shares outstanding Price per share Earnings per share Free cash flow per share Book value per share Total assets Total debt Abercrombe 6 million $34.00 $2.20 Gunter 11 million $51.00 B&C 500,000 NA 111 $1.63 $14.00 $3.13 $2.60 $2.00 $2.54 $22.00 $19.00 $119 million $292 million $13.5 million $35 million $50 million $4 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 a. 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 FCF 1 2 3 4 5 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 Per share value of equity $ $ b. 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. D/A P/E Market/Book ROE P/FCF Abercrombe Gunter B&C % % % % % % c. 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 $ to $ Check My Work Reset Problem
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
At the beginning of the year, COMET Company decided to raise additional capital by issuing 8,000 of 1,000 face amount 5-year bonds with interest rate of 12% payable semi-annually on June 30 and...
-
The following data, presented in alphabetical order, are taken from the records of Urbina Corporation. Accounts payable $ ................... 240,000 Accounts receivable ................... 140,000...
-
Over the past few decades, public health officials have examined the link between weight concerns and teen girls' smoking. Researchers surveyed a group of 273 randomly selected teen girls living in...
-
What should be included in an engagement letter? What are some reasons a client might change the terms of the engagement? What are the two basic types of engagement proposals?
-
Hitchcock, Michelson, and Jasper, a partnership, is considering admitting Ken Saunders as a new partner. On July 31 of the current year, the capital accounts of the three existing partners and their...
-
HotFoot Shoes would like to maintain its cash account at a minimum level of $41,000 but expects the standard deviation in net daily cash flows to be $3,600, the effective annual rate on marketable...
-
Firms achieve strategic competitiveness by: O a. being the first to try a new business strategy. O b. formulating and implementing a value-creating strategy. c. creating a vision for a company. O d....
-
Why education is considered a science
-
How can we design a wireless power transmission system that can efficiently and safely deliver megawatts of power over long distances (several kilometers) while minimizing energy losses due to...
-
Write an essay about "The importance of water to animals, people and the environment" ?
-
The ability to analyze a story can be further demonstrated by creating something new. For your Written Assignment, you will take the story you read for this week and write a one paragraph news story...
-
In this assignment, you will acquire the knowledge and skills to think critically and evaluate reliable and credible sources. Write a concise report, consisting of a single paragraph, by selecting a...
-
This only needs to be a paragrah or two in length What is the difference between correlation and causation? Include real-world examples in your answer that illustrate the difference between...
-
Explain the term "Equivalent Units". Why are they calculated in process costing? [4 Marks] [minimum 350 words]
-
Interest in Advance versus Interest Paid When Loan Is Due On July 1, 2008, Moton Company needs exactly $206,400 in cash to pay an existing obligation. Moton has decided to borrow from State Bank,...
-
Comparison of Alternatives On January 1, 2008, Chen Yus Office Supply Store plans to remodel the store and install new display cases. Chen has the following options of payment. Chens interest rate is...
-
The items at the top of the opposite page are components of Munsey Companys income statement for the year ended December 31, 20xx. Recast the income statement in proper multistep form, including...
Study smarter with the SolutionInn App