Hi Marc, On 9/15/12, Meketon, Marc <[email protected]> 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 _______________________________________________ Help-glpk mailing list [email protected] https://lists.gnu.org/mailman/listinfo/help-glpk
