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)

have to answer the blanks with the information given in excel sheet
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)

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!