Modelling accounts receivable - solution

Download the Accounts Receivable solution file:

To obtain the worked example file to accompany this chapter buy the financial modelling handbook.

Although you can't tell from the solution case, I started with the balance corkscrew. I then added the other two calculation blocks.

I prefer to forecast the Accounts Receivable balance and then infer the cash flow in the period. I have also shown the alternative method.

The two calculation blocks follow exactly the calculation structure outlined in the assignment notes:

The cash flow received from invoices and the Accounts Receivable balances are exported to the financial statements.

There are no active error checks as the balance sheet now balances.

Don't forget to run your Section Completion checklist.

When performing your analytical review, try to test different values of accounts receivable days. What do you expect to happen when you increase this number? Decrease it? Set it to zero? Full test the calculation under different assumptions.


Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.

Subscribe to Financial Modelling Handbook

Don’t miss out on the latest financial modelling guides. Sign up now to get access to the library of members-only guides.