Finance 3.0 - Social Network for Finance
Smart financial thinking
Capital Budgeting Excel Template (NPV, XNPV, IRR, MIRR, XIRR)
This excel template provides worked examples of Excel's 3 traditional capital budgeting functions available as well as 2 of these functions that are date specific.
This worksheet illustrates the use of the NPV, the IRR, and MIRR functions. In addition, using the NPV function to determine a PI (Profitability Index) is all illustrated. Some solution detail is provided below in addition to the Excel function solutions.
The date specific functions are presented in the XNPV and XIRR Example worksheet.
Caution: When using the NPV function, Excel treats the first cash flow as occurring at time period t = 1, not t = 0. In contrast, with all of the other capital budgeting functions; the first cash flow is assumed to occur in period t = 0.
Created by Bob Johnston of the School of Management at George Mason University.
This worksheet illustrates the use of the NPV, the IRR, and MIRR functions. In addition, using the NPV function to determine a PI (Profitability Index) is all illustrated. Some solution detail is provided below in addition to the Excel function solutions.
The date specific functions are presented in the XNPV and XIRR Example worksheet.
Caution: When using the NPV function, Excel treats the first cash flow as occurring at time period t = 1, not t = 0. In contrast, with all of the other capital budgeting functions; the first cash flow is assumed to occur in period t = 0.
Created by Bob Johnston of the School of Management at George Mason University.
Tags: capital budgeting, irr, mirr, npv, xirr, xnpv
- Attachments:
-
-
Capital Budgeting Template.xls, 134 KB
-
Replies to This Discussion
-
Permalink Reply by Mohamed El-Toukhy on -
Thanks for your efforts
-
Permalink Reply by Andrew Smith on -
Thanks a lot.. This amazing template will help me for my upcoming comprehensive exam in MBA.. God Bless you for sharing this..
-
Permalink Reply by Rabeea Ashraf on
-
hi Bob...this is excellent.will u plz help me in creating operating model of any textile firm.and will u plz tell me about credit rating process? thanks
Regards
Rabeea
-
Permalink Reply by VIVEK P TONDAPURKAR on -
Bob
Rabeea
Am equally interested in having operating model of any textile firm.if done & / or during the process I would like to be part of the whole process
vivek Tondapurkar
-
Permalink Reply by Dirk Jacobus Schreuder on -
hey bob
could you please email this attachment to me?
-
Permalink Reply by Bob Lowi on -
Hi Bob,
I was wondering if you or anyone can help me out with this problem. My organisation is making a asset replacement decision, to replace about 14 PC's all bought back b/w 03-05 period. Due to budget limitations, management has made a decision to upgrade all the PC's rather than buy. I want to convince them that upgrading old PC's, which by standard is out-of-date, would in fact cost more in future; thus they should replace with new sets of PC's. The upgraded Pc's are anticipated to be replaced in 2 years time should they be undertaken this year.
I would appreciate your assistance with this to assist me understand better your excel template and the Capital Budgeting Technique.
Many thanks,
BL
Many thanks.
BL
- ‹ Previous
- 1
- …
- 7
- 8
- 9
- Next ›
Sign in
Badge
Continuing Education
 |
Accounting |
 |
Banking Regulations |
 |
Certification Training |
 |
Commercial Bank Management |
 |
Corporate Finance & Valuation |
 |
Treasury Management |
 |
Credit Risk Management |
 |
Financial Derivatives |
 |
Financial Institution Management |
 |
Financial Markets |
 |
Financial Modeling |
 |
Financial Planning |
 |
Market Risk Management |
 |
Operational Risk Management |
 |
Operations & Compliance |
 |
Quantitative Analysis |
 |
Strategic Financial Management |
Newsletter
Linkedin
RSS
Facebook
Widgets
Twitter© 2010 Created by Finance 3.0
