Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

U.S. Mergers And Acquisitions Legal And Financial Aspects

Authors: Felix Lessambo

1st Edition

3030857344,3030857352

More Books

Students also viewed these Finance questions