Question: need help solving this in excel show work and explain how you got answers please. Intro Your company is considering a project to produce electric

need help solving this in excel show work and explain how you got answers please.
Intro Your company is considering a project to produce electric scooters. You've spent $10,000 already on a market research study that projects the following unit sales: A B C D E 1 Year 0 1 2 3 2 Units 01,900 2,090 2,299 After 3 years, the market will be saturated and you will shut down production. Each scooter is expect to sell for $260 and will incur variable costs of $182 for labor and materials. In addition, you'll incur fixed costs of $98,800 every year. You will need a new machine to produce the scooters. If you buy the machine now [year ), it will start producing scooters next year (year 1). The machine costs $65,000 to purchase. The machine can be depreciated straight-line to zero over 5 years and can probably be sold for $32,500 after 3 years. Your company has a weighted average cost of capital of 10% and a marginal tax rate of 21% Part 1 18. Attempt 1/30 for 10 pts. What is the cash flow from salvage value of the machine in year 3? 0+ decimals Submit Attempt 1/30 for 10 pts Part 2 What is the cash flow now (year O)? 0+ decimals Submit Attempt 1/30 for 10 pts. Part 3 What is the cash flow in year 3? O+ decimals Submit Part 4 Attempt 1/30 for 10 pts. What is the NPV of the investment? 0+ decimals
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
