Please use excel when you do this!

4) The company you work for is installing Solar Panels. These will allow the company to eliminate electricity costs (zero cost cach year) for the next 30 years. Below is the important data about this project. Determine the after tax cashflow cach year for this investment and calculate the NPV for this project. Use 6% MARR. Initial cost of the panels is $200,000 which can be depreciated using MACRS 10- year recovery period This project has a 30 year life In the year that the solar panels are put into service there is a 10% (on the cost of the panels ($20,000)) credit to taxes. This results in lower taxes paid in year 1. Over the last 2 years, electricity costs have been $15,000/year. If the solar panels are not implemented, this cost will continue to increase at a rate of 5% per year. There is no salvage value for the solar panels. Tax rate is 28% Use 8% MARR 4) The company you work for is installing Solar Panels. These will allow the company to eliminate electricity costs (zero cost cach year) for the next 30 years. Below is the important data about this project. Determine the after tax cashflow cach year for this investment and calculate the NPV for this project. Use 6% MARR. Initial cost of the panels is $200,000 which can be depreciated using MACRS 10- year recovery period This project has a 30 year life In the year that the solar panels are put into service there is a 10% (on the cost of the panels ($20,000)) credit to taxes. This results in lower taxes paid in year 1. Over the last 2 years, electricity costs have been $15,000/year. If the solar panels are not implemented, this cost will continue to increase at a rate of 5% per year. There is no salvage value for the solar panels. Tax rate is 28% Use 8% MARR