Question: can i know how to solve it with formulas and not excel please Advantech, Inc is considering a new prodcut. The company spent $200,000 to
can i know how to solve it with formulas and not excel please Advantech, Inc is considering a new prodcut. The company spent $200,000 to develop the product. The estimated life of the product is 3 years and the estimated operating revenues and costs are the following: Sales 600,000 700,000 500,000 Operating costs 300,000 350,000 250,000 To produce this product the company will have to acquire a new equipment that costs $300,000. The equipment has a life of 5 years and will be depreciated straight line to zero. The company believes that the equipment can be sold in 3 year for $80,000. The new product does not require changes in the level of networking capital. The tax rate is 34% and the appropriate discount rate is 8%. a. Estimate the cash-flows associated with the project. b. Compute the NPV for the project. c. Should Advantech start with the production of the new product? Explain why
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
