• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hopefully a simple formula

J

jhemmerly

New Member
First I want to say that I love this website. Things are put in a way that even someone like myself that is not an expert can begin to understand how to create a dynamic spreadsheet.

Okay, this is what I am looking for. What would the formula look like to come up with the IRR on a life insurance policy that you paid $10,000 for the first 10 years and the cash value is $200k in year 20 without taking any cash from the policy? And, when you take cash from the policy?

I know this is very simple to most on this site but I am having a hard time coming up with a simple formula using the Rate function or IRR.
 
try using this Formula

=RATE (nper, pmt, pv, [fv], [type], [guess])


Regards,
Rick Bale
 
Hello,
I'm using the XIRR function to calculate the IRR for a custom series of cash flows.
I study Finance at Berlin School of Economics and Law and we practically need to memorize Excel Financial functions (used in our pimion finance course) by heart.
 
You must log in or register to reply here.
Back
Top