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