Solutions Corp. is considering an investment in an equipment to produce a new medical testing device. The project will require an initial investment in equipment of $850,000, and will last four years, after which, it is estimated that so much population will be immunized that there will not be enough demand to continue with the product, so the projects life is 4 years. It will generate an annual revenue of $500,000 and will carry annual operating costs of $200,000.

The project will also increase Solutions net working capital by $80,000. At the end of the project, the equipment will be sold for $120,000. The tax rate is 26.5% and the CCA rate for depreciation purposes is 27%.

Solutions Corp. assesses that the risk of the project is higher than its existing operations. Therefore, it has decided to use a discount rate for the project that is 2% higher than the firms cost of capital. Currently, the cost of common equity is 11%, the cost of preferred equity is 8% and the before-tax cost of debt of the firm is 7%. The capital structure of the firm based on market values indicate that assets are financed by 40% of common equity, 20% of preferred equity, and 40% of debt.

Calculate the NPV (round your final answer to the dollar, no decimals) of the project and recommend whether the company should undertake this project.

(would really appreciate if you could please solve this using excel)