Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Technical Analysis Of The Financial Markets

Authors: John J. Murphy

1st Edition

0735200661, 978-0735200661

More Books

Students also viewed these Finance questions