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 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
Get step-by-step solutions from verified subject matter experts
