Details of this Paper

Please complete the following exercises and/or problems from the textbook: E26-19 E26-20 E26-21 E26-24 E26-25 CP26-38 Prepare your answers in an Excel workbook, using one worksheet per exercise or problem.

Description

solution

Question

Please complete the following exercises and/or problems from the textbook;E26-19;E26-20;E26-21;E26-24;E26-25;CP26-38;Prepare your answers in an Excel workbook, using one worksheet per exercise or problem.;E26-19 Using payback to make capital investment decisions;Robinson Hardware is adding a new product line that will require an investment;of \$1,454,000. Managers estimate that this investment will have a 10-year life and;generate net cash inflows of \$300,000 the first year, \$270,000 the second year;and \$260,000 each year thereafter for eight years. Compute the payback period.;Note: Exercise S26-19 must be completed before attempting Exercise S26-20.;E26-20 Using ARR to make capital investment decisions;Refer to the Robinson Hardware information in Exercise E26-19. Assume the;project has no residual value. Compute the ARR for the investment. Round to;two places.;E26-21 Using the time value of money;Janice wants to take the next five years off work to travel around the world. She;estimates her annual cash needs at \$28,000 (if she needs more, she will work odd;jobs). Janice believes she can invest her savings at 8% until she depletes her funds.;Requirements;1. How much money does Janice need now to fund her travels?;2. After speaking with a number of banks, Janice learns she will only be able to;invest her funds at 4%. How much does she need now to fund her travels?;E26-24 Using NPV and profitability index to make capital investment decisions;Use the NPV method to determine whether Kyler Products should invest in the;following projects;P26-38 Using payback, ARR, NPV, and IRR to make capital investment;decisions;This problem continues the Davis Consulting, Inc. situation from Problem P25-34;of Chapter 25. Davis Consulting is considering purchasing two different types of;servers. Server A will generate net cash inflows of \$25,000 per year and have a zero;residual value. Server A?s estimated useful life is three years and it costs \$40,000.;Server B will generate net cash inflows of \$25,000 in year 1, \$11,000 in year 2;and \$4,000 in year 3. Server B has a \$4,000 residual value and an estimated life of;three years. Server B also costs \$40,000. Davis?s required rate of return is 14%.;Requirements;1. Calculate payback, accounting rate of return, net present value, and internal;rate of return for both server investments. Use Microsoft Excel to calculate NPV;and IRR.;2. Assuming capital rationing applies, which server should Davis invest in?

Paper#77090 | Written in 18-Jul-2015

Price : \$37