Finance Homework--Dr. W

Complete the following problems from chapter 10 in the textbook:

· P10-4

· P10-10

· P10-11

· P10-15

· P10-21

· P10-24

Follow these instructions for completing and submitting your assignment:

1. Do all work in Excel. Do not submit Word files or *.pdf files.

2. Submit a single spreadsheet file for this assignment, do not submit multiple files.

3. Place each problem on a separate spreadsheet tab.

4. Label all inputs and outputs and highlight your final answer.

5. Follow the directions in the “Guidelines for Developing Spreadsheets” located in the Course Materials.

P10–4 Long-term investment decision, payback method Bill Williams has the opportunity

to invest in project A that costs $9,000 today and promises to pay annual end-ofyear

payments of $2,200, $2,500, $2,500, $2,000, and $1,800 over the next 5 years.

Or, Bill can invest $9,000 in project B that promises to pay annual end-of-year payments

of $1,500, $1,500, $1,500, $3,500, and $4,000 over the next 5 years.

a. How long will it take for Bill to recoup his initial investment in project A?

b. How long will it take for Bill to recoup his initial investment in project B?

c. Using the payback period, which project should Bill choose?

d. Do you see any problems with his choice

P10–10 NPV: Mutually exclusive projects Hook Industries is considering the replacement of

one of its old drill presses. Three alternative replacement presses are under consideration.

The relevant cash flows associated with each are shown in the following table.

The firm’s cost of capital is 15%.

Press A Press B Press C Initial investment (CF0) $85,000 $60,000 $130,000 Year (t) Cash inflows (CFt) 1 $18,000 $12,000 $50,000 2 18,000 14,000 30,000 3 18,000 16,000 20,000 4 18,000 18,000 20,000 5 18,000 20,000 20,000 6 18,000 25,000 30,000 7 18,000 — 40,000 8 18,000 — 50,000

a. Calculate the net present value (NPV) of each press.

b. Using NPV, evaluate the acceptability of each press.

c. Rank the presses from best to worst using NPV.

d. Calculate the profitability index (PI) for each press.

e. Rank the presses from best to worst using PI.

P10–11 Long-term investment decision, NPV method Jenny Jenks has researched the financial

pros and cons of entering into a 1-year MBA program at her state university. The

tuition and books for the master’s program will have an up-front cost of $50,000. If

she enrolls in an MBA program, Jenny will quit her current job, which pays $50,000

per year after taxes (for simplicity, treat any lost earnings as part of the up-front

cost). On average, a person with an MBA degree earns an extra $20,000 per year (after

taxes) over a business career of 40 years. Jenny believes that her opportunity cost

of capital is 6%. Given her estimates, find the net present value (NPV) of entering

this MBA program. Are the benefits of further education worth the associated costs?

P10–15 Internal rate of return Peace of Mind, Inc. (PMI), sells extended warranties for durable

consumer goods such as washing machines and refrigerators. When PMI sells an extended

warranty, it receives cash up front from the customer, but later PMI must cover any repair

costs that arise. An analyst working for PMI is considering a warranty for a new line

of big-screen TVs. A consumer who purchases the 2-year warranty will pay PMI $200.

On average, the repair costs that PMI must cover will average $106 for each of the warranty’s

2 years. If PMI has a cost of capital of 7%, should it offer this warranty for sale?

P10–21 All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering

two mutually exclusive projects, each with an initial investment of $150,000.

The company’s board of directors has set a maximum 4-year payback requirement

and has set its cost of capital at 9%. The cash inflows associated with the two projects

are shown in the following table.

Cash inflows (CFt) Year Project A Project B 1 $45,000 $75,000 2 45,000 60,000 3 45,000 30,000 4 45,000 30,000 5 45,000 30,000 6 45,000 30,000

a. Calculate the payback period for each project.

b. Calculate the NPV of each project at 0%.

c. Calculate the NPV of each project at 9%.

d. Derive the IRR of each project.

e. Rank the projects by each of the techniques used. Make and justify a recommendation.

f. Go back one more time and calculate the NPV of each project using a cost of

capital of 12%. Does the ranking of the two projects change compared to your

answer in part e? Why?

P10–24 All techniques: Decision among mutually exclusive investments Pound Industries is

attempting to select the best of three mutually exclusive projects. The initial investment

and after-tax cash inflows associated with these projects are shown in the

following table.

Cash flows Project A Project B Project C Initial investment (CF0) $60,000 $100,000 $110,000 Cash inflows (CFt), t 5 1 to 5 20,000 31,500 32,500

a. Calculate the payback period for each project.

b. Calculate the net present value (NPV) of each project, assuming that the firm has

a cost of capital equal to 13%.

c. Calculate the internal rate of return (IRR) for each project.

d. Draw the net present value profiles for both projects on the same set of axes, and

discuss any conflict in ranking that may exist between NPV and IRR.

e. Summarize the preferences dictated by each measure, and indicate which project

you would recommend. Explain why.