All Industries, Financial Model, General Excel Financial Models

Accounts Receivable, Excel, Financial Analysis, Financial Model

The Accounts Receivable Analysis is a template that helps to analyze the 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 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 the 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.

This model template comes in .xlsx file type which can be opened using MS Excel.

You must log in to submit a review.