Loan / Lease Calculator

slider-loan-calcConnect your loan calculator directly to your working papers in CaseWare.

The Loan & Lease calculator increases the functionality of the long-term debt, callable debt, and Capital lease working papers. It eliminates the need to calculate payment, principle, and interest on a separate spreadsheet. Calculated amounts are entered into the working paper at the push of a button eliminating the need to re-enter data.

The Loan & Lease caldulator also includes support for Canadian mortgage calculations.

The Loan & Lease calculator can be accessed directly from any of the above working papers by double clicking on its loan ID. Alternatively it can be accessed by right-clicking the express button.

newsletter loan-calc access

When accessed in the above manner, the loan details are automatically filled into the calculator. Options for amortization method, payment intervals and compounding intervals are available.

The Loan & Lease calculator can use the payment amount as entered on the working paper for its calculations Or can calculate the payment amount on its own.

newsletter loan-calc options

Payment, principal, and interest information is calculated and displayed in the Loan & Lease calculator. Changes to options and payment information can be made as required. Payments for individual periods can also be changed. Changes made are automatically reflected in the calculation.

Once the information as calculated is approved by the preparer, the information can be transferred back to the working paper by clicking on the transfer button.

newsletter loan-calc results

Another feature is the ability to specify the loan balance at the end of the fiscal period for the purposes of calculating future repayments. This is particularly useful in prime + loan situations.

 newsletter loan-calc period-balance