> dguille...@gmail.com
> -Original Message- From: NewToThisGroup
> Sent: Saturday, November 26, 2011 12:18 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ IRR & Cash Flows
>
>
> Hello.
>
> Column A, Column B
> Date 1, CashFlow 1
> Date 2, Cash Flow
Reply to this and attach file,if allowed, or send directly to me.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: NewToThisGroup
Sent: Saturday, November 26, 2011 12:18 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ IRR & Cash Flows
H
The goal seek is built for such purposes. Look this up on the net, and you
should get examples of how you can achieve your task.
You can also lookup the Solver, but that is a third-party add-on.
Sam Mathai Chacko
On Sat, Nov 26, 2011 at 11:48 AM, NewToThisGroup wrote:
> Hello.
>
> Column A, Col
Hello.
Column A, Column B
Date 1, CashFlow 1
Date 2, Cash Flow 2
Date 3, Cas Flow X
I want to solve for Cash Flow X so that it gives me a number such that
the stream of cash flows (and the associated dates) results in a 10%
return (using the XIRR function)? Is there a forumla that I can enter
int
