Please help explain the formulas for this spread sheet.

Apply Your Knowledge Project 6 - Cost Comparison Input boxes in tan Output boxes in yellow Given data in blue Answers in red edge COST OF NEW COMPUTER Discount Rate Computer Software Additional Hardware Training Software upgrades Maintenance Total Costs 1 0.9325 0.8109 0.7051 Time 0 Year 1 Year 2 Year 3 $ 1,000.00 $ 2,000.00 $ 800.00 $ 800.00 $ $ - $ $ $ $ $ 1,000.00 $ 500.00 $ ### $ ### $ ### $ ### $ 1,000.00 $ 500.00 $ 600.00 $ 700.00 Present Value Costs