Preview 50% of the Answer Below
Answer Preview
Name: ________________________
Write a report (about 5 pages) on the following:
- What types of project did New Heritage have? Characterize them by division and project attributes.
New Heritage’s projects could be classified into three categories based on division (production, retail and licensing) and by the project attributes of risk level, lifetime project costs, payback period, NPV, IRR and profitability index. I used these project types and characteristics to group the projects and decide which were the best projects to invest in.
- Generally which collection of funded project do you expect to be associated with good overall performance?
In general, I would expect the licensing projects, especially those with low to medium risk, high net present value , low lifetime project costs and a short payback period, to be associated with good overall performance. This is because licensing projects, based on New Heritage Doll Company’s Financial Snapshot, have historically been the main driver of cash flow and operating profit. In addition, less risky and higher-NPV projects have been empirically proven to be associated with good overall performance.
- How much is your final APV?
My final APV is 611.37.
- Display your decision history.
My decision history is displayed in the table below:
NPV |
IRR |
PI |
Pay Bk Yrs |
Life time Prj. Costs |
2014 Prj. Costs |
1 Yr. EBITDA |
5 Yr. EBITDA |
|
Dollhouses with Miniature Dolls |
9.09 |
27.06% |
2.65 |
7.74 |
4.73 |
3.43 |
-0.80 |
5.70 |
New East Coast Distribution Facility |
6.30 |
18.91% |
0.63 |
4.92 |
16.00 |
10.00 |
0.00 |
1.00 |
Coupon Promotion/Frequent Shopper Campaign |
6.04 |
25.16% |
3.66 |
X.99 |
5.XX |
X.XX |
-2.XX |
1.83 |
Young XXXXXXX XXXX Series |
8.XX |
XX.XX% |
XX.XX |
2.XX |
X.XX |
0.XX |
-0.XX |
2.XX |
Cable TV XXXXXXX |
3.52 |
33.XX% |
4.XX |
5.91 |
X.XX |
X.75 |
-X.XX |
X.XX |
Toddler XXXX Accessory Line |
7.XX |
XX.06% |
11.XX |
8.XX |
3.XX |
0.XX |
1.XX |
3.37 |
Match my Doll' Clothing XXXX |
6.XX |
XX.XX% |
1.XX |
X.XX |
5.XX |
0.01 |
X.89 |
X.XX |
Dolls XX XXX XXXXX' XXXXXXXXXX |
X.XX |
19.90% |
X.51 |
X.93 |
X.XX |
X.XX |
1.XX |
4.XX |
Grow With Me' XXXX Line |
X.XX |
18.52% |
1.04 |
> XX |
X.XX |
0.04 |
2.XX |
X.XX |
Replace XXXXXXXX XXXXXXXXX at XXXXXXXXXX Facility |
0.06 |
38.XX% |
0.87 |
X.XX |
X.XX |
0.XX |
X.06 |
X.XX |
Match XX XXXX' Clothing XXXX, XXXXXXXXX XX Concept |
X.XX |
XX.XX% |
2.XX |
X.69 |
X.87 |
0.XX |
1.15 |
X.60 |
XXX Supplier Software XXXXXX |
X.XX |
XX.76% |
X.XX |
3.XX |
X.XX |
0.XX |
-0.XX |
X.XX |
XXXXXX XXXX XXX XXXX' |
9.XX |
XX.20% |
X.XX |
X.86 |
7.99 |
0.XX |
X.00 |
X.40 |
XXXXXX XXXXX Expansion in XXXXXXXXX |
X.XX |
XX.65% |
- |
5.XX |
X.29 |
1.25 |
1.01 |
X.XX |
Warehouse Facility Consolidation |
2.76 |
XX.26% |
0.XX |
X.23 |
10.50 |
0.XX |
X.75 |
3.XX |
Expansion XX XXXX-order XXXXXXX Business to XXXX |
X.57 |
XX.XX% |
2.85 |
&XX; 10 |
2.73 |
X.02 |
X.24 |
X.XX |
XXXXXXX XXXX XXXXXXXXX |
6.XX |
XXX.58% |
266.50 |
X.06 |
X.XX |
0.XX |
0.XX |
X.19 |
Bookstore Café and XXXXXXX' Club |
X.71 |
48.90% |
13.42 |
4.44 |
0.XX |
0.XX |
X.78 |
3.62 |
New XXXX XXXX/DVD |
X.XX |
XXX.61% |
-3.84 |
1.43 |
X.XX |
0.XX |
X.XX |
XX.85 |
XXXXX XXXX Series |
X.XX |
43.57% |
13.64 |
X.XX |
X.61 |
0.01 |
0.XX |
0.99 |
† Acquisition XX Children's Magazine |
24.08 |
18.26% |
0.95 |
8.03 |
26.25 |
0.XX |
X.38 |
XX.XX |
Toddlers Music XX Series |
X.97 |
104.99 |
23.23 |
2.09 |
1.XX |
X.01 |
X.XX |
X.XX |
- XXX do you select the XXXXXXXX XXXX you would XXXX to XXXXXX? XXXX capital XXXXXXXXX decision XXXXXXXX XXX you use?
I selected XXX XXXXXXXX XX invest in XXXXX New Heritage XXXX Company’s historical performance, and XXX XXX, XXXX XXXXX, payback period and XXXXXXXXX XXXXXXXX costs of XXXX project. In XXXXX XX XXXXXXXX, I XXXX had a XXXXXXXXXX XXXXXX XXXXXXXXX, XXXXXXX while XXX XXXXXXXXX revenue driver comes from retail (190 million, XXX a vis XXXXXXXXXX’s 125 XXXXXXX XXX Licensing’s XX.X XXXXXXX), XXX strongest cash XXXX and operating XXXXXX driver comes, XX XXX XXXXX XXXX, XXXX licensing (14.12 XXXXXXX XXXX XXXXXXXXX in operating profit in 2009). Licensing XX XXXX an XXXXX-light XXXXXXXX, XXXXX XXXXXXXX the company from having to invest too heavy in assets. In XXXXX XX XXXXXXX XXXXXXXXXX, the budgeting decision XXXXXXXX I used XXX to choose a project XXXXX XXX a XXXX NPV, XXX to medium risk XXXXX (XXXXXXXX I did XXXX several XXXXXXXXXX for choosing XXXXXXXX with a XXXX XXXX XXXXX when I felt XXXX XXX NPV warranted a XXXXXX XXXX level), XXXXXXXXXX XXXXXXX XXXXXX and reasonable projected lifetime XXXXX. I optimized XXXXX XXXXXXXX XXX XXXX round and XXXXX the best XXXXXXXX XXXXXXXX, XXXXXXX in mind the XXXXXX constraint for each round.
- When two projects are mutually XXXXXXXXX, how XXX you choose XXX project? What XXXXXXX budgeting decision XXXXXXXX XXX you XXX?
Mutually exclusive XXXXXXXX refer to projects XXXXX XXXXXX both XX XXXXXX, for XXXXXXX of XXXXXXXX, budget XXXXXXXXXX or operational limitations. One example XX this was XXX acquisition XX Children’s Magazine XXX XXX XXXXXXXXXXX of Electronic XXX Manufacturer. XXX New Heritage Doll XXXXXXX’s board XX XXXXXXXXX had XXXXXXXX XXX prospects XXX XXXXXXXXXXXX, XXXXX XXXX to be capital XXXXXXXXX, XXXX risk endeavors, XXX had XXXXXXX XXXX XXX Heritage could XXX successfully execute more than one acquisition XXX year. XX this case, XXX XXXXXXX XXXXXXXXX XXXXXXXX XXXXXXXX I used was XX look XX which acquisition had a XXXXXX XXX present XXXXX (XXX), lower XXXX level and higher XXXXXXXXXXXXX index, XX XXXX as XXXXX XXXXXXX XXX XXXX XXXXXXXXXXXXX XXXX XXX XXXXXXXXX XXXX outlined XX New XXXXXXXX Doll company. XX XXXX case, it XXX clear that the XXXXXXXXXXX of the children’s magazine was the XXXXXXXX choice between XXX two XXXXXXXX exclusive projects.
- Do you use a XXXXXXXX to XXXXXXXX your XXXXXXXXXXX? XXXX strategy XXX you use?
I used a strategy comprised of XXXXXXXX XXXXX. Foremost, I pursued a diversification strategy XXXXX I tried XX have a mix XX projects of different XXXX levels per XXXXX. This meant XXXX XXXX XXXXX XXXXXXXX a XXX of XXX, medium and XXXX XXXX XXXXXXXX, although XXXX XXXXXXXX XXXX comparable risk XXXXXX XXX XXXXXXXXX NPVs XXXXXXXX, I naturally chose XXX higher NPV alternative. XXXXXXXX, I tried XX choose the XXX 3-X projects XXX XXXXX in order to conserve XXXXXXX XXX future XXXXXX, in XXXX XXXXXXXX XXXX XXXXXX NPVs XXXXXXXX in later rounds. Thirdly, I chose XXXXXXXX XXXXX were expiring soon. Fourthly, I XXXXX XX XXXXX XX licensing XXXXXXX it XXXXXX in XXX XXXX cash flow, net XXXXXX XXX XXXXXXXXX XXXXXX XXXXX XX XXX XXXXXXXX’s XXXXXX statements and XXXXXXX XXXXXX. XXXXXXX, I XXXX with projects with the highest NPV rather XXXX XXXXXXX IRR XX XXX XX the empirically superior XXXXXXX XXXXXXXXXX XXXXXX, given XXXX it accounts XXX different discount XXXXX over XXXX, and shows definitively XXXXXXX a XXXXXXX XX XXXXX XXXXXXXX or value XXXXXXXXXX. On the other XXXX, the simple IRR is XXX XXXXX, XXX does not XXXXXXX XXX uncertain cash flows, or cash flows at XXXXXXXXX XXXXXXXX rates. XX a result, I was able to achieve a XXXXXXXXXXXX XXX at XXX end XX the simulation XXXX.
- Complete the student survey.
span class="Apple-XXXXXXXXX-XXXXX"&XX;
Appendix: Qualitative Results XX Capital Budgeting Simulation Game.
XXXX
1. XXXXXXXXXX with XXXXXXXXX Dolls XXXX XXXXXXX XXXXXXXX XXXXXXXXXXXX but with somewhat lower margins than expected, XXXXXXXXXXXX to XXXXXX XXXXXXXXXX and XXXXXXXXX costs.
2. New XXXX XXXXX XXXXXXXXXXXX Facility This facility was XXXXXXXXX and performing XX expected.
3. Coupon XXXXXXXXX/XXXXXXXX Shopper XXXXXXXX The XXXXXXXX XXX XXXXXXXXX but fell XXXXXXXX short of XXX retail XXXXXXXX's revenue XXXXXXX.
X. Young XXXXXXX XXXX Series 'XXXX XX Girls' XXXXX XXXX an immediate XXXXXXX XXXX the XXXXXXXX XXXXXXXXXXX. Both revenue XXX XXXXXX XXXXXX exceeded XXXXXXXXXXXX.
5. Cable XX XXXXXXX XXXXXXXX XXXX producing XXX XXXXX TV show XXXX XXXXXXXX XXXXXX than XXXXXXXXXXX, XXX XXXXXXXXXX costs XXXXXXXX XXXXXXXXXXXX, resulting in a XXXXX operating XXXXXX
XXXX
1. Replace XXXXXXXX XXXXXXXXX at Sacramento XXXXXXXX The new machinery XXXXXXXXX XX expected.
2. EDI XXXXXXXX Software System The XXX XXXXXX XXXXXXXXX XXXXXX than expected with regard to SG&X and working capital savings.
X. 'Design Your Own Doll' : Project costs in the XXXXX XXXX XXXX XX XXXXXXXX but were XXX XXXXXXXXXX to get XXX assembly XXXXXXXXX and related software working XXXXXXXX. Additional outlays XXX required XX complete the XXXXXXX, and the launch XX accordingly XXXXXXX.
4. XXXXXXX Doll Community Development costs were XXXXX XXXXX XXXXXX than budgeted, and revenues were XXXXXXXXXXXXX XXXXX, XXX XXX XXXXXXX XXX XXXXXXXXXXXX XXXXXXX to be XXXXXXXXXX.
X. XXXXXXXXX Café XXX Writers' Club Initial revenues XXXX XXX initiative XXXX somewhat XXXXXX than expected, XXX XXXX XXX XXXXXX by XXXXX gross XXXXXXX resulting XXXX a XXXXXXXX XXXXXXXXX product mix XXXX XXXXXXXXXXX.
6. Toddlers XXXXX XX Series XXXXXXX revenues XXXX Toddler XXX were XXXXX as XXXXX as XXXXXXXXXXX.
XXXX
1. 'Dolls of XXX World' XXXXXXXXXX Development of successful XXXXXXXXXX XXXX longer XXXX XXXXXXXX, which delayed XXXXXX by several XXXXXX XXX XXXXXX NH XX XXXX an XXXXXX XXXXXXX season. XXX XXXXXXXXXX XX still XXXXXXXX XX XXXXXXX.
X. 'Match XX XXXX' Clothing Line, Expansion XX Concept XXX expanded XXXXXXXX XXXX XXXXXXXXX from XXX strong XXXXXXXXXXX XX XXX initial 'XXXXX My Doll' XXXX and has outperformed projections.
X. XXXXXX XXXXX XXXXXXXXX in XXXXXXXXX XXX Northeast XXXXXX XXXXXXXXXX generated more XXXXXXX XXXX expected and XXXX XXXXXXXXXX XXXXX XXXX.
4. Warehouse XXXXXXXX XXXXXXXXXXXXX XXXXXXXXX consolidation generated XXXXXXXX greater XXXXXXX than XXXXXXXXXXX.
5. XXXXXXXXX XX Mail-order XXXXXXX Business to Asia XXXXXXXXXXXX for concept XXXXXXX XXXX three XXXXX higher XXXX projected. However, revenues XXXX likewise XXXX higher than expected. Local XXXXXXXX XXX XXX XXXXXXX for XXXX XX speed up XXXXXXXXXXX in XXXXX and XXXXX.
X. Acquisition XX Children's XXXXXXXX The magazine's paid XXXXXXXXXX base XXX XXXX up XXXXXX XXXX XXXXXXXX, XXXXXXX stiff online XXXXXXXXXXX and XXXXXXXXX XXXX performance XX other magazines. XXXXXXXXX XXXXXXXXXXX XX XXXXXXXXXXXX somewhat stronger than expected.
XXXX
1. 'Match XX XXXX' XXXXXXXX Line XXX clothing line XXXXXXXXXXXX XXXXXXXXXXXX XXXXX a XXXXXXXXX's daughters XXXX XXXXXXXXXXXX wearing items from XXX XXXX XXXXXXX after XXX XXXXX. Gross margin XXX XXXX higher XXXX XXXXXXXX XXX to lower than anticipated raw-XXXXXXXXX costs.
X. 'Grow XXXX XX' XXXX XXXX XXXXXXXXXX XXXXXXX problems caused XXXXX-XXXX revenues XX XXXX short of expectations by XXXX. XXXX return XXXXX XXX XXXXX XXXXXXXXXX with XXXXXXXXXXXXX a key XXXXXXXXXX XXXXXXXXX XXXXXX SG&A costs significantly.
X. XXXXX Book XXXXXX XXX appearance XX XXX titles in XXXX XXXXXX XX a XXXX show XXXX's recommended summer XXXXXXX list for kids boosted XXXXXXX XXXXXX XXXXX expectations.
XXXX
1. Toddler Doll Accessory Line XXXX XXXX of accessories XXXXXXXXX in line with expectations XXXXXXXXX XXXX XXXXX and costs.
X. XXX Doll Film/XXX The XXXX XXX released on schedule. XXX marketing campaign XXX XXXX XXXXXXXXXX, XXX DVD XXXXX exceeded those XX XX's previous XXXXX.
">