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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!