Chapter 12, Problem 6DQ

Determine the equipment units

Question 5: Acid-Test RatioA company has the following data: Cash: $50,000Accounts Receivable: $30,000Inventory: $60,000Current Liabilities: $70,000a) What is the company’s acid-test ratio?b) Is the company in a strong liquidity position based on this ratio? Expl

D E F G H RELATIVE CELL REFERENCES J K L M N A B 1234567 Growth Rate (Expected) Year 0 Year 1 Formulas 4 Investment A 12% $2,200 #N/A 5 Investment B 6 Investment C 1% $2,200 3% $2,200 #N/A #N/A Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 8 "Take each value in column C and multiply it by its adjacent growth rate in column B (which is 1 plus the percentage expected growth)." 9 10 ABSOLUTE CELL REFERENCES 11 12 Growth Rate (Expected) 13 Investment A 12% Year 0 $2,200 Year 1 Year 2 Year 3 Year 4 14 15 Formulas #N/A #N/A #N/A #N/A #N/A 16 #N/A #N/A #N/A #N/A 17 "Start in column D, then move across allowing the column to change, and multiply the preceding value by its FIXED growth rate in cell $B$13 (which is 1 plus the percentage expected growth) to get the current value." #N/A 18 19 FIXED COLUMN / RELATIVE ROW CELL REFERENCES 20 Growth Rate 21 (Expected) Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 22 Investment A 23 Investment B 24 Investment C 12% 1% 3%…