I would prefer to use the XIRR function since it matches cashflows with actual dates
This week we move on to the twin brother of NPV – The Internal Rate of Return or IRR.
Net present Value (NPV) is a key metric used by investors to calculate the attractiveness of a potential investment.
Standards in themselves do not promote good or best practice. They simply promote a way of doing things that is commonly understood by the community that chooses to adopt them.
So what happens to all that spare thinking time? Where does it go?
The person who had built the original model was on another assignment, in another time zone, and wasn’t available to help.
These are the 6 steps that should have been made to ensure my training effort wasn’t wasted
“Here are five items that I will be taking with me in my Excel FAST financial modelling kit bag”
“There is no software to my knowledge that can help with conceptual testing. For the moment we must continue to rely on our own intelligence and understanding.”