B F A 1 2 Discount Rate D E COST OF NEW COMPUTER 0.9325 0.8109 0.7051 1 Time 0 Year 1 Year 2 Year 3 Present Value Costs 4 Computer me 5 Software 6 Additional Hardware 7 Training 8 Software upgrades 9 Maintenance ete 10 "11 Total Costs 12 $ 1,000.00 $ $ $ $ 2,000.00 $ $ $ $ 800.00 $ $ $ $ 800.00 $ $ $ $ $ 1,000.00 $ 1,000.00 $ 500.00 $ $ 500.00 $ 600.00 $ 700.00 - ed D E 4 Book Boxes Title Weight Cost Sale Price Profit per Book Total Profit Total Weight 5 4 9 8 7 6 7 8 9 -me 10 11 12 13 14 Harry Potter. JK Rowling The Lord of the Rings JRR Tolkien Chronicles of Namia, CS Lewis A Series of Unfortunate Events, Lemony Snicket Charlie and the Chocolate Factory Roald Dahl A Wrinkle in Time, Madeleine L'Engle Total 17 13 11 9 7 6 Number of Books per Box 4 3 5 7 2 6 3 2.5 1 5 Question 14 4 points Save Answer In the "Cost Comparison" spreadsheet, complete the cells for the calculations of the Present Value Costs (PVC), Total Costs for each year, and the Total PVC. In the "Maximize Profit" sheet, the cells for the calculations of the Profit per Book, Total Profit, Total Weight, and the Total of each of the Total profit and Total weight. In a row below each of the two spreadsheet, enter your full name in a cell and format it using suitable font and color appropriately to indicate that you completed the content. Then rename the file with a1-[Firstname-Lastame).xlsx" where (Firstname-Lastname] is your first and last names. Finally, upload the completed Excel file here. Attach File