Question

Intermediate Accounting

Aging schedule

There are three reports that you need to complete.

The second and third reports are given in sheets 2 and 3.

Execl Project
There are three reports that you need to complete.
The second and third reports are given in sheets 2 and 3.
Your name:
Today's Date:			11/1/2017
(1) Prepare an aging schedule:
	Use the =IF() function to identify past due invoices and # of days past due.
	Use the =IF(AND()) function for the aging schedule.
Invoice #	Customer Type	Invoice Date	Due Date	Amount	# of days past due
1001	X	6/28/2017	7/28/2017	$                          5,740
1002	Y	7/12/2017	8/11/2017	$                       14,027
1003	Z	8/5/2017	9/4/2017	$                          7,029
1004	X	8/30/2017	9/29/2017	$                          3,620
1005	Y	9/4/2017	10/4/2017	$                          7,319
1006	Z	9/9/2017	10/9/2017	$                       12,411
1007	X	9/14/2017	10/14/2017	$                       14,427
1008	Y	9/19/2017	10/19/2017	$                          6,064
1009	Z	9/24/2017	10/24/2017	$                       10,249
1010	X	10/9/2017	11/8/2017	$                          3,148
1011	Y	10/14/2017	11/13/2017	$                       10,103
Aging schedule-		Past Due Amount:
Invoice #	Csustomer Type	1-30 days	31-60 days	61-90 days	Over 90 days
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
Total

Answer 1

No of days past due..

nvoice #	Customer Type	Invoice Date	Due Date	Amount	# of days past due
1001	X	6/28/2017	7/28/2017	$                          5,740	95
1002	Y	43076	43047	$                       14,027	81
1003	Z	42863	42834	$                          7,029	57
1004	X	8/30/2017	9/29/2017	$                          3,620	32
1005	Y	42834	42835	$                          7,319	27
1006	Z	42987	42988	$                       12,411	22
1007	X	9/14/2017	10/14/2017	$                       14,427	16
1008	Y	9/19/2017	10/19/2017	$                          6,064	12
1009	Z	9/24/2017	10/24/2017	$                       10,249	7
1010	X	42988	42958	$                          3,148	0
1011	Y	10/14/2017	11/13/2017	$                       10,103	0

ging schedule-		Past Due Amount:
Invoice #	Csustomer Type	1-30 days	31-60 days	61-90 days	Over 90 days
1001	X				5740
1002	Y			14027
1003	Z		7029
1004	X		3620
1005	Y	7319
1006	Z	12411
1007	X	14427
1008	Y	6064
1009	Z	10249
1010	X	0
1011	Y	0
Total		50470	10649	14027	5740