please show your work and don't copy paste the answer from another tutor bc it's wrong. This question needs to be done in Excel, so please show all your steps and work in Excel or if you are doing by hand take a photo please.

Drone Corp. is a company located in Barrington II - it is owned by Jennifer Swanson who inherited the business from her family. The company's original business was to manufacture and sell remote control toy aircraft and they have been in business for many years. In recent years they developed a drone aircraft and a variety of related specialty items, all of which have been reasonably successful. Kara Mielke is a recent NEIU graduate hired to their finance department. One of the company's major income-producing lines of business involves Buzzer, an early entry into the drone market. They have one model on the market and it has been very successful. The Buzzer is distinguished from the competition because it comes in various colors and is preprogrammed to work with add-on features that make it attractive to customers. But the rate of change in the industry is fast and some of the competitor products that are coming to market seem to provide the customer with choices and features which will make those competitive products more attractive than Drone's Buzzer. Jennifer expended $750,000 to develop a prototype that would upgrade the Buzzer so that it would stay a step ahead of the competitors. The company then spent an additional $200,000 on a feasibility study to determine the expected revenue figures for the upgraded Buzzer. The company can manufacture the new upgraded Buzzer for $205 in variable costs. Their fixed fees for the operation are assessed to be approximately $5.1 million annually. The estimated unit sales are 64,000,106,000,87,000, 78,000 , and 54,000 annually for the next five years, respectively. The unit price of the new upgraded Buzzer will be $485. The requisite equipment can be acquired for \$34.5 million and it will be depreciated on a seven-year MACRS schedule. It is believed that the value of the equipment in five years will be $5.5 miltion. Net working capital for the upgraded Buzzer will be 20% of sales and will occur with the timing of the cash flows for the respective year (that is, no working capital investment in the initial outlay). Changes in working capital will therefore first occur in year 1 with the first year's sales. The firm Has a 35% corporate tax rate and a required return of 12%. Their questions are: 1. What is the payback period for the project