Use MS Excel and turn in your XLS document. This work is to be turned in individually.

Compute the present value of a project that has a lifetime of 7 years. The total investment is 1.5 million dollars. The depreciation method is MACRS-GDS classified as 5 year property. The tax rate is 21%. 43% of the investment is financed with a loan at 7% per year, payable in 5 yearly payments. The positive cash flows in each one of the seven years are $420,000 each year. The salvage value of the investment is $225,000 at the end of the 7th year. The MARR is 14%

Show all your computations in a single table in MS Excel.

please submit the excel screenshot of the results and the screenshot of the formula used in excel to do the calculation