[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Help-glpk] IRR (Internal Rate of Return) using MathProg

From: Noli Sicad
Subject: Re: [Help-glpk] IRR (Internal Rate of Return) using MathProg
Date: Sat, 15 Sep 2012 11:42:56 +1000

Hi Marc,

On 9/15/12, Meketon, Marc <address@hidden> wrote:
> One idea:  how about using the ODBC connection to export the solution to
> Excel or some spreadsheet, and using the IRR calculation there?

Yes, you are right. Excel IRR is easier to use.

I am trying to avoid Excel formulas as much as possible. Right now, I
am output results in CSV files and doing all the calculations for the
report using MathProg. It works well for models with longer planning
horizon / period (e.g. 45 to 70 years). Just like to use Excel for
graphs at the moment. This modelling is just prototyping.

Here are some screenshots in this modelling.

> Note that you are missing one really important piece of information in your
> example - what is the original investment?  Often in the IRR calculation,
> the 0th year is a negative number representing the initial investment, and
> the numbers afterwards represent the cash flows that come in due to that
> initial investment.  Of course, there may be investments in later years as
> well.

Yes. I need the initial investment (e.g. the price / amount in acquire
a forest estate). Right now, I don't have the any idea since the
forest estate is just hypothetical.

I guess I have to deal with IRR and Forest Valuation using Excel when
the situation in the future arise.



reply via email to

[Prev in Thread] Current Thread [Next in Thread]