Currency Table

In the Currency Table you define the various currencies that you will use in your plan and their projected exchange rates during the plan period.

The table contains the following columns.

Currency Code: Give the commonly used code for the currency e.g. DEM for Deutsche Marks.

Description: The name that describes the currency e.g. US Dollar.

Exchange Rate: Enter a value that will be used as the basic exchange rate. When you enter a value it is duplicated automatically to all the periods of the plan.

Φ Note: the exchange rates of all the currencies should relate to one currency that will be the basic currency, e.g. If you use Euro and US Dollar in your plan, one of them should have an exchange rate of 1 and the other should have the related exchange rate.

In the period columns, you may alter the exchange rate for each period if you assume it will be changed. The system takes the basic exchange rate for calculations until it reaches a period with a different rate. Then this rate will be used until another period with a different rate is encountered. If an exchange rate per period is zero, the exchange rate for this period will be the same as in the previous period.

Toolbar Buttons

OK - Close screen (and save all changes if applicable)

Exit - Close screen and discard any changes if applicable.

Add row - Add a new row at the end of the displayed table

Insert row - Insert a new row above the selected/marked row

Delete row - Delete the selected/marked row

Print Table - Create a report for the current table, showing it on the print preview screen

Forecast - Copy cell values across next periods

Export to MS Excel file - Exports the displayed table to MS Excel