(800) 234-1111

FINPACK News

How to Use the FINPACK Loan Calculator

by | May 15, 2020

How to use FINPACK Loan CalculatorThe FINPACK Loan Calculator is a useful tool as you enter or edit loan payment information into a Balance Sheet, Cash Flow Projection, Long Range Plan, or Financial Analysis in FINPACK.  The loan payment details from the Loan Calculator can be pasted into data entry, or it can also be used as a freestanding tool to brainstorm possible loan payment options.  When using the calculator in freestanding mode, the information cannot be pasted into FINPACK.  Here the only option is to View Payment Schedule and print or export the schedule.

There are two types of repayment options in the FINPACK Loan Calculator – amortized payments or fixed-principal payments.  The type of loan being modeled will dictate the specific calculator chosen. 

Using the Calculator

Assuming the FINPACK Loan Calculator is being used within data entry, the user will first enter the Lender, Description, Interest Rate, Principal Balance, and Accrued Interest details for the loan.  The Loan Calculator is then used to calculate payment details.

FINPACK Loan Calculator Icon

FINPACK Loan Calculator Icon

To access the FINPACK Loan Calculator, click the Loan Calculator icon on the FINPACK toolbar.  In the Loan Calculator dialog, details can be entered in the tab for Amortized Payments or Fixed-Principal Payments.

Amortized Payments

For amortized loans, the first selection is either for a New or Existing Loan.  Details regarding the First Payment or Next Payment Date; Payment Frequency (from the drop-down list); and Loan Period in Years or Number of Payments Remaining are then entered.  (First Payment Date and Loan Period in Years are used when entering information for a new loan.  Next Payment Date and Number of Payments Remaining are used when entering information for an existing loan.)   For most of these entries, there is a button with an equals sign (=) to the right of the entry.  Click this button will calculate that entry item based on the data entered for all the other entries.  Typically the Scheduled Payment is the item being calculated, but any item with an equals sign button can be back-calculated.  For example, you can enter different Scheduled Payments then calculate the Amount Borrowed to see how much you can borrow given different payment amounts.

The full amortization schedule can be viewed and printed by clicking View Payment Schedule button.  If the Loan Calculator dialog was opened from a loan data entry section in FINPACK, the Paste button will be enabled for you to paste the payment information into the highlighted loan in data entry.

Fixed-Principal Payments

When using the Loan Calculator to model fixed-principal payments the same underlying loan information is entered into data entry prior to opening the Loan Calculator.  Once this information is entered and the Loan Calculator is opened, you can enter the fixed-principal payments in the particular month(s).  The month(s) when an interest payment is due is selected by clicking the Interest Payment check-box.  When this data entry is completed, the Annual P & I Payment is and displayed.  Again, the payment scheduled can be viewed and printed by clicking View Payment Schedule.  Also, If the Loan Calculator dialog was opened from a loan data entry section in FINPACK, the Paste button will be enabled for you to paste the payment information into the highlighted loan in data entry.

Using the FINPACK Loan Calculator is helpful for estimating payment details for a loan or for experimenting with different repayment scenarios.

Latest News
Speedier loan approvals

Speedier loan approvals

The goal of any financial institution is quick loan approvals, which leads to happy customers. How can FINPACK help with this process? Consider FINPACK’s Credit Decision Scorecard, a customizable Credit Analysis tool, to aid in this process. The scorecard is...

Challenges with CCC loans reported as income

Challenges with CCC loans reported as income

Tax preparers are not consistent in reporting repayment of CCC loans that have previously been reported as income for tax purposes. FINPACK tries to adjust for these inconsistencies but adjustments are not always possible. While these problems cause cash...

Portfolio Risk Analyst (PRA)

Portfolio Risk Analyst (PRA)

You know your borrowers and their individual business risks. But how is your entire portfolio positioned to face the volatility of today's business environment? PRA creates a database of your borrowers and generates reports that help you see where the stress points...

Determining Schedule F Income in FINPACK

Determining Schedule F Income in FINPACK

FINPACK uses IRS Schedule F data in two analysis tools - the Schedule F type Tax Form and the Schedule F Cash to Accrual tool. Several items on the Schedule F tax form have both total and taxable entries. Because of this, questions arise about which Schedule F entries...

Mitigating Uncertainty: Transition Planning

Mitigating Uncertainty: Transition Planning

Transitioning a business brings about a lot of uncertainty, excitement, and anxiety. As a lender, there are several questions like these top of mind. Who will be operating the business? What role will the parent generation have going forward? What does the transition...