You are to create a debtor ageing summary report for the year 2017/2018 for the CEO. Forecasted Sales figure for 2017/18 = 16,971,236 Using the percentages provided – calculate the figures for the report. After you have finished your yearly calculations you will then need to break down equally per quarter. Debtors ageing budget The historical records show that the debtors balance at the end of each quarter is usually about 20% of the quarter’s sales. At any time in the debtor’s balances 1% of the total debtors is overdue 90 days and over, 5% is 60 days overdue, 10% is 30 days overdue and the balance of the total debtors is current. The aged debtors’ budgets are only distributed to the accountant and the accounts receivable clerk.   Aged debtors   Aged Debtors Budget 2017/2018 Total Yearly Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Sales x,xxx x,xxx x,xxx x,xxx x,xxx % Debtors Sales   % % % % Total Debtors % Calculation Calculation Calculation Calculation Current % Calculation Calculation Calculation Calculation 30 Days % Calculation Calculation Calculation Calculation 60 Days % Calculation Calculation Calculation Calculation 90 Days % Calculation Calculation Calculation Calculation

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

You are to create a debtor ageing summary report for the year 2017/2018 for the CEO.

Forecasted Sales figure for 2017/18 = 16,971,236

Using the percentages provided – calculate the figures for the report.

After you have finished your yearly calculations you will then need to break down equally per quarter.

Debtors ageing budget

The historical records show that the debtors balance at the end of each quarter is usually about 20% of the quarter’s sales. At any time in the debtor’s balances 1% of the total debtors is overdue 90 days and over, 5% is 60 days overdue10% is 30 days overdue and the balance of the total debtors is current. The aged debtors’ budgets are only distributed to the accountant and the accounts receivable clerk.

 

Aged debtors

 

Aged Debtors Budget 2017/2018

Total Yearly

Qtr. 1

Qtr. 2

Qtr. 3

Qtr. 4

Sales

x,xxx

x,xxx

x,xxx

x,xxx

x,xxx

% Debtors Sales

 

%

%

%

%

Total Debtors

%

Calculation

Calculation

Calculation

Calculation

Current

%

Calculation

Calculation

Calculation

Calculation

30 Days

%

Calculation

Calculation

Calculation

Calculation

60 Days

%

Calculation

Calculation

Calculation

Calculation

90 Days

%

Calculation

Calculation

Calculation

Calculation

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education