Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 5 2 points Save Answer Computer Purchase: This question requires the use of an Excel file that can be downloaded from the link shown
Question 5 2 points Save Answer Computer Purchase: This question requires the use of an Excel file that can be downloaded from the link shown in the instruction above. The spreadsheet named "Cost Comparison in the Excel file provides data about a company that sells books and that is budgeting for hardware and software purchases for the upcoming 3 years. The company determined that costs invested today will be discounted over time and therefore, identified the discounted rates for years elapsed after Time (shown in cells C2.E2). Each name listed in Cells A:A9 is one item that will incur costs. Each value in Cells B4:E9 is a cost to be invested at a certain time (an empty cell indicates no cost for that item-year combination). Note that "Time O' is the beginning of the three-year period; "Year 1", "Year 2" and "Year 3" are the ends of the first second, and third years respectively. Column Findicates the total "Present Value Costs" (PVC) of the items over the three-year period. The PVC of an item-year combination is calculated by multiplying the discount rate with the item cost. When calculating the total costs for Year 2 (Cell D11), which of the following formulas is correct? D2 TOTAL(D4:08) D2*SUM(D4:09) ADD(D4:09) SUM(D4:09) D2^2*SUM(D4:08) D2^2*SUM(D4:09) A. B E F G 1 2 Discount Rate D COST OF NEW COMPUTER 0.9325 0.8109 0.7051 1 Time 0 Year 1 Year 2 Year 3 Present Value Costs te 3 4 Computer 5 Software 6 Additional Hardware 7 Training 8 Software upgrades 9 Maintenance $ 1,000.00 $ $ $ $ 2,000.00 $ $ $ 800.00 $ $ $ 800.00 $ $ $ $ 1,000.00 $ 1,000.00 $ 500.00 $ $ 500.00 $ 600.00 $ 700.00 alololololo e 10 11 Total Costs
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started