Evaluate the effectiveness of your company’s sales on credit

The Accounts Receivable Analysis is a template that helps to analyze Debtors and Accounts Receivable of a company. This model evaluates the effectiveness of the company’s collection of debts and their reliability. Accounts Receivable Analysis is important because it affects directly the amount of profit the company earns, its cash balance as well as the Cash Conversion Cycle.

The template contains four worksheets:

  • Input data: collects the information on each debtor, such as the amount of debts for each overdue period;
  • Analysis by individual debtor: displays analytics by each individual debtor, i.e. the breakdown of its debts by overdue dates;
  • Analysis by overdue period: displays the breakdown of debts by each overdue period;
  • Recovery forecast: calculates the actual (expected) amount of Accounts Receivable outstanding; this data can be used to calculate the values for bad and doubtful debts as well as the required amount of provision for them.

The functionality of the Accounts Receivable Analysis:

  • analyze Receivables by individual debtors and overdue periods;
  • easily plug in data from your accounting system;
  • calculate the expected amount of Accounts Receivable.
Reviews Add a review
No reviews yet

More From Andrew Grigolyunovich, CFA, CFM, FMVA

Browse our top rated business templates. See All
CFO Excel Template Bundle (10 complete templates)
This CFO excel template bundle is of great value to serious financial modelers and chief financial officers. It includes templates…
Financial Analyst Bundle (8 complete Excel Templates)
Financial Analyst Bundle will be of great help to anyone who is familiar with financial modeling, who needs to carefully…
Financial Assistant Bundle (5 core templates)
Financial Assistant Excel Template Bundle will greatly assist in everyday simple financial calculations. The bundle allows gaining a quick overview…
WACC Calculator
WACC Calculator is a weighted average cost of capital Calculator. This model will help you to calculate the fair cost…
Optimal Purchase Volume Calculator
Optimal Purchase Volume Calculator is an MS Excel financial model used for comparing up to five purchase options of inventory…
Loan Calculator (for Lenders)
This Loan calculator is a very useful tool for loan management. This template helps to calculate the interest that should…
See All