Please see prompt attached as well as excel template
Valuing buyout investments Alternative Investments: Week 5 Marked Assessment This problem set is designed to help you understand the way buyout deals are valued, as well as giving you practice in applying the APV method of valuing companies and using the Growth-In-Perpetuity Model to calculate terminal values. The problem is based on the case ‘Berkshire Partners: Bidding for Carter’s’, it provides exposure to the issues that arise when making a competitive bid. In addition to the class presentation slides, you will find the notes, The Adjusted Present Value Method for Capital Assets, helpful in completing the problem set. To answer the questions below you will first need to construct an Excel spreadsheet summarising the key projected financial parameters of the William Carter Company, using the information provided in the case and additional information provided below. Once you have done this, you will need to add to the spreadsheet the projections necessary for calculating APV using the approach to calculating APVs explained in class and in the note. To assist you with this I have provided the spreadsheet LBO Problem Set Spreadsheet Template.xlsx which is saved on Moodle. Once you have constructed the spreadsheet, you will be able to answer Questions (1) through (8), which are designed to lead you through the steps necessary for calculating the value of Carter’s. The answers to subsequent questions will be straightforward and take little time. Hints For Getting Started First, construct a spreadsheet that enables you to project Carter’s income statement, after tax cash flow, and debt balances at the beginning and end of each year for the years 2002 through 2006 using management’s projections shown in the case. Assume net working capital required in each year is equal to 18% of net sales in that year and a tax-rate of 40%. To simplify your task, assume use of Goldman’s staple-on finance facility for the debt but assume there is only a single tranche of senior debt with an interest rate of 9.6%, rather than the more complicated debt structure shown in Exhibit 6 of the case. Furthermore, use $317.5 million as the beginning amount of senior debt in 2002. You will see this is the same amount as the total beginning debt implied by the staple-on financing facility in Exhibit 6 (ensure you understand how this figure is arrived at). Important Notice: If you construct the spreadsheet properly and use correct assumptions, the debt balance at the end of 2006 should be close to $136.7 million. If not, you have made a mistake somewhere and you should not go any further until your spreadsheet projects this figure. Question 1: What is Carter’s after tax cash flow in 2006, using the forecasts provided by Carter’s management? Answer: Question 2: What is the Equity Discount Rate in this situation? Hint: Information about what to assume as the risk-free-rate and the information necessary to calculate the Asset Beta can be found in the case. Assume the Equity Market Premium is 7.7%, which is the difference between US stock mark returns and the yields of intermediate–term government bonds from 1926 to 2000, as calculated by Ibbotson Associates. Answer: Question 3: Based on management’s forecast financials, what is the NPV of Carter’s cashflows from 2002 to 2006, assuming Carter's is financed only with equity? Hint: Add pro-forma projections of cash flows to your spreadsheet assuming Carter’s is financed only with equity. Answer: Question 4: Based on management’s forecast financials, what is the terminal value at the end of 2006 of Carter’s cash flows using the Growth-In-Perpetuity model? Hint: Add to your spreadsheet the calculation of the terminal value, using the Growth-in-Perpetuity model and assuming the perpetual growth rate is 4% Answer: Question 5: What is the NPV of Carter’s terminal value? Answer: Question 6: Based on management’s forecast financials, what is the NPV of the interest tax shields from 2002 to 2006? Hint: Add to your spreadsheet the projections necessary to calculate interest tax shields. Ignore the value of the interest tax shields after 2006 (ie, don’t calculate a terminal value for the interest tax shields). Answer: Question 7: What Enterprise Value for Carter’s does the APV valuation technique yield, based on management’s projections, and your answers above? Answer: Question 8: Based on the answer to Question (7), what would be the Equity Value of Carter’s; based on management’s projections and assuming Goldman’s staple-on financing facility is used? Answer: Question 9: What is the Enterprise Value of Carter’s, assuming historical sales growth and EBITDA margins (instead of management’s projections)? Hint: Modify your spreadsheet so that Net Sales and EBITDA are calculated using historical sales growth and historical EBITDA margins, rather than the figures projected by management. Repeat the APV calculation using these different assumptions. Exhibit 4 provides historical financial results from 1997 to 2000 and Exhibit 7a provides estimated results for 2001. This information can be analysed to calculate the average historical growth (1997-2001) in Net Sales and the average EBITDA margin. Such an analysis shows average Net Sales growth in 1997-2001 was 11.2% and average EBITDA margin was 11.3%. Assume Depreciation and Amortisation and Capital Expenditure remain the same as assumed by management, and working capital continues to be 18% of Net Sales. Answer: Question 10: Based on the answer to Question (9), what would be the Equity Value of Carter’s, using historical growth in Net Sales and EBITDA margin and assuming Goldman’s staple-on financing facility is used? Answer: Question 11: Taking into account your answers to the above questions and all information in the case, would you make a bid for Carter’s – Yes or No? Hint: You do not have to accept either management’s projections or the historical projection. You can use your model to make your own personal projections based on what you personally feel are the best assumptions to make about the rate of sales growth and the EBITDA margin percentage, taking into account all of the information in the case and your own belief as to how successful Carter’s management might be in making improvements to the business. Answer: Question 12: If the answer to Question (11) is “Yes”, what would be the value of your Equity bid, assuming you use Goldman’s staple-on financing facility? Answer: Question 13: With regard to your answers to Questions 11 and 12, what did you personally assume in your model to be the rate of sales growth and the EBITDA margin percentage – ie, management’s assumption, the historical assumptions, or your own assumptions? If you used your own assumptions of sales growth/EBITDA margin, indicate what assumptions you used. Answer: Berkshire Partners: Bidding for Carter’s E du ca tio na l m at er ia l s up pl ie d by T he C as e C en tre C op yr ig ht e nc od ed A 76 H M -J U J9 K -P JM N 9I O rd er re fe re nc e F3 92 01 2 _______ Professo basis for manage Copyrig 800-545- may be photoco M A L C O J A M E S Ber In levera appar retail the co mana To by m Exhib the st bid st In would the op Cart Ca highly toddle Divid young for th In Mutu swim not w Frede 1 Morg billion commo _______________ or Malcolm Baker a r class discussion. ment. ght © 2005, 2008, 2 -7685, write Harvar reproduced, store opying, recording, o O L M B A K E R Q U I N N rkshire the spring o aged buyout rel in the Un and manufac ompany had agement team o investigate t anaging dire bit 2 for biogr ages of a Gol trategy. addition to d be offering ption to finan ter’s arter’s was fo y competitive er and baby a ding its mark g children’s s e first six yea the early 199 ual Benefit Lif wear and un well received b erick J. Rowa gan Stanley had r in debt financin on. _______________ and Research Assoc Cases are not inte 011 President and rd Business School d in a retrieval sys or otherwise—with e Partne of 2001, Bost (LBO) of the nited States. B cturing sector developed d m. (See Exhibit the option of ectors Ross Jo raphical sketc ldman Sachs- running the g “staple-on” nce the deal th ounded in 18 e apparel in apparel in the ket into five sleepwear, an ars of life, “fro 90s, the comp fe and Wesray nderwear, and by consumers an, with the recently made a g after leading th ________________ ciate James Quinn, ended to serve as e Fellows of Harvar l Publishing, Boston stem, used in a sp hout the permission ers: Bid ton-based pri William Cart Berkshire Par rs, was initia during its 136 t 1 for a profil f a potential L ones and Bra ches.) The tea -led auction— auction and financing. U hrough a prep 865 in Needh dustry, the c e United State segments—la nd young chil om birth to bu any found its y Capital Cor d many of its s. In 1992, the intention of similar offering he auction. Whi _______________ Global Research G endorsements, sou rd College. To ord n, MA 02163, or go preadsheet, or trans n of Harvard Busin dding f ivate equity ter Co., a lead rtners, which ally drawn to 6-year history le of Berkshir LBO, Berkshir adley Bloom am would hav —from initial r thereby serv nder this arr packaged capi am, Massach company bec es and also a ayette (i.e., n ldren’s playw us.” self struggling rp., Carter’s h s more decora e company ins “steering it to the eventual b ile staple-on fina _______________ Group, prepared thi urces of primary da der copies or reque o to http://www.h smitted in any form ness School. for Cart firm Berkshi ding producer h had extensi o Carter’s bec y, as well as re.) re assembled and senior a ve less than e research and ving as Carter rangement, th ital structure husetts. Over came the lar leading mak newborn), ba wear—the com g. Owned at had develope ative features stalled a new back to its c buyer of Dresser ancing was not a R _______________ is case. HBS cases a ata, or illustrations est permission to r hbsp.harvard.edu.