Sageworks Blog

May25

What is your biggest concern when using spreadsheets? Billy Burnet [email]

May 25, 2013 08:24

Sageworks recently hosted a webinar, “Concerns Examiners Have About Your Spreadsheets and How to Respond”, led by Jay Gallo, partner at RMPI Consulting, and Regan Camp, senior risk management consultant at Sageworks. On the webinar, Jay and Regan discussed best practices, common pitfalls, and examiners’ concerns related to financial institutions’ use of spreadsheets. During the presentation, over 180 financial institutions were asked what their biggest concern is when using spreadsheets. [More]

May02

Common challenges when performing Global Cash Flow Analysis Sanaa Bhambri [email] Marketing Analyst

May 02, 2013 16:51

Sageworks recently hosted a webinar, Global Cash Flow Analysis: What, When, Why and How. During the presentation, more than 120 financial institutions were polled on their biggest challenges when performing Global Cash Flow Analysis. Almost 40% expressed difficulty combining personal and business incomes as their biggest challenge. [More]

Apr26

Are you sure your spreadsheets are error-free? Billy Burnet [email]

Apr 26, 2013 11:20

Eighty-eight percent of spreadsheet documents contain errors, as stated in a recent article in MarketWatch, which cited a 2008 analysis of multiple studies. Ray Panko, a professor of IT management at the University of Hawaii and an authority on bad spreadsheet practices, noted, “Spreadsheets, even after careful development, contain errors in 1% or more of all formula cells. In large spreadsheets with thousands of formulas, there will be dozens of undetected errors.” [More]

Apr20

Calculating living expenses in a global cash flow analysis Billy Burnet [email]

Apr 20, 2013 08:53

Sageworks recently hosted a webinar, Global Cash Flow Analysis: What, When, Why, and How, which featured David Matricciano, owner of DM Analytics LLC, and Chuck Nwokocha, director of advisory services at Sageworks. During the presentation, several questions were asked by attendees. In this post, Nwokocha answers questions about calculating living expenses in a global cash flow analysis. [More]

Dec 18, 2012 12:39

Starting with the financial crisis, there has been a decided shift in the lending environment. Banks and credit unions with commercial lending have turned away from Commercial Real Estate loans (CRE) in favor of Commercial and Industrial Loans (C&I). How should banks prepare? Would a probability of default model ease the transition? [More]

Dec 05, 2012 09:50

Breaking into the commercial lending paradigm to improve your commercial loan presentations can be difficult, says Gary Welsh, Banking Services Manager at Condley and Company, a leading bank advisory and full service accounting firm. In Part 2 of this guest column, Welsh provides five suggestions to help get things right the first time. [More]

Nov 13, 2012 10:00

Drive down any major road, and at some point you could run into trouble: A wreck that has shut down traffic, construction causing delays, or a dangerous object in your lane you must swerve to miss. In the same way, businesses can prepare for or even avoid disastrous business credit relationships with suppliers, distributors, customers and other partners when they have warning – when they can predict which of those players are riskiest in a business relationship. [More]

Nov09

Using a probability of default Brad Schaefer [email] Analyst

Nov 09, 2012 14:48

In the last post, we had looked at credit risk models and, specifically, what a probability of default model does. But how does that apply to banks, and why should a financial institution trust a probability of default (PD) analysis. [More]

Nov07

What is a probability of default model? Libby Bierman [email] Analyst

Nov 07, 2012 08:29

A probability of default model uses multivariate analysis and examines multiple characteristics or variables of the borrower, and it will usually account for credit or business cycles by either incorporating current financial data into the generation of the model or by including economic adjustments. [More]

Oct 30, 2012 09:57

Many small private businesses are finding it challenging to access financial resources for growth at a time when lenders are still cautious and facing pressure to avoid risky loans. Many businesses already know this, because they have seen their borrowing requests rejected by a lender. Others may be considering starting a loan application and want to ensure the business is best prepared to receive an approval. [More]