Skip to main content
Business LibreTexts

5: How Is Capital Budgeting Used to Make Decisions?

  • Page ID
    51394
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    Julie Jackson is the president and owner of Jackson’s Quality Copies, a store that makes photocopies for its customers and that has several copy machines. Julie has the following discussion with Mike Haley, the company’s accountant:

     

    Julie:
    Mike, I think it’s time to buy a new copy machine. Our volume of copies has increased dramatically over the last year, and we need a copier that does a better job of handling the big jobs.

    Mike:
    Do you have any idea how much the new machine will cost?

    Julie:
    We can purchase a new copier for $50,000, maintenance costs will total $1,000 a year, and the copier is expected to last 7 years. Since the new machine is quicker and will require less attention by our employees, we should save about $11,000 a year in labor costs.

    Mike:
    Will it have any salvage value at the end of seven years?

    Julie:
    Yes. The salvage value should be about $5,000.

    Mike:
    How soon do you want to do this?

    Julie:
    As soon as possible. From what I can tell, this is a winning proposition. The cash inflows of $82,000 that we will get from the labor cost savings and the salvage value exceed the cash outflows of $57,000 that we expect to spend on the machine and annual maintenance costs. What do you think?

    Mike:
    Let me take a look at the numbers before we jump into this. We have to consider more than just total cash inflows and outflows. I’ll get back to you by the end of the week.

    Julie:
    Okay, thanks for your help!

     

    Jackson’s Quality Copies is facing a decision common to many organizations: whether to invest in equipment that will last for many years or to continue with existing equipment. This type of decision differs from the decisions covered in the previous chapter because long-term investment decisions affect organizations for several years. We will return to Julie’s plan to purchase a new copier after we provide background information on long-term investment decisions.

    5.1 Capital Budgeting and Decision Making

    Learning Objective

    1. Apply the concept of the time value of money to capital budgeting decisions.

     

    Question: What is the difference between management decisions made in Chapter 4 “How Are Relevant Revenues and Costs Used to Make Decisions?” and management decisions made in this chapter?

    Answer: The types of decisions covered in this chapter and Chapter 4 “How Are Relevant Revenues and Costs Used to Make Decisions?” are similar in that they require an analysis of differential revenues and costs. However, Chapter 4 “How Are Relevant Revenues and Costs Used to Make Decisions?” involves short-run operating decisions (e.g., special orders from customers), while this chapter focuses on long-run capacity decisions (e.g., purchasing long-lived assets to increase capacity for many years).

    Organizations make a variety of long-run investment decisions. The San Francisco Symphony invests in stage risers for its orchestra members. McDonald’s invests in new restaurants. Honda Motor Co. invests in new manufacturing facilities. Bank of America invests in new branches. These examples have one common feature: all of these companies are investing in assets that will affect the organization for several years.

    Question: The process of analyzing and deciding which long-term investments to make is called a capital budgeting decision , also known as a capital expenditure decision. Capital budgeting decisions involve using company funds (capital) to invest in long-term assets. How does the evaluation of these types of capital budgeting decisions differ from short-term operating decisions discussed in Chapter 4 “How Are Relevant Revenues and Costs Used to Make Decisions?”?

    Answer: When looking at capital budgeting decisions that affect future years, we must consider the time value of money. The time value of money concept is the premise that a dollar received today is worth more than a dollar received in the future. To clarify this point, suppose a friend owes you $100. Would you prefer to receive $100 today or 3 years from today? The money is worth more to you if you receive it today because you can invest the $100 for 3 years.

    For capital budgeting decisions, the issue is how to value future cash flows in today’s dollars. The term cash flow refers to the amount of cash received or paid at a specific point in time. The term present value describes the value of future cash flows (both in and out) in today’s dollars.

    Question: We use two methods to evaluate long-term investments, both of which consider the time value of money. What are these two methods?

    Answer: The first is called the net present value (NPV) method, and the second is called the internal rate of return method. Before presenting these two methods, let’s discuss the time value of money (present value) concepts.

    The Present Value Formula

    Question: Suppose you invest $1,000 for 1 year at an interest rate of 5 percent per year, as shown in the following timeline. How much will you have at the end of 1 year (or what is the future value of the investment)?

    image

    Answer: You will have $1,050:

    $1,050 = $1,000 × (1 + .05)

    Question: Let’s change course and find the present value of the same future cash flow. If you receive $1,050 in 1 year, how much is that worth in today’s dollars assuming an annual interest rate of 5 percent?

    image

    Answer: The present value is $1,000, calculated as follows:

    $1,000=$1,050 / (1+.05)

    Question: Let’s go back to finding a future value. Assume you invest $1,000 today at an annual rate of 5 percent for 2 years. How much will you have at the end of 2 years?

    image

    Answer: At the end of 1 year, you will have $1,050 (= $1,000 × [1 + .05]). At the end of the second year, you will have $1,102.50, which is $1,050 × (1 + .05). The equation is

    $1,102.50 = $1,000 × (1 + .05) × (1 + .05)
    or
    $1,102.50 = $1,000 × (1 + .05)2

    Question: Again, let’s change course and find the present value of the same future cash flow. If you receive $1,102.50 in 2 years, how much is that worth in today’s dollars assuming an annual interest rate of 5 percent?

    image

    Answer: The present value is $1,000, calculated as follows:

    $1,000=$1,102.50 / (1+.05)2

    These examples show that one equation can be used to find the present value of a future cash flow. The equation is

    Key Equation

    P=Fn / (1+r)n

    where

    P = Present value of an amount
    Fn = Amount received n years in the future
    r = Annual interest rate
    n = Number of years

    Question: Let’s use this formula to solve for the following: Assume $500 will be received 4 years from today, and the annual interest rate is 10 percent. What is the present value of this cash flow?

    image

    Answer: The present value is $341.51, calculated as follows:

    P=Fn / (1+r)n=$500 / (1+.10)4=$500 / 1.4641=$341.51

    Present Value Tables

    Question: Although most managers use spreadsheets, such as Excel, to perform present value calculations (discussed later in this chapter), you can also use the present value tables in the appendix to this chapter, labeled Figure 5.9 “Present Value of $1 Received at the End of ” and Figure 5.10 “Present Value of a $1 Annuity Received at the End of Each Period for “, for these calculations. Figure 5.9 “Present Value of $1 ” simply provides the present value of $1 (i.e., F = $1) given the number of years (n) and the interest rate (r). How are these tables used to calculate present value amounts?

    Answer: Let’s look at an example to see how these tables work. Assume $1 will be received 4 years from today (n = 4), and the interest rate is 10 percent (r = 10 percent). What is the present value of this cash flow? Look at Figure 5.9 “Present Value of $1 Received at the End of ” in the appendix. Find the column labeled 10 percent and the row labeled 4. The present value is $0.6830, or $0.68 rounded. The table amount given is often called a factor. The factor in this example is 0.6830 (note that the formula to find this factor is shown at the top of Figure 5.9 “Present Value of $1 Received at the End of “).

    Now assume all the same facts, except that $500 rather than $1 will be received in 4 years. To find the present value, simply multiply the factor found in Figure 5.9 “Present Value of $1 Received at the End of ” by $500, as follows:

    Present value=Amount received in the future × Present value factor=$500×0.6830=$341.50

    Notice that this present value is the same as the one we calculated using the formula P = Fn ÷ (1 + r)n, with the exception of a small difference due to rounding the factor in Figure 5.9 “Present Value of $1 Received at the End of “. Next, we use present value concepts to evaluate projects with the NPV method.

    Key Takeaways
    • Present value calculations tell us the value of future cash flows in today’s dollars. The present value of a cash flow can be calculated by using the formula P = Fn ÷ (1 + r)n. It can also be calculated by using the tables in the appendix of this chapter. Simply find the factor in Figure 5.9 “Present Value of $1 Received at the End of ” given the number of years (n) and annual interest rate (r). Then multiply the factor by the future cash flow, as follows:

      Present value = Amount received in the future × Present value factor

     

    Check Yourself

    For each of the following independent scenarios, calculate the present value of the cash flow described. Round to the nearest dollar.

    1. You will receive $5,000, 5 years from today, and the interest rate is 8 percent.
    2. You will receive $80,000, 9 years from today, and the interest rate is 10 percent.
    3. You will receive $400,000, 20 years from today, and the interest rate is 20 percent.
    4. You will receive $250,000, 10 years from today, and the interest rate is 15 percent.

    Solution 

    Two approaches can be used to find the present value of a cash flow. The first requires using the formula P = Fn ÷ (1 + r)n. The second requires using Figure 5.9 “Present Value of $1 Received at the End of ” in the appendix to find the present value factor and inserting it in the following formula:

    Present value = Amount received in the future × Present value factor (from Figure 5.9 “Present Value of $1 Received at the End of “)

    We show both approaches in the following solutions.

    1. Using the formula P = Fn ÷ (1 + r)n, we get

      $3,403=$5,000÷(1+.08)5

      Using Figure 5.9 “Present Value of $1 Received at the End of “, we get

      Present value=Future value × Present value factor $3,403=$5,000×0.6806

    2. Using the formula P = Fn ÷ (1 + r)n, we get

      $33,928=$80,000÷(1+.10)9

      Using Figure 5.9 “Present Value of $1 Received at the End of “, we get

      Present value=Future value × Present value factor $33,928=$80,000×0.4241

    3. The small difference between the two approaches is due to rounding the factor in Figure 5.9 “Present Value of $1 Received at the End of “.

      Using the formula P = Fn ÷ (1 + r)n, we get

      10,434=$400,000÷(1+.20)20

      Using Figure 5.9 “Present Value of $1 Received at the End of “, we get

      Present value=Future value × Present value factor$10,440=$400,000×0.0261

    4. The small difference between the two approaches is due to rounding the factor Figure 5.9 “Present Value of $1 Received at the End of “.

      Using the formula P = Fn ÷ (1 + r)n, we get

      $61,796=$250,000÷(1+.15)10

      Using Figure 5.9 “Present Value of $1 Received at the End of “, we get

      Present value=Future value × Present value factor $61,800=$250,000×0.2472

     

    5.2 Net Present Value

    Learning Objective

    1. Evaluate investments using the net present value (NPV) approach.

     

    Question: Now that we have the tools to calculate the present value of future cash flows, we can use this information to make decisions about long-term investment opportunities. How does this information help companies to evaluate long-term investments?

    Answer: The net present value (NPV) is a method of evaluating investments adds the present value of all cash inflows and subtracts the present value of all cash outflows. The term discounted cash flows is also used to describe the NPV method. In the previous section, we described how to find the present value of a cash flow. The term net in net present value means to combine the present value of all cash flows related to an investment (both positive and negative).

    Recall the problem facing Jackson’s Quality Copies at the beginning of the chapter. The company’s president and owner, Julie Jackson, would like to purchase a new copy machine. Julie feels the investment is worthwhile because the cash inflows over the copier’s life total $82,000, and the cash outflows total $57,000, resulting in net cash inflows of $25,000 (= $82,000 – $57,000). However, this approach ignores the timing of the cash flows. We know from the previous section that the further into the future the cash flows occur, the lower the value in today’s dollars.

    Question: How do managers adjust for the timing differences related to future cash flows?

    Answer: Most managers use the NPV approach. This approach requires three steps to evaluate an investment:

    Step 1. Identify the amount and timing of the cash flows required over the life of the investment.

    Step 2. Establish an appropriate interest rate to be used for evaluating the investment, typically called the required rate of return. (This rate is also called the discount rate or hurdle rate.)

    Step 3. Calculate and evaluate the NPV of the investment.

    Let’s use Jackson’s Quality Copies as an example to see how this process works.

    Step 1. Identify the amount and timing of the cash flows required over the life of the investment.

    Question: What are the cash flows associated with the copy machine that Jackson’s Quality Copies would like to buy?

    Answer: Jackson’s Quality Copies will pay $50,000 for the new copier, which is expected to last 7 years. Annual maintenance costs will total $1,000 a year, labor cost savings will total $11,000 a year, and the company will sell the copier for $5,000 at the end of 7 years. Figure 5.1 “Cash Flows for Copy Machine Investment by Jackson’s Quality Copies” summarizes the cash flows related to this investment. Amounts in parentheses are cash outflows. All other amounts are cash inflows.

    Figure 5.1 Cash Flows for Copy Machine Investment by Jackson’s Quality Copies

    image

    Step 2. Establish an appropriate interest rate to be used for evaluating the investment.

    Question: How do managers establish the interest rate to be used for evaluating an investment?

    Answer: Although managers often estimate the interest rate, this estimate is typically based on the organization’s cost of capital. The cost of capital is the weighted average costs associated with debt and equity used to fund long-term investments. The cost of debt is simply the interest rate associated with the debt (e.g., interest for bank loans or bonds issued). The cost of equity is more difficult to determine and represents the return required by owners of the organization. The weighted average of these two sources of capital represents the cost of capital (finance textbooks address the complexities of this calculation in more detail).

    The general rule is the higher the risk of the investment, the higher the required rate of return (assume required rate of return is synonymous with interest rate for the purpose of calculating the NPV). A firm evaluating a long-term investment with risk similar to the firm’s average risk will typically use the cost of capital. However, if a long-term investment carries higher than average risk for the firm, the firm will use a required rate of return higher than the cost of capital.

    The accountant at Jackson’s Quality Copies, Mike Haley, has established the cost of capital for the firm at 10 percent. Since the proposed purchase of a copy machine is of average risk to the company, Mike will use 10 percent as the required rate of return.

    Step 3. Calculate and evaluate the NPV of the investment.

    Question: How do managers calculate the NPV of an investment?

    Answer: Figure 5.2 “NPV Calculation for Copy Machine Investment by Jackson’s Quality Copies” shows the NPV calculation for Jackson’s Quality Copies. Examine this table carefully. The cash flows come from Figure 5.1 “Cash Flows for Copy Machine Investment by Jackson’s Quality Copies”. The present value factors come from Figure 5.9 “Present Value of $1 Received at the End of ” in the appendix (r = 10 percent; n = year). The bottom row, labeled present value is calculated by multiplying the total cash in (out) × present value factor, and it represents total cash flows for each time period in today’s dollars. The bottom right of Figure 5.2 “NPV Calculation for Copy Machine Investment by Jackson’s Quality Copies” shows the NPV for the investment, which is the sum of the bottom row labeled present value.

    Figure 5.2 NPV Calculation for Copy Machine Investment by Jackson’s Quality Copies

    image

    The NPV is $1,250. Because NPV is > 0, accept the investment. (The investment provides a return greater than 10 percent.)

    The NPV Rule

    Question: Once the NPV is calculated, how do managers use this information to evaluate a long-term investment?

    Answer: Managers apply the following rule to decide whether to proceed with the investment:

    NPV Rule: If the NPV is greater than or equal to zero, accept the investment; otherwise, reject the investment.

    As summarized in Figure 5.3 “The NPV Rule”, if the NPV is greater than zero, the rate of return from the investment is higher than the required rate of return. If the NPV is zero, the rate of return from the investment equals the required rate of return. If the NPV is less than zero, the rate of return from the investment is less than the required rate of return. Since the NPV is greater than zero for Jackson’s Quality Copies, the investment is generating a return greater than the company’s required rate of return of 10 percent.

    Figure 5.3 The NPV Rule

    image

    Note that the present value calculations in Figure 5.3 “The NPV Rule” assume that the cash flows for years 1 through 7 occur at the end of each year. In reality, these cash flows occur throughout each year. The impact of this assumption on the NPV calculation is typically negligible.

    Business in Action 5.1

    Cost of Capital by Industry

    Cost of capital can be estimated for a single company or for entire industries. New York University’s Stern School of Business maintains cost of capital figures by industry. Almost 7,000 firms were included in accumulating this information. The following list shows industries with the highest cost of capital of the industries tracked by NYU. Notice that high-risk industries  have relatively high costs of capital.

     

    Annuity Tables

    Question: Notice in Figure 5.1 “Cash Flows for Copy Machine Investment by Jackson’s Quality Copies” that the rows labeled maintenance cost and labor savings have identical cash flows from one year to the next. Identical cash flows that occur in regular intervals, such as these at Jackson’s Quality Copies, are called an annuity . How can we use annuities in an alternate format to calculate the NPV?

    Answer: In Figure 5.4 “Alternative NPV Calculation for Jackson’s Quality Copies”, we demonstrate an alternative approach to calculating the NPV.

    Figure 5.4 Alternative NPV Calculation for Jackson’s Quality Copies

    image

    *Because this is not an annuity, use Figure 5.9 “Present Value of $1 Received at the End of ” in the appendix.

    **Because this is an annuity, use Figure 5.10 “Present Value of a $1 Annuity Received at the End of Each Period for ” in the appendix. The number of years (n) equals seven since identical cash flows occur each year for seven years.

    Note: the NPV of $1,250 is the same as the NPV in Figure 5.2 “NPV Calculation for Copy Machine Investment by Jackson’s Quality Copies”.

    The purchase price and salvage value rows in Figure 5.4 “Alternative NPV Calculation for Jackson’s Quality Copies” represent one-time cash flows, and thus we use Figure 5.9 “Present Value of $1 Received at the End of ” in the appendix to find the present value factor for these items (these are not annuities). The annual maintenance costs and annual labor savings rows represent cash flows that occur each year for seven years (these are annuities). We use Figure 5.10 “Present Value of a $1 Annuity Received at the End of Each Period for ” in the appendix to find the present value factor for these items (note that the number of years, n, equals seven since the cash flows occur each year for seven years). Simply multiply the cash flow shown in column (A) by the present value factor shown in column (B) to find the present value for each line item. Then sum the present value column to find the NPV. This alternative approach results in the same NPV shown in Figure 5.2 “NPV Calculation for Copy Machine Investment by Jackson’s Quality Copies”.

    Business in Action 5.2

    Winning the Lottery

    Like many other states, California pays out lottery winnings in installments over several years. For example, a $1,000,000 lottery winner in California will receive $50,000 each year for 20 years.

    Does this mean that the State of California must have $1,000,000 on the day the winner claims the prize? No. In fact, California has approximately $550,000 in cash to pay $1,000,000 over 20 years. This $550,000 in cash represents the present value of a $50,000 annuity lasting 20 years, and the state invests it so that it can provide $1,000,000 to the winner over 20 years.

    Key Takeaways

    • Present value calculations tell us the value of cash flows in today’s dollars. The NPV method adds the present value of all cash inflows and subtracts the present value of all cash outflows related to a long-term investment. If the NPV is greater than or equal to zero, accept the investment; otherwise, reject the investment.

     

    Check Yourself

    The management of Chip Manufacturing, Inc., would like to purchase a specialized production machine for $700,000. The machine is expected to have a life of 4 years, and a salvage value of $100,000. Annual maintenance costs will total $30,000. Annual labor and material savings are predicted to be $250,000. The company’s required rate of return is 15 percent.

    1. Ignoring the time value of money, calculate the net cash inflow or outflow resulting from this investment opportunity.
    2. Find the NPV of this investment using the format presented in Figure 5.2 “NPV Calculation for Copy Machine Investment by Jackson’s Quality Copies”.
    3. Find the NPV of this investment using the format presented in Figure 5.4 “Alternative NPV Calculation for Jackson’s Quality Copies”.
    4. Should Chip Manufacturing, Inc., purchase the specialized production machine? Explain.

    Solution

    1. The net cash inflow, ignoring the time value of money, is $280,000, calculated as follows:

      image
    2. The NPV is $(14,720), calculated as follows:

      image
    3. The alternative format used for calculating the NPV is shown as follows. Note that the NPV here is identical to the NPV calculated previously in part 2.

      image

      *Because this is not an annuity, use Figure 5.9 “Present Value of $1 Received at the End of ” in the appendix.

      **Because this is an annuity, use Figure 5.10 “Present Value of a $1 Annuity Received at the End of Each Period for ” in the appendix. The number of years (n) equals four since identical cash flows occur each year for four years.

    4. Because the NPV is less than 0, the return generated by this investment is less than the company’s required rate of return of 15 percent. Thus Chip Manufacturing, Inc., should not purchase the specialized production machine.

     

    5.3 The Internal Rate of Return

    Learning Objectives

    1. Evaluate investments using the internal rate of return (IRR) approach.

     

    Question: Using the internal rate of return (IRR) to evaluate investments is similar to using the net present value (NPV) in that both methods consider the time value of money. However, the IRR provides additional information that helps companies evaluate long-term investments. What is the IRR, and how does it help managers make decisions related to long-term investments?

    Answer: The internal rate of return (IRR) is the rate required (r) to get an NPV of zero for a series of cash flows. The IRR represents the time-adjusted rate of return for the investment being considered. The IRR decision rule states that if the IRR is greater than or equal to the company’s required rate of return (recall that this is often called the hurdle rate), the investment is accepted; otherwise, the investment is rejected.

    Most managers use a spreadsheet, such as Excel, to calculate the IRR for an investment (we discuss this later in the chapter). However, we can also use trial and error to approximate the IRR. The goal is simply to find the rate that generates an NPV of zero. Let’s go back to the Jackson’s Quality Copies example. Figure 5.4 “Alternative NPV Calculation for Jackson’s Quality Copies” provides the projected cash flows for a new copy machine and the NPV calculation using a rate of 10 percent. Recall that the NPV was $1,250, indicating the investment generates a return greater than the company’s required rate of return of 10 percent.

    Although it is useful to know that the investment’s return is greater than the company’s required rate of return, managers often want to know the exact return generated by the investment. (It is often not enough to state that the exact return is something higher than 10 percent!) Managers also like to rank investment opportunities by the return each investment is expected to generate. Our goal now is to determine the exact return—that is, to determine the IRR. We know from Figure 5.4 “Alternative NPV Calculation for Jackson’s Quality Copies” that the copy machine investment generates a return greater than 10 percent. Figure 5.5 “Finding the IRR for Jackson’s Quality Copies” summarizes this calculation with the 2 columns under the 10 percent heading.

    The far right side of Figure 5.5 “Finding the IRR for Jackson’s Quality Copies” shows that the NPV is $(2,100) if the rate is increased to 12 percent (recall our goal is to find the rate that yields an NPV of 0). Thus the IRR is between 10 and 12 percent. Next, we try 11 percent. As shown in the middle of Figure 5.5 “Finding the IRR for Jackson’s Quality Copies”, 11 percent provides an NPV of $(469). Thus the IRR is between 10 and 11 percent; it is closer to 11 percent because $(469) is closer to 0 than $1,250. (Note that as the rate increases, the NPV decreases, and as the rate decreases, the NPV increases.)

    Figure 5.5 Finding the IRR for Jackson’s Quality Copies

    image

    *Because this is not an annuity, use Figure 5.9 “Present Value of $1 Received at the End of ” in the appendix.

    **Because this is an annuity, use Figure 5.10 “Present Value of a $1 Annuity Received at the End of Each Period for ” in the appendix. The number of years (n) equals seven since identical cash flows occur each year for seven years.

    Note: the NPV of $(469) is closest to 0. Thus the IRR is close to 11 percent.

    This trial and error approach allows us to approximate the IRR. As stated earlier, if the IRR is greater than or equal to the company’s required rate of return, the investment is accepted; otherwise, the investment is rejected. For Jackson’s Quality Copies, the IRR of approximately 11 percent is greater than the company’s required rate of return of 10 percent. Thus the investment should be accepted.

    Computer Application

    Using Excel to Calculate NPV and IRR

    Let’s use the Jackson’s Quality Copies example presented at the beginning of the chapter to illustrate how Excel can be used to calculate the NPV and IRR. Two steps are required to calculate the NPV and IRR using Excel. All cell references are to the following spreadsheet shown.

    image

    Step 1. Enter the data in the spreadsheet.

    Rows 1 through 7 in the spreadsheet show the cash flows associated with the proposal to purchase a new copy machine at Jackson’s Quality Copies (first presented in Figure 5.1 “Cash Flows for Copy Machine Investment by Jackson’s Quality Copies”).

    Step 2. Input the functions to calculate NPV and IRR.

    We selected cell H16 to calculate the NPV, so this is where the NPV function is input. Cell E16 shows the function in detail with dialogue boxes provided for clarification. Notice that the resulting NPV of $1,250 shown in cell H16 is the same as the NPV calculated in Figure 5.2 “NPV Calculation for Copy Machine Investment by Jackson’s Quality Copies” and Figure 5.4 “Alternative NPV Calculation for Jackson’s Quality Copies”.

    We selected cell H28 to calculate the IRR, so this is where the IRR function is input. Cell E28 shows the function in detail. Notice that the resulting IRR of 10.72 percent shown in cell H28 is very close to our approximation of slightly less than 11 percent shown in Figure 5.5 “Finding the IRR for Jackson’s Quality Copies”.

    As an alternative to entering a function directly into the spreadsheet, the NPV function under the Formulas menu in Excel can be used. Simply select the cell in the spreadsheet where you would like the answer to appear (H16 in this case), and go to the Formulas menu. Click on the fx symbol or Insert Function on the formula bar. Search for the function by typing in NPV, select NPV where it appears in the box, then select OK. When asked for the Rate, enter the cell where the rate appears (B10). Then under Value 1 enter the cells containing the series of cash flows, starting with year 1 (shown as C7:I7, which means C7 through I7). Select OK. Now go back and add the cash flow at time 0 (B7) to the end of the NPV function. The resulting formula will look like the formula shown in E16, and the answer will appear in the cell where the function is entered (H16).

    The IRR function can be inserted into a cell using the same process presented previously. Select the cell in the spreadsheet where you would like the answer to appear (H28), and go to the Formulas menu. Click on the fx symbol or Insert Function on the formula bar. Search for the function by typing in IRR, select IRR where it appears in the box below, then select OK. When asked for Values, enter the cells containing the series of cash flows, starting with time 0 (shown as B7:I7, which means B7 through I7 the amount in the first referenced cell must be negative or excel will give you an error). When asked for a Guess, enter your best guess as to what the IRR might be (this provides the system with a starting point), then select OK. The resulting formula will look like the formula shown in E28, and the answer will appear in the cell where the function is entered (H28).

    Key Takeaways

    • The IRR is the rate required (r) to get an NPV of zero for a series of cash flows and represents the time-adjusted rate of return for an investment. If the IRR is greater than or equal to the company’s required rate of return (often called the hurdle rate), the investment is accepted; otherwise, the investment is rejected.  Excel can be used to easily calculate the NPV and IRR.

     

     

    5.4 Other Factors Affecting NPV and IRR Analysis

    Learning Objectives

    1. Understand the impact of cash flows, qualitative factors, and ethical issues on long-term investment decisions.

     

    Question: We have described the net present value (NPV) and internal rate of return (IRR) approaches to evaluating long-term investments. With both of these approaches, there are several important issues that must be considered. What are these important issues?

    Answer: These issues include focusing on cash flows, factoring in inflation, assessing qualitative factors, and ethical considerations. All are described next.

    Focusing on Cash Flows

    Question: Which basis of accounting is used to calculate the NPV and IRR for long-term investments, cash or accrual?

    Answer: Both methods of evaluating long-term investments, NPV and IRR, focus on the amount of cash flows and when the cash flows occur. Note that the timing of revenues and costs in financial accounting using the accrual basis is often not the same as when the cash inflows and outflows occur. A sale can be recorded in one period, and the cash be collected in a future period. Costs can occur in one period, and the cash be paid in a future period. For the purpose of making NPV and IRR calculations, managers typically use the time period when the cash flow occurs.

    When a company invests in a long-term asset, such as a production building, the cash outflow for the asset is included in the NPV and IRR analyses. The depreciation taken on the asset in future periods is not a cash flow and is not included in the NPV and IRR calculations. However, there is a cash benefit related to depreciation (often called a depreciation tax shield) since income taxes paid are reduced as a result of recording depreciation expense.

    Factoring in Inflation

    Question: Is inflation included in cash flow projections when calculating the NPV and IRR?

    Answer: Most managers make cash flow projections that include an adjustment for inflation. When this is done, a rate must be used that also factors in inflation over the life of the investment. As discussed earlier in the chapter, the required rate of return used for NPV calculations is based on the firm’s cost of capital, which is the weighted average cost of debt and equity. Since the cost of debt and equity already includes the effect of inflation, no inflation adjustment is necessary when establishing the required rate of return.

    The important point here is that cash flow projections must include adjustments for inflation to match the required rate of return, which already factors in inflation. If cash flows are not adjusted for inflation, managers are likely underestimating future cash flows and therefore underestimating the NPV of the investment opportunity. This is particularly pronounced for economies that have relatively high rates of inflation.

    For the purposes of this chapter, assume all cash flows and required rates of return are adjusted for inflation.

    Be Aware of Qualitative Factors

    Question: So far, this chapter has focused on using cash flow projections and the time value of money to evaluate long-term investments. Using these quantitative factors to make decisions allows managers to support decisions with measurable data. For example, the investment opportunity at Jackson’s Quality Copies presented at the beginning of the chapter was accepted because the NPV of $1,250 was greater than 0, and the IRR of 11 percent was greater than the company’s required rate of return of 10 percent. Why do most companies also consider nonfinancial factors, often called qualitative factors, when making a long-term investment decision?

    Answer: Although using quantitative factors for decision making is important, qualitative factors may outweigh the quantitative factors in making a decision. For example, a large manufacturer of medical devices recently invested several million dollars in a small start-up medical device firm. When asked about the NPV analysis, the manager responsible for the investment indicated, “My staff did a quick and dirty NPV analysis, which indicated we should not invest in the company. However, the technology they were using for their device was of such strategic importance to us, we could not pass up the investment.” This is an example of qualitative factors (strategic importance to the company) outweighing quantitative factors (negative NPV).

    Similar situations often arise when companies must invest in long-term assets even though NPV and IRR analyses indicate otherwise. Here are a few examples:

    • Investing in new production facilities may be essential to maintaining a reputation as the industry leader in innovation, even though the quantitative analysis (NPV and IRR) points to rejecting the investment. (It is difficult to quantify the benefits of being the “industry leader in innovation.”)
    • Investing in pollution control devices for an oil refinery may provide social benefits even though the quantitative analysis (NPV and IRR) points to rejecting the investment. (Although a reduction in fines and legal costs may be quantifiable and included in the analyses, it is difficult to quantify the social benefits.)
    • Investing in a new product line of entry-level automobiles may increase foot traffic at the showroom, resulting in increased sales of other products, even though the quantitative analysis (NPV and IRR) points to rejecting the investment. (It is difficult to quantify the impact of the new product line on sales of existing product lines.)

    Clearly, managers must look at the financial information and analysis when considering whether to invest in long-term assets. However, the analysis does not stop with financial information. Managers and decision makers must also consider qualitative factors.

    Business in Action 5.3 – Nike’s financial statements and management explanation

    Nike Cash Flow statement

    Ethical Issues

    Question: Our discussion of NPV and IRR methods implies that managers can easily make capital budgeting decisions once NPV and IRR analyses are completed and qualitative factors have been considered. However, managers sometimes make decisions that are not in the best interest of the company. Why might managers make decisions that are not in the best interest of the company?

    Answer: Several examples are provided next.

    Short-Term Incentives Affect Long-Term Decisions

    Managers are often evaluated and compensated based on annual financial results. The financial results are typically measured using financial accounting data prepared on an accrual basis.

    Suppose you are a manager considering an investment opportunity to start a new product line that has a positive NPV. Because the NPV is positive, you should accept the investment proposal. However, revenues and related cash inflows are not significant until after the second year. In the first two years, revenues are low and depreciation charges are high, resulting in significantly lower overall company net income than if the project were rejected. Assuming you are evaluated and compensated based on annual net income, you may be inclined to reject the new product line regardless of the NPV analysis.

    Many companies are aware of this conflict between the manager’s incentive to improve short-term results and the company’s goal to improve long-term results. To mitigate this conflict, some companies offer managers part ownership in the company (e.g., through stock options), creating an incentive to increase the value of the company over the long run.

    Modifying Cash Flow Estimates to Get Approval

    Managers often have a vested interest in getting proposals approved regardless of NPV and IRR results. For example, assume a manager spent several years developing a plan to construct a new production facility. Because of the significant work involved, and the projected benefits of building a new facility, the manager wants to see the proposal approved. However, the NPV analysis indicates the production facility proposal does not meet the company’s minimum required rate of return. As a result, the manager decides to inflate projected cash inflows to get a positive NPV, and the project is approved.

    Clearly, a conflict exists between the company’s desire to accept projects that meet or exceed the required rate of return and the manager’s desire to get approval for a “pet” project regardless of its profitability. Again, having part ownership in a company provides an incentive for managers to reject proposals that will not increase the value of the company.

    Another way to mitigate this conflict is to conduct a postaudit, which compares the original capital budget with the actual results. Managers who provide misleading capital budget analyses are identified through this process. Postaudits provide an incentive for managers to provide accurate estimates.

    Key Takeaways

    • Although accountants are responsible for providing relevant and objective financial information to help managers make decisions, several important factors play a significant role in the decision-making process as described here:

      • NPV and IRR analyses use cash flows to evaluate long-term investments rather than the accrual basis of accounting.
      • Cash flow projections must include adjustments for inflation to match the required rate of return, which already factor in inflation.
      • Using quantitative factors to make decisions allows managers to support decisions with measurable data. However, nonfinancial factors (often called qualitative factors) must be considered as well.
      • Circumstances sometimes exist that cause managers to make decisions that are not in the best interest of the company. For example, managers may be evaluated on short-term financial results even though it is in the best interest of the company to invest in projects that are profitable in the long term. Thus projects that reduce short-term profitability in lieu of significant long-term profits may be rejected.

     

     

    5.6 Additional Complexities of Estimating Cash Flows

    Learning Objective

    1. Evaluate investments with multiple investment and working capital cash flows.

     

    Question: The examples in this chapter are intended to help you learn the basics of evaluating investments using the net present value (NPV), and internal rate of return (IRR). However, there are two additional items related to estimating cash flows that must be considered: investment cash outflows and working capital. How do these two items impact long-term investment decisions?

    Answer: These items impact the analysis of long-term investments as described next.

    Investment Cash Outflows

    The examples thus far have assumed that cash outflows for the investment occur only at the beginning of the investment. However, some investments require cash outflows at varying points throughout the life of the project. For example, suppose the Walmart plans to open a new store, which requires a $10,000,000 investment at the beginning of the project for construction of the building. However, the building will be expanded at the end of year 4, at a cost of $2,000,000, to meet an expected increase in demand. The $2,000,000 cash outflow must be included in the cash flows of the project for year 4 when calculating the NPV and IRR.

    Working Capital

    Working capital is defined as current assets (cash, accounts receivable, inventory, and the like) minus current liabilities (accounts payable, wages payable, and accrued liabilities, for instance). Many long-term investments require working capital. For example, Walmart will need cash in its registers when it opens the new store. Working capital is also required to fund inventory. Working capital necessary for long-term investments should be included as a cash outflow, typically at the beginning of the project.

    Some long-term investments have an expected life, at the end of which working capital is returned to the company for investment elsewhere. When this happens, the working capital is included in the cash flow analysis as a cash outflow at the beginning of the project and a cash inflow at the end of the project.

    Key Takeaways
    • Investment proposals often include investment cash outflows at varying points throughout the life of the project. These cash flows must be included when evaluating investment proposals using NPV, and IRR. Many investments include working capital cash flows required to fund items such as inventory and accounts receivable. Working capital is included as a cash outflow, typically at the beginning of the project, and is often returned back to the company as a cash inflow later in the project.

     

    Check yourself

    The management of Environmental Engineering, Inc. (EEI), would like to open an office for 6 years in a high-growth area of Las Vegas. The initial investment required to purchase an office building is $250,000, and EEI needs $50,000 in working capital for the new office. Working capital will be returned to EEI at the end of 6 years. EEI expects to remodel the office at the end of 3 years at a cost of $200,000. Annual net cash receipts from daily operations (cash receipts minus cash payments) are expected to be as follows:

    Year 1 $  60,000
    Year 2 $  80,000
    Year 3 $120,000
    Year 4 $150,000
    Year 5 $160,000
    Year 6 $110,000

    Although the company’s cost of capital is 8 percent, management set a required rate of return of 12 percent due to the high risk associated with this project.

    1. Find the NPV of this investment using the format presented in Figure 5.2 “NPV Calculation for Copy Machine Investment by Jackson’s Quality Copies”.
    2. Based on your answer to 1, should EEI open the new office? Explain.

    Solution

    1. The NPV is $27,571, as shown in the following figure.

      image

      2.  The NPV is $27,571. Because NPV is > 0, accept the investment. (The investment provides a return greater than 12 percent.)

     

     

    5.8 Appendix: Present Value Tables

    Figure 5.9 Present Value of $1 Received at the End of n Periods

    image

    Note: Factor=1(1+r)n

    Figure 5.10 Present Value of a $1 Annuity Received at the End of Each Period for n Periods 

    image

    Note: Factor=1−(1+r)−nr

    End-of-Chapter Exercises

    Questions
    1. What is the difference between capital budgeting decisions covered in this chapter and management decisions covered in Chapter 4 “How Are Relevant Revenues and Costs Used to Make Decisions?”?
    2. What concept must be considered when looking at cash flows over several years for a long-term investment? Explain.
    3. What is meant by the term present value?
    4. What is the formula used to calculate the present value of a future cash flow? Describe each component.
    5. Describe the three steps required to evaluate investments using the net present value method.
    6. How do most firms establish the required rate of return used to calculate the net present value?
    7. What is meant by the term internal rate of return? Explain the IRR decision rule?
    8. For the purpose of calculating net present value and internal rate of return, do companies use the accrual basis of accounting? Explain.
    9. Why might a firm choose to accept a long-term investment even if the net present value is below zero?
    10. What might cause a manager to reject a long-term investment even though the net present value is positive?
    11. Describe the two steps required to calculate net present value and internal rate of return when using Excel.
    12. What does the term working capital refer to, and how does working capital affect the evaluation of long-term investments?

    Brief Exercises

    13.   Investment Decision at Jackson’s Quality Copies. Refer to the dialogue at Jackson’s Quality Copies presented at the beginning of the chapter. What is Julie Jackson proposing? What information did Mike, the accountant, get from Julie to evaluate the proposal?

    14.   Present Value Calculations. For each of the following independent scenarios, use Figure 5.9 “Present Value of $1 Received at the End of ” in the appendix to calculate the present value of the cash flow described.

      1. $10,000 will be received 4 years from today. The rate is 10 percent.
      2. $10,000 will be received 4 years from today. The rate is 20 percent.
      3. $50,000 will be received 15 years from today. The rate is 12 percent.
      4. $50,000 will be received 15 years from today. The rate is 6 percent.

    15.   Present Value Calculations (Annuities). For each of the following independent scenarios, use Figure 5.10 “Present Value of a $1 Annuity Received at the End of Each Period for ” in the appendix to calculate the present value of the cash flow described. Round to the nearest dollar.

        1. $1,000 will be received at the end of each year for 6 years. The rate is 12 percent.
        2. $1,000 will be received at the end of each year for 6 years. The rate is 15 percent.
        3. $10,000 will be received at the end of each year for 6 years. The rate is 7 percent.
        4. $250,000 will be received at the end of each year for 4 years. The rate is 10 percent.

    16.   Net Present Value Calculations. Freefall, Inc., has two independent investment opportunities, each requiring an initial investment of $65,000. The company’s required rate of return is 8 percent. The cash inflows for each investment are provided as follows.

    image

    Required:

          1. Without resorting to calculations, which investment will have the highest net present value? Explain.

    Calculate the net present value for each investment (remember to include the initial investment cash outflow in your calculation). Should the company invest in either investment? Round to the nearest dollar.

    17. Internal Rate of Return Calculation. An investment costing $50,000 today will result in cash savings of $5,000 per year for 15 years. Use trial and error to approximate the internal rate of return for this investment proposal.

    18. Evaluating Qualitative Factors. Chem, Inc., produces chemical products. The company recently decided to invest in expensive pollution control devices even though the negative net present value pointed toward rejecting this investment. What qualitative factor likely led the company to make the investment in spite of the negative net present value?

    19.  Ethical Issues in Making a Capital Budgeting Decision. Assume the manager of a store earns an annual bonus based on meeting a certain level of net income, which has been achieved consistently over the past five years. The company is currently considering the addition of a second store, which is expected to become profitable after two years. The manager is responsible for making the final decision whether the second store should be opened and would receive an annual bonus only if a certain level of net income were achieved for both stores combined.

    Why might the manager refuse to invest in the new store even though the investment is projected to achieve a return greater than the company’s required rate of return?

    20.  Net Present Value Calculation Using Excel. An investment costing $200,000 today will result in cash savings of $85,000 per year for 3 years. The company’s required rate of return is 11 percent. Use Excel to calculate the net present value of this investment in a format similar to the one in the Computer Application box in the chapter.

    21.   Net Present Value Analysis with Multiple Investments. A project requiring an investment of $20,000 today and $10,000 one year from today, will result in cash savings of $4,000 per year for 15 years. Find the net present value of this investment using a rate of 10 percent. Round to the nearest dollar.

     

    Exercises:

    22.  Net Present Value Analysis. Architect Services, Inc., would like to purchase a blueprint machine for $50,000. The machine is expected to have a life of 4 years, and a salvage value of $10,000. Annual maintenance costs will total $14,000. Annual savings are predicted to be $30,000. The company’s required rate of return is 11 percent.

    Required:

      1. Ignoring the time value of money, calculate the net cash inflow or outflow resulting from this investment opportunity.
      2. Find the net present value of this investment using the format presented in Figure 5.2 “NPV Calculation for Copy Machine Investment by Jackson’s Quality Copies”.  Should the company purchase the blueprint machine? Explain.

    23. Internal Rate of Return Analysis. Architect Services, Inc., would like to purchase a blueprint machine for $50,000. The machine is expected to have a life of 4 years, and a salvage value of $10,000. Annual maintenance costs will total $14,000. Annual savings are predicted to be $30,000. The company’s required rate of return is 11 percent (this is the same data as the previous exercise).

    Required:

        1. Use trial and error to approximate the internal rate of return for this investment proposal. Round to the nearest dollar.
        2. Should the company purchase the blueprint machine? Explain.

    24.  Net Present Value Analysis with Multiple Investments, Alternative Format. Conway Construction Corporation would like to purchase a fleet of trucks at a cost of $260,000. Additional equipment needed to maintain the fleet of trucks will be purchased at the end of year 2 for $40,000. The trucks are expected to have a life of 8 years, and a salvage value of $20,000. Annual costs for maintenance, insurance, and other cash expenses will total $42,000. Annual net cash receipts resulting from this purchase are predicted to be $135,000. The company’s required rate of return is 14 percent.

    Required:

          1. Find the net present value of this investment using the format presented in Figure 5.4 “Alternative NPV Calculation for Jackson’s Quality Copies”.
          2. Should the company purchase the new fleet of trucks? Explain.

    25.  Calculating NPV and IRR Using Excel. Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is expected to have a life of 5 years, and a salvage value of $5,000. Annual maintenance costs will total $20,000. Annual net cash receipts resulting from this machine are predicted to be $45,000. The company’s required rate of return is 15 percent.

    Required:

            1. Use Excel to calculate the net present value and internal rate of return in a format similar to the Computer Application spreadsheet shown in the chapter.
            2. Should the company purchase the wood lathe? Explain.
    1.  
    Problems

    26.  Evaluating Alternative Investments. Washington Brewery has two independent investment opportunities to purchase brewing equipment so the company can meet growing customer demand. The first option (equipment A) requires an initial investment of $230,000 for equipment with an expected life of 5 years and a salvage value of $20,000. The second option (equipment B) requires an initial investment of $120,000 for equipment with an expected life of 4 years and a salvage value of $15,000. The company’s required rate of return is 10 percent. Additional cash flow information for each investment is provided as follows.

      Year 1 Year 2 Year 3 Year 4 Year 5
    Equipment A
    Utility savings $ 12,000 $ 14,000 $ 15,000 $ 16,000 $ 17,000
    Additional revenue 45,000 48,000 50,000 55,000 60,000
    Maintenance costs (5,000) (8,000) (10,000) (13,000) (16,000)
    Equipment B
    Utility savings $  8,000 $  9,000 $ 10,000 $ 10,000
    Additional revenue 35,000 36,000 38,000 42,000
    Maintenance costs (6,000) (8,000) (9,000) (11,000)

    Required:

      1. Calculate the net present value for each investment using the format presented in Figure 5.2 “NPV Calculation for Copy Machine Investment by Jackson’s Quality Copies”. (Remember to include the initial investment cash outflow and salvage value in your calculation.) Round to the nearest dollar
      2. Which, if any, investment is preferable? Explain.

    27.  Calculating NPV and IRR Using Excel. Sherwin Moore Paint Company would like to further automate its production process by purchasing production equipment for $660,000. The equipment is expected to have a useful life of 8 years, and will be sold at the end of 8 years for $40,000. The equipment requires significant maintenance work at an annual cost of $75,000. Labor and material cost savings, shown in the table, are also expected to be significant.

    Year 1 $160,000
    Year 2 $190,000
    Year 3 $200,000
    Year 4 $240,000
    Year 5 $280,000
    Year 6 $220,000
    Year 7 $180,000
    Year 8 $155,000

    The company’s required rate of return is 11 percent.

    Required:

        1. Use Excel to calculate the net present value and internal rate of return in a format similar to the Computer Application spreadsheet shown in the chapter.
        2. Should the company purchase the production equipment? Explain.

    28.  Calculating NPV and IRR Using Excel. Oil Production, Inc., would like to drill oil from land the company already owns. The equipment is expected to cost $4,000,000, has a useful life of 5 years, and will be sold at the end of 5 years for $400,000. Annual costs for maintenance and other cash expenses will total $550,000. Annual net cash receipts resulting from the sale of oil are predicted to be $1,900,000. Working capital of $270,000 is required at the beginning of the project and will be returned at the end of 5 years. The equipment will require refurbishing at the end of year 3 at a cost of $300,000. Although the company’s cost of capital is 15 percent, management established a required rate of return of 20 percent due to the high risk associated with this project.

    Required:

          1. Use Excel to calculate the net present value and internal rate of return in a format similar to the Computer Application spreadsheet shown in the chapter.
          2. Should the company accept the proposal? Explain.

    29.  Net Present Value and Internal Rate of Return; Ethical Issues. Tower CD Stores would like to open a retail store in Houston. The initial investment to purchase the building is $420,000, and an additional $50,000 in working capital is required. Since this store will be operating for many years, the working capital will not be returned in the near future. Tower expects to remodel the store at the end of 3 years at a cost of $100,000. Annual net cash receipts from daily operations (cash receipts minus cash payments) are expected to be as follows.

    Year 1 $ 80,000
    Year 2 $115,000
    Year 3 $118,000
    Year 4 $140,000
    Year 5 $155,000
    Year 6 $167,000
    Year 7 $175,000

    The company’s required rate of return is 13 percent. Assume management decided to limit the analysis to 7 years.

    Required:

            1. Find the net present value of this investment using the format presented in Figure 5.2 “NPV Calculation for Copy Machine Investment by Jackson’s Quality Copies”. Round to the nearest dollar.
            2. Use Excel to calculate the internal rate of return for this investment proposal.
            3. Based on your answer to requirements 1 and 2, should Tower open the new store? Explain.
            4. Assume the manager of the company wanted to live in Houston and intentionally inflated the projected annual cash receipts so that the proposal would be accepted. The proposal would otherwise have been rejected. Explain how the company’s use of a postaudit would help to prevent this type of unethical behavior.
    1.  

    One Step Further: Skill-Building Cases

    30.  Internet Project: Capital Expenditures at Intel. Go to Intel’s Web site (http://www.intel.com) and review the Consolidated Statements of Cash Flows portion of the company’s financial statements. Find the Additions to property, plant and equipment line item in the Investing Activities section of the statement, and answer the following questions. Be sure to submit a printed copy of the consolidated statements of cash flows with your answers.

      1. How much cash did Intel spend on additions to property, plant, and equipment in the most current year? How does this amount compare with amounts spent in the previous two years?
      2. Describe two capital budgeting decision techniques that were likely used by Intelto make long-term investment decisions.

    31.Group Activity: Qualitative Factors. Each of the following scenarios is being considered at three separate companies.

        1. A large regional energy company uses coal to produce electricity that is sold to local power companies. Although government regulations will not require a cleaner process for at least five years, the company is considering spending millions of dollars on equipment that will reduce pollutants from its production process. However, the net present value analysis indicates this proposal should be rejected.
        2. A producer of mountain bikes known for its expensive, high-quality bikes would like to introduce a less expensive entry-level line of mountain bikes. However, the projected internal rate of return for this proposal is lower than the company’s minimum required rate of return.
        3. A maker of computer chips with a reputation of staying on the cutting edge of technology would like to invest in a new production facility. However, the net present value analysis indicates this proposal should be rejected.

          Required:

          Your instructor will divide the class into groups of two to four students, and assign one of the three independent scenarios listed previously to each group. Each group must perform the requirements listed here:

          1. Identify at least two qualitative factors that may lead to accepting the proposal.
          2. Discuss each option, based on the findings of your group, with the class.

    Comprehensive Cases

    32. Ethical Issues in Capital Budgeting. Loomis Nursery grows a variety of plants for wholesale distribution. The company would like to expand its operations and is considering a move to one of two locations. The first location, Wyatville, is one hour from the ocean and therefore attractive for employees who like to travel on weekends. The second location, Kenton, is not as close to the ocean, and much further from desirable vacation destinations.

    The company’s controller, Lisa Lennox, created a net present value analysis for each location. The Kenton location had a positive net present value, and the Wyatville location had a negative net present value. Upon providing this information to the chief financial officer of the company, Max Madden, Lisa was asked to “review the numbers carefully and make sure all the benefits of moving to Wyatville were included in the analysis.” Lisa knew that Max preferred vacationing near the ocean and had a strong desire to move operations to Wyatville. However, she was unable to find any errors in her analysis and could not identify any additional benefits.

    Lisa approached Max with this information. Max responded, “There is no way Kenton should have a higher net present value than Wyatville. Redo your analysis to show that Wyatville has the highest net present value, and have it on my desk by the end of the week.”

    Required:

    1. Is Max Madden’s request ethical? Explain.
    2. How should Lisa handle this situation? (It may be helpful to review the presentation of ethics in Chapter 1 “What Is Managerial Accounting?”.)

    33. Ethical Issues in Capital Budgeting. Toyonda Motor Company produces a variety of products including motorcycles, all-terrain vehicles, marine engines, automobiles, light trucks, and heavy-duty trucks. Each division manager at Toyonda Motor Company is paid a base salary and is given an annual cash bonus if the division achieves profits of at least 10 percent of the value of assets invested in the division (this is called return on investment).

    Peggy Parkins, manager of the Light Truck Division, is considering investing in new production equipment. The net present value of the proposal is positive, and Peggy is convinced the new equipment will provide a competitive edge in future years. However, because of the significant up-front cost and related depreciation, short-term profits will be negatively affected by this investment. In fact, the new equipment will reduce return on investment below the 10 percent threshold for at least 3 years, which will prevent Peggy from receiving her annual bonuses for at least 3 years. However, profits are expected to increase significantly after the three-year period. Peggy is planning to retire in two years and therefore would prefer to reject the proposal to invest in new production equipment.

    Required:

    1. Describe the ethical conflict facing Peggy Parkins.
    2. What type of employee compensation system might prevent this type of conflict?
     

    5: How Is Capital Budgeting Used to Make Decisions? is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?