1. You have to use formulas to calculatethe present value costsin the output areas, and you have to use cell locations, not numbers from the input areas in the formulas or functions.
2. Data in the B4:E9 range are given, don't add, or change any value in the range.In other words, formulas should only be entered in the output ranges marked with yellow color.
3. A present value cost ofis the total costs of each year times the discount rates (in cells B2, C2, D2, E2). In your formulas, use absolute addresses for these discount rates and calculate the total present value costs of every item in a related cell locations such asF4 for Computer, etc.
4. You have to use sum function for total costs of each yearB11 to F11 and for the total of present value costs of each category F4 to F9.