Home
Add Document
Sign In
Register
268852099-New-Heritage-Doll-Company-resuelto-Solution.xlsx
Home
268852099-New-Heritage-Doll-Company-resuelto-Solution.xlsx
Descripción completa...
Author:
Paul Soria
10 downloads
291 Views
168KB Size
Report
DOWNLOAD .PDF
Recommend Documents
No documents
New Heritage Doll Company: Capital Budgeting Exhibit 1 ,ele(ted perating 'roe(tion) or Match My My Doll Clothing Clothing 5ine 5ine Expan)ion 2010
2011
2012
2013
2014
201
4#00
$#%$0
%#40&
%2
%0%
52.4%
22.6%
8.0%
8.0%
5"5
5"5
58"
5#8
6$0
20)5
)404
42#$
466#
50"8
$52
$52
$52
$52
$64
0
2#+$2
4#131
#02&
#41&
#%3
,elling# -eneral . /dmini)trati"e
1#20
1#1
1#+3
2#102
2#2+0
2#42
*otal perating Expen)e)
1#20
3#&1+
#%$$
+#132
+#$&0
%#30
1#20
%3
&&4
1# 1#2++
1# 1#3&2
1# 1#03
+ini,u, 'sh -lnce s % o /les
).0%
).0%
).0%
).0%
).0%
*s /les 1utstndin
5#.2x
5#.2x
5#.2x
5#.2x
5#.2x
"."x
8.)x
$2."x
$2."x
$2."x
)0.8x
)0.#x
)$.0x
)$.0x
)$.0x
#52
$52
$52
))4
)6$
!e"enue
Revenue Growth 'rodu(tion Co)t)
Fixed Production Expense (excl deprecition! ri&le Production 'osts *eprecition *otal 'rodu(tion Co)t)
perating 'roit
Working Capital Assumptions:
3nventor urnover (prod. costendin inv.! *s P&le 1utstndin (&sed on tot. op. exp.!
'pitl Expenditures
$4"0
201$
201+
201%
201&
2020
10#&3
11#440
12#3
13#344
14#411
8.0%
8.0%
8.0%
8.0%
8.0%
622
6)5
648
660
6"4
552$
6000
65$#
"0"#
"685
$"8
$#2
20"
224
242
$#321
$#%2+
+#3+3
+#&$3
%#$00
2#$4%
2#%$0
3#0%&
3#33$
3#$03
%#&$&
$%+
10#4$2
11#2&&
12#203
1#$23
1#+3
1#%&3
2#04
2#20&
).0%
).0%
).0%
).0%
).0%
5#.2x
5#.2x
5#.2x
5#.2x
5#.2x
$2."x
$2."x
$2."x
$2."x
$2."x
)$.0x
)$.0x
)$.0x
)$.0x
)$.0x
)8#
42$
454
4#$
5)0
New Heritage Doll Company: Capital Budgeting Exhibit 2 ,ele(ted perating 'roe(tion) or Design Your Own Doll 2010 !e"enue
2011
2012
2013
2014
201
0
$#000
14#3$0
20#222
21#43
Revenue Growth
$)#.)%
40.8%
6.0%
'rodu(tion Co)t)
Fixed Production Expense (excl deprecition!
0
$650
$68)
$"$"
$"5$
ri&le Production 'osts
0
2250
"65$
$$42"
$2$82
*eprecition
0
)$0
)$0
)$0
4)6
*otal 'rodu(tion Co)t)
0
42$0
#644
$)454
$4)6#
,elling# -eneral . /dmini)trati"e
$20$
0
$240
2#22
4044
428"
*otal perating Expen)e)
$20$
0
5450
$2566
$"4#8
$8656
($20$!
0
550
$"#4
2"24
2""#
+ini,u, 'sh -lnce s % o /les
).0%
).0%
).0%
).0%
*s /les 1utstndin
5#.2x
5#.2x
5#.2x
5#.2x
3nventor urnover (prod. costendin inv.!
$2.2x
$2.)x
$2.6x
$2."x
*s P&le 1utstndin (&sed on tot. op. exp.!
))."x
)).8x
)).#x
)).#x
)$0
)$0
perating 'roit
Working Capital Assumptions:
'pitl Expenditures
46$0
0
2$#2
826
201$
201+
201%
201&
2020
22#+21
24#0%4
2#2&
2+#0$1
2%#$%
6.0%
6.0%
6.0%
6.0%
6.0%
$"86
$822
$858
$8#5
$#))
$2#8)
$)8))
$4")6
$56#4
$6"$2
462
4#0
520
55$
584
$52)$
$6$45
$"$$)
$8$40
$#22#
4544
48$"
5$06
54$2
5")"
$#""5
20#62
222$#
2)55)
24#66
2#46
)$2)
))$0
)50#
)"$#
).0%
).0%
).0%
).0%
).0%
5#.2x
5#.2x
5#.2x
5#.2x
5#.2x
$2."x
$2."x
$2."x
$2."x
$2."x
)).#x
)).#x
)).#x
)).#x
)).#x
8"5
#28
#8)
$04)
$$05
New Heritage Doll Company: Capital Budgeting /naly)i) Match My Doll Clothing Line Expansion Cashflow Estimation and Investment Analysis 2010
less less less less less less dd less less <
Revenue ri&le Production 'osts Contribution Fixed Production 'osts R * expenditure /ellin +t Generl nd 9d,in Exp. perating 'roit *eprecition Ernins &eore x x Ernins ter x *eprecition 9dd. :' re;uired 'pex
'shlow dd er,inl 'shlow = )% rowth rte 'shlow or the er
2011
2012
2013
2014
4500
6860
840#
#082
7)520
0
0
0
0
0
0
0
0
0
7625 7625
7800 7$4"0 7)520
E)timation o 6or7ing Capital !e8uired
'sh -lnce (0.0) x /les! dd 9c Receiv&les dd 3nventor less 9c P&les < >et :' or the er
201
201$
201+
201%
201&
2020
#808
$05#)
$$440
$2)55
$))44
$44$$
0
0
0
0
0
0
0
0
0
0
0
0
New Heritage Doll Company: Capital Budgeting /naly)i) Design Your Own Doll Cashflow Estimation and Investment Analysis 2010
less less less less less less dd less less <
Revenue ri&le Production 'osts Contribution Fixed Production 'osts R * expenditure /ellin +t Generl nd 9d,in Exp. perating 'roit *eprecition Ernins &eore x x Ernins ter x *eprecition 9dd. :' re;uired 'pex
'shlow dd er,inl 'shlow = )% rowth rte 'shlow or the er
2011
2012
2013
2014
6000
$4)60
20222
784$ 7)60
7$000 746$0 758$$
($000!
6000
$4)60
20222
758$$
($000!
6000
$4)60
20222
0
0
0
0
0
E)timation o 6or7ing Capital !e8uired
'sh -lnce (0.0) x /les! dd 9c Receiv&les dd 3nventor less 9c P&les < >et :' or the er
201
201$
201+
201%
201&
2020
2$4)5
22"2$
24084
2552#
2"06$
28685
2$4)5
22"2$
24084
2552#
2"06$
28685
2$4)5
22"2$
24084
2552#
2"06$
28685
0
0
0
0
0
0
×
Report "268852099-New-Heritage-Doll-Company-resuelto-Solution.xlsx"
Your name
Email
Reason
-Select Reason-
Pornographic
Defamatory
Illegal/Unlawful
Spam
Other Terms Of Service Violation
File a copyright complaint
Description
×
Sign In
Email
Password
Remember me
Forgot password?
Sign In
Our partners will collect data and use cookies for ad personalization and measurement.
Learn how we and our ad partner Google, collect and use data
.
Agree & close