this is an excel assignment

Discount Rate Present Value Costs Computer Software Additional Hardware Training Software upgrades Maintenance COST OF NEW COMPUTER 1 0.9325 0.8109 0.7051 Time 01 Year 1 Year 2 Year 3 $1,000.00 $ - S $2,000.00 $ $ 800.00 $- $ IS $ 800.00 $ $ $1,000.00 $1,000.00 $ 500.00 $ $ 500.00 $ 600.00 $ 700.00 Total Costs 2. The formula for F4 is... A. Computer cost in Time 0 multiplied by Discount Rate in Time 0. plus Computer cost in Year 1 multiplied by Discount Rate in Year 1. plus Computer cost in Year 2 multiplied by Discount Rate in Year 2, plus Computer cost in Year 3 multiplied by Discount Rate in Year 3. (3.0) B. Use formula operators to craft a formula with a minimum of operators (+-.0 so that once the formula in F4 is crafted, you can copy it by dragging/copying it to cells F5 through F9. Unnecessary operators will be penalized at a point each. (5.0) * Remember order of operators to help you craft the formula with the minimum of operators 3. The yellow cells on the Total Costs row sum the rows 3 through 9 above. (1.0)