Preview

Excel Computation for Capital Budgeting

Powerful Essays
Open Document
Open Document
1843 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Excel Computation for Capital Budgeting
INTRODUCTION TO
CAPITAL BUDGETING
Overview 159
7.1 The NPV Rule for Judging Investments and Projects 159
7.2 The IRR Rule for Judging Investments 161
7.3 NPV or IRR, Which to Use? 162
7.4 The “Yes–No” Criterion: When Do IRR and NPV Give the Same Answer? 163
7.5 Do NPV and IRR Produce the Same Project
Rankings? 164
7.6 Capital Budgeting Principle: Ignore Sunk Costs and
Consider Only Marginal Cash Flows 168
7.7 Capital Budgeting Principle: Don’t Forget the Effects of Taxes—Sally and Dave’s Condo Investment 169
7.8 Capital Budgeting and Salvage Values 176
7.9 Capital Budgeting Principle: Don’t Forget the Cost of Foregone Opportunities 180
7.10 In-House Copying or Outsourcing? A Mini-case
Illustrating Foregone Opportunity Costs 181
7.11 Accelerated Depreciation 184
Conclusion 185
Exercises 186
0195301501_158-192_ch7.qxd 11/3/05 12:47 PM Page 158
CHAPTER 7 Introduction to Capital Budgeting 159
OVERVIEW
Capital budgeting is finance terminology for the process of deciding whether or not to undertake an investment project. There are two standard concepts used in capital budgeting: net present value (NPV) and internal rate of return (IRR). Both of these concepts were introduced in Chapter
5; in this chapter we discuss their application to capital budgeting. Here are some of the topics covered: • Should you undertake a specific project? We call this the “yes–no” decision, and we show how both NPV and IRR answer this question.
• Ranking projects: If you have several alternative investments, only one of which you can choose, which should you undertake?
• Should you use IRR or NPV? Sometimes the IRR and NPV decision criteria give different answers to the yes–no and the ranking decisions. We discuss why this happens and which criterion should be used for capital budgeting (if there’s disagreement).
• Sunk costs. How should you account for costs incurred in the past?
• The cost of foregone opportunities.
• Salvage values and terminal

You May Also Find These Documents Helpful

  • Satisfactory Essays

    BGA1 Task 4

    • 343 Words
    • 2 Pages

    Net present value (NPV) method is used to decide whether or not a company should take on a new project or acquisition. The formula for NPV is the difference between the present value of a project’s cash inflows and its cash outflows. To calculate the present values the future cash flows are discounted using the time value of money method. For the project to be accepted the NPV should be positive, because it means the return is greater than the required rate of return; or zero, because that means the return is equal to the required rate of return. However, if negative the project should be rejected, because its return is less than the required rate of return. This required rate of return is also referred to as the cost of capital.…

    • 343 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    BGA1 Task4

    • 349 Words
    • 2 Pages

    2. Under Internal Rate of Return the investment is evaluated based on the expected rate of return. The IRR for a cash flow is an interest rate that results in a NPV equal to zero.…

    • 349 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Bsat 303 Final Study Guide 1

    • 4353 Words
    • 23 Pages

    o Nonstructured decision – one for which there may be several “right” answers, without a sure…

    • 4353 Words
    • 23 Pages
    Powerful Essays
  • Powerful Essays

    Information Technology (IT) projects are an important part of a company's growth and advancement. Playing a key role in the development of most businesses, IT projects impact all departments and many work processes that take place throughout an organization. Certain factors must be taken into consideration when moving forward with an IT project, such as budget and importance. Effectively prioritizing IT projects helps to ensure that important projects are completed first. Using Project Portfolio Management (PPM) helps companies to identify projects that offer the most potential return on investment (ROI) and the highest likelihood of success.…

    • 1027 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Paccar Build vs Buy

    • 655 Words
    • 3 Pages

    NPV (Net Present Value) measures the expected change in wealth from undertaking the project. The NPV of purchasing is $60.34 million and $93.23 million for developing the technologies. NPV is the most effective measurement since both IRR and MIRR have the project scale issues. In this case, developing the technologies gives a greater NPV and is the best choice.…

    • 655 Words
    • 3 Pages
    Good Essays
  • Better Essays

    To give team members control over the ranking of projects, each member was asked to write three different criteria on three Post-it Notes. These Post-it Notes were divided into similar item groups and each group was named. This process established the important criteria for selection. The criteria were used to determine how well each project would fit into the strategy of the company (Kloppenborg, 2009, p. 35).…

    • 1019 Words
    • 5 Pages
    Better Essays
  • Powerful Essays

    Sm Ch 26

    • 10104 Words
    • 98 Pages

    Copyright © 2015 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of…

    • 10104 Words
    • 98 Pages
    Powerful Essays
  • Satisfactory Essays

    Health Care Practitioner

    • 701 Words
    • 3 Pages

    4. The following are the criteria used to evaluate the alternatives in the following order.…

    • 701 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Self-Assessment

    • 519 Words
    • 3 Pages

    Based on self-assessment of decision-making style, the result of scoring and interpretation elaborate the highest is in analytical and the lowest rated in directive style.…

    • 519 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    Case Study: Ocean Carriers

    • 1553 Words
    • 7 Pages

    1. Assessment of the amount of expected returns over the life of the present contract.…

    • 1553 Words
    • 7 Pages
    Better Essays
  • Good Essays

    Internal Rate of Return

    • 653 Words
    • 3 Pages

    NPV and IRR take full account of cash flows and the time value of money. When we use NPV to decide whether the project will be accepted or not, the condition is that NPV should above 0. Otherwise the investment should be rejected. In the same situation, it is better to use the project which NPV is higher than others. However if we use IRR approach, the rate should be higher than what the company requires. Eddie McLaney (2006) mentioned that IRR cannot deal with different required rates of return which Pike, R & Neale, B (2006) have pointed out in four areas:…

    • 653 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    use to evaluate the merits of an investment. Some of these techniques are quite intuitive…

    • 16121 Words
    • 105 Pages
    Powerful Essays
  • Powerful Essays

    Stone Theroy

    • 1409 Words
    • 6 Pages

    Introduction to Finance includes the basic concepts of models of finance; the major thematic areas that will be included are time value of money, valuation of securities, risk and return, analysis of financial statements, cash flow statements and working capital.…

    • 1409 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    PETER DRUCKER

    • 618 Words
    • 3 Pages

    3. The decision: what is right – We have to confirm that the decision made is correct before placing in practice. We need to understand that…

    • 618 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Capital Budgeting- Air India

    • 8924 Words
    • 36 Pages

    I HEREBY DECLARE THAT I HAVE COMPLETED THIS PROJECT ON “CAPITAL BUDGETING” IN THE ACADEMIC YEAR 2010-2011. THIS INFORMATION IS TRUE AND ORIGINAL TO THE BEST OF MY KNOWELEDGE.…

    • 8924 Words
    • 36 Pages
    Powerful Essays