Question: need help solving this in excel show work and explain how you got answers please. Intro Your company is considering producing a virtual reality headset,

need help solving this in excel show work and explain how you got answers please.
Intro Your company is considering producing a virtual reality headset, for which you've collected the following sales projections (in 5 million). Operating expenses are expected to add up to 70% of sales. A BC D E 1 Year 0 1 2 3 2 Sales 0 120 144 158.4 The project requires a new machine that costs $150 million 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 to zero over 3 years The machine requires an immediate increase in net working capital of $24 million which can be recouped at the end of year 3. Your company has a weighted average cost of capital of 8% and a marginal tax rate of 19% Part 1 8 Attempt 1/30 for 10 pts Open a spreadsheet with a blank tab and name it "CF", for cash flows. Duplicate the table above and extend it to find the operating cash flow for each year. What is the operating cash flow for year 3 (in 5 milion)? 1+ decimals Submit 8 Attempt 1/30 for 10 pts. Part 2 Extend the spreadsheet to find the cash flow for each year. What is the CF in year 3 (in 5 million)? 0+ decimals Submit 8 Attempt 1/30 for 10 pts Part 3 What is the NPV of the project (in $ million)? 1+ decimals Submit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
