Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved 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

image text in transcribed

image text in transcribed

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 $1,100,000 Development cost Estimated development time Pilot testing Ramp-up cost Marketing and support cost $ 150,000 per year Sales and production volume60,000 per year Unit production cost Unit price Interest rate 9 months s 200, 000 s 400,000 100 190 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 YEAR I YEAR 3 YEAR 4 YEAR 2 PROJECT SCHEDULE KIDDY DOZER 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.) NPV 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.) NPV 50,000 NPV 70,000 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.) NPV 9962 NPV 10%,- can you please give Excel steps- Thank you

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

Wealth Inequality Asset Redistribution And Risk Sharing Islamic Finance

Authors: Tarik Akin , Abbas Mirakhor

1st Edition

3110583739, 3110583887, 9783110583885

More Books

Students also viewed these Finance questions