Question: Analysis Assumptions - Redesign Launch Proj Yr 1 Proj Yr 2 Proj Yr 3 Proj Yr 4 Proj Yr 5 Operating assumptions Sales growth Category

Analysis
Assumptions - Redesign Launch Proj Yr 1 Proj Yr 2 Proj Yr 3 Proj Yr 4 Proj Yr 5
Operating assumptions
Sales growth
Category growth rate 4% 4% 4% 4% 4%
Incremental growth rate 2.0% 1.0% 0.50% 0.0% 0.0%
Historic/Base sales 139,500,000
Gross margin 69% 69% 69% 69% 69%
Cost reductions since new design is less expensive 119,000 119,000 119,000 119,000 119,000
Development
Marketing and R&D 700,000
Start-up expenses
Partial case returns net of salvage value 1,800,000
Label conversion costs 700,000
Freight charge/launch year expenses 400,000
Other miscellaneous 300,000
Tax rate 27%
Discount rate 7%
New investment
PP&E
Cap/Pump molds 1,590,000
Change parts 260,000
Pump assembly 570,000
Depreciable life (years) 6
Start up Proj Yr 1 Proj Yr 2 Proj Yr 3 Proj Yr 4 Proj Yr 5
Initial investment (negative number) (2,420,000)
Incremental sales
Incremental COGS
Incremental gross profit - - - - -
Depreciation 403,414 403,414 403,414 403,414 403,414
Marketing and R&D 700,000 0.00 0.00 0.00 0.00
Partial case returns net of salvage value 1,800,000 0.00 0.00 0.00 0.00
Label conversion costs 700,000 0.00 0.00 0.00 0.00
Freight charge/launch year expenses 400,000 0.00 0.00 0.00 0.00
Other miscellaneous 300,000 0.00 0.00 0.00 0.00
Incremental expenses 4,303,414 403,414 403,414 403,414 403,414
Cost reductions from new design 119,000 119,000 119,000 119,000 119,000
Incremental operating profit (4,184,414) (284,414) (284,414) (284,414) (284,414)
Depreciation 403414 403414 403414 403414 403414
Project cash flows -2420000 -3781000 119000 119000 119000 119000
NPV ($5,212,090.02)
IRR #NUM!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!