Other Loans

Use the Other Loans screen to enter data for loans that were not entered in the Loan Table either because their payback data does not conform to the methods available for calculation in the Loan Table, or because you found it more convenient to enter the data here, e.g. in case the schedule and amounts of the loan payback is already prepared and you don't have to calculate the amortization table.

The screen includes up to 10 loans, each with 3 lines as follows:

Loans Received: Enter the description of the loan in the first column and then the amount of the loan in the period when it is expected to be received.

Principal Payments: Enter the amount of the principal payment for the loan in each period, not including interest.

Interest Payments: Enter the amount of interest paid per period for the loan.

Currency: For each loan, you can choose the currency from a drop down list, by which the loan is received and paid. The amounts will be translated to the analysis currency by the exchange rate specified in the Currency Table.

Toolbar Buttons

All the tables include similar toolbar that appears at the top of the window and includes the following buttons:

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

Exit - Close screen and discard any changes if applicable.

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