A lab purchases a new piece of equipment that costs $280,000 directly from the manufacturer. The equipment is MACRS-GDS 5-Year Property and is estimated to have an 8-year life with a salvage value of $30,000 at that time. Annual calibration and recertification costs $3,000 per year. Assume a 12% after-tax MARR and taxes of 25% per year. B D E F G H 2 P= $280,000.00 3 S = $30,000.00 + 4. BT Net Rev = -$3,000.00 5 MARRAT 12.000% 6 n = 8 7 8 Tax rate = 25.000% 9 MARRBT = 12%/(1-25%)= 16.000% 10 EOY BTCF DWO M-G(5) TI T ATCF MACRS- GDS(5) 11 12 0 -$280,000.00 -$280,000.00 13 1 -$3,000.00 20.00% 14 2 -$3,000.00 32.00% 15 3 -$3,000.00 19.20% 16 4 -$3,000.00 11.52% 17 5 -$3,000.00 11.52% 18 6 -$3,000.00 5.76% 19 7 -$3,000.00 0.00% 20 8 $27,000.00 0.00% 21 The partially filled-in table above represents an Excel spreadsheet. Which Excel entry should you use to determine the T value for the EOY 3? O=C8E15 O=C2*H15 =C8*E17 O=C15-D15