Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Chapter_9_Applying_Excel.xls
Construct the schedule of expected cash payments
1 2 3 4 Year
Beginning balance accounts payable 81,500$ 81,500$
First-quarter purchases 129,960 86,640$ 216,600
Second-quarter purchases 198,600 132,400$ 331,000
Third-quarter purchases 197,040 131,360$ 328,400
Fourth-quarter purchases 138,480 138,480
Total cash disbursements 211,460$ 285,240$ 329,440$ 269,840$ 1,095,980$
Year 2 Quarter
Chapter_9_Applying_Excel.xls
2
80,000
2
80,000
$8
$640,000
1 2
70,000 80,000
24,000
94,000
21,000
73,000
Year 3 Quarter
1
73,000
5
365,000
Quarter
Quarter
Year 3 Quarter
Page 13
Chapter_9_Applying_Excel.xls
2
100,000
2
100,000
$7
$700,000
1 2
90,000 100,000
30,000
120,000
27,000
93,000
Year 3 Quarter
1
93,000
5
465,000
Quarter
Quarter
Year 3 Quarter
Page 16
Chapter_9_Applying_Excel.xls
Page 17
Chapter_9_Applying_Excel.xls
Page 18
Chapter_9_Applying_Excel.xls
Page 19
