Open one of the mentioned working papers and double-click on the UID next to a loan line item to link the working paper to the Loan Calculator working paper.
Required inputs
The Loan Calculator requires the following inputs from the linked working paper:
Interest Rate
Start Date
Maturity Date
Opening Balance
Additions During year
Optional inputs include:
Payment - Payments can calculated by the loan calculator based on the inputs above or be based on what is entered in the WP. (See Payments calculator method below)
Closing Balance - Closing balance can be calculated based on the inputs above or be entered directly into the calculator under the Actual loan balance information. (see below)
The inputs will be pulled into the Loan Calculator working paper.
Transfer results back to the Working paper
When you are satisfied with the amounts in the tables below, click on Transfer button to move the results back to the working paper.
Data transferred back includes:
Interest Paid
Principal Paid
Future Repayments data
Payment amount (if calculator is set to calculate the payment amount)
