E-BMAAVASM

E-BMAAVASM - Worksheet Title Determine Acquirer and Target...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Worksheet Title Short Name Determine Acquirer and Target Standalone Valuations Acquirer 5-Year Forecast and Standalone Valuation BP_App_B1 Acquirer Historical Data and Ratios BP_App_B2 Acquirer Debt Repayment Schedules BP_App_B3 Acquirer Cost of Equity and Capital Calculation BP_App_B4 Target 5-Year Forecast and Standalone Valuation AP_App_B1 Target Historical Data and Ratios AP_App_B2 Target Cost of Equity and Capital Calculation AP_App_B3 Value Combined Acquirer and Target Firms Including Synergy Combined Firm's 5-Year Forecast and Valuation AP_App_C Synergy Estimation AP_App_D Determine Initial Offer Price for Target Firm Offer Price Determination AP_App_E Alternative Valuation Summaries AP_App_F Determine Combined Firm's Ability to Finance Transaction Combined Firm's Financing Capacity AP_App_G Acquisition Timeline AP_App_A1 Summary: Milestones and Responsible Individual(s) AP_App_A2
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
MATTEL Business Plan 2001-2005 Financial Forecast Appendix B-1 Mattel Business Plan 2 of 18 01/28/2011 Step 1: Acquirer 5-Year Forecast and Standalone Valuation Forecast Assumptions 2006 - 2010 2006 2007 2008 2009 2010 Net Sales Growth Rate 4.0% 4.0% 4.0% 4.0% 4.0% Cost of Sales (Variable) / Sales % 52.5% 51.5% 51.0% 50.5% 50.5% 8.3% 8.3% 8.3% 8.3% 8.3% Selling Expenses / Sales (%) 14.5% 14.5% 14.5% 14.5% 14.5% 19.0% 18.5% 18.0% 17.2% 16.4% 5.0% 5.0% 5.0% 5.0% 5.0% Interest Rate on New Debt (%) 8.3% 8.3% 8.3% 8.3% 8.3% Marginal Tax Rate 18.0% 22.0% 25.0% 30.0% 37.0% Other Current Operations Assets / Sales (%) 35.0% 35.0% 35.0% 35.0% 35.0% Other Assets / Sales (%) 35.0% 30.0% 25.0% 20.0% 20.0%
Background image of page 2
MATTEL Business Plan 2001-2005 Historical Ratios and Explanations of Assumptions Appendix B-2 Mattel Business Plan dbf7efbd19effd66c775717a0bd587d7ee901944.xlsBP_App_B2 01/28/2011 Step 1 Continued: Acquirer Historical Data and Ratios Historical Ratios Historical Financial Ratios 2002 2003 2004 2005 Average Minimum Maximum Net Sales Growth Rate 1) -1.7% -2.2% 1.6% -0.8% -2.2% 1.6% Cost of Sales (Variable) / Sales % 2) 50.5% 50.8% 52.5% 53.3% 51.8% 50.5% 53.3% 3) 10.7% 8.9% 7.1% 6.7% 8.3% 6.7% 10.7% Selling Expenses / Sales (%) 4) 15.9% 16.7% 14.9% 14.6% 15.5% 14.6% 16.7% 5) 16.3% 18.4% 18.9% 19.4% 18.3% 16.3% 19.4% 6) 3.0% 3.5% 4.0% 5.0% 3.9% 3.0% 5.0% Interest Rate on Debt (%) 7) 6.0% 5.6% 5.5% 6.7% 6.0% 5.5% 6.7% Tax Rate 8) 28.6% 26.0% 13.7% 13.6% 20.5% 13.6% 28.6% Other Assets / Sales (%) 9) 17.8% 38.7% 45.6% 41.0% 35.8% 17.8% 45.6% Gross Fixed Assets / Sales (%) 10) 19.6% 24.7% 25.0% 24.0% 23.3% 19.6% 25.0% Cash Balance / Sales (%) 11) 14.5% 4.5% 5.4% 5.0% 7.4% 4.5% 14.5% Other Current (Operations) Assets / Sales (%) 12) 37.0% 39.3% 34.9% 32.5% 35.9% 32.5% 39.3% Current Liabilities / Sales (%) 13) 24.6% 28.0% 34.1% 32.2% 29.7% 24.6% 34.1% Debt / Equity
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/28/2011 for the course FIN 315 taught by Professor Welker during the Spring '09 term at IUP.

Page1 / 18

E-BMAAVASM - Worksheet Title Determine Acquirer and Target...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online