Question: have to answer the blanks with the information given in excel sheet Period (Year) 0 1 2 3 Cumulative (Total Cost/Benefit To Date) ($100,000.00) ($110,000.00)

Period (Year) 0 1 2 3 Cumulative (Total Cost/Benefit To Date) ($100,000.00) ($110,000.00) Cost/Benefit Analysis System A Benefit (Cost) Remarks ($100,000.00) system development cost ($10,000.00) customer confusion/lost sales $30,000.00 benefits begin to show $30,000.00 $30,000.00 $30,000.00 $30,000.00 $30,000.00 $0.00 cost and benefits again equal 4 5 6 7 8 Using the link to Tech Midterm Cost Benefit Worksheet A above, fill in the blanks below with integers only (no dollar sign ($), comma.), percent sign (%), or decimal point(.), etc.): 1. It will take years and months for System A to break even. 2. The internal rate of return (IRR) of System A is % (round to the nearest integer). 3. At 3% interest rate, the net present value (NPV) of System A is $ dollars (round to the nearest integer). 4. If the system development cost in Cell B4 is ($115,000) instead - note this number must be entered as a negative number - while all other benefit (cost) remain the same, it will take years and months for System A to break even
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
