Loan Table
The Loan Table enables you to enter information on long-term loans that the business intends to borrow. The software calculates the amortization table for each loan and includes its information in the projected financial reports.
The number of loans that can be entered in the Other Loans table was increased from 10 to 20 different loans (50 in the Pro version).
For each loan the following information is entered:
Loan Name: A brief description of the loan
Principal: The total amount of the loan
Currency: The currency in which the loan is received and paid
Annual Interest Rate: The loan's annual percentage interest rate
Number of Payments in a Year: The number of payments each year. Usually a loan is paid in payments every month (12 payments per year), every three months (4 payments per year), every six months (2 payments per year) or once a year.
Total Number of Payments: The total number of the loan's payments. E.g. if the loan is paid back in 5 years with payment every month then the total number of payments will be 5 x12 = 60.
Date Received: The date the loan is received
First Principal Payment: The date of the first payment that includes return of the principal of the loan or part of it. Usually the first principal date is the same as the first interest date, but in some types of loans, there is a grace period at the beginning of the loan period in which only the interest is paid.
First Interest Date.: The date of the first interest payment.
Payback Method: You have a choice of two types of loans:
Amortized Loan - Equal payments are made each payment date.
Fixed Principal - The principal amount is the same for each payment, but the interest amount decreases.
After you enter loan information, the loan amortization table is calculated automatically and presented below the Loan Table. The amortization table shows the loan payments and a total for each year, in a tree structure.
Φ Note: Do not duplicate information about these loans in the Other Loans screen.
The number of loans that can be entered in the Loan table was increased from 10 to 20 different loans (unlimited in the Pro version)
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
 Export to MS Excel file - Exports the displayed table to MS Excel
| 
