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

[Noli Sicad]

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.

http://office.microsoft.com/en-au/excel-help/irr-HP005209146.aspx

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.

https://picasaweb.google.com/116847891529748214201/ForestValueFOLPIBasedFormulationForestValuationForestEstateModellingAndWoodflowModel#


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

Thanks.

Noli