Question: need help solving this , must do in Excel and explain how you got your answer please. Problem 11 0 Intro You've started a company

 need help solving this , must do in Excel and explain

need help solving this , must do in Excel and explain how you got your answer please.

Problem 11 0 Intro You've started a company to produce electrified selfie sticks. A stick will give you a mild electric shock whenever you try to take a selfie while your hand is shaking (e.g., if you are intoxicated). In fact, your hand was shaking when you came up with the idea for this business. You project the following unit sales: B DE 1 Year 1 2 3 2 Units 0 29,000 31,900 35,090 Each selfie stick is expectd to sell for $26 and will incur variable costs of $20.8 for labor and materials. In addition, you'll incur fixed costs of $75,400 every year. You will need a new machine to produce the selfie sticks. If you buy the machine now (year 0), it will start producing sticks next year (year 1). The machine costs $18,000 to purchase and install. After year 3, production will end and the new machine will be scrapped without cost or resale value. The equipment can be depreciated straight-line to zero over 3 years. Your company has a weighted average cost of capital of 20% and a marginal tax rate of 21%. BAttempt 1/30 for 10 pts. Part 1 What is the cash flow in year 3? 0+ decimals Submit 8 Attempt 1/30 for 10 pts. Part 2 What is the NPV of the investment? 0+ decimals Submit

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!