Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions