Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please use the Monster Financials Spreadsheet to complete all the tabs of the Valuation Model spreadsheet. NAME: TICKER SYMBOL: MONSTER WORLDWIDE INC MWW PRIMARY SIC
Please use the "Monster Financials" Spreadsheet to complete all the tabs of the "Valuation Model" spreadsheet.
NAME: TICKER SYMBOL: MONSTER WORLDWIDE INC MWW PRIMARY SIC CODE: 7370 STOCK EXCHANGE: 11 CUSIP: New York Stock Exchange 611742 STATEMENT OF FINANCIAL POSITION Fiscal Year: (FYR Ending): 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 (31DEC2004 ) (31DEC2005 ) (31DEC2006 ) (31DEC2007 ) (31DEC2008 ) (31DEC2009 ) (31DEC2010 ) (31DEC2011 ) (31DEC2012 ) (31DEC2013 ) (31DEC2014 ) ASSETS Cash & Equivalents 198.111 320.344 596.573 578.447 223.685 284.706 163.169 250.317 148.185 88.581 94.297 Receivables - Total (Net) 441.827 392.439 444.747 499.854 376.720 287.698 346.751 343.546 335.905 332.675 282.523 26.375 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 37.198 60.276 82.488 106.664 82.416 73.089 75.451 82.069 95.563 82.809 83.326 Current Assets - Total 703.511 773.059 1,123.808 1,184.965 682.821 645.493 585.371 675.932 579.653 504.065 460.146 Plant, Property & Equip (Gross) 250.921 257.685 278.972 342.487 395.460 426.105 483.518 420.493 455.398 448.690 425.720 Accumulated Depreciation 156.363 164.333 176.570 215.525 234.178 282.378 333.371 264.211 307.785 324.521 305.991 Plant, Property & Equip (Net) 94.558 93.352 102.402 126.962 161.282 143.727 150.147 156.282 147.613 124.169 119.729 Investments at Equity .000 46.758 59.625 70.871 1.843 .546 1.359 1.183 .562 .218 20.700 Investments and Advances - Other .000 .000 .000 .000 90.347 15.410 .000 .000 .000 .000 .000 723.217 735.678 640.736 661.850 946.881 969.621 1,189.135 1,184.122 919.854 919.576 571.124 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 Assets - Other 22.327 29.868 43.232 33.162 33.416 52.393 51.990 40.479 37.183 38.229 45.452 TOTAL ASSETS 1,543.613 1,678.715 1,969.803 2,077.810 1,916.590 1,827.190 1,978.002 2,057.998 1,684.865 1,586.257 1,217.151 258.670 100.047 56.098 57.334 41.524 32.066 36.569 27.411 181.914 166.257 159.027 12.939 .000 .000 .000 54.971 .000 .000 .000 11.389 .000 .000 Inventories - Total Prepaid Expenses Current Assets - Other Intangibles Deferred Charges LIABILITIES Accounts Payable Notes Payable Accrued Expenses Taxes Payable .000 49.397 84.433 13.384 7.896 20.779 12.907 16.830 .000 .000 .000 29.262 31.378 23.249 .184 .018 5.010 84.500 188.836 6.875 9.375 9.563 Other Current Liabilities 429.872 525.124 662.464 757.758 619.299 449.301 552.848 549.886 384.802 343.205 300.724 Total Current Liabilities 730.743 705.946 826.244 828.660 723.708 507.156 686.824 782.963 584.980 518.837 469.314 Long Term Debt 33.975 15.678 .415 .231 .010 45.000 40.000 .000 145.975 125.900 201.821 Deferred Taxes (Balance Sheet) 21.901 22.374 32.594 19.154 24.658 51.499 17.186 4.665 3.707 36.930 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 1.480 1.377 .865 113.264 120.941 90.371 105.342 106.243 70.164 60.445 71.271 .000 .000 .000 .000 .000 .000 Debt (Long-Term) Due In One Year Investment Tax Credit Liabilities - Other Noncontrolling Interest - Redeemable TOTAL LIABILITIES 788.099 745.375 860.118 961.309 869.317 694.026 849.352 893.871 804.826 742.112 742.406 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 SHAREHOLDERS' EQUITY Preferred Stock Common Stock .122 .127 .131 .133 .133 .134 .136 .138 .140 .142 .144 Capital Surplus 1,144.105 1,548.936 1,636.023 1,468.808 1,367.373 1,395.969 1,424.815 1,405.915 1,357.126 2,003.394 2,040.209 -388.713 -615.723 -526.469 -352.440 -320.233 -262.939 -296.301 -241.926 -477.227 -501.503 -844.915 .000 .000 .000 .000 .000 .000 .000 .000 .000 712.362 774.940 755.514 933.340 1,109.685 1,116.501 1,047.273 1,133.164 1,128.650 1,164.127 880.039 789.671 420.498 54.474 54.247 Retained Earnings (Net Other) Less: Treasury Stock Shareholders Equity - Parent Noncontrolling Interest - Nonredeemable TOTAL SHAREHOLDERS EQUITY 755.514 933.340 1,109.685 1,116.501 1,047.273 1,133.164 1,128.650 1,164.127 880.039 844.145 474.745 TOTAL LIABILITIES AND EQUITY 1,543.613 1,678.715 1,969.803 2,077.810 1,916.590 1,827.190 1,978.002 2,057.998 1,684.865 1,586.257 1,217.151 INCOME STATEMENT Fiscal Year: (FYR Ending): 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 (31DEC2004 ) (31DEC2005 ) (31DEC2006 ) (31DEC2007 ) (31DEC2008 ) (31DEC2009 ) (31DEC2010 ) (31DEC2011 ) (31DEC2012 ) (31DEC2013 ) (31DEC2014 ) Sales (Net) 845.519 986.917 1,116.676 1,351.309 1,345.840 907.413 919.186 1,042.763 890.392 807.579 770.013 Cost of Goods Sold 693.570 784.784 847.032 1,048.168 1,059.145 823.892 856.897 893.206 748.944 692.317 704.163 Gross Profit 151.949 202.133 269.644 303.141 286.695 83.521 62.289 149.557 141.448 115.262 65.850 Operating Income Before Depreciation 151.949 202.133 269.644 303.141 286.695 83.521 62.289 149.557 141.448 115.262 65.850 Depreciation, Depletion, & Amortiz 37.623 37.955 39.780 46.977 58.020 68.533 67.096 74.600 64.279 59.156 48.643 Operating Income After Depreciation 114.326 164.178 229.864 256.164 228.675 14.988 -4.807 74.957 77.169 56.106 17.207 1.431 4.545 6.000 Selling, General, & Admin Expenses Interest Expense Non-Operating Income/Expense Special Items .693 -.610 2.832 11.384 17.046 9.444 -8.714 -.198 1.649 -6.964 -6.678 -8.242 .000 .000 .000 -41.451 -58.720 -23.799 -37.214 1.562 -45.017 -22.915 -328.063 Pretax Income 113.023 167.010 241.248 231.759 179.399 -18.956 -46.764 72.168 25.188 26.513 -319.098 38.716 60.809 87.661 84.599 64.910 -37.883 -14.405 18.371 -32.978 23.004 -35.291 .193 5.482 3.316 -289.289 Income Taxes - Total Minority Interest Income Before EI&DO 74.307 Extraordinary Items 106.201 153.587 147.160 114.489 18.927 -32.359 53.797 58.166 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 Discontinued Operations -1.203 -8.007 -116.450 -.761 10.304 .000 .000 .000 -316.886 -3.798 .000 Net Income (Loss) 73.104 98.194 37.137 146.399 124.793 18.927 -32.359 53.797 -258.720 -.482 -289.289 Income Before EI&DO 74.307 106.201 153.587 147.160 114.489 18.927 -32.359 53.797 58.166 3.316 -289.289 Preferred Dividends .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 74.307 106.201 153.587 147.160 114.489 18.927 -32.359 53.797 58.166 3.316 -289.289 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 74.307 106.201 153.587 147.160 114.489 18.927 -32.359 53.797 58.166 3.316 -289.289 EPS - Primary, Excluding EI&DO .630 .870 1.200 1.140 .950 .160 -.270 .440 .520 .030 -3.290 EPS - Primary, Including EI&DO .620 .800 .290 1.140 1.040 .160 -.270 .440 -2.290 .000 -3.290 EPS - Fully Diluted, Excluding EI&DO .620 .850 1.170 1.130 .940 .160 -.270 .430 .510 .030 -3.290 EPS - Fully Diluted, Including EI&DO .610 .790 .280 1.120 1.030 .160 -.270 .430 -2.270 -.010 -3.290 Common Shares for Primary EPS Calculation 117.738 122.055 128.077 128.785 120.557 119.359 120.608 122.002 112.866 106.947 88.045 Common Shares for Fully Diluted EPS Calc. 120.075 125.038 131.247 130.755 121.167 121.170 120.608 123.923 113.995 107.913 88.045 Common Shares Outstanding at Fiscal Yr End 120.532 125.465 128.564 123.775 118.614 119.659 121.113 117.628 111.129 92.372 87.936 Available for Common Before EI&DO Common Stock Equivalents - Savings Adjusted Available for Common EARNINGS PER SHARE COMMON SHARES STATEMENT OF RETAINED EARNINGS Fiscal Year: (FYR Ending): Retained Rearnings - Beginning Balance 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 (31DEC2004 ) (31DEC2005 ) (31DEC2006 ) (31DEC2007 ) (31DEC2008 ) (31DEC2009 ) (31DEC2010 ) (31DEC2011 ) (31DEC2012 ) (31DEC2013 ) (31DEC2014 ) -500.916 -388.713 -615.723 -526.469 -352.440 -320.233 -262.939 -296.301 -241.926 -477.227 -501.503 73.104 98.194 37.137 146.399 124.793 18.927 -32.359 53.797 -258.720 -.482 -289.289 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 -427.812 -290.519 -578.586 -380.070 -227.647 -301.306 -295.298 -242.504 -500.646 -477.709 -790.792 Adj. to Long-Term Marketable Securities .000 .000 .000 .149 -1.454 .149 .149 .149 .149 .149 .149 Other CMP Adj,(Stock Splits/Retirement) -.072 .197 .279 .279 .279 .279 .279 .279 .279 .279 .279 39.171 -325.401 51.838 27.351 -92.865 38.088 -1.282 .299 23.140 -24.073 -54.402 Net Income Cash Dividends Retained Earnings After Dividends Change - Foreign Currency Translation Non-Compustat Adjustments (Plug Calculation) Retained Earnings - Ending Balance -388.713 -615.723 -526.469 -352.440 -320.233 -262.939 -296.301 -241.926 -477.227 -501.503 -844.915 Retroactive Adjustments (Acct'g Chgs) .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 Retained Earnings - After Adjustments -388.713 -615.723 -526.469 -352.440 -320.233 -262.939 -296.301 -241.926 -477.227 -501.503 -844.915 STATEMENT OF CASH FLOWS Fiscal Year: (FYR Ending): 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 (31DEC2004 ) (31DEC2005 ) (31DEC2006 ) (31DEC2007 ) (31DEC2008 ) (31DEC2009 ) (31DEC2010 ) (31DEC2011 ) (31DEC2012 ) (31DEC2013 ) (31DEC2014 ) INDIRECT OPERATING ACTIVITIES Income Before Extraordinary Items 74.307 106.201 153.587 147.160 114.489 18.927 -32.359 53.797 58.166 3.509 -283.807 Depreciation and Amortizations 37.623 37.955 39.780 46.977 58.020 68.533 67.096 74.600 70.000 59.156 48.643 Extraordinary Items and Disc. Operations -5.727 -19.643 19.201 -7.584 -6.849 .000 .000 .000 -49.031 -3.798 .000 Deferred Taxes 22.932 27.062 10.781 -3.377 7.430 1.189 -27.890 -5.659 -9.814 28.574 -43.418 7.839 4.317 2.870 1.242 1.081 .908 .078 3.933 .000 -2.415 -1.732 .000 .000 -13.647 Equity in Net Loss (Earnings) .000 Sale of PPEq and Investments - Loss (Gain) Funds from Operations - Other Receivables - Decrease (Increase) .000 .000 23.979 44.559 29.394 48.814 86.184 52.185 50.393 45.982 -2.255 -10.298 366.554 -100.450 -79.135 -171.312 -67.778 112.520 80.462 -53.555 -.856 -2.013 8.018 40.567 .000 .000 .000 .000 .000 .000 .000 .000 .000 Inventory - Decrease (Increase) Accounts/P and Accrued Liabs - Inc(Dec) Income Taxes - Accrued - Increase(Decrease) .000 .000 Other Assets and Liabilities - Net Change 39.871 .000 104.571 187.334 104.967 -157.732 -180.888 88.932 -17.697 -12.807 -52.247 -32.215 Operating Actiities - Net Cash Flow 92.535 221.570 268.765 269.179 225.834 44.725 93.072 149.677 53.327 33.822 82.755 Investments - Increase .000 50.137 29.936 10.000 190.334 14.884 5.648 2.559 2.077 Sale of Investments .000 4.716 .000 .000 540.297 71.740 27.309 2.175 .728 .000 .000 .000 -118.461 -414.146 89.190 .000 .000 .000 24.349 39.807 55.606 64.055 93.627 48.677 57.126 61.818 59.572 32.616 39.843 .000 .000 .000 .000 .000 .000 .000 .000 225.795 .000 .000 .000 27.005 INVESTING ACTIVITIES Short term Investments - Change Capital Expenditures Sale of Property Plant and Equipment Acquisitions Investing Activities - Other -114.962 -98.968 46.630 -2.549 -292.836 -.300 .000 .000 .000 -6.266 -13.218 Investing Activites - Net Cash Flow -139.311 -302.657 -453.058 12.586 -36.500 7.879 -261.260 -62.202 -60.921 -38.882 -80.066 101.484 95.026 92.263 54.890 1.461 .067 .300 .023 .023 .000 .000 Purchase of Common and Preferred Stock .000 9.304 37.492 262.495 128.165 4.571 .000 41.973 65.611 107.167 52.070 Cash Dividends .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 .000 Long Term Debt - Issuance .000 .000 .000 .000 .000 50.000 90.000 .000 324.718 69.500 380.150 FINANCING ACTIVITIES Sale of Common and Preferred Stock Long Term Debt - Reduction 1.472 1.814 29.416 23.462 .171 Financing Activities - Other .000 54.078 Current Debt - Changes -56.993 15.500 44.501 349.459 98.474 283.925 108.722 .000 .000 .000 .000 .000 -14.227 -17.139 -8.482 80.462 -36.697 100.012 83.908 42.757 -217.268 -71.794 -11.418 60.573 5.132 -98.811 -49.772 7.657 2.620 -4.335 3.619 6.567 -25.024 12.001 -4.663 -5.459 4.273 -4.772 -4.630 55.856 -1.514 -137.917 71.064 92.516 53.187 -112.278 87.148 -102.132 -59.604 5.716 .854 2.252 2.318 2.318 3.249 4.030 6.432 8.671 12.013 7.422 7.390 -1.052 Financing Activities - Net Cash Flow .000 1.810 20.145 69.599 29.127 -27.908 12.791 21.283 16.654 3.544 7.843 Exchange Rate Effect Cash and Cash Equivalents - Change OTHER INFORMATION Interest Paid - NetStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started