Question: Please use Excel to answer this question Question 5 [Total of 15 points] Logitech is considering a new portable streaming camera that can be used

Please use Excel to answer this question Please use Excel to answer this question Question 5 [Total of 15

Question 5 [Total of 15 points] Logitech is considering a new portable streaming camera that can be used as a cell phone accessory and has hired you to consult. You estimate that in each of the next four years Logitech will sell 2.1mil portable streaming cameras. Each camera will sell at a price of $180 and will cost $110 to produce. The project requires a $72mil upfront investment in production machinery and this investment will be depreciated (straight line) over six years. You estimate that Logitech will spend $90 mil on social media and marketing each year. After the four years, the project will shut down. Assume that accounts payable are 16% of COGS and that accounts receivable are 5% of revenues. The corporate tax rate is 21% and the discount rate is 12.3%. Part 1: [10 points] Calculate the FCF and NPV of the project. Report here final values (2-digits of significance) and have complete calculations in your spreadsheet. Part 2: [5 points] If Logitech sells the production machinery at the end of the fourth year at a price of $42mil, how much will Logitech owe the government in additional taxes from the sale (in year 4)? Report here final values (2-digits of significance) and have complete calculations in your spreadsheet

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!