Finance (excel assignment2)

Complete the following problems in Microsoft Excel. Your work must be completed in the attached template. Chapter 4:

4-10 see picture below

4-12 

See picture above.

Chapter 5:

5-9

Respond to the following comments:

a. “I like the IRR rule. I can use it to rank projects without having to specify a discount rate.”

b. “I like the payback rule. As long as the minimum payback period is short, the rule makes sure that the company takes no borderline projects. That reduces risk.”

5-16

Some people believe firmly, even passionately, that ranking projects on IRR is OK if each project’s cash flows can be reinvested at the project’s IRR. They also say that the NPV rule “assumes that cash flows are reinvested at the opportunity cost of capital.” Think carefully about these statements. Are they true? Are they helpful?

Chapter 6:

6-2

See attachment below

6-13

Each of the following statements is true. Explain why they are consistent.

a. When a company introduces a new product, or expands production of an existing product, investment in net working capital is usually an important cash outflow.

b. Forecasting changes in net working capital is not necessary if the timing of all cash inflows and outflows in carefully specified.

Computations must be solved using Excel. Show all your work to earn partial credit. Essay questions require references.