Entire dynamic model to be completed in Excel

Pointless Luxuries Inc. $($PLI$)$ produces unusual gifts targeted at wealthy consumers. The firm is analyzing the possibility of introducing a new device designed to attach to the color of a cat or dog. The device emits sonic waves that neutralize airplane engine noise, so that pets traveling with their owners can enjoy a more peaceful ride. PLI estimates that developing this product will require up$-$front capital expenditures of $$9$ million. These costs will be depreciated on a MACRS $5-$year schedule. PU believes that it can sell the product initially for $$250.$ The selling price will increase to $$260$ in years $2$ and $3,$ before falling to $$245$ and $$240$ in years $4$ and $5,$ respectively. After five years the company will withdraw the product from the market and replace it with something else. Upon withdrawal, the firm believes that the salvage value of the equipment would be $$625,000.$ Variable costs are $$135$ per unit. PLI forecasts sales volume of $20,000$ units in the first year, with subsequent increases of $25\%($year $2),20\%($year $3),20\%($year $4),$ and $15\%($year $5).$ The firm expects operating expenses, other than depreciation, to be $$220,000$ for all five years. PU is currently in the $34\%$ tax bracket.

The working capital needs are the following.$--$

$\backslash$table$[[$Year $0,$$$0$