Ch13test02a

# Ch13test02a - Format Column F for Percentage and 1 Decimal...

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

BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 13 - Test 02 BATTERIES, BATTERIES, BATTERIES PARTIAL COMPARATIVE BALANCE SHEET Year 2 and Year 1 Increase or Decrease Assets Year 2 Year 1 Current Assets Cash \$108,000 \$85,000 \$23,000 27.1% Notes receivable \$45,000 \$35,250 \$9,750 27.7% Accounts receivable \$5,000 \$3,500 \$1,500 42.9% Supplies \$12,350 \$11,200 \$1,150 10.3% Total Current Assets \$170,350 \$134,950 \$35,400 26.2% Fixed Assets Professional equipment \$55,000 \$45,000 \$10,000 22.2% Building \$68,500 \$63,250 \$5,250 8.3% Total Fixed Assets \$123,500 \$108,250 \$15,250 14.1% Total Assets \$293,850 \$243,200 \$50,650 20.8% Directions: a. Total Current Assets, Fixed Assets, and Total Assets for Year 1 and Year 2. f.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Format Column F for Percentage and 1 Decimal place. Amount of Change Percent of Change b. Format answers in Columns C and D for Currency. Set Decimal places to 0. Set Currency symbol to \$. c. Enter formulas in the Amount of Change column to subtract Year 1 from Year 2 for each item. d. Format Column E for Currency. Set Decimal places to 0. Set Currency symbol to \$. Set negative numbers to be shown in parentheses and in red. e. Enter formulas in the Percent column to divide the Amount of Change by Year 1 (original year) for each item. g. Save the file as ch13test02a.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...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online