Managing Project With Microsoft Excel

Techniques of Capital Budgeting
Free tutorial
Rating: 3.7 out of 5 (165 ratings)
4,492 students
41min of on-demand video
English [Auto]

Project Management. Selection of Project. Microsoft Excel
Calculation of NPV. IRR, ROI


  • Basic knowledge about Excel and Project Management


Capital Budgeting come under branch of Financial Management - Investment Decisions.

Capital budgeting is the process a business undertakes to evaluate potential major projects or investments.

Construction of a new plant or a big investment in an outside venture are examples of projects that would require capital budgeting before they are approved or rejected.

Organisation want to undertake project then  two important factors to be considered

Technical Feasibility if Project is not Technical feasible then no point in moving forward

Different capital budgeting methods include the Payback Period,

the accounting rate of return, the net present value, the discounted cash flow, the profitability Index, and the Internal Rate of Return method.

To Check Financial Feasibility we use Different methods /Techniques of capital budgeting

Capital Budgeting is planning process to check  weather project is worth to take or not

1 NPV 

2 IRR 

3 PI


These methods use the incremental cash flows from each potential investment, or project. Techniques based on accounting earnings and accounting rules are sometimes used - though economists consider this to be improper - such as the accounting rate of return, and "return on investment." Simplified and hybrid methods are used as well

An example of a project with cash flows which do not conform to this pattern is a loan, consisting of a positive cash flow at the beginning, followed by negative cash flows later. The greater the IRR of the loan, the higher the rate the borrower must pay, so clearly, a lower IRR is preferable in this case. Any such loan with IRR less than the cost of capital has a positive NPV.

Excluding such cases, for investment projects, where the pattern of cash flows is such that the higher the IRR, the higher the NPV, for mutually exclusive projects, the decision rule of taking the project with the highest IRR will maximize the return, but it may select a project with a lower NPV.

In some cases, several solutions to the equation NPV = 0 may exist, meaning there is more than one possible IRR. The IRR exists and is unique if one or more years of net investment (negative cash flow) are followed by years of net revenues. But if the signs of the cash flows change more than once, there may be several IRRs. The IRR equation generally cannot be solved analytically but only via iterations.

Who this course is for:

  • Students, Professionals, Business Analysts
  • Accounts, Business Development, Project Management,Finance


PMP Certified with 31 yrs of experience in Service Industry
  • 3.7 Instructor Rating
  • 925 Reviews
  • 19,475 Students
  • 5 Courses

Self Motivated  Senior Management  Professional with Total Experience in different industry in which 15 years’ plus experience in project planning, implementation and execution. Proven ability to manage multiple projects.

A results-driven professional with strong business-centric skills and an agile approach to project management

Director (3 Yrs)

Business Analysts (2.5 Yrs )

Projects Head (2.5 Yrs)

Projects Engineer (2 Yrs)

Projects Coordinator (3 Yrs)

Top companies trust Udemy

Get your team access to Udemy's top 22,000+ courses