ScholarLens Back to search
2011•Advances In ManagementRequires access

A Couple of Capital Budgeting Techniques using Microsoft Excel

Mason John O.

Open publisher page 0 citations

Abstract

Microsoft Excel has two functions that can be extremely valuable in capital budgeting. One is the NPV function, the other is the IRR function. The NPV function, which Excel refers to as the Net Present Value function, computes the present value of a series of periodic cash flows that are not necessarily the same amount each period. The IRR function computes the internal rate of return of an investment project.

About this research paper

What this paper is about

Microsoft Excel has two functions that can be extremely valuable in capital budgeting. One is the NPV function, the other is the IRR function. The NPV function, which Excel refers to as the Net Present Value function, computes the present value of a series of periodic cash flows that are not necessarily the same amount each period. The IRR function computes the internal rate of return of an investment project.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Microsoft Excel has two functions that can be extremely valuable in capital budgeting. One is the NPV function, the other is the IRR function. The NPV function, which Excel refers to as the Net Present Value function, computes the present value of a series of periodic cash flows that are not necessarily the same amount each period. The IRR function computes the internal rate of return of an investment project.

Key concepts: Internal rate of return, Capital budgeting, Net present value, Microsoft excel, Modified internal rate of return, Present value, Function (biology), Cash flow

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
A Couple of Capital Budgeting Techniques using Microsoft Excel — Research Paper | ScholarLens