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

Economist at FINPACK | 6126254219 | pvannurd@umn.edu | Website | + posts

Pauline Van Nurden joined the FINPACK Team as an Economist in 2017.

Prior to joining the FINPACK Team, she worked as a lender. This provides her valuable industry experience and knowledge in her work with FINAPCK. Pauline holds a Master’s Degree in Agricultural Education and Bachelor’s Degree in Applied Economics, both from the University of Minnesota.

Latest News
New and Improved: Financial Ratios in FINPACK

New and Improved: Financial Ratios in FINPACK

This post highlights the updated financial ratios in FINPACK. The ratio updates are based on the recent updates to the Farm Financial Standards Council's Financial Guidelines for Agriculture. The 2022 release of the Farm Financial Standards Council's (FFSC) Financial...

FINPACK News – November Digest

FINPACK News – November Digest

The FINPACK Lenders Conference is around the corner, the FINPACK 2022 update is live including new monthly Commercial Cash Flow capabilities, and the FINPACK team at the ABA Ag Bankers conference in Omaha! Register Now for the FINPACK Lenders Conference...

The New Monthly Commercial Cash Flow Capability of FINPACK

The New Monthly Commercial Cash Flow Capability of FINPACK

What's New in the Commercial Cash Flow Tool in FINPACK? The 2022 Fall Release of FINPACK adds the capability to complete annual OR monthly cash flow projections for commercial clients. These projections can be for a few months or multiple years. This replaces the...

What’s New in the 2022 FINPACK Update?

What’s New in the 2022 FINPACK Update?

The 2022 FINPACK update brings changes to Tax Forms, incorporates new Financial Standards Measures, introduces a new Cash Flow Projection into our commercial tools and more! Farm Financial Standards Update The FINAN Financial Analysis and FINFLO Cash Flow Projection...

FINPACK NEWS Digest – October 2022

FINPACK NEWS Digest – October 2022

FINPACK lenders conference registration is open, the updated Farm Financial Scorecard, lender training, and looking forward to the ABA Ag Bankers Conference Register for the FINPACK Lenders Conference The FINPACK Lenders Conference is back in-person! Join us...