Question
Create a spreadsheet to model the following: 1. [20pts] You are the product manager of a toy company thinking of launching a new product, the
Create a spreadsheet to model the following: 1. [20pts] You are the product manager of a toy company thinking of launching a new product, the indoor fort building kit Links to an external site.. Your critics say these are just overpriced cardboard boxes, but you know this product will be successful and you seek out initial investors. In year 0 (right now), you will incur a cost of $4 million to build and staff a production factory. In year 1, you expect to sell 80,000 kits at a unit price of $25 each. The price of $25 will remain unchanged through years 1 to 5. Unit sales are expected to grow by the same percentage (g) each year. During years 1 to 5, you incur two types of costs: variable costs and fixed SG&A (selling, general, and administrative) costs. Each year, variable costs equal half of revenue. During year 1, SG&A costs equal 40% of revenue. This percentage is assumed to drop 2% per year, so during year 2, SG&A costs will equal 38% of revenue, and so on. Your goal is to have profits for years 0 to 5 sum to 0 (ignoring the time value of money). This will ensure that the $4M investment in year 0 is paid back by the end of year 5. What annual percentage growth rate g is needed to pay back the plant cost by the end of year 5?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started