1 answer

Problem 3-10 The Tuff Wheels was getting ready to start its development project for a new...

Question:

Problem 3-10 The Tuff Wheels was getting ready to start its development project for a new product to be added to their smallb. What is the impact on NPV for the kiddy Dozer if the actual sales are 50,000 per year? 70,000 per year? (Enter your answer

Problem 3-10 The Tuff Wheels was getting ready to start its development project for a new product to be added to their small motorized vehicle line for children. The new product is called the Kiddy Dozer. It will look like a miniature bulldozer, complete with caterpillar tracks and a blade. Tuff Wheels has forecasted the demand and the cost to develop and produce the new Kiddy Dozer. The table below contains the relevant information for this project. Development cost Estimated development time Pilot testing Ramp-up cost Marketing and support cost Sales and production volume Unit production cost Unit price Interest rate $950,000 9 months $200,000 $400,000 $150,000 per year 60,000 per year $ 100 $ 175 8 % Tuff Wheels also has provided the project plan shown below. As can be seen in the project plan, the company thinks that the product life will be three years until a new product must be created. 9 YEAR 1 ₂ 0 9 9 YEAR 2 2 9 4 9 YEAR 3 O O O O YEAR 4 O O Q4 PROJECT SCHEDULE KIDDY DOZER Development Pilot Testing Ramp-up Marketing and Support Production and Sales Assume all cash flows occur at the end of each period. a. What is the net present value (discounted at 8%) of this project? Consider all costs and expected revenues. (Enter your answer in thousands of dollars. Perform all calculations using Excel. Do not round any intermediate calculations. Round your answer to the nearest thousand.)
b. What is the impact on NPV for the kiddy Dozer if the actual sales are 50,000 per year? 70,000 per year? (Enter your answer in thousands of dollars. Perform all calculations using Excel. Do not round any intermediate calculations. Round your answer to the nearest thousand.) Answer is complete but not entirely correct. NPV 50,000 NPV 70,000 $ 32,368,898 X $ 46,046,871 % c. Based on the original sales level of 60,000, what is the effect on NPV caused by changing the discount rate to 9%, 10%, or 11%? (Enter your answer in thousands of dollars. Perform all calculations using Excel. Do not round any intermediate calculations. Round your answer to the nearest thousand.) Answer is complete but not entirely correct. NPV 9% NPV 10% NPV 11% $ 38,209,490 $ 37,241,086 $ 36,301,644

Answers

Development Cost $9,50,000
Estimated Development Time 9 months
Pilot Testing $2,00,000
Ramp-up Cost $4,00,000
Marketing and support cost $1,50,000 per year
Sales and Production volume 60000 per year
Unit Production cost $100
Unit Price $175
Interest Rate 8% 2% Quarterly
Period (n) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Project Schedule Year 1 Year 2 Year 3 Year 4
Kiddey Dozer Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 TOTAL
Development -$3,16,666.67 -$3,16,666.67 -$3,16,666.67 0 0 0 0 0 0 0 0 0 0 0 0 0
Pilot Testing 0 0 0 -$2,00,000 0 0 0 0 0 0 0 0 0 0 0 0
Ramp-up 0 0 0 -$4,00,000 0 0 0 0 0 0 0 0 0 0 0 0
Marketing and support 0 0 0 0 -$37,500 -$37,500 -$37,500 -$37,500 -$37,500 -$37,500 -$37,500 -$37,500 -$37,500 -$37,500 -$37,500 -$37,500
Production 0 0 0 0 -$15,00,000 -$15,00,000 -$15,00,000 -$15,00,000 -$15,00,000 -$15,00,000 -$15,00,000 -$15,00,000 -$15,00,000 -$15,00,000 -$15,00,000 -$15,00,000
Sales $26,25,000 $26,25,000 $26,25,000 $26,25,000 $26,25,000 $26,25,000 $26,25,000 $26,25,000 $26,25,000 $26,25,000 $26,25,000 $26,25,000
Net Cashflow -$3,16,666.67 -$3,16,666.67 -$3,16,666.67 -$6,00,000.00 $10,87,500.00 $10,87,500.00 $10,87,500.00 $10,87,500.00 $10,87,500.00 $10,87,500.00 $10,87,500.00 $10,87,500.00 $10,87,500.00 $10,87,500.00 $10,87,500.00 $10,87,500.00
PV Factor @ 8% i.e 2% Quarterly (1/1.02^n) 0.9804 0.9612 0.9423 0.9238 0.9057 0.8880 0.8706 0.8535 0.8368 0.8203 0.8043 0.7885 0.7730 0.7579 0.7430 0.7284
NPV -$3,10,457.52 -$3,04,370.11 -$2,98,402.07 -$5,54,307.26 $9,84,982.26 $9,65,668.88 $9,46,734.19 $9,28,170.78 $9,09,971.35 $8,92,128.78 $8,74,636.06 $8,57,486.33 $8,40,672.87 $8,24,189.09 $8,08,028.52 $7,92,184.82 $91,57,317
b. Sales NPV
50000 $73,25,446
70000 $1,09,89,188
C.
Interest Rate NPV
9% $89,03,875
10% $86,58,191
11% $84,19,996

answers for b and c can be obtained by changing cell value of Sales and production volume (B6) and Interest Rate (B9) respectively.

.

Similar Solved Questions

1 answer
6. A marble of mass mı slides on a horizontal smooth surface with velocity vo until...
6. A marble of mass mı slides on a horizontal smooth surface with velocity vo until it col- lides elastically with a second marble of mass m2-Зап1, which was initially at rest. The marble of mass m2 falls from a step of height h - 0.5m. Find the value of vo for which the marbl...
1 answer
During the period, Halverson’s cost of goods manufactured was $540,000. In addition, its beginning and ending...
During the period, Halverson’s cost of goods manufactured was $540,000. In addition, its beginning and ending inventories for work in process and finished goods were: Beginning Ending Work in Process    $125,000 $150,000 Finished Goods $200,000 $180,000 Halverson’s S...
1 answer
Consider the ARMA(2,1) model 2+ = 0.624-1 -0.092-2 + at – 0.204-1, a4~WN(0,1) Find the AR...
Consider the ARMA(2,1) model 2+ = 0.624-1 -0.092-2 + at – 0.204-1, a4~WN(0,1) Find the AR representation of {Z}....
1 answer
A projectile proton with a speed of 1100 m/s collides elastically with a target proton initially...
A projectile proton with a speed of 1100 m/s collides elastically with a target proton initially at rest. The two protons then move along perpendicular paths, with the projectile path at 78° from the original direction. After the collision, what are the speeds of (a) the target proton and (b) th...
1 answer
An elderly patient has just been admitted into the ER with symptoms of confusion, muscle tremors,...
an elderly patient has just been admitted into the ER with symptoms of confusion, muscle tremors, and red swollen tongue. when taking his history, it is revealed he had been discharged from the hospital 2 days ago. he has been on IV therapy for a stomach virus but could not keep down fluids after he...
1 answer
How do you write the equation of the line with slope 2/3 through the point (-3, -7) in slope-intercept form?
How do you write the equation of the line with slope 2/3 through the point (-3, -7) in slope-intercept form?...
1 answer
What is the solubility of Cr(OH)₃ at a pH of 9.30? (Ksp Cr(OH)₃ is 6.70 ×...
What is the solubility of Cr(OH)₃ at a pH of 9.30? (Ksp Cr(OH)₃ is 6.70 × 10⁻³¹)...
1 answer
2. Bruno's Lunch Counter is expanding and expects operating cash flows of $26,000 a year for...
2. Bruno's Lunch Counter is expanding and expects operating cash flows of $26,000 a year for 4 years as a result. This expansion requires $39,000 in new fixed assets. These assets will be worthless at the end of the project. In addition, the project requires $3,000 of net working capital, 100% o...
1 answer
For each of the following events, consider how you might react. What things might you consume...
For each of the following events, consider how you might react. What things might you consume more or less of? Would you work more or less? Would you increase or decrease your savings? Are your responses consistent with the topic of chapter 6? Interest rates rise dramatically, and savings accounts a...
1 answer
Scenario for 2-5: Research question: Is there a difference in the infant mortality rates of states...
Scenario for 2-5: Research question: Is there a difference in the infant mortality rates of states above and below the mean income? Use the SPSS output below. Test the mean difference and the assumption of equal variances at the .05 level. Group Statistics N INCGROUP INFMORT Infant mortalit 1.00 bel...
1 answer
Marlene Bellamy purchased 400 shares of Writeline Communications stock at $ 55.36 per share using the...
Marlene Bellamy purchased 400 shares of Writeline Communications stock at $ 55.36 per share using the prevailing minimum initial margin requirement of 54%. She held the stock for exactly 7 months and sold it without any brokerage costs at the end of that period. During the 7​-month holdingR...
2 answers
How do you find the domain of #f(x)= (8x)/((x-1)(x-2)) #?
How do you find the domain of #f(x)= (8x)/((x-1)(x-2)) #?...
1 answer
Three entrepreneurs were looking to start a new brewpub near Sacramento, California, called Roseville Brewing Company...
Three entrepreneurs were looking to start a new brewpub near Sacramento, California, called Roseville Brewing Company (RBC). Brewpubs provide two products to customers-food from the restaurant segment and freshly brewed beer from the beer production segment. Both segments are typically in the same b...
1 answer
Describe one common error in using dynamic memory allocation.
describe one common error in using dynamic memory allocation....
1 answer
A project that will last for 11 years is expected to have equal annual cash flows...
A project that will last for 11 years is expected to have equal annual cash flows of $104,200. If the required return is 8.3 percent, what maximum initial investment would make the project acceptable?...