Benefits of Spreading Financial Statements
The primary goal of spreading financial statements is to assess a company's current financial health, trends, and ability to meet commitments by standardizing key balance sheet, income, and cash flow items.
The two most common challenges businesses face with spreading financial statements are:
-
Time Consuming
-
Analyst Interpretation
CreditKernel's template solves both challenges, plus provides the best practices in financial statement spreading:
-
The spreading template standardized financial data and key ratios, ensuring consistent, fair, and unbiased comparisons between companies.
-
Quickly identify red flags using predefined categories and calculations. Deviations from industry norms or trends signal further investigation.
-
Financial spreading templates provide a documented analysis record, essential for internal review, compliance, and future reference.
Need help requesting counterparty financial statements?
Check out our financial statement request letters that can be used immediately.
Spreading Categories and Line Items
1. Balance Sheet
-
Assets are what a company owns and can use to generate revenue. They include items such as cash, accounts receivable, inventory, plant property & equipment, and intangible assets.
-
Liabilities are what a company owes to others. They include items such as accounts payable, amounts outstanding on a line of credit, current portion of long-term debt, long term debt, and leases.
-
Shareholder Equity represents the net worth of the company and includes the capital contributed by shareholders and retained earnings (profits not distributed as dividends).
2. Income Statement
An income statement summarizes a company's performance, detailing revenues, costs, expenses, and net income over a specific period.
The main line items of an income statement include:
-
Revenue: Represents the income generated from the company’s primary operations, often referred to as sales.
-
Costs of Goods Sold (COGS): The direct costs of producing the goods or services the company sells.
-
Gross Profit: Calculated as Revenue minus COGS, gross profit reflects the profitability of the company’s core business operations.
-
Operating Expenses: These include administrative and selling expenses, depreciation, and other costs not directly tied to production.
-
Operating Income: Also known as operating profit or earnings before interest and tax (EBIT), it is calculated by subtracting operating expenses from gross profit.
-
Interest Expense: These are the costs of borrowed funds.
-
Net Income: This is the bottom line of the income statement, reflecting the company’s profit or loss after all expense, including taxes and interest, have been deducted from revenue.
3. Cash Flow Statement
A cash flow statement shows cash inflows and outflows, assessing liquidity and how the company generates and spends cash.
The cash flow statement is divided into three sections:
-
Operating Activities – Indicates the cash generated or spent from the company’s ongoing business operations, such as collection of revenue, payment to suppliers, and changes in working capital.
-
Investing Activities – Includes cash spent or generated from long term assets, such as plant, property, and equipment, or investments in other businesses.
-
Financing Activities – Shows cash flows from activities related to issuing debt, paying down debt, and paying dividends to shareholders.
4. Off Balance Sheet Items
Available in the accompanying notes of the financial statements. Refers to assets, debt, or other financing activities not included on the company balance sheet.
5. Debt Maturity Schedule
A table lists debt repayment dates, detailing debt type, principal amount, and maturity date. Maturities are typically categorized into periods: less than 1 year, 2 - 5 years, and over 5 years.
The debt maturity schedule is beneficial in credit analysis for several reasons:
-
Liquidity Risk: The schedule shows the company’s debt due within 1 year. If the company has significant debt maturities in the near term, it may face liquidity risks, especially if its cash flows are uncertain, tight, or access to credit is suspect.
-
Refinance Risk: For longer-term debt, the schedule indicates when the company will need to refinance its obligations. Refinancing risks arise when the company might be unable to secure new financing on favorable terms, perhaps because of changes in credit markets or its own financial condition.
-
Interest Rate Risk: The schedule can also highlight the company’s exposure to changes in interest rates, particularly if it has variable-rate debt. If interest rates rise before the debt matures, the company will face higher financing costs.
Overall, using a financial spreading template helps maintain a structured, efficient, and reliable approach to understanding counterparty credit ratings.
How Financial Ratios Influence Credit Decisions
Spreading financial statements establishes a baseline for understanding credit risk, industry financial benchmarks, and identifying trends.
CreditKernel calculates 20+ Liquidity, Leverage, and Profitability ratios. We also provide industry averages for select ratios.
It is encouraged to spread at least two years of financial statements to track historical performance and compare financial ratios with industry averages.
-
Can risk thresholds be customized to align with our internal risk policies?Yes. CreditKernel allows you to configure risk thresholds by a variety of categories, ensuring alignment with your internal policies.
-
What types of risks does your model assess?Our framework follows the fundamental truths of counterparty credit risk - Counterparty's operating.... In higher risk industries With fewer years in business With lower revenue and margins versus industry peers With higher levels of leverage versus industry peers With minimal liquidity ...carry a higher probability of default. As such, our model assess the following counterparty credit risks: Industry Risk Business Longevity Peer Competition Financial Risk Liquidity
-
What industries do you specialize in, and how robust is your benchmarking data?CreditKernel provides benchmarking analysis for 68 industries. Each industry has a minimum of 10 peer counterparties.
-
What data inputs are required?Users enter the counterparty's Standard Industry Classification (SIC) Code and spread a minimum of 11 financial statement line items.
-
What is the average turnaround time for generating credit scores and reports?According to McKinsey & Company, a standard credit review takes 4 hours of an analysts time. Pain points include inputting financial statements, gathering industry and benchmark data, interpreting credit risk, preparing credit reviews, and aligning on risk appetite. More complex reviews can take up to 12 hours. Our credit reviews take less than 10 minutes.
-
Is there a free trial period?Yes, we offer and welcome a free trial period. Let’s setup a quick call to ensure you get the most out of CreditKernel. Typically, after 5-10 credit reviews teams understand the solution.
-
What level of training or support do you offer for onboarding and ongoing use?Onboarding is typically less than 5 days. Our team is here for you before, during, and after implementation. The platform does not require IT support nor do we assign a Project Team or Subject Matter Experts. For ongoing support, users have access to our “Credit in 5” videos. Each video is less than 5 minutes to cover topics such as rating model methodology, workflow, and each of the five credit assessment categories.
-
How secure is our data?All data stored is encrypted at rest and in transit, following industry best practices. All data disks are encrypted at rest using Azure Storage Encryption, which uses server-side encryption to protect your data. Data in Azure managed disks is encrypted using 256-bit AES encryption. Data in transit is encrypted with Transport Layer Security (TLS) 1.3. This is to ensure privacy, authentication, and data integrity.