(800) 234-1111

FINPACK News

Changing interest rates in FINPACK Projections

by | Apr 22, 2020

The Credit Renewal Process - FINPACK

Interest rates charged on loans can change during the year for any number of reasons; the rate is variable, the rate was renegotiated at renewal, or the customer’s risk profile changed to name a few. Because of this, interest rate changes on operating or term loans can be easily modeled in a FINPACK monthly cash flow projection.

Term loans

Accessing Interest Rate detail in Loan Payments data entry allows you to enter the appropriate monthly interest rate. Rates can be changed each month if needed, either increasing or decreasing as appropriate. Interest rate changes included here then correctly adjust the principal and interest payment details for any affected loan payments. If payment terms are not changing, there is no need to update the P & I Payment entered for the loan in Loan Payments data entry. Of course, if payment terms are changing as well, these updates will need to be made in the projection.

Interest rate changes are handled in this manner for current loans that have not been designated as Annual Operating on the corresponding balance sheet as well. Non-annual operating, current loans appear in Loan Payments data entry. Therefore, interest rate changes can be included as needed by accessing interest rate detail.

* Note – the default assumption is the interest rate remains at the value entered on the balance sheet for the projection period. Any changes need to be manually entered.

Interest Rate detailed entry.

Annual operating loan

Changing the interest rate for the annual operating loan is completed in Annual Operating Loan data entry. As seen below, the monthly interest rate charged for this loan is entered for each month of the projection in data entry. The interest rate defaults to the annual operating loan interest rate from the balance sheet. You have control over any interest rate variations that may be needed.

Annual Operating Loan data entry.

Summary

Interest rate changes for operating and term loans are easily modeled in a monthly cash flow projection. Utilize these recommendations to change loan interest rates as needed for the loans in your next cash flow projection.

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...