Capital Budgeting Excel Template (NPV, XNPV, IRR, MIRR, XIRR)

Replies to This Discussion

Permalink Reply by Baby Grace on March 24, 2008 at 2:00am

Hi Bob,

Wow, your brilliant.
Thanks for sharing this template.

Regards,

Grace

▶ Reply to This

Permalink Reply by Ricky Sosotya Wuri Handayani on March 27, 2008 at 3:10am

Please share about investment credit in oil and gas sector. How to put the investment credit data in the capital budgeting analysis? How is it affects net cash flow? Can anybody help me, please? Thanks for share this template.

▶ Reply to This

Permalink Reply by Daniel Chow on March 27, 2008 at 3:36am

Not sure if this attached oil and gas investment calculator spreadsheet works. Think its geared more towards the personal investor, but the logic and calculations should be adaptable for corporate needs.

I havent tested or verified its accuracy, so use at your own discretion.

Trust this helps

Attachments:

• InvestmentHuntersCalculator.xls, 170 KB

▶ Reply to This

Permalink Reply by Ricky Sosotya Wuri Handayani on March 28, 2008 at 3:16am

Thanks for the spreadsheet. It will usefull for data room.

▶ Reply to This

Permalink Reply by Howard Cohen on May 12, 2009 at 11:19pm

Hi Daniel

Thanks for the useful Calculator

I need a favour with regard to the following small Exercise

Attached please find the following Spreadsheet

Each project has an expected life of 3 Years and the initial outlay is $ 6750 each. Annual Net Cash flows begin in Year 1 after the initial Investment is made. The riskier project is at 12% (I have assumed Project b) and the less risky Project at 10%

I need your help on the following

1) Calculating Coefficient of Variation
2) What is the risk adjusted NPV of Each Project
3) If it was established that project B was negatively Correlated with other cash flows Whereas Project A was positively Correlated, How would this effect the decision? If Project B’s cash Flows was negatively Correlated with GDP, how would that influence the assessment of Risk


Look forward to your assistance

▶ Reply to This

Permalink Reply by VIVEK P TONDAPURKAR on March 27, 2008 at 8:32am

THANK YOU VERY MUCH , MR BO JOHNSTON

ITS A FANTASTIC TREATISE .

IT GIVES LOT OF CLARITY

AM DELIGHTED TO SEE SUCH A PRESENTATION WHICH GIVES LOT OF KNOW;EDGE
VIVEK
C.O.O. tEXTILE MFG INDUSTRY

▶ Reply to This

Permalink Reply by Shahzad on April 4, 2008 at 5:11pm

hi any can help me in finance

▶ Reply to This

Permalink Reply by CA Raju on April 10, 2008 at 1:03pm

Hi Bob Jonnston,

Templates are very useful for Capital Budgeting.
Thank s for sharing this

Regards,

CA Raju.

▶ Reply to This

Permalink Reply by Robert Busuulwa on April 26, 2008 at 10:07am

Any help? When i calculate NPV using the =npv(cost of cap,sum of cflows) formula from excel, the results are a clear margin off than when i calculate npv by discounting each cf separately and summing up....i have used this on an investment that i was presenting and at the last minute realised the discrepancy, so i decided to use the 'from scratch' approach...........can anyone help me with this?

Rob Busuulwa

▶ Reply to This

Permalink Reply by Retha Kwok on April 29, 2008 at 11:52am

There is a bug in Excel's NPV function that throws the results a little off.

The manual "for scratch" method is generally regarded as being a more accurate way to calculate NPV.

Although, the margin of difference between using Excel's NPV function and the manual method is normally not material, hence many still using the Excel function for simplicity and efficiency.

▶ Reply to This

Permalink Reply by Syed Rizwan Abbas on February 27, 2009 at 3:47am

I hope by now you have got answer to your question, just in case

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.

Regards

▶ Reply to This

Permalink Reply by Hans Noteboom on May 4, 2008 at 7:16pm

Hello Michelle and Bob Johnston,

Thanks for this template. Am currently setting up a business plan with financial projections, so this template will be useful.

Thanks again,

Hans Noteboom
GAM-Solar Energy

▶ Reply to This

• ‹ Previous
• 1
• 2
• 3
• …
• 9
• Next ›
• Page