Write a report on which project should Harris recommend or neither In your report, you need to include quantitative analysis, including NPV, IRR, Payback and sensitivity analysis You also need to include qualitative analysis including risk factors, long term impact of the project on the overall business, growth potentials, etc In Module7Lecture xlsx, I have finished cash flows, NPV, IRR and Payback under three different scenarios Finish cash flow forecasting on the second project and calculating NPV, IRR and Payback for three scenarios as well A sensitivity analysis parameters have been created for the first project Please use the same parameters to construct sensitivity analysis for both projects Write the report using the following template named Module7Template docx Module7Lecture xlsx New Heritage Doll Company Capital Budgeting Exhibit 1 Selected Operating Projections for Match My Doll Clothing Line Expansion 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082 9,808 10,593 11,440 12,355 13,344 14,411 Revenue Growth 52 4 22 6 8 0 8 0 8 0 8 0 8 0 8 0 8 0 Production Costs Fixed Production Expense (excl depreciation) 575 575 587 598 610 622 635 648 660 674 Variable Production Costs 2,035 3,404 4,291 4,669 5,078 5,521 6,000 6,519 7,079 7,685 Depreciation 152 152 152 152 164 178 192 207 224 242 Total Production Costs 0 2,762 4,131 5,029 5,419 5,853 6,321 6,827 7,373 7,963 8,600 Selling, General Administrative 1,250 1,155 1,735 2,102 2,270 2,452 2,648 2,860 3,089 3,336 3,603 Total Operating Expenses 1,250 3,917 5,866 7,132 7,690 8,305 8,969 9,687 10,462 11,299 12,203 Operating Profit 1,250 583 994 1,277 1,392 1,503 1,623 1,753 1,893 2,045 2,209 Working Capital Assumptions Minimum Cash Balance as of Sales 3 0 3 0 3 0 3 0 3 0 3 0 3 0 3 0 3 0 3 0 Days Sales Outstanding 59 2x 59 2x 59 2x 59 2x 59 2x 59 2x 59 2x 59 2x 59 2x 59 2x Inventory Turnover (prod cost ending inv ) 7 7x 8 3x 12 7x 12 7x 12 7x 12 7x 12 7x 12 7x 12 7x 12 7x Days Payable Outstanding (based on tot op exp ) 30 8x 30 9x 31 0x 31 0x 31 0x 31 0x 31 0x 31 0x 31 0x 31 0x Capital Expenditures 1,470 952 152 152 334 361 389 421 454 491 530 Net Working Capital (NWC) Cash 135 206 252 272 294 318 343 371 400 432 Account Receivable 729 1,112 1,363 1,472 1,590 1,717 1,855 2,003 2,163 2,336 Inventory 360 500 396 427 461 498 538 581 627 677 Account Payable 317 484 593 640 692 747 807 871 941 1016 Net Working Capital 800 907 1,334 1,418 1,531 1,653 1,786 1,929 2,083 2,250 2,429 Change in NWC 800 107 427 84 113 122 132 143 154 167 180 2,429

Question: Write a report on which project should Harris recommend or neither. In your report, you need to include quantitative analysis, including NPV, IRR, Payback and

Write a report on which project should Harris recommend or neither. In your report, you need to include quantitative analysis, including NPV, IRR, Payback and sensitivity analysis. You also need to include qualitative analysis including risk factors, long term impact of the project on the overall business, growth potentials, etc.

In Module7Lecture.xlsx, I have finished cash flows, NPV, IRR and Payback under three different scenarios. Finish cash flow forecasting on the second project and calculating NPV, IRR and Payback for three scenarios as well. A sensitivity analysis parameters have been created for the first project. Please use the same parameters to construct sensitivity analysis for both projects. Write the report using the following template named Module7Template.docx.

Module7Lecture.xlsx

New Heritage Doll Company: Capital Budgeting
Exhibit 1		Selected Operating Projections for Match My Doll Clothing Line Expansion

			2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020
Revenue				4,500	6,860	8,409	9,082	9,808	10,593	11,440	12,355	13,344	14,411
	Revenue Growth				52.4%	22.6%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%
Production Costs
Fixed Production Expense (excl depreciation)				575	575	587	598	610	622	635	648	660	674
Variable Production Costs				2,035	3,404	4,291	4,669	5,078	5,521	6,000	6,519	7,079	7,685
Depreciation				152	152	152	152	164	178	192	207	224	242
Total Production Costs			0	2,762	4,131	5,029	5,419	5,853	6,321	6,827	7,373	7,963	8,600
Selling, General & Administrative			1,250	1,155	1,735	2,102	2,270	2,452	2,648	2,860	3,089	3,336	3,603
Total Operating Expenses			1,250	3,917	5,866	7,132	7,690	8,305	8,969	9,687	10,462	11,299	12,203

Operating Profit			-1,250	583	994	1,277	1,392	1,503	1,623	1,753	1,893	2,045	2,209

Working Capital Assumptions:
Minimum Cash Balance as % of Sales				3.0%	3.0%	3.0%	3.0%	3.0%	3.0%	3.0%	3.0%	3.0%	3.0%
Days Sales Outstanding				59.2x	59.2x	59.2x	59.2x	59.2x	59.2x	59.2x	59.2x	59.2x	59.2x
Inventory Turnover (prod. cost/ending inv.)				7.7x	8.3x	12.7x	12.7x	12.7x	12.7x	12.7x	12.7x	12.7x	12.7x
Days Payable Outstanding (based on tot. op. exp.)				30.8x	30.9x	31.0x	31.0x	31.0x	31.0x	31.0x	31.0x	31.0x	31.0x

Capital Expenditures			1,470	952	152	152	334	361	389	421	454	491	530

Net Working Capital (NWC)
Cash				135	206	252	272	294	318	343	371	400	432
Account Receivable				729	1,112	1,363	1,472	1,590	1,717	1,855	2,003	2,163	2,336
Inventory				360	500	396	427	461	498	538	581	627	677
Account Payable				317	484	593	640	692	747	807	871	941	1016
Net Working Capital			800	907	1,334	1,418	1,531	1,653	1,786	1,929	2,083	2,250	2,429
Change in NWC			800	107	427	84	113	122	132	143	154	167	180	-2,429

Step by Step Solution

★★★★★

3.44 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

New Heritage Doll Company Capital Budgeting New Heritage Doll Company founded in 1985 deals with doll production offering different types of products The company wants to expand its brand and market s... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

610a979b3fffb_83725.xlsx

300 KBs Excel File

Students Have Also Explored These Related Corporate Finance Questions!

Write a report on "Cross-Culture Leadership"

I need a report on which DMS is best suited for a small engineering and manufacturing firm on a tight budget. It needs to store document packages containing electrical wiring diagrams, mechanical...

Write a report on Audi "South Korea". Collect two types of data, general country indicators, relating to the general business environment and indicators to assess product market favorability. You...

At the beginning of 2012, Mansen Company acquired equipment costing $80,000. It was estimated that this equipment would have a useful life of 6 years and a residual value of $8,000 at that time. The...

(Comprehensive Problem: Issuance, Classification, Reporting) Presented below are four independent situations. (a) On March 1, 2011, Wilke Co. issued at 103 plus accrued interest $4,000,000, 9% bonds....

Margaret OFlaherty, a portfolio manager for MCF Investments, is considering investing in Alpine Chemical 7% bonds, which mature in 10 years. She asks you to analyze the company to determine the...

Harrington Explorations Inc. is interested in expanding its copper mining operations in Indonesia. The area has long been noted for its rich deposits of copper ore. With copper prices at near-record...

New Heritage Doll Company: Capital Budgeting Exhibit 1 Selected Operating Projections for Match My Doll Clothing Line Expansion 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500...

Marcus Tube, a manufacturer of high-quality aluminum tubing, has maintained stable sales and profits over the past 10 years. Although the market for aluminum tubing has been expanding by 3% per year,...

Many consultants recognize that expensing R&D investments gives a poor indication of the performance of a firm or its managers because investing in R&D results in lower income. So they adjust GAAP...

1 8 points eBook Derrick Iverson is a divisional manager for Holston Company. His annual pay raises are largely determined by his division's return on investment (ROI), which has been above 25% each...

1/19/2017 Principles of Operations Management: Sustainability and Supply Chain Management, Global Edition PRINTED BY: abdelkader.mazouz@aau.ac.ae. Printing is for personal, private use only. No part...

Devise three unique parametric expressions for a circle with a radius of \' r . \' These expressions should originate from the point ( 0 , - r ) and must meet the following conditions: ( a ) Complete...

QUESTION 5 [30 marks] Case Study: Innovation Offshoring: Asia's Emerging Role in Global Innovation Networks Source: www.eastwestcenter.org Most analysts agree that critical ingredients for economic...

1. Gwerrero 24 Aviation 31 Mid-Term Exam 10/18/22 onus (1 Point): Describe the primary means by which adverse yaw is reduced on the Cessna-150/152 and how works: Show all of your work and Pro Bonus...

2. List the Young's modulus, Yield strength(or breaking strength for brittle material), and failure strain for a)steel, b)aluminum alloy,c) glass, d) rubber, and e)Nylon. For strength and failure...

When searching for a file in a path in a loop in Mendix, how can I determine if it is the last index if it is not found? I will add an error message accordingly.

Refer to the table to answer the following questions. Year Nominal GDP (in billions) Total Federal Spending (in billions) Real GDP (in billions) Real Federal Spending (in billions) 2000 9,817 578...

A pistoncylinder device contains superheated steam. During an actual adiabatic process, the entropy of the steam will (never, sometimes, always) increase.

You are asked to design a heating system for a swimming pool that is 2 m deep, 25 m long, and 25 m wide. Your client desires that the heating system be large enough to raise the water temperature...

Reconsider Prob. 1248. Using an appropriate software, investigate the effect of irreversible head loss on the mechanical efficiency of the pump. Let the head loss vary from 0 to 15 m in increments of...

Compare and contrast the built-in loss duplication rule as it relates to 351 with the built-in loss disallowance rule as it applies to a complete liquidation.

Explain whether a corporate shareholder recognizes gains and losses on the receipt of distributions of property from the complete liquidation of a subsidiary corporation.

What tax benefits does the buyer hope to obtain by making a 338 or 338(h)(10) election?