Question

In: Accounting

Assume monetary benefits of an information system of $50,000 the first year and increasing benefits of...

Assume monetary benefits of an information system of $50,000 the first year and increasing benefits of $5,000 a year for the next four years (year 1 = 50,000; year 2- 55,000; year 3 = 60,000; year 4 = 65,000; year 5 – 70,000). One-time development costs were $90,000 and recurring costs beginning in year 1 were $40,000 over the duration of the system’s life. The discount rate for the company was 10 percent. Using a 5-year horizon, calculate the net present value of these costs and benefits. Also calculate the overall return on investment of the project and then present a break-even analysis. At what point does break-even occur?

You must use formula MS Excel for your calculations in the worksheet

Solutions

Expert Solution

Year

Annual Monetary benefit

recurring cost

annual savings

present value of annual savings

0

-90000

-90000

1

50000

40000

10000

9090.90909

2

55000

40000

15000

12396.6942

3

60000

40000

20000

15026.296

4

65000

40000

25000

17075.3364

5

70000

40000

30000

18627.6397

Net present value

sum of present value of cash flow

-17783.1246

Overall rate of return

(average annual savings/initial investment)*100

22.22%

Average annual savings

(10000+15000+20000+25000+30000)/5

20000

initial investment

90000

Year

annual savings

cumulative saving

0

-90000

1

10000

10000

2

15000

25000

3

20000

45000

4

25000

70000

5

30000

20000

amount to be recovered

Break even point of time

Year before the final recovery+(amount to be recovered in final year/annual savings of final year)

4+(20000/30000)

4.67


Related Solutions

Assume monetary benefits of an information system of $50,000 the first year and increasing benefits of...
Assume monetary benefits of an information system of $50,000 the first year and increasing benefits of $5,000 a year for the next four years (year 1 = 50,000; year 2- 55,000; year 3 = 60,000; year 4 = 65,000; year 5 – 70,000). One-time development costs were $90,000 and recurring costs beginning in year 1 were $40,000 over the duration of the system’s life. The discount rate for the company was 10 percent. Using a 5-year horizon, calculate the net...
Assume monetary benefits of an information system of $40,000 the first year and increasing benefits of...
Assume monetary benefits of an information system of $40,000 the first year and increasing benefits of $10,000 a year for the next five years (year 1 = $50,000, year 2 = $60,000, year 3 = $70,000, year 4 = $80,000, year 5 = $90,000). Onetime development costs were $80,000 and recurring costs were $45,000 over the duration of the system’s life. The discount rate for the company was 11 percent. Using a six-year time horizon, calculate the net present value...
Assuming monetary benefits of an information system at $150 at Year 1, $200 at Year 2,...
Assuming monetary benefits of an information system at $150 at Year 1, $200 at Year 2, and $250 at Year 3, one-time costs of $200, recurring costs of $50 per year, a discount rate of 7 percent, and a three-year time horizon, please fill in the cost-analysis benefit table below. Please round each value to 2 decimal places (which indicates that you should keep at least 3 decimal places for intermediate calculations). Each blank between (1) and (23) is worth...
**please i need full answer to understand this question** 5.43 Assume monetary benefits of an information...
**please i need full answer to understand this question** 5.43 Assume monetary benefits of an information system of $40,000 the first year and increasing benefits of $10,000 a year for the next five years (year 1=$50,000, year 2=$60,000, year 3=$70,000, year 4=$80,000, year 5=$90,000). One-time development costs were $80,000 and recurring costs were $45,000 over the duration of the system's life. The discount rate for the company was 11 percent. Using a six-year time horizon, calculate the net present value...
You are to receive an end-of-year bonus of $50,000 increasing by $1000 for each of the...
You are to receive an end-of-year bonus of $50,000 increasing by $1000 for each of the next ten years. If MARR is 12% and inflation rate is anticipated to be 2%, what will be purchasing power?
Use the following information regarding ABC Co. in 2020 (assume this is the first year of...
Use the following information regarding ABC Co. in 2020 (assume this is the first year of operations for ABC Co., and assume ABC pays cash unless noted otherwise). Assume ABC uses FIFO perpetual for inventory, straight-line depreciation, and estimates it will not collect 4% of accounts receivable. 1/1 Issues 10,000 shares of common stock for $5 each. 2/15 Purchase 2,000 units of inventory at $4/unit. 3/1 Sells 500 units of inventory for $16/unit, customer pays on account. 4/1 Signs a...
Assume a farmer takes out a five year loan for $50,000.
Assume a farmer takes out a five year loan for $50,000. The annual interest rate is 4% and the farmer will make equal annual principal payments for years one through five. Approximately how much interest will be paid over the life of the loan? Round all numbers to the nearest whole dollar.A. 6160B. 56000C. 56160D.6000
A labor contract provides a first year (nominal) wage of $50,000 per year, and specifies that...
A labor contract provides a first year (nominal) wage of $50,000 per year, and specifies that the real wage will increase by 4% each year. The CPI is 2.0 in the first year, 2.1 in the second year, and 2.15 in the third year. Please enter your answers as numeric responses rounded to the nearest dollar (ie. 32,900 or $32,900 not 32,900.00 or "Thirty-two thousand nine hundred dollars"). What is the real wage for the first year of this contract?...
For a new product, sales volume in the first year is estimated to be 50,000 units...
For a new product, sales volume in the first year is estimated to be 50,000 units and is projected to grow at a rate of 7% per year. The selling price is $100 and will increase by $10 each year. Per-unit variable costs are $22 and annual fixed costs are $1,000,000. Per-unit costs are expected to increase 4% per year. Fixed costs are expected to increase 10% per year. Develop a spreadsheet model to predict the net present value of...
A firm initiates a 4 year project with an investment of $50,000. Assume that this initial...
A firm initiates a 4 year project with an investment of $50,000. Assume that this initial investment is depreciated using the straight line method. There is no salvage value at the end of the project. Under this project a certain product is produced and sold. Key financial information is provided below: Price/unit 10 Direct Expenses/unit 2 SGA (excl. Depreciation) 7,500 Taxes 30% What is the NI break-even? What is the NPV break-even? Assume that r = 9%. Is the NI...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT