Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Period (Year) 0 Cumulative (Total Cost/Benefit To Date) ($255,000.00) ($280,000.00) 5 1 2 Cost/Benefit Analysis System Y Benefits (Costs) Remarks ($255,000.00) system development cost ($25,000.00)
Period (Year) 0 Cumulative (Total Cost/Benefit To Date) ($255,000.00) ($280,000.00) 5 1 2 Cost/Benefit Analysis System Y Benefits (Costs) Remarks ($255,000.00) system development cost ($25,000.00) customer confusion/lost sales $70,000.00 benefits begin to show $85,000.00 $90,000.00 strong benefits $60,000.00 $30,000.00 reduced benefits $20,000.00 $0.00 cost and benefits again equal 3 4 5 6 1 7 8 Tech Final Cost Benefit WorkSheet Y.xlsx Using the link to Tech Final Cost Benefit Worksheet Y 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 Y to break even. 2. The internal rate of return (IRR) of System Yis % (round to the nearest integer). 3. At 3% interest rate, the net present value (NPV) of System Y is $ dollars (round to the nearest integer), 4. If the system development cost in Cell B4 is ($285,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 Y to break even
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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