Please show the full solution by hand showing every equation that you have used. Also, don't do things in excel, everything should be seen. Show all steps taken to reach the answer. Thank you very much.

A construction company is deciding if they should make a new building bronze, silver, or gold LEED-certied, or not at all. Regardless of the level of certication, this new building will generate extra annual revenues of $40 000 starting at the end of the first year due to intended business operation. In terms of operational cost, each option offers different levels of annual energy savings (can be taken as annual incomes), but also different operation and maintenance costs. Please also note that a building with no certication will have no energy savings, but energy costs. Further, the government offers different tax credits depending on the level of environmental consciousness. Please note that all annual costs and savings begin at the end of year 3 and extend until the end of the operation life. The buildings are intended to operate for 20 years, and the company has a minimum attractive rate of return (MARR) of 5%. The following data is available for each option: Annual Certication Initial Cost Operation and Enwronmental Salvage Mamtenance Tax Credit value costs No $320,000 -$13,000 $8,000 $0 $180,000 $630,000 $16,400 $13,000 $5,000 $430,000 $880,000 $29,400 $21,500 $10,000 $660,000 $1,040,000 $51,300 $29,500 $15,000 $750,000