Based upon this information is my answer in the attached picture of my spreadsheet correct in calculated the Present worth?

second how do i calculate the EAC or EAW?

Replace Air Handling Units Every 5 Years $ 2,000,000

Re-Roof Nursing Towers Every 10 Years 250,000

Nursing Tower Salvage Value after 25 Years 0%

Annual Energy Consumption (Cost)850,000

Maintenance/Repair Costs/Year 1,250,000

Nursing Staff Annual Costs Cost, 7,776,000

Project life cycle 25 years ?

Interest Rate 10% compounded annually

Inflation approach Constant dollars

Staffing costs escalation $325,000/year

Problem 1 0 Interest Rate, i 25 Years, N Cash Flow Replace engergy miantena unit nce Staffing Year Single Costs Reroof consum Salva every 5 every 10 ption repairs annual ge Total years annual Annual COS Value $0 $0 $0 $0 $0 $0 $0 $0 $0 -$850,000 -$1,250,000 -$7 776,000] $0 -$9,876,000 $0 $0 -$850,000 -$1,250,000 -$8.101,000 $0 -$10,201,000 $0 $0 $0 $0 -$850,000 -$1.250,000 -$8.426.000 $0 -$10.526,000 $0 $0 $0 -$2,000,000 $0 -$850.000 -$1.250,000 -$8.751,000 $0 -$850,000 -$1.250,000|-$9,076,000 $0 -$10.851.000 $0 -$13.176,000 $0 $0 $0 -$850,000 -$1,250,000 -$9.401,000 -$11.501,000 $0 $0 -$850.000 $0 $0 000 -$9.726,000 $0 -$11826,000 $0 $0 $0 -$850.000 - $0 :0 -$850,000 -$1,250 -$1 250,000 -$10,051,000 -$10,376,000 -$12.151,000 $0 -$2,000,000 -$250,000 -$850,000 -$1,250,000 -$12 476,000 $0 -$10,701,000 $0 -$15.051,000 $0 -$850,000 -$1,250,000 -$11,026,000 $0 -$13.126,000 $0 $0 -$850,000 -$1,250,000|-$11,351,000 $0 -$850,000 -$1,250,000 -$11,676,000 $0 -$13.451,000 -$13.776,000 $0 0 -$2,000,000 $0 -$850,000 -$1,250,000|-$12,001,000 -$14.101,000 $0 -$850,000 -$1.250,000 -$12,326,000 -$16,426,000 $0 $0 -$850,000 -$1.250,000|-$12 651,000 -$14.751,000 $0 $0 $0 -$850,000 -$1.250,000 -$12.976,000 -$15.076,000 $0 -$850,000 -$1.250,000 -$13,301,000 $0 -$15.401,000 $0 -$850,000 -$1.250,000 -$13.626.000 $0 -$15.726.000 $0 -$2.000,000 -$250,000 -$850,000|-$1.250,000 -$13.951,000 $0 $0 -$18.301,000 $0 $0 -$850,000 -$1.250,000 -$14 276,000 $0 -$16.376,000 $0 $0 -$850,000 -$1.250.000 -$14601,000 $0 -$16.701,000 $0 $0 $0 -$850,000 -$1.250,000 -$14,926,000 $0 -$17 026,000 $0 $0 0 -$850.000 -$1.250,000 -$15.251,000 $0 -$17 351,000 NPV $0 -$2,000,000 $0 -$850,000 -$1.250,000 -$15.576,000 $0 -$19.676,000 [ $990.862.42] OR Problem 1 10 Interest Rate, i 25 Years, N Initial Price, P $7.776.000 Operating Expenses, A -$2.100,000 Maintenance and Repair, A [500,000.00) Maintenance and Repair, G NPV = $A$42-PV[$A$40.$A$41.$A$43]-PV[$A$40.$A$41.$A$44)-PV($A$40.$A$41.,--500000) NPV = -987.600