YearUnit Sales$13,00025,00036,00046,5006,00065,00074,00083,000$The military is investigating the feasibility of a new line of drones aimed at the growing market of recreational drone enthusiasts looking for cheaper options. Based on exploratory conversations with buyers for large retailers, it projects unit sales as follows:The new drone will be priced to sell at $$120$ per unit to start. When the competition catches up after three years, BWQ anticipates that the price will drop to $$110$:The drone project will require an initial investment of $$20,000$ in net working capital. Subsequently, total net working capital at the end of each year will be about $15$ percent of sales revenue for that year. TheIt will cost $$800,000$ to buy the equipment necessary to begin production. This investment qualifies as a straight$-$line depreciation asset over $8$ years, with no residual value. The equipment will have a salvage value of $20$ percent of its cost after eight years, or $$800,000\backslash$times $0\mathrm{.}20-$ $$160,000.$ The relevant tax rate is $21$ percent.BWQ is an all$-$equity$-$financed company. The current risk$-$free rate is $4\%,$ and the market portfolio has returned $11\%$ recently. The beta for the recreational drone industry, based on comparable companies, is$1\mathrm{.}9$Based on this information, should BWQ proceed? $-$ Present NPV and IRR analysis. Please present your work in Excel