4212 -8-Exhibit 1Selected Operating Projections for Match My Doll Clothing Line Expansion ($ in thousands)20112012201320142015201620192020$ 9,082$ 10,59311,440 $ 12,355 13,34480%Revenue$ 14,411ue Grow52.4%80%Production CostsFixed Production Expense (excl depreciation)Variable Production Costs6607,0796747,6855,0785,5211525,0292,1027,132Depreciationo Total Production Costs5,419Selling, General & AdministrativeTotal Operating Expenses2,7621,155$ 3,9174,1311,7352,648$ 8,9692,452$ 9,687 10,462 $11,299Operating Profit$ (1,250)Q Working Capital AssumptionsMinimum Cash Balance as % of Sales5 Days Sales OutstandingI Inventory Turnover (prod. cost/ending inv.)8 Days Payable Outstanding (based on tot. op. exp.)59.2x59.2x59.2x59.2x59.2x12.7x31.0x59.2x59.2x59.2x59.2x30.9x31.0x31.0xapi2 Exhibit 2Selected Operating Projections for Design Your Own Doll (S in thousands)2011201320142015201620182020$ 6,000 14,360139.3%20,22240.8%S 21,435 22,72160%Revenue24,084 25,52927,061S 28,685Revenue6.0%60%60%GrowthProduction CostsFixed Production Expense (excl depreciation)Variable Production Costs1,6837,6511,6501,7861,8581,89515,69411,42712,18213,83316,712 C52017,113ż DepreciationTotal Production Costs18,1405,412$18,65619,775 20,962 22,219 23,55316,145o Selling, General & Administrative5,737S 24,966Total Operating Expenses$ 5,45012,566 $ 17,498Operating ProfitWorking Capital Assumptions:Minimum Cash Balance as % of SalesDays Sales Outstanding$(1,201)$0550 1,794$ 2,7242,779 2,9463,123 3,310 3,5093,719C3.0%3.0%59.2x59.2x59.2x59.2x59.2x59.2xOInventory Turnover (prod. cost/ending inv.)12.7x33.9xDays Payable Outstanding (based on tot. op. exp.)33.9x33.9x33.9x33.9x33.9x33.9x4,610$ 2,192$ 1,043

Question
Asked Mar 31, 2019
61 views

 

2. What are the free cash flows that are relevant to analyzing the two projects? Compute the NPVs of the two projects. Which project creates more value?

4212 -8-
Exhibit 1
Selected Operating Projections for Match My Doll Clothing Line Expansion ($ in thousands)
2011
2012
2013
2014
2015
2016
2019
2020
$ 9,082
$ 10,59311,440 $ 12,355 13,344
80%
Revenue
$ 14,411
ue Grow
52.4%
80%
Production Costs
Fixed Production Expense (excl depreciation)
Variable Production Costs
660
7,079
674
7,685
5,078
5,521
152
5,029
2,102
7,132
Depreciation
o Total Production Costs
5,419
Selling, General & Administrative
Total Operating Expenses
2,762
1,155
$ 3,917
4,131
1,735
2,648
$ 8,969
2,452
$ 9,687 10,462 $11,299
Operating Profit
$ (1,250)
Q Working Capital Assumptions
Minimum Cash Balance as % of Sales
5 Days Sales Outstanding
I Inventory Turnover (prod. cost/ending inv.)
8 Days Payable Outstanding (based on tot. op. exp.)
59.2x
59.2x
59.2x
59.2x
59.2x
12.7x
31.0x
59.2x
59.2x
59.2x
59.2x
30.9x
31.0x
31.0x
api
2 Exhibit 2
Selected Operating Projections for Design Your Own Doll (S in thousands)
2011
2013
2014
2015
2016
2018
2020
$ 6,000 14,360
139.3%
20,222
40.8%
S 21,435 22,721
60%
Revenue
24,084 25,529
27,061
S 28,685
Revenue
6.0%
60%
60%
Growth
Production Costs
Fixed Production Expense (excl depreciation)
Variable Production Costs
1,683
7,651
1,650
1,786
1,858
1,895
15,694
11,427
12,182
13,833
16,712 C
520
17,113
ż Depreciation
Total Production Costs
18,140
5,412
$18,65619,775 20,962 22,219 23,553
16,145
o Selling, General & Administrative
5,737
S 24,966
Total Operating Expenses
$ 5,45012,566 $ 17,498
Operating Profit
Working Capital Assumptions:
Minimum Cash Balance as % of Sales
Days Sales Outstanding
$(1,201)
$0
550 1,794$ 2,7242,779 2,946
3,123 3,310 3,509
3,719C
3.0%
3.0%
59.2x
59.2x
59.2x
59.2x
59.2x
59.2x
OInventory Turnover (prod. cost/ending inv.)
12.7x
33.9x
Days Payable Outstanding (based on tot. op. exp.)
33.9x
33.9x
33.9x
33.9x
33.9x
33.9x
4,610
$ 2,192
$ 1,043
help_outline

Image Transcriptionclose

4212 -8- Exhibit 1 Selected Operating Projections for Match My Doll Clothing Line Expansion ($ in thousands) 2011 2012 2013 2014 2015 2016 2019 2020 $ 9,082 $ 10,59311,440 $ 12,355 13,344 80% Revenue $ 14,411 ue Grow 52.4% 80% Production Costs Fixed Production Expense (excl depreciation) Variable Production Costs 660 7,079 674 7,685 5,078 5,521 152 5,029 2,102 7,132 Depreciation o Total Production Costs 5,419 Selling, General & Administrative Total Operating Expenses 2,762 1,155 $ 3,917 4,131 1,735 2,648 $ 8,969 2,452 $ 9,687 10,462 $11,299 Operating Profit $ (1,250) Q Working Capital Assumptions Minimum Cash Balance as % of Sales 5 Days Sales Outstanding I Inventory Turnover (prod. cost/ending inv.) 8 Days Payable Outstanding (based on tot. op. exp.) 59.2x 59.2x 59.2x 59.2x 59.2x 12.7x 31.0x 59.2x 59.2x 59.2x 59.2x 30.9x 31.0x 31.0x api 2 Exhibit 2 Selected Operating Projections for Design Your Own Doll (S in thousands) 2011 2013 2014 2015 2016 2018 2020 $ 6,000 14,360 139.3% 20,222 40.8% S 21,435 22,721 60% Revenue 24,084 25,529 27,061 S 28,685 Revenue 6.0% 60% 60% Growth Production Costs Fixed Production Expense (excl depreciation) Variable Production Costs 1,683 7,651 1,650 1,786 1,858 1,895 15,694 11,427 12,182 13,833 16,712 C 520 17,113 ż Depreciation Total Production Costs 18,140 5,412 $18,65619,775 20,962 22,219 23,553 16,145 o Selling, General & Administrative 5,737 S 24,966 Total Operating Expenses $ 5,45012,566 $ 17,498 Operating Profit Working Capital Assumptions: Minimum Cash Balance as % of Sales Days Sales Outstanding $(1,201) $0 550 1,794$ 2,7242,779 2,946 3,123 3,310 3,509 3,719C 3.0% 3.0% 59.2x 59.2x 59.2x 59.2x 59.2x 59.2x OInventory Turnover (prod. cost/ending inv.) 12.7x 33.9x Days Payable Outstanding (based on tot. op. exp.) 33.9x 33.9x 33.9x 33.9x 33.9x 33.9x 4,610 $ 2,192 $ 1,043

fullscreen
check_circle

Expert Answer

Step 1

Free cashflow is calculated using formula:

FCFF = EBIT - Taxes + Depreciation - Capex - Change in NWC (Current Assets - Current Liabilities)

THis is how you can do it in excel. Pay special attention to NWC calculation.

fullscreen
Step 2

These are the values you can expect to get.  Values may be rounded off as required.

fullscreen
Step 3

This is  how NPV and IRR are calculated f...

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Business

Finance

Capital Budgeting

Related Finance Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Consider the following two mutually exclusive projects: year      cash flow A            cash flow B...

A: Let me state upfront that none of the alternatives listed in the question states the correct answer....

question_answer

Q: Money is deposited at the end of each week into an investment paying 2.6% interest compounded weekly...

A: Calculating the rent of the increasing annuity. We have,Rent of increasing annuity = [r / (1+r)n – 1...

question_answer

Q: I already ask this but I whant know how you do the calculation, please could you show me all the ste...

A: Calculating the price of bond if bond mature in 10 year. We have,Price of bond = C [1- (1 / (1+r)n ]...

question_answer

Q: What is the estimate of the marginal cost of the Phase 4 hospital servicesassuming, as given in the ...

A: Marginal costs are the incremental costs that will be incurred on hospital 4 services. The cost data...

question_answer

Q: Project: The streets and roads maintained by the government have not had an adequate maintenance pro...

A: The initial investment for the project is $175000 as patching system has to be purchased so that wor...

question_answer

Q: Deb and Rusty have just gotten married and wish to buy a home. They both work in Boston and have a c...

A: Let the largest amount they can use for a down payment be $ A.Cost of the house, C  = $ 350,000Hence...

question_answer

Q: In 2018, Beta Corporation earned gross profits of $720,000. a. Suppose that Beta was financed by a c...

A: Calculation of net profits:Excel spreadsheet: 

question_answer

Q: a. If you borrow $1,100 and agree to repay the loan in six equal annual payments at an interest rate...

A: Part (a)Let the annual payment be P. Interest rate, i = 11%; n = period = number of payment = 6Hence...

question_answer

Q: The following problem refers to the stock table for ABC Inc.​ (a tire​ company) given below. Use the...

A: Hi, I’m answering the first 3 subparts of the question as the given question consists of multiple su...