Be Careful Excel Warning

If you are using Excel 2013, I’m sure you must have encountered be careful Excel warning. When you try to save a workbook, suddenly a pop-up appears saying “Be careful! Parts of your document may include personal information that can't be removed by the Document...

The Curious Case of Negative IRR

Negative IRR indicates that the sum of post-investment cash flows is less than the initial investment; i.e. the non-discounted cash flows add up to a value which is less than the investment. So yes, both in theory and practice negative IRR exists, and it means that an...

How to Create Hatched Charts in Excel

Hatched charts in Excel look beautiful. They look cool and professional. Hatching or shading between plotted lines enhances charts and helps to convey the story. Creating hatched charts in Excel is rather easy (I’m using Excel 2013). For this illustration we will be...

How Does Excel Calculate IRR?

Have you ever wondered how does Excel calculate internal rate of return (IRR)? I never gave it second thought until I wrote a post on the issues with NPV calculation in Excel. Our reader, Deyan, pointed that similar type of issue can exist with the IRR calculation in...

Future Value Calculation in Excel

Future value calculation in Excel can be done either by using Excel FV formula or by manual calculation. Before we get into the calculations, let’s review the concept of future value. We have discussed the time value of money earlier. To remind ourselves, the basic...

Wait

I want to teach you how to conduct feasibility studies!

Enter you email to know more!