• 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.

Need Help with what seems to be a simple thing

Status
Not open for further replies.
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.
 
jhemmerly
Do not duplicate Your thread:
You should continue to give more details to Your original:

Hopefully a simple formula

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...
chandoo.org
As well ... You could reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
especially How to get the Best Results at Chandoo.org
This thread is closed.
 
Status
Not open for further replies.
Back
Top