Chapter 16: Working Capital Management
Comprehensive/Spreadsheet Problem
445
Comprehensive/Spreadsheet Problem
Note to Instructors:
The partial solution for parts a and b of this problem are provided at the back of the text;
however, the solutions to parts c and d are not. Instructors can access the
Excel
file on the
textbook’s website.
16–11 See problem 16-10 Parts a through d on the preceding two pages.
The “Sales adjustment factor” can be used to cause sales to vary from the base levels. Similarly,
we can change the percentage of late-paying customers. Here is the relevant data table:
Change
in Sales
$155,100 0% 15% 30% 45% 60% 75% 90%
–100% $ 2,296,200 $ 2,296,200 $ 2,296,200 $ 2,296,200 $ 2,296,200 $ 2,296,200 $ 2,296,200
% Collections in 2nd month