ABC Inc. is considering a proposal to manufacture sanitizers. The proposal envisages an investment in plant and equipment of $$1$ million and the sum of transit, installment, and training costs of $$100,000.$ The feasibility study cost for the project was $$100,000.$ This fixed asset investment could be fully depreciated for tax purposes straight$-$line over $10$ years without salvage value. However, ABC expects to terminate the project at the end of $7$ years and to resell the plant and equipment in year $7$ for $$400,000.$ The project would use an existing warehouse that is currently rented out to a neighboring firm. The first project year's rental charge on the warehouse is $$100,000,$ and after that, the rent is expected to grow in line with inflation at $5\%$ a year. Operating fixed costs, excluding depreciation, are expected to be $$500,000$ at year $1$ and will grow with the same inflation rate of $5\%$ every project year. Finally, the project requires an immediate investment in working capital of $$300,000$ from year $0.$ Thereafter, working capital is forecasted to be $10\%$ of sales in each of years $1$ through $6.$ Working capital will be run down to zero in year $7$ when the project shuts down. Year $1$ sales of sanitizers are expected to be $$4$ million, and after that, sales are forecasted to grow by $8\%$ a year, slightly faster than the inflation rate. Manufacturing costs are expected to be $75\%$ of sales, and profits are subject to tax at $21\%.$ The cost of capital is $14\%.$ The project has a discount payback period restriction that should be at least shorter than $5$ years to accept the project. Build the Project Cash Flow Model for the $7$ years with the following template.