I got the AW and PW for Design B wrong, the values shown are correct. The values I got for Design B were: AW = $-71171.83 and PW = $-733299.62. Please help, show details, and excel details if excel is used. Thank you.

A new highway is to be constructed. Design A calls for a concrete pavement costing $95 per foot with a 16-year life; three paved ditches costing $5 per foot each; and three box culverts every mile, each costing $10,000 and having a 16-year life. Annual maintenance will cost $1,900 per mile, the culverts must be cleaned every four years at a cost of $400 each per mile Design B calls for a bituminous pavement costing $50 per foot with a 8-year life; three sodded ditches costing $1.60 per foot each; and four pipe culverts every mile, each costing $2,100 and having a 8-year life. The replacement culverts will cost $2,350 each. Annual maintenance will cost $2,700 per mile; the culverts must be cleaned yearly at a cost of S235 each per mile, and the annual ditch maintenance will cost $1.55 per foot per ditch. Compare the two designs on the basis of equivalent worth per mile for a 16-year period. Find the most economical design on the basis of AW and PW if the MARR is 6% per year Click the icon to view the interest and annuity table for discrete compounding when the MARR is 6% per year The AW value for Design A is $ -62614 /mi. (Round to the nearest hundreds.) The PW value for Design A is S 632773 /mi. (Round to the nearest hundreds.) The AW value for Design B is S -76,200 /mi. (Round to the nearest hundreds.) The PW value for Design B is S -770,100 /mi. (Round to the nearest hundreds.) The most economical design on the basis of AW and PW is Design A A new highway is to be constructed. Design A calls for a concrete pavement costing $95 per foot with a 16-year life; three paved ditches costing $5 per foot each; and three box culverts every mile, each costing $10,000 and having a 16-year life. Annual maintenance will cost $1,900 per mile, the culverts must be cleaned every four years at a cost of $400 each per mile Design B calls for a bituminous pavement costing $50 per foot with a 8-year life; three sodded ditches costing $1.60 per foot each; and four pipe culverts every mile, each costing $2,100 and having a 8-year life. The replacement culverts will cost $2,350 each. Annual maintenance will cost $2,700 per mile; the culverts must be cleaned yearly at a cost of S235 each per mile, and the annual ditch maintenance will cost $1.55 per foot per ditch. Compare the two designs on the basis of equivalent worth per mile for a 16-year period. Find the most economical design on the basis of AW and PW if the MARR is 6% per year Click the icon to view the interest and annuity table for discrete compounding when the MARR is 6% per year The AW value for Design A is $ -62614 /mi. (Round to the nearest hundreds.) The PW value for Design A is S 632773 /mi. (Round to the nearest hundreds.) The AW value for Design B is S -76,200 /mi. (Round to the nearest hundreds.) The PW value for Design B is S -770,100 /mi. (Round to the nearest hundreds.) The most economical design on the basis of AW and PW is Design A