News & Updates

Subscribe here.

Enter your email address to get the latest FISCAL updates delivered straight to your inbox.

Path 2

Accurately Calculating Annual Debt Service in Excel

January 09, 2024

Annual debt service is a foundational calculation for financial statement spreading and evaluating small business loans. Much like other key calculations, getting annual debt service right is...

What Is a Tickler System and How Do I Use It In Excel?

September 20, 2023

For decades, banks and credit unions have used tickler systems to manage commercial lending accounts and ensure they are staying on top of documentation. Once done on paper and kept in filing...

Spreading Financials: Common Mistakes to Avoid

July 18, 2023

Community banks and credit unions that lend to small businesses typically have a standard set of practices they use to assess the risk and profitability of potential loans. While there are a number...

6 Tips for Bank Financial Statement Analysis in Excel

June 29, 2023

Credit unions and banks that use Excel for financial statement analysis have likely encountered the common pitfalls of the application: overwritten templates, broken formulas, and lack of...

Essential Excel Formulas for Financial Analysts and Underwriting

May 18, 2023

Loan analysts use Excel nearly every day. Many learned the formulas, functions, and how to set up spreads on their own, asking colleagues or searching the internet for help. Even with their hands-on...

Financial Statement Spreading in Excel vs. Software

April 26, 2023

Many community banks today manage financial statement spreading using Excel. Others opt for spreading software solutions. Both have their pros and cons, depending on the size of your institution,...

When You Should Transition to Financial Spreading Software

March 30, 2023

Transitioning to financial spreading software is a big step for community banks and credit unions. Before making the switch, they must consider need, benefits and cost. In our experience, banks and...

The Pros and Cons of Commercial Loan Analysis Worksheets

January 10, 2023

Helping a business grow or a new business open its doors is one of the most satisfying parts of working in commercial lending. However, the process of analyzing and approving small business loans can...

5 Exception Tracking Best Practices to Track More Efficiently

November 29, 2022

If there’s one constant in tracking, it’s that the specifics of what is tracked changes from customer to customer. What exceptions are tracked and how they’re tracked can even vary between officers...