ch13qz03a - c In Column F key in the Acid Test Ratio...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 13 - Quiz 03 A. Calculate the current ratio for the years shown. Year 2000 88,632 77,586 1.1 1.1:1 2001 259,188 200,658 1.3 1.3:1 2002 463,255 365,142 1.3 1.3:1 2003 192,666 146,251 1.3 1.3:1 2004 98,453 72,846 1.4 1.4:1 Directions: a. Enter formulas in Column D to calculate the Current Ratio. b. Format Column D for Number. Set Decimal places to 1. c. In Column E, key in the Current Ratio Expressed as a Ratio. d. Format Column E for General. B. Calculate the acid test ratio for the years shown. Year Cash 2000 45,652 125,632 25,645 6.7 6.7:1 2001 60,263 216,235 88,654 3.1 3.1:1 2002 76,251 25,358 100,352 1.0 1:01 2003 25,622 79,658 65,855 1.6 1.6:1 2004 58,246 143,562 72,446 2.8 2.8:1 Directions: a. Enter formulas in Column E to calculate the Acid Test Ratio. b. Format Column E for Number. Set Decimal places to 1.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: c. In Column F, key in the Acid Test Ratio Expressed as a Ratio. d. Format Column F for General. C. Calculate the return on investment for the years shown. Year Net Income 2000 110,255 725,444 15.2% 2001 132,545 1,245,325 10.6% 2002 286,225 1,985,486 14.4% 2003 115,325 942,664 12.2% 2004 895,256 2,458,694 36.4% Directions: b. Format Column D for Percentage and 1 Decimal place. Current Assets Current Liabilities Current Ratio Expressed as a Ratio Accounts Receivable Accounts Payable Acid Test Ratio Expressed as a Ratio Owner’s Equity Return on Investment a. Enter formulas in Column D to calculate Return on Investment. c. Save the file as ch13qz03a.xls. A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45...
View Full Document

This note was uploaded on 02/19/2012 for the course BUS bus 130 taught by Professor Munoz during the Winter '10 term at Everett CC.

Ask a homework question - tutors are online