Assume that $500,000 is considered material for audit planning purposes for 1999.
Could any of the fluctuations in the computed rations indicate a possible material misstatement? Demonstrate this by using the spreadsheet program to perform a sensitivity analysis