Finance

The FINANCE module adds facilities to the DESIGN module. In FINANCE you can extend the energy and economic calculation to more than 40 years. The calculation includes Cash Flow on a monthly basis, financing, investments and the usual investment key figures, Pay Back Time, Internal Rate of Return and Present Value.

Figure 1: Example of the cash flow and pay back time illustrated grahically. You can also monitor the cashflow month by month on a printed report.

Calculation model The economic calculation in FINANCE adds facilities as investments and finance with national and international loans. The module also calculates Cash Flow of the project on a monthly basis taking factors such as the delay between an income or expense and the actual payment into account. The economic calculation is as detailed as required by the World Bank. This means that a project calculated with energyPRO FINANCE is fully "bankable".

Headings for MONTHLY CASHFLOW: Revenues Operation expenditures Investments Cash from Long Term Financing Debt service Interest on Cash Account Cash Surplus Cash account

Figure 2: An example of the main input window showing the economic information of the project.

FINANCE uses the same tree structure for the input elements as DESIGN which gives a quick overview and easy access to enter data. In FINANCE the input data are extended to also include information for several years controlled by time series or by indexes. FINANCE also adds a number of input facilities to financial data.

As in DESIGN you specify the payments to include as revenues and operation expenditures. In each payment it is possible to select any of the calculated monthly energy conversion figures and multiply them with an unit price.

Regardlessly how complicated e.g. an operation expenditure is, it is possible to describe it if choosing "User Defined", in which you can edit your own formulas and model the economic conditions with precision.

The investments can be divided into several "investments accounts" which again can be sub-divided into several disbursements.

The financing can be described with one or more loans such as Nominal loan, Foreign Loan, Indexed Loan or deposit of Owners Capital and it can be modeled in details based on interest, loan period, payment grace period, etc. Fees can also be described in details. If it is impossible to obtain the exact same result as in the payment overview from the bank or if it is an already established loan, you can select "User defined" in which you can enter the payments according to your own specifications.

Reports The reports can be shown on-screen, printed or copied to clipboard. Examples of Reports Click on a report name to see a full-page example of the different prints Cashflow, Monthly,finance Cashflow, graphical,finance

Figure 3: Report possibilities in FINANCE

Site map

EMD International A/S  Niels Jernes Vej 10  9220 Aalborg Ø Denmark  
Tel.: +45 9635 4444  Fax: +45 9635 4446  E-mail: emd@emd.dk