New Heritage Doll Company

Submitted by: Submitted by

Views: 336

Words: 1791

Pages: 8

Category: Business and Industry

Date Submitted: 04/09/2014 12:57 PM

Report This Essay

Exhibit 1 0 2010 Revenue Revenue Growth Production Costs Fixed Production Expense (excl depreciation) Variable Production Costs Depreciation Total Production Costs Selling, General & Administrative Total Operating Expenses Operating Profit Operating Profit / Sales SG&A / Sales Working Capital Assumptions: Minimum Cash Balance as % of Sales Days Sales Outstanding Inventory Turnover (prod. cost/ending inv.) Days Payable Outstanding (based on tot. op. exp.) Capital Expenditures 1,470 1 2011 4,500

Selected Operating Projections for Match My Doll Clothing Line Expansion ($ in thousands) 2 2012 6,860 52.4% 575 3,404 152 4,131 1,735 5,866 994 0.145 0.253 3 2013 8,409 22.6% 587 4,291 152 5,030 2,102 7,132 1,277 0.152 0.250 4 2014 9,082 8.0% 598 4,669 152 5,419 2,270 7,689 1,393 0.153 0.250 5 2015 9,808 8.0% 610 5,078 164 5,852 2,452 8,304 1,504 0.153 0.250 6 2016 10,593 8.0% 622 5,521 178 6,321 2,648 8,969 1,624 0.153 0.250 7 2017 11,440 8.0% 635 6,000 192 6,827 2,860 9,687 1,753 0.153 0.250 8 2018 12,355 8.0% 648 6,519 207 7,374 3,089 10,463 1,892 0.153 0.250 9 2019 13,344 8.0% 660 7,079 224 7,963 3,336 11,299 2,045 0.153 0.250 10 2020 14,411 8.0% 674 7,685 242 8,601 3,603 12,204 2,207 0.153 0.250

0 1,250 1,250 (1,250)

575 2,035 152 2,762 1,155 3,917 583 0.130 0.257

3.0% 59.2 7.7 30.8 952

3.0% 59.2 8.3 30.9 152

3.0% 59.2 12.7 31 152

3.0% 59.2 12.7 31 334

3.0% 59.2 12.7 31 361

3.0% 59.2 12.7 31 389

3.0% 59.2 12.7 31 421

3.0% 59.2 12.7 31 454

3.0% 59.2 12.7 31 491

3.0% 59.2 12.7 31 530

Corporate Tax Rate Net Working Capital Accounts Cash Accounts Receivable Inventory Accounts Payable Net Working Capital Change in Net Working Capital NPV Analysis EBIT Taxes After Tax Earnings Depreciation Less Change in Net Working Capital Less Capital Expenditures Free Cash Flows Terminal Value Cash Flows including terminal value Cumulative Cash Flows Discounted Factor Present Value Growth Rate Return NPV NPV without terminal value IRR Payback...